Hello,
Have had problems installing the Perl Oracle DBI for an OS X Oracle instance on Leopard on an intel iMac.

Initially tried to install using CPAN. This failed and broke my environment. Now I can access sqlplus as the Oracle user, but as my user have to log in with the sid, e.g. sqplus sc...@sid, or I get this error:

                dyld: Library not loaded: /b/227/rdbms/lib/libodm10.dylib
Referenced from: /Volumes/u01/app/oracle/product/10.2.0/db_1/bin/ oracle
                  Reason: image not found
                ERROR:
                ORA-12547: TNS:lost contact

Was able to install the DBD by following this blog:

        http://blacka.com/david/2008/11/12/how-to-install-dbdoracle-on-mac-os-x/

(Without these changes the install failed.)

Now when I try to connect using the Perl tie to the instance I get this error:

dyld: lazy symbol binding failed: Symbol not found: _OCINlsEnvironmentVariableGet Referenced from: /Library/Perl/5.8.8/darwin-thread-multi-2level/ auto/DBD/Oracle/Oracle.bundle
                  Expected in: dynamic lookup
                
                dyld: Symbol not found: _OCINlsEnvironmentVariableGet
Referenced from: /Library/Perl/5.8.8/darwin-thread-multi-2level/ auto/DBD/Oracle/Oracle.bundle
                  Expected in: dynamic lookup
                
                ./runtest: line 5: 57176 Trace/BPT trap          perl test.prl

This page appears to address an identical problem (Snow Leopard):

        http://www.nntp.perl.org/group/perl.dbi.users/2009/11/msg34424.html

Their conclusion: user 'activated' 64-bit perl on their system, which fixed the problem for them. perl -V gives me a lot of version info but not a nice list like this page displays; I see 5.8.8 which I would expect and that only; no bit-information included. Not sure how to apply to my system.

Thanks in advance for any advice.

Reply via email to