-----Original Message-----
From: Olivier Boyaval [mailto:user-f56ee5cec7be@xymon.invalid] Sent: Tuesday, September 19, 2006 10:00 AM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] pb with hobbit-perl-client and dbcheck
Hello,
* /To/: <user-ae9b8668bcde@xymon.invalid>
* /Subject/: RE: [hobbit] pb with hobbit-perl-client and dbcheck
* /From/: "Francesco Duranti" <user-7104dcecbfef@xymon.invalid>
* /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