Hello,
* /To/: <hobbit (at) hswn.dk> * /Subject/: RE: [hobbit] pb with hobbit-perl-client and dbcheck * /From/: "Francesco Duranti" <fduranti (at) q8.it> * /Date/: Tue, 19 Sep 2006 00:04:57 +0200 * /Thread-index/: AcbbXNjiyCoEBWDISL+6vz/9wLlMUwAD3t5g * /Thread-topic/: [hobbit] pb with hobbit-perl-client and dbcheck
I've not tested the dbcheck.pl with the InstantClient because I've a full 10r2 client installed on the machine but checking on some mailing list archive it seems that InstantClient and DBD::Oracle have some problems working together.... One suggestion I've found was to set the Oracle_home (in the dbcheck.ini file) to the lib directory instead of the root into which the instant client is installed (something like /usr/lib/oracle/10.2.0.2/client/lib)...
With Instantclient, there's not lib directory, my ORACLE_HOME and my LD_LIBRARY_PATH are OK
Another thing is to check that you have the following package installed (took from the DBD:Oracle readme)
- The "Basic" package for the essential Oracle libraries.
- The "SDK" package for the headers and makefile.
- The "SQL*Plus" component is optional, but will help you check your configuration and DBD::Oracle determine your Oracle version.
it's OK for this package
Then you can try to define the full hostname/port/sid/user/password in the dbcheck.ini file under the db you want to configure (it should skip the tnsnames.ora and go through to the db server). Or you can try to define your db in a tnsnames.ora under $ORACLE_HOME/network/admin and put only sid username and password in the dbconfiguration.
I tested with bbcmd and sqlplus, I can connect with the database I tested with bbcmd and the next perl script and I can also connect with the database
use DBI; $dbh = DBI->connect("dbi:Oracle:host=server;sid=SID;port=1521", "user", "password");
What version of DBD::Oracle module are you using? Did it compile/test successfully? Can you check if with sqlplus you can connect correctly to that database?
DBD::Oracle 1.18 I have detected a pb with the Makefile.PL of DBD :
Configuring DBD::Oracle for perl 5.008003 on linux (x86_64-linux-thread-multi)
Remember to actually *READ* the README file! Especially if you have any problems.
Using Oracle in /opt/instantclient SP2-1503: Unable to initialize Oracle call interface SP2-0152: ORACLE may not be functioning properly
If sqlplus failed due to a linker/symbol/relocation/library error or similar problem then it's likely that you've not configured your environment correctly. Specifically, your LD_LIBRARY_PATH environment variable set to include the directory containing the Oracle libraries.
I'm having trouble finding your Oracle version number... trying harder
WARNING: I could not determine Oracle client version so I'll just default to version 8.0.0.0. Some features of DBD::Oracle may not work. Oracle version based logic in Makefile.PL may produce erroneous results. You can use "perl Makefile.PL -V X.Y.Z" to specify a your client version.
Oracle version 8.0.0.0 (8.0) Looks like an Instant Client installation, okay Your LD_LIBRARY_PATH env var is set to '/opt/instantclient/'
I will test with "perl Makefile.PL -V 10.2.0"
Francesco Cordialement
Olivier Boyaval