Re: [cx-oracle-users] cx_Oracle-5.1.1 install help (Solaris 11 w/ Oracle DB Client 11.2.0.3 64-bit)

[Brad H. <bra...@gm...>]

Thanks for that Chris. I was able to build/install cx_Oracle after
deinstalling the 64-bit client and installing the 32-bit client. However,
there still appears to be an issue. It looks like cx_Oracle-5.1.1 is not
setup for python2.6?

# python
Python 2.6.4 (r264:75706, Oct 17 2011, 17:17:06) [C] on sunos5
Type "help", "copyright", "credits" or "license" for more information.
>>> import cx_Oracle
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "build/bdist.solaris-2.11-sun4v/egg/cx_Oracle.py", line 7, in
<module>
  File "build/bdist.solaris-2.11-sun4v/egg/cx_Oracle.py", line 6, in
__bootstrap__
ImportError: ld.so.1: isapython2.6: fatal: libclntsh.so.11.1: open failed:
No such file or directory
>>>

# ls -l
/u01/app/oracle/product/11.2.0/client_1/lib/libclntsh.so

lrwxrwxrwx   1 oracle   oinstall      61 Feb 15 08:53
/u01/app/oracle/product/11.2.0/client_1/lib/libclntsh.so ->
/u01/app/oracle/product/11.2.0/client_1/lib/libclntsh.so.11.1
# pwd
/usr/lib/python2.6/site-packages
[root@ilhsf001v010]# ls -l cx_Oracle-5.1.1-py2.6-solaris-2.11-sun4v.egg
-rw-r--r--   1 root     root       59402 Feb 15 09:09
cx_Oracle-5.1.1-py2.6-solaris-2.11-sun4v.egg
# cat easy-install.pth
import sys; sys.__plen = len(sys.path)
./SQLAlchemy-0.7.5-py2.6.egg
./cx_Oracle-5.1.1-py2.6-solaris-2.11-sun4v.egg
import sys; new=sys.path[sys.__plen:]; del sys.path[sys.__plen:];
p=getattr(sys,'__egginsert',0); sys.path[p:p]=new; sys.__egginsert =
p+len(new)
#

On Tue, Feb 14, 2012 at 6:35 PM, Christopher Jones <
chr...@or...> wrote:

>
> Try installing the 32bit Instant Client 'basic' & 'sdk' packages and
> link cx_Oracle with it (by creating a symlink libclntsh.so ->
> libclntsh.so.11.1 and setting ORACLE_HOME to the instant client
> directory).
>
> Subsequently, prior to python runtime, set LD_LIBARY_PATH to the
> Instant Client directory.  ORACLE_HOME should not be set at runtime
> since python is using Instant Client.  It's only the cx_Oracle
> installer that overloads the meaning of ORACLE_HOME.  Connections will
> need a connect string, such as "localhost/orcl".  If you use a
> tnsnames.ora file, then simply set TNS_ADMIN to its containing
> directory.
>
> Chris
>
>