New subject: [hobbit] pb with hobbit-perl-client and dbcheck (End)

19 Sep 2006 · *READ*

      Some more information from the README of DBD::Oracle 1.18a
From: John Scoles <scoles at pythian.com>
Date: Fri, 29 Sep 2005 10:48:47 -0700 (EST)
Subject: RE: Oracle 10g Instantclient
The Makefile.PL will now work for  Oracle 10g Instantclient. To have
both the Compile and
the test.pl to work you must first have the LD_LIBRARY_PATH correctly
set to your
"instantclient" directory.
(http://www.oracle.com/technology/tech/oci/instantclient/instantclient.h
tml)
The present version of the make creates a link on your "instantclient"
directory as follows
"ln -s libclntsh.so.10.1 libclntsh.so". It is needed for both the
makefile creation and the compile
but is not need for the test.pl. It should be removed after the compile.
If the Makefile.PL or make fails try creating this link directly in your
"instantclient" directory.
Hoping this could solve the problem...
...
-----Original Message-----
From: Olivier Boyaval [mailto:oboyaval at ch-bethune.fr]
Sent: Tuesday, September 19, 2006 10:00 AM
To: hobbit at hswn.dk
Subject: RE: [hobbit] pb with hobbit-perl-client and dbcheck
Hello,
...
* /To/: &lt;hobbit (at) hswn.dk>
* /Subject/: RE: [hobbit] pb with hobbit-perl-client and dbcheck
* /From/: "Francesco Duranti" &lt;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
To unsubscribe from the hobbit list, send an e-mail to
hobbit-unsubscribe at hswn.dk

[hobbit] pb with hobbit-perl-client and dbcheck

fduranti＠q8.it

use DBI; $dbh = DBI->connect("dbi:Oracle:host=server;sid=SID;port=1521", "user", "password");

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/'

Francesco Cordialement

oboyaval＠ch-bethune.fr

oboyaval＠ch-bethune.fr

tags

participants (2)