DSXchange

Hi

Is it possible for me to use oracle instant client to connect Oracle plugins.
I am so confused because the info i can see is
drwxr-xr-x 2 oracle dba 512 Mar 9 08:42 .
drwxr-xr-x 3 oracle dba 512 Mar 9 08:36 ..
-r--r--r-- 1 oracle dba 1600090 Dec 20 15:00 classes12.jar
-rwxr-xr-x 1 oracle dba 27904 Dec 20 14:59 genezi
-r--r--r-- 1 oracle dba 1525 Dec 20 15:01 glogin.sql
-rwxr-xr-x 1 oracle dba 20857608 Dec 20 15:00 libclntsh.so.10.1
-rwxr-xr-x 1 oracle dba 117252 Dec 20 15:01 libheteroxa10.so
-rwxr-xr-x 1 oracle dba 6135928 Dec 20 14:59 libnnz10.so
-rwxr-xr-x 1 oracle dba 1165184 Dec 20 15:00 libocci.so.10.1
-rwxr-xr-x 1 oracle dba 72433976 Dec 20 14:59 libociei.so
-rwxr-xr-x 1 oracle dba 101888 Dec 20 15:00 libocijdbc10.so
-rwxr-xr-x 1 oracle dba 1141196 Dec 20 15:01 libsqlplus.so
-rwxr-xr-x 1 oracle dba 1434256 Dec 20 15:01 libsqlplusic.so
-r--r--r-- 1 oracle dba 1545954 Dec 20 15:00 ojdbc14.jar
-rw-r--r-- 1 oracle dba 159 Mar 9 08:40 oracle_env.env
-r--r--r-- 1 oracle dba 1645114 Dec 20 15:01 orai18n.jar
-rw-r--r-- 1 oracle dba 813 Mar 9 08:42 sqlnet.log
-rwxr-xr-x 1 oracle dba 6508 Dec 20 15:01 sqlplus
-rw-r--r-- 1 oracle dba 380 Mar 9 08:49 tnsnames.ora
$ pwd
/export/home/oracle/instantclient/instantclient_10_2

I dont see lib32 to type LD_LIBRARY_PATH in dsenv.

Please clear this for me,i am getting confused.

Do you mean, you are trying to connect to remote database?

Were you able to connect to Oracle database using this setup from command line?

I am trying to set up connection between datastage and oracle.
I understand i have to edit dsenv ie oracle_home.
My problem is i dont even see lib32 for LD_LIBRARY_PATH.
All i see is the information above.I want to start using oracle plugins.

No, you should have standard Oracle client installation on the server.

So there is no way to use this one.Cant i use this one in odbc.ini?

Iam afraid not. Though the configuration that require in dsenv is the same, you can just give it a try by giving $DSHOME/./branded_odbc/lib.
The files that you will need to edit would be dsenv, .odbc.ini, uvodbc.config.

But as per Kenneth, in the following post, post1 post2it seems its possible with 32 bit client. And ODBC doesn't require it.

Thanks,

Thanks,

Is the double Thanks for my double post?

Thanks,

You got to be kidding.

My computer started hanging and all this thanks where send after that.

Can anyone who using oracle instant client 10G , tell me how to configur e and which libraries to use.This is what i have so far in my dsenv.

#ORACLE HOME
ORACLE_HOME=/home/oracle/instantclient/instantclient_10_2; export ORACLE_HOME
LD_LIBRARY_PATH=/home/oracle/instantclient/instantclient_10_2; export
LIBRARY_PATH
TNS_ADMIN=/home/oracle/instantclient/instantclient_10_2; export TNS_ADMIN

Oracle instant client is installed and this i what i can see.
$ pwd
/export/home/oracle/instantclient/instantclient_10_2
$ ls -la
total 211780
drwxr-xr-x 2 oracle dba 512 Mar 9 08:42 .
drwxr-xr-x 3 oracle dba 512 Mar 9 08:36 ..
-r--r--r-- 1 oracle dba 1600090 Dec 20 15:00 classes12.jar
-rwxr-xr-x 1 oracle dba 27904 Dec 20 14:59 genezi
-r--r--r-- 1 oracle dba 1525 Dec 20 15:01 glogin.sql
-rwxr-xr-x 1 oracle dba 20857608 Dec 20 15:00 libclntsh.so.10.1
-rwxr-xr-x 1 oracle dba 117252 Dec 20 15:01 libheteroxa10.so
-rwxr-xr-x 1 oracle dba 6135928 Dec 20 14:59 libnnz10.so
-rwxr-xr-x 1 oracle dba 1165184 Dec 20 15:00 libocci.so.10.1
-rwxr-xr-x 1 oracle dba 72433976 Dec 20 14:59 libociei.so
-rwxr-xr-x 1 oracle dba 101888 Dec 20 15:00 libocijdbc10.so
-rwxr-xr-x 1 oracle dba 1141196 Dec 20 15:01 libsqlplus.so
-rwxr-xr-x 1 oracle dba 1434256 Dec 20 15:01 libsqlplusic.so
-r--r--r-- 1 oracle dba 1545954 Dec 20 15:00 ojdbc14.jar
-rw-r--r-- 1 oracle dba 159 Mar 9 08:40 oracle_env.env
-r--r--r-- 1 oracle dba 1645114 Dec 20 15:01 orai18n.jar
-rw-r--r-- 1 oracle dba 813 Mar 9 08:42 sqlnet.log
-rwxr-xr-x 1 oracle dba 6508 Dec 20 15:01 sqlplus
-rw-r--r-- 1 oracle dba 380 Mar 9 08:49 tnsnames.ora

Please note there is also a file called oracle_env.env and contains in info:$ cat oracle_env.env
LD_LIBRARY_PATH=/home/oracle/instantclient/instantclient_10_2
export LD_LIBRARY_PATH

TNS_ADMIN=/home/oracle/instantclient/instantclient_10_2
export TNS_ADMIN


Please guide me,i am getting unable to initialise plugin.

Typical Oracle script; loads itself into LD_LIBRARY_PATH and leaves out everything else.
What it should be is You will just need to find where lib32 is - typically $ORACLE_HOME/lib