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.