cx-oracle-users

[cx-oracle-users] cx_oracle and EL Capitan?

[Dominic G. <dom...@gm...>]

After upgrading to El Capitan. cx_oracle now appears to have broken. 


prior to upgrading my environment worked fine. Now I get the message indicating problems with DYLD_LIBRARY_PATH.


python WaitTime.py 
Traceback (most recent call last):
  File "WaitTime.py", line 5, in <module>
    import cx_Oracle
ImportError: dlopen(/Library/Python/2.7/site-packages/cx_Oracle.so, 2): Library not loaded: /ade/b/2649109290/oracle/rdbms/lib/libclntsh.dylib.11.1
  Referenced from: /Library/Python/2.7/site-packages/cx_Oracle.so
  Reason: image not found



previously it worked flawlessly… Sqlplus and jdbc_oci still work.


reinstall of cx_oracle doesn’t make any difference.  


Sent with Unibox

Re: [cx-oracle-users] cx_oracle and EL Capitan?

[Christopher J. <chr...@or...>]

On 12/10/2015 10:58 pm, Dominic Giles wrote:
> After upgrading to El Capitan. cx_oracle now appears to have broken.
>
> prior to upgrading my environment worked fine. Now I get the message indicating problems with DYLD_LIBRARY_PATH.
>
> python WaitTime.py
> Traceback (most recent call last):
>    File "WaitTime.py", line 5, in <module>
>      import cx_Oracle
> ImportError: dlopen(/Library/Python/2.7/site-packages/cx_Oracle.so, 2): Library not loaded: /ade/b/2649109290/oracle/rdbms/lib/libclntsh.dylib.11.1
>    Referenced from: /Library/Python/2.7/site-packages/cx_Oracle.so
>    Reason: image not found
>
> previously it worked flawlessly… Sqlplus and jdbc_oci still work.
>
> reinstall of cx_oracle doesn’t make any difference.

Hi Dom,

This is due to El Capitan's SIP.

It's a general issue for all users of Oracle client libraries.
E.g node-oracledb also has the problem: https://github.com/oracle/node-oracledb/issues/231

There are various scripts around that might help:
https://blogs.oracle.com/opal/entry/installing_node_oracledb_on_os
This may or may not have issues.

I'm waiting to hear from our Apple group for their recommendations.

Chris

-- 
http://twitter.com/ghrd

Re: [cx-oracle-users] cx_oracle and EL Capitan?

[Kubo T. <ku...@ji...>]

On Tue, Oct 13, 2015 at 8:18 AM, Christopher Jones
<chr...@or...> wrote:

> It's a general issue for all users of Oracle client libraries.
> E.g node-oracledb also has the problem: https://github.com/oracle/node-oracledb/issues/231

ruby-oci8 also.
http://www.rubydoc.info/github/kubo/ruby-oci8/file/docs/install-on-osx.md
https://github.com/kubo/fix_oralib_osx

"ruby fix_oralib.rb" must be run with "--absolute-path" option
cx_oracle and node-oracledb
because ruby-oci8 passes -Wl,-rpath,/path/to/oracle/library to cc but
cx_oracle and node-oraclede don't.

Re: [cx-oracle-users] cx_oracle and EL Capitan?

[Kubo T. <ku...@ji...>]

On 12/10/2015 10:58 pm, Dominic Giles wrote:
> After upgrading to El Capitan. cx_oracle now appears to have broken.
>
> prior to upgrading my environment worked fine. Now I get the message indicating problems with DYLD_LIBRARY_PATH.
>
> python WaitTime.py
> Traceback (most recent call last):
>    File "WaitTime.py", line 5, in <module>
>      import cx_Oracle
> ImportError: dlopen(/Library/Python/2.7/site-packages/cx_Oracle.so, 2): Library not loaded: /ade/b/2649109290/oracle/rdbms/lib/libclntsh.dylib.11.1
>    Referenced from: /Library/Python/2.7/site-packages/cx_Oracle.so
>    Reason: image not found

If libclntsh.dylib.11.1 is in /opt/oracle/instantclient_11_2, run the
following command.

   curl -O https://raw.githubusercontent.com/kubo/fix_oralib_osx/master/fix_oralib.rb
   ruby fix_oralib.rb --ic_dir /opt/oracle/instantclient_11_2
/Library/Python/2.7/site-packages/cx_Oracle.so

This changs the install name in cx_Oracle.so from
/ade/b/2649109290/oracle/rdbms/lib/libclntsh.dylib.11.1
to @rpath/libclntsh.dylib.11.1 and adds /opt/oracle/instantclient_11_2
as rpath to cx_Oracle.so.

Re: [cx-oracle-users] cx_oracle and EL Capitan?

[Kubo T. <ku...@ji...>]

On Tue, Oct 13, 2015 at 12:33 PM, Kubo Takehiro <ku...@ji...> wrote:
>    ruby fix_oralib.rb --ic_dir /opt/oracle/instantclient_11_2
> /Library/Python/2.7/site-packages/cx_Oracle.so

My mail client folded one line to two lines.
Don't run the above two lines separately.
Join them and run in a line.

Re: [cx-oracle-users] cx_oracle and EL Capitan?

[Kubo T. <ku...@ji...>]

I made document to install cx_Oracle on El Capitan.
https://gist.github.com/kubo/8a45c653d06040c30135