Re: [cx-oracle-users] OCI.DLL cannot be found ?

[Anthony T. <an...@co...>]

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