DBD::Oracle for Oracle instant client

Dear Tim,

I've just downloaded and tested the Oracle 10 Instant
client software, including SQL*Plus. This appears to
work well, with ORACLE_HOME, LD_LIBRARY_PATH and PATH
settings. However when I try execute : 'install
DBD::Oracle' this is what I get:

The ORACLE_HOME environment variable value
(/usr/lib/oracle/10.2.0.1) is not valid.
It must be set to hold the path to an Oracle
installation directory
on this machine (or a machine with a compatible
architecture)
See the README.clients file for more information.
ABORTED!
Running make test
Make had some problems, maybe interrupted? Won't
test
Running make install
Make had some problems, maybe interrupted? Won't
install

These files are on the machine:

[root@lclnt03 root]# ls -lR $ORACLE_HOME
/usr/lib/oracle/10.2.0.1:
total 12
drwxr-xr-x 4 root root 4096 Oct 19 11:09 client
drwxr-xr-x 3 root root 4096 Oct 19 11:35 network

/usr/lib/oracle/10.2.0.1/client:
total 16
drwxr-xr-x 2 root root 4096 Oct 19 11:09 bin
drwxr-xr-x 2 root root 4096 Oct 19 11:09 lib

/usr/lib/oracle/10.2.0.1/client/bin:
total 12
-r-xr-xr-x 1 root root 8697 Oct 11 00:40 sqlplus

/usr/lib/oracle/10.2.0.1/client/lib:
total 99548
-r--r--r-- 1 root root 1590491 Oct 11 00:39
classes12.jar
-r--r--r-- 1 root root 1525 Oct 11 00:39
glogin.sql
-rwxr-xr-x 1 root root 18505986 Oct 11 00:39
libclntsh.so.10.1
-r-xr-xr-x 1 root root 5480533 Oct 11 00:39
libnnz10.so
-rwxr-xr-x 1 root root 1397960 Oct 11 00:39
libocci.so.10.1
-rwxr-xr-x 1 root root 70659429 Oct 11 00:39
libociei.so
-r-xr-xr-x 1 root root 119947 Oct 11 00:39
libocijdbc10.so
-r-xr-xr-x 1 root root 1434227 Oct 11 00:39
libsqlplusic.so
-r-xr-xr-x 1 root root 1047293 Oct 11 00:39
libsqlplus.so
-r--r--r-- 1 root root 1536979 Oct 11 00:39
ojdbc14.jar

/usr/lib/oracle/10.2.0.1/network:
total 4
drwxr-xr-x 2 root root 4096 Oct 19 11:56 admin

/usr/lib/oracle/10.2.0.1/network/admin:
total 48
-rw-r--r-- 1 root root 191 Oct 19 11:55 sqlnet.ora
-rw-r--r-- 1 root root 8623 Oct 19 11:56 tnsnames.ora

(How) will it be possible to install de DBD::Oracle
driver (with these files)?

Kind regards,

R.C. van der Zant




__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com

Re: DBD::Oracle for Oracle instant client

piet paaltjens wrote:

see below
> Dear Tim,
>
> I've just downloaded and tested the Oracle 10 Instant
> client software, including SQL*Plus. This appears to
> work well, with ORACLE_HOME, LD_LIBRARY_PATH and PATH
> settings. However when I try execute : 'install
> DBD::Oracle' this is what I get:
>
> The ORACLE_HOME environment variable value
> (/usr/lib/oracle/10.2.0.1) is not valid.
> It must be set to hold the path to an Oracle
> installation directory
> on this machine (or a machine with a compatible
> architecture)
> See the README.clients file for more information.
> ABORTED!
> Running make test
> Make had some problems, maybe interrupted? Won't
> test
> Running make install
> Make had some problems, maybe interrupted? Won't
> install
>
> These files are on the machine:
>
> [root@lclnt03 root]# ls -lR $ORACLE_HOME
> /usr/lib/oracle/10.2.0.1:
> total 12
> drwxr-xr-x 4 root root 4096 Oct 19 11:09 client
> drwxr-xr-x 3 root root 4096 Oct 19 11:35 network
>
> /usr/lib/oracle/10.2.0.1/client:
> total 16
> drwxr-xr-x 2 root root 4096 Oct 19 11:09 bin
> drwxr-xr-x 2 root root 4096 Oct 19 11:09 lib
>
> /usr/lib/oracle/10.2.0.1/client/bin:
> total 12
> -r-xr-xr-x 1 root root 8697 Oct 11 00:40 sqlplus
>
> /usr/lib/oracle/10.2.0.1/client/lib:
> total 99548
> -r--r--r-- 1 root root 1590491 Oct 11 00:39
> classes12.jar
> -r--r--r-- 1 root root 1525 Oct 11 00:39
> glogin.sql
> -rwxr-xr-x 1 root root 18505986 Oct 11 00:39
> libclntsh.so.10.1
> -r-xr-xr-x 1 root root 5480533 Oct 11 00:39
> libnnz10.so
> -rwxr-xr-x 1 root root 1397960 Oct 11 00:39
> libocci.so.10.1
> -rwxr-xr-x 1 root root 70659429 Oct 11 00:39
> libociei.so
> -r-xr-xr-x 1 root root 119947 Oct 11 00:39
> libocijdbc10.so
> -r-xr-xr-x 1 root root 1434227 Oct 11 00:39
> libsqlplusic.so
> -r-xr-xr-x 1 root root 1047293 Oct 11 00:39
> libsqlplus.so
> -r--r--r-- 1 root root 1536979 Oct 11 00:39
> ojdbc14.jar
>
> /usr/lib/oracle/10.2.0.1/network:
> total 4
> drwxr-xr-x 2 root root 4096 Oct 19 11:56 admin
>
> /usr/lib/oracle/10.2.0.1/network/admin:
> total 48
> -rw-r--r-- 1 root root 191 Oct 19 11:55 sqlnet.ora
> -rw-r--r-- 1 root root 8623 Oct 19 11:56 tnsnames.ora
>

export ORACLE_HOME=/usr/lib/oracle/10.2.0.1/client
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$PATH:$ORACLE_HOME/bin

Set and move ../network down into the client directory.

you've got ORACLE_HOME pointing too high in the directory structure for
your layout

Jay