Thread: RE: [cx-oracle-users] OCI.DLL cannot be found ?
Brought to you by:
atuining
Menu
▾
▴
cx-oracle-users
|
From: Nik B. <Nik...@pe...> - 2004-09-27 07:11:47
|
Hi, > I got the "standard" errormessage under WinXP : >=20 > >>> import cx_Oracle > Traceback (most recent call last): > File "<pyshell#6>", line 1, in ? > import cx_Oracle > ImportError: DLL load failed: La proc=E9dure sp=E9cifi=E9e est = introuvable.=20 > (the specified procedure cannot be found). Is there only one OCI.DLL in the system path? I've seen this error on installs with multiple Oracle installs, where the ORACLE_HOME is set "incorrectly" (e.g. set to 8.1.7 with a 9i Oracle_cx install).=20 If there are, try manually inserting a directory into the front of the = path and then trying each one turn. Hope this helps... Nick Barron |
|
From: Nik B. <Nik...@pe...> - 2004-09-27 09:07:03
|
> I believe Visual Studio includes (included) an utility called > depends.exe which did this. There's a freeware equivalent at http://www.dependencywalker.com/ that's pretty good. Nick Barron |
|
From: Philip S. <phi...@cg...> - 2004-10-05 08:29:23
|
It works !!! Thanks for your help to you all. In fact, both cx_Oracle-4.0.1-win32-9i-py23 and cx_Oracle-4.1.beta1-win32-9i-py23 where unable to found the entry point in the oci.dlls I have on my machine (although I own both 81 and 9i versions). I had a clearer errormessage when running python from the command line. So I installed the pywin32-202.win32-py2.3 and it linked OK against the Oracle 81's OCI.DLL. I can go on testing now... Philip. Nik Barron wrote: >>I believe Visual Studio includes (included) an utility called >>depends.exe which did this. > > > There's a freeware equivalent at http://www.dependencywalker.com/ that's > pretty good. > > Nick Barron > > > ------------------------------------------------------- > This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170 > Project Admins to receive an Apple iPod Mini FREE for your judgement on > who ports your project to Linux PPC the best. Sponsored by IBM. > Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > |
|
From: Anthony T. <an...@co...> - 2004-10-05 13:49:23
|
Glad to hear you got it working. Just so that others who might run into this problem have something to look at in the archives and so that I understand it a bit better, could you answer a few questions? 1) what was the clearer error message that was displayed when running Python from the command line? 2) What did you do after the installation of pywin32-202.win32-py2.3 that caused it to "link OK" aginst Oracle 8i's oci.dll? Thanks. Philip SION wrote: > It works !!! > > Thanks for your help to you all. > > In fact, both cx_Oracle-4.0.1-win32-9i-py23 and > cx_Oracle-4.1.beta1-win32-9i-py23 where unable to found the entry point > in the oci.dlls I have on my machine (although I own both 81 and 9i > versions). I had a clearer errormessage when running python from the > command line. > > So I installed the pywin32-202.win32-py2.3 and it linked OK against the > Oracle 81's OCI.DLL. > > I can go on testing now... > > Philip. > > Nik Barron wrote: > >>> I believe Visual Studio includes (included) an utility called >>> depends.exe which did this. >> >> >> >> There's a freeware equivalent at http://www.dependencywalker.com/ that's >> pretty good. >> >> Nick Barron >> >> >> ------------------------------------------------------- >> This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170 >> Project Admins to receive an Apple iPod Mini FREE for your judgement on >> who ports your project to Linux PPC the best. Sponsored by IBM. >> Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php >> _______________________________________________ >> cx-oracle-users mailing list >> cx-...@li... >> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >> > > > > ------------------------------------------------------- > This SF.net email is sponsored by: IT Product Guide on ITManagersJournal > Use IT products in your business? Tell us what you think of them. Give us > Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more > http://productguide.itmanagersjournal.com/guidepromo.tmpl > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users -- Anthony Tuininga an...@co... Computronix Distinctive Software. Real People. Suite 200, 10216 - 124 Street NW Edmonton, AB, Canada T5N 4A3 Phone: (780) 454-3700 Fax: (780) 454-3838 http://www.computronix.com |
|
From: Philip S. <phi...@cg...> - 2004-10-06 08:22:47
|
*** Sorry I was wrong with the file name :-( It's not pywin32-202.win32-py2.3 that I installed back but cx_Oracle-4.0.1-win32-8i-py23.exe (THERE IS NO RELATION WITH pywin32 AT ALL of course...) BTW, (I owed you to reproduce the problem ;-) : When using Python from the command line, you obtain 2 different dialog boxes depending on the error : a) With oracle81/bin/oci.dll and oracle9i/bin/oci.dll on the disk and in the path : When I use cx_Oracle-4.1.beta1-win32-9i-py23, or cx_Oracle-4.0.1-win32-9i-py23.exe, it displays a window stating (translated from french): "Procedure entry point OCISessionGet cannot be found in dynamic link library OCI.DLL With IDLE, I have the following errormessage in the Python Shell : ImportError: DLL load failed: the specified procedure cannot be found Errormessages match. b) With both oci.dll renamed to aci.dll (so they are not any longer on the disk for the app) This time the window is : This application could start because OCI.dll cannot be found. Re-installation of this application can solve this problem. And Python Shell error is : ImportError: DLL load failed: the specified MODULE cannot be found !!! So the PythonShell errormessage was OK (although a bit incomplete), I just read it too fast :-( c) With cx_Oracle-4.0.1-win32-9i-py23.exe uninstalled and cx_Oracle-4.0.1-win32-8i-py23.exe installed back, oracle9i (or 81)/bin/aci.dll renamed to the right name, everything runs fine. Finally, am I using oracle 9i or 81 ??? It depends on the DLL I left on the machine ? Or is it the cx_oracle version which rules ? Thanks a lot anyway. Philip. Anthony Tuininga wrote: > Glad to hear you got it working. Just so that others who might run into > this problem have something to look at in the archives and so that I > understand it a bit better, could you answer a few questions? > > 1) what was the clearer error message that was displayed when running > Python from the command line? > > 2) What did you do after the installation of pywin32-202.win32-py2.3 > that caused it to "link OK" aginst Oracle 8i's oci.dll? > > Thanks. > > Philip SION wrote: > >> It works !!! >> >> Thanks for your help to you all. >> >> In fact, both cx_Oracle-4.0.1-win32-9i-py23 and >> cx_Oracle-4.1.beta1-win32-9i-py23 where unable to found the entry >> point in the oci.dlls I have on my machine (although I own both 81 and >> 9i versions). I had a clearer errormessage when running python from >> the command line. >> >> So I installed the pywin32-202.win32-py2.3 and it linked OK against >> the Oracle 81's OCI.DLL. >> >> I can go on testing now... >> >> Philip. >> >> Nik Barron wrote: >> >>>> I believe Visual Studio includes (included) an utility called >>>> depends.exe which did this. >>> >>> >>> >>> >>> There's a freeware equivalent at http://www.dependencywalker.com/ that's >>> pretty good. >>> >>> Nick Barron >>> >>> >>> ------------------------------------------------------- >>> This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170 >>> Project Admins to receive an Apple iPod Mini FREE for your judgement on >>> who ports your project to Linux PPC the best. Sponsored by IBM. >>> Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php >>> _______________________________________________ >>> cx-oracle-users mailing list >>> cx-...@li... >>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >>> >> >> >> >> ------------------------------------------------------- >> This SF.net email is sponsored by: IT Product Guide on ITManagersJournal >> Use IT products in your business? Tell us what you think of them. Give us >> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out >> more >> http://productguide.itmanagersjournal.com/guidepromo.tmpl >> _______________________________________________ >> cx-oracle-users mailing list >> cx-...@li... >> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > > |
|
From: Anthony T. <an...@co...> - 2004-10-06 14:04:26
|
Ah yes, the infamous "OCISessionGet" procedure entry point missing error. We have the same error occur on a regular basis when someone with an Oracle 8i client installation attempts to run an Oracle 9i version of cx_Oracle. Running an Oracle 8i version of cx_Oracle on either an 8i or 9i installation (on Windows) does not have a problem. In general, however, you need to make sure that your client software matches the version of cx_Oracle that you are using. The server software version is completely irrelevant. The only funny exception is Oracle 9.0.1 (an early version of 9i) which does not have the OCISessionGet() method either. Hope that clears up any questions you might have. If not, feel free to ask more questions! Philip SION wrote: > *** Sorry I was wrong with the file name :-( > > It's not pywin32-202.win32-py2.3 that I installed back but > cx_Oracle-4.0.1-win32-8i-py23.exe (THERE IS NO RELATION WITH pywin32 > AT ALL of course...) > > BTW, (I owed you to reproduce the problem ;-) : > > When using Python from the command line, you obtain 2 different dialog > boxes depending on the error : > > a) With oracle81/bin/oci.dll and oracle9i/bin/oci.dll on the disk and > in the path : > > When I use cx_Oracle-4.1.beta1-win32-9i-py23, or > cx_Oracle-4.0.1-win32-9i-py23.exe, it displays a window stating > (translated from french): "Procedure entry point OCISessionGet cannot > be found in dynamic link library OCI.DLL > > With IDLE, I have the following errormessage in the Python Shell : > ImportError: DLL load failed: the specified procedure cannot be found > > Errormessages match. > > b) With both oci.dll renamed to aci.dll (so they are not any longer on > the disk for the app) > > This time the window is : This application could start because OCI.dll > cannot be found. Re-installation of this application can solve this > problem. > > And Python Shell error is : ImportError: DLL load failed: the > specified MODULE cannot be found !!! > > So the PythonShell errormessage was OK (although a bit incomplete), I > just read it too fast :-( > > c) With cx_Oracle-4.0.1-win32-9i-py23.exe uninstalled and > cx_Oracle-4.0.1-win32-8i-py23.exe installed back, oracle9i (or > 81)/bin/aci.dll renamed to the right name, everything runs fine. > > Finally, am I using oracle 9i or 81 ??? It depends on the DLL I left > on the machine ? Or is it the cx_oracle version which rules ? > > Thanks a lot anyway. > > Philip. > > Anthony Tuininga wrote: > >> Glad to hear you got it working. Just so that others who might run >> into this problem have something to look at in the archives and so >> that I understand it a bit better, could you answer a few questions? >> >> 1) what was the clearer error message that was displayed when running >> Python from the command line? >> >> 2) What did you do after the installation of pywin32-202.win32-py2.3 >> that caused it to "link OK" aginst Oracle 8i's oci.dll? >> >> Thanks. >> >> Philip SION wrote: >> >>> It works !!! >>> >>> Thanks for your help to you all. >>> >>> In fact, both cx_Oracle-4.0.1-win32-9i-py23 and >>> cx_Oracle-4.1.beta1-win32-9i-py23 where unable to found the entry >>> point in the oci.dlls I have on my machine (although I own both 81 >>> and 9i versions). I had a clearer errormessage when running python >>> from the command line. >>> >>> So I installed the pywin32-202.win32-py2.3 and it linked OK against >>> the Oracle 81's OCI.DLL. >>> >>> I can go on testing now... >>> >>> Philip. >>> >>> Nik Barron wrote: >>> >>>>> I believe Visual Studio includes (included) an utility called >>>>> depends.exe which did this. >>>> >>>> >>>> >>>> >>>> >>>> There's a freeware equivalent at http://www.dependencywalker.com/ >>>> that's >>>> pretty good. >>>> >>>> Nick Barron >>>> >>>> >>>> ------------------------------------------------------- >>>> This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170 >>>> Project Admins to receive an Apple iPod Mini FREE for your >>>> judgement on >>>> who ports your project to Linux PPC the best. Sponsored by IBM. >>>> Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php >>>> _______________________________________________ >>>> cx-oracle-users mailing list >>>> cx-...@li... >>>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >>>> >>> >>> >>> >>> ------------------------------------------------------- >>> This SF.net email is sponsored by: IT Product Guide on >>> ITManagersJournal >>> Use IT products in your business? Tell us what you think of them. >>> Give us >>> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find >>> out more >>> http://productguide.itmanagersjournal.com/guidepromo.tmpl >>> _______________________________________________ >>> cx-oracle-users mailing list >>> cx-...@li... >>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >> >> >> > > > > ------------------------------------------------------- > This SF.net email is sponsored by: IT Product Guide on ITManagersJournal > Use IT products in your business? Tell us what you think of them. Give us > Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out > more > http://productguide.itmanagersjournal.com/guidepromo.tmpl > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users |
|
From: Nik B. <Nik...@pe...> - 2004-10-06 09:29:03
|
> c) With cx_Oracle-4.0.1-win32-9i-py23.exe uninstalled and > cx_Oracle-4.0.1-win32-8i-py23.exe installed back, oracle9i (or > 81)/bin/aci.dll renamed to the right name, everything runs fine. > > Finally, am I using oracle 9i or 81 ??? It depends on the DLL > I left on > the machine ? Or is it the cx_oracle version which rules ? It's complicated. It appears to depend on both the server and client versions installed. I had to recompile cx_Oracle for one of our configurations (8i client/server) although foolishly didn't write down the step by step process (but it was pretty much in line with the docs I recall). This is more of an Oracle issue than cx_oracle I think; I've had similar problems with a number of client-side tools that interact with Oracle directly, often having to swap ORACLE_HOME according to which specific tool was being used! Nick Barron |
|
From: Anthony T. <an...@co...> - 2004-10-06 14:07:12
|
This is definitely an Oracle client issue -- the server software is irrelevant, actually. In general, make sure that if you are running Oracle 8i on the client you are using the Oracle 8i version of cx_Oracle and if you are running Oracle 9i on the client make sure you are using the Oracle 9i version of cx_Oracle. As mentioned earlier, the only exception is Oracle 9.0.1 which doesn't have the required procedure. Make sense? Nik Barron wrote: >>c) With cx_Oracle-4.0.1-win32-9i-py23.exe uninstalled and >>cx_Oracle-4.0.1-win32-8i-py23.exe installed back, oracle9i (or >>81)/bin/aci.dll renamed to the right name, everything runs fine. >> >>Finally, am I using oracle 9i or 81 ??? It depends on the DLL >>I left on >>the machine ? Or is it the cx_oracle version which rules ? >> >> > >It's complicated. It appears to depend on both the server and client >versions installed. I had to recompile cx_Oracle for one of our >configurations (8i client/server) although foolishly didn't write down the >step by step process (but it was pretty much in line with the docs I >recall). > >This is more of an Oracle issue than cx_oracle I think; I've had similar >problems with a number of client-side tools that interact with Oracle >directly, often having to swap ORACLE_HOME according to which specific tool >was being used! > >Nick Barron > > >------------------------------------------------------- >This SF.net email is sponsored by: IT Product Guide on ITManagersJournal >Use IT products in your business? Tell us what you think of them. Give us >Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more >http://productguide.itmanagersjournal.com/guidepromo.tmpl >_______________________________________________ >cx-oracle-users mailing list >cx-...@li... >https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > > |
|
From: Philip S. <phi...@cg...> - 2004-10-06 15:20:11
|
Sorry but no :-( cx_Oracle-4.0.1-win32-9i-py23 did'nt work with either the 9i or 81 version of oci.dll, and cx_Oracle-4.0.1-win32-8i-py23 works with both 9i and 81 version of the DLL... (I switch from one DLL to the other by renaming the one I don't want to Aci.dll). So I will go on like this for the moment... Thanks, Philip. Anthony Tuininga wrote: > This is definitely an Oracle client issue -- the server software is > irrelevant, actually. In general, make sure that if you are running > Oracle 8i on the client you are using the Oracle 8i version of cx_Oracle > and if you are running Oracle 9i on the client make sure you are using > the Oracle 9i version of cx_Oracle. As mentioned earlier, the only > exception is Oracle 9.0.1 which doesn't have the required procedure. > Make sense? > > Nik Barron wrote: > >>> c) With cx_Oracle-4.0.1-win32-9i-py23.exe uninstalled and >>> cx_Oracle-4.0.1-win32-8i-py23.exe installed back, oracle9i (or >>> 81)/bin/aci.dll renamed to the right name, everything runs fine. >>> >>> Finally, am I using oracle 9i or 81 ??? It depends on the DLL I left >>> on the machine ? Or is it the cx_oracle version which rules ? >>> >> >> >> It's complicated. It appears to depend on both the server and client >> versions installed. I had to recompile cx_Oracle for one of our >> configurations (8i client/server) although foolishly didn't write down >> the >> step by step process (but it was pretty much in line with the docs I >> recall). >> >> This is more of an Oracle issue than cx_oracle I think; I've had similar >> problems with a number of client-side tools that interact with Oracle >> directly, often having to swap ORACLE_HOME according to which specific >> tool >> was being used! >> >> Nick Barron >> >> >> ------------------------------------------------------- >> This SF.net email is sponsored by: IT Product Guide on ITManagersJournal >> Use IT products in your business? Tell us what you think of them. Give us >> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out >> more >> http://productguide.itmanagersjournal.com/guidepromo.tmpl >> _______________________________________________ >> cx-oracle-users mailing list >> cx-...@li... >> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >> >> > > > ------------------------------------------------------- > This SF.net email is sponsored by: IT Product Guide on ITManagersJournal > Use IT products in your business? Tell us what you think of them. Give us > Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more > http://productguide.itmanagersjournal.com/guidepromo.tmpl > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > |
|
From: Anthony T. <an...@co...> - 2004-10-06 15:36:58
|
Interesting. What client version are you using, exactly? You wouldn't happen to be using 9.0.1, would you? The 9i version of cx_Oracle will not work with an 8i client at all but it should work with a 9i client -- we've never noticed otherwise, anyway. Regardless, if you have it working now, no need to continue this thread except from curiousity, of course! ;-) Philip SION wrote: > Sorry but no :-( > > cx_Oracle-4.0.1-win32-9i-py23 did'nt work with either the 9i or 81 > version of oci.dll, and cx_Oracle-4.0.1-win32-8i-py23 works with both > 9i and 81 version of the DLL... > (I switch from one DLL to the other by renaming the one I don't want > to Aci.dll). > > So I will go on like this for the moment... > > Thanks, > > Philip. > > Anthony Tuininga wrote: > >> This is definitely an Oracle client issue -- the server software is >> irrelevant, actually. In general, make sure that if you are running >> Oracle 8i on the client you are using the Oracle 8i version of >> cx_Oracle and if you are running Oracle 9i on the client make sure >> you are using the Oracle 9i version of cx_Oracle. As mentioned >> earlier, the only exception is Oracle 9.0.1 which doesn't have the >> required procedure. Make sense? >> >> Nik Barron wrote: >> >>>> c) With cx_Oracle-4.0.1-win32-9i-py23.exe uninstalled and >>>> cx_Oracle-4.0.1-win32-8i-py23.exe installed back, oracle9i (or >>>> 81)/bin/aci.dll renamed to the right name, everything runs fine. >>>> >>>> Finally, am I using oracle 9i or 81 ??? It depends on the DLL I >>>> left on the machine ? Or is it the cx_oracle version which rules ? >>>> >>> >>> >>> >>> It's complicated. It appears to depend on both the server and client >>> versions installed. I had to recompile cx_Oracle for one of our >>> configurations (8i client/server) although foolishly didn't write >>> down the >>> step by step process (but it was pretty much in line with the docs I >>> recall). >>> >>> This is more of an Oracle issue than cx_oracle I think; I've had >>> similar >>> problems with a number of client-side tools that interact with Oracle >>> directly, often having to swap ORACLE_HOME according to which >>> specific tool >>> was being used! >>> >>> Nick Barron >>> >>> >>> ------------------------------------------------------- >>> This SF.net email is sponsored by: IT Product Guide on >>> ITManagersJournal >>> Use IT products in your business? Tell us what you think of them. >>> Give us >>> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find >>> out more >>> http://productguide.itmanagersjournal.com/guidepromo.tmpl >>> _______________________________________________ >>> cx-oracle-users mailing list >>> cx-...@li... >>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >>> >>> >> >> >> ------------------------------------------------------- >> This SF.net email is sponsored by: IT Product Guide on ITManagersJournal >> Use IT products in your business? Tell us what you think of them. >> Give us >> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find >> out more >> http://productguide.itmanagersjournal.com/guidepromo.tmpl >> _______________________________________________ >> cx-oracle-users mailing list >> cx-...@li... >> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >> > > > > ------------------------------------------------------- > This SF.net email is sponsored by: IT Product Guide on ITManagersJournal > Use IT products in your business? Tell us what you think of them. Give us > Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out > more > http://productguide.itmanagersjournal.com/guidepromo.tmpl > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users |
|
From: Philip S. <phi...@cg...> - 2004-10-07 09:06:40
|
OK so just for curiosity : According to windows file properties, the version of my c:\oracle\ora9i\bin\oci.dll is 9.0.1.1.1 It is the version which DOESN'T work with cx_Oracle-4.0.1-win32-9i-py23 but which WORKS with cx_Oracle-4.0.1-win32-8i-py23. Normal ? Philip. Anthony Tuininga wrote: > Interesting. What client version are you using, exactly? You wouldn't > happen to be using 9.0.1, would you? The 9i version of cx_Oracle will > not work with an 8i client at all but it should work with a 9i client -- > we've never noticed otherwise, anyway. Regardless, if you have it > working now, no need to continue this thread except from curiousity, of > course! ;-) > > Philip SION wrote: > >> Sorry but no :-( >> >> cx_Oracle-4.0.1-win32-9i-py23 did'nt work with either the 9i or 81 >> version of oci.dll, and cx_Oracle-4.0.1-win32-8i-py23 works with both >> 9i and 81 version of the DLL... >> (I switch from one DLL to the other by renaming the one I don't want >> to Aci.dll). >> >> So I will go on like this for the moment... >> >> Thanks, >> >> Philip. >> >> Anthony Tuininga wrote: >> >>> This is definitely an Oracle client issue -- the server software is >>> irrelevant, actually. In general, make sure that if you are running >>> Oracle 8i on the client you are using the Oracle 8i version of >>> cx_Oracle and if you are running Oracle 9i on the client make sure >>> you are using the Oracle 9i version of cx_Oracle. As mentioned >>> earlier, the only exception is Oracle 9.0.1 which doesn't have the >>> required procedure. Make sense? >>> >>> Nik Barron wrote: >>> >>>>> c) With cx_Oracle-4.0.1-win32-9i-py23.exe uninstalled and >>>>> cx_Oracle-4.0.1-win32-8i-py23.exe installed back, oracle9i (or >>>>> 81)/bin/aci.dll renamed to the right name, everything runs fine. >>>>> >>>>> Finally, am I using oracle 9i or 81 ??? It depends on the DLL I >>>>> left on the machine ? Or is it the cx_oracle version which rules ? >>>>> >>>> >>>> >>>> >>>> >>>> It's complicated. It appears to depend on both the server and client >>>> versions installed. I had to recompile cx_Oracle for one of our >>>> configurations (8i client/server) although foolishly didn't write >>>> down the >>>> step by step process (but it was pretty much in line with the docs I >>>> recall). >>>> >>>> This is more of an Oracle issue than cx_oracle I think; I've had >>>> similar >>>> problems with a number of client-side tools that interact with Oracle >>>> directly, often having to swap ORACLE_HOME according to which >>>> specific tool >>>> was being used! >>>> >>>> Nick Barron >>>> >>>> >>>> ------------------------------------------------------- >>>> This SF.net email is sponsored by: IT Product Guide on >>>> ITManagersJournal >>>> Use IT products in your business? Tell us what you think of them. >>>> Give us >>>> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find >>>> out more >>>> http://productguide.itmanagersjournal.com/guidepromo.tmpl >>>> _______________________________________________ >>>> cx-oracle-users mailing list >>>> cx-...@li... >>>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >>>> >>>> >>> >>> >>> ------------------------------------------------------- >>> This SF.net email is sponsored by: IT Product Guide on ITManagersJournal >>> Use IT products in your business? Tell us what you think of them. >>> Give us >>> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find >>> out more >>> http://productguide.itmanagersjournal.com/guidepromo.tmpl >>> _______________________________________________ >>> cx-oracle-users mailing list >>> cx-...@li... >>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >>> >> >> >> >> ------------------------------------------------------- >> This SF.net email is sponsored by: IT Product Guide on ITManagersJournal >> Use IT products in your business? Tell us what you think of them. Give us >> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out >> more >> http://productguide.itmanagersjournal.com/guidepromo.tmpl >> _______________________________________________ >> cx-oracle-users mailing list >> cx-...@li... >> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > > > > > ------------------------------------------------------- > This SF.net email is sponsored by: IT Product Guide on ITManagersJournal > Use IT products in your business? Tell us what you think of them. Give us > Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more > http://productguide.itmanagersjournal.com/guidepromo.tmpl > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > |
|
From: Anthony T. <an...@co...> - 2004-10-07 14:42:16
|
Correct. 9.0.1 does not have the procedure OCISessionGet() or many of the other features that make 9i what it is. Oracle has also stated that users of 9.0.1 should upgrade in favor of 9.2.0 since 9.0.1 is no longer supported (or won't be soon -- I can't remember which). The use of the 8i version works on Windows only. On Unix where the name of the shared library changes on major versions a recompile is necessary. The documentation says 9.2 instead of simply "9i" but only in passing so perhaps this should be more obviously stated. That said, you are only the second person that has been bitten by this "discrepancy". :-) Philip SION wrote: > OK so just for curiosity : > > According to windows file properties, the version of my > c:\oracle\ora9i\bin\oci.dll is 9.0.1.1.1 > > It is the version which DOESN'T work with cx_Oracle-4.0.1-win32-9i-py23 > but which WORKS with cx_Oracle-4.0.1-win32-8i-py23. > > Normal ? > > Philip. > > Anthony Tuininga wrote: > >> Interesting. What client version are you using, exactly? You wouldn't >> happen to be using 9.0.1, would you? The 9i version of cx_Oracle will >> not work with an 8i client at all but it should work with a 9i client >> -- we've never noticed otherwise, anyway. Regardless, if you have it >> working now, no need to continue this thread except from curiousity, >> of course! ;-) >> >> Philip SION wrote: >> >>> Sorry but no :-( >>> >>> cx_Oracle-4.0.1-win32-9i-py23 did'nt work with either the 9i or 81 >>> version of oci.dll, and cx_Oracle-4.0.1-win32-8i-py23 works with both >>> 9i and 81 version of the DLL... >>> (I switch from one DLL to the other by renaming the one I don't want >>> to Aci.dll). >>> >>> So I will go on like this for the moment... >>> >>> Thanks, >>> >>> Philip. >>> >>> Anthony Tuininga wrote: >>> >>>> This is definitely an Oracle client issue -- the server software is >>>> irrelevant, actually. In general, make sure that if you are running >>>> Oracle 8i on the client you are using the Oracle 8i version of >>>> cx_Oracle and if you are running Oracle 9i on the client make sure >>>> you are using the Oracle 9i version of cx_Oracle. As mentioned >>>> earlier, the only exception is Oracle 9.0.1 which doesn't have the >>>> required procedure. Make sense? >>>> >>>> Nik Barron wrote: >>>> >>>>>> c) With cx_Oracle-4.0.1-win32-9i-py23.exe uninstalled and >>>>>> cx_Oracle-4.0.1-win32-8i-py23.exe installed back, oracle9i (or >>>>>> 81)/bin/aci.dll renamed to the right name, everything runs fine. >>>>>> >>>>>> Finally, am I using oracle 9i or 81 ??? It depends on the DLL I >>>>>> left on the machine ? Or is it the cx_oracle version which rules ? >>>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> It's complicated. It appears to depend on both the server and client >>>>> versions installed. I had to recompile cx_Oracle for one of our >>>>> configurations (8i client/server) although foolishly didn't write >>>>> down the >>>>> step by step process (but it was pretty much in line with the docs I >>>>> recall). >>>>> >>>>> This is more of an Oracle issue than cx_oracle I think; I've had >>>>> similar >>>>> problems with a number of client-side tools that interact with Oracle >>>>> directly, often having to swap ORACLE_HOME according to which >>>>> specific tool >>>>> was being used! >>>>> >>>>> Nick Barron >>>>> >>>>> >>>>> ------------------------------------------------------- >>>>> This SF.net email is sponsored by: IT Product Guide on >>>>> ITManagersJournal >>>>> Use IT products in your business? Tell us what you think of them. >>>>> Give us >>>>> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find >>>>> out more >>>>> http://productguide.itmanagersjournal.com/guidepromo.tmpl >>>>> _______________________________________________ >>>>> cx-oracle-users mailing list >>>>> cx-...@li... >>>>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >>>>> >>>>> >>>> >>>> >>>> ------------------------------------------------------- >>>> This SF.net email is sponsored by: IT Product Guide on >>>> ITManagersJournal >>>> Use IT products in your business? Tell us what you think of them. >>>> Give us >>>> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find >>>> out more >>>> http://productguide.itmanagersjournal.com/guidepromo.tmpl >>>> _______________________________________________ >>>> cx-oracle-users mailing list >>>> cx-...@li... >>>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >>>> >>> >>> >>> >>> ------------------------------------------------------- >>> This SF.net email is sponsored by: IT Product Guide on ITManagersJournal >>> Use IT products in your business? Tell us what you think of them. >>> Give us >>> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find >>> out more >>> http://productguide.itmanagersjournal.com/guidepromo.tmpl >>> _______________________________________________ >>> cx-oracle-users mailing list >>> cx-...@li... >>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >> >> >> >> >> >> ------------------------------------------------------- >> This SF.net email is sponsored by: IT Product Guide on ITManagersJournal >> Use IT products in your business? Tell us what you think of them. Give us >> Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out >> more >> http://productguide.itmanagersjournal.com/guidepromo.tmpl >> _______________________________________________ >> cx-oracle-users mailing list >> cx-...@li... >> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >> > > > > ------------------------------------------------------- > This SF.net email is sponsored by: IT Product Guide on ITManagersJournal > Use IT products in your business? Tell us what you think of them. Give us > Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more > http://productguide.itmanagersjournal.com/guidepromo.tmpl > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users -- Anthony Tuininga an...@co... Computronix Distinctive Software. Real People. Suite 200, 10216 - 124 Street NW Edmonton, AB, Canada T5N 4A3 Phone: (780) 454-3700 Fax: (780) 454-3838 http://www.computronix.com |
|
From: Nik B. <Nik...@pe...> - 2004-10-15 07:09:02
|
> This is definitely an Oracle client issue -- the server software is > irrelevant, actually. In general, make sure that if you are running > Oracle 8i on the client you are using the Oracle 8i version > of cx_Oracle and if you are running Oracle 9i on the client make sure you > are using the Oracle 9i version of cx_Oracle. As mentioned earlier, the only > exception is Oracle 9.0.1 which doesn't have the required procedure. > Make sense? About as much as Oracle stuff ever does :-) Something was definitely out of the norm with our product client install, as neither the 8i or 9i "prepackaged" build of cx_Oracle worked, which is why I ended up recompiling it. However we've now moved on to 9i so the problem has gone away. Great news that it works on 10g; I may be able to offer to test it on a Windows platform in the not too distant future...! Nik |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X