oracle instant client and datastage connection help

dsecom · Post by **dsecom** » Fri Mar 09, 2007 3:02 am

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.

kumar_s · Post by **kumar_s** » Fri Mar 09, 2007 3:10 am

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

kumar_s · Post by **kumar_s** » Fri Mar 09, 2007 3:13 am

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

dsecom · Post by **dsecom** » Fri Mar 09, 2007 3:15 am

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.

kumar_s · Post by **kumar_s** » Fri Mar 09, 2007 3:18 am

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

dsecom · Post by **dsecom** » Fri Mar 09, 2007 3:22 am

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

kumar_s · Post by **kumar_s** » Fri Mar 09, 2007 3:50 am

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.

kumar_s · Post by **kumar_s** » Fri Mar 09, 2007 3:55 am

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

dsecom · Post by **dsecom** » Fri Mar 09, 2007 4:02 am

Thanks,

dsecom · Post by **dsecom** » Fri Mar 09, 2007 4:03 am

Thanks,

kumar_s · Post by **kumar_s** » Fri Mar 09, 2007 4:18 am

Is the double Thanks for my double post?

dsecom · Post by **dsecom** » Fri Mar 09, 2007 4:37 am

Thanks,

kumar_s · Post by **kumar_s** » Fri Mar 09, 2007 4:39 am

You got to be kidding.

dsecom · Post by **dsecom** » Fri Mar 09, 2007 6:19 am

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.

ray.wurlod · Post by **ray.wurlod** » Fri Mar 09, 2007 7:53 am

Typical Oracle script; loads itself into LD_LIBRARY_PATH and leaves out everything else.
What it should be is

Code: Select all

LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/home/oracle/instantclient/instantclient_10_2; export LIBRARY_PATH

You will just need to find where lib32 is - typically $ORACLE_HOME/lib