oracle instant client and datastage connection help

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

The is no lib directory.
This is what i can see in home oracle home directory.
$ pwd
/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

People can make coonection to this oracle database.Not using datastage.

kcbland · Post by **kcbland** » Fri Mar 09, 2007 8:49 am

Instant client is not configured like the normal Oracle client. Your bin, lib, network directories are all in one. DS assumes that the tnsnames.ora file will be located in $ORACLE_HOME/network/admin. You need to point all environment variables at the one install directory. In order to "fool" DataStage into finding the tnsnames.ora file, consider creating subdirectory network/admin and deposit a symbolic link pointing to the real tnsnames.ra file.

You're attempting to use the non-supported client, consider installing the normal Oracle client. There's no excuse, it's free to download.

chulett · Post by **chulett** » Fri Mar 09, 2007 8:50 am

That's because you don't have a full client installed - you have that new fangled "instant client" that is new with 10G. Search the forum and see if anyone has mentioned successfully using the Instant Client with DataStage.

kcbland · Post by **kcbland** » Fri Mar 09, 2007 8:52 am

Unfortunately I answered a previous post and didn't clarify that you need normal Oracle client, I just stated that set ORACLE_HOME and 32bit client was needed.

kumar_s · Post by **kumar_s** » Fri Mar 09, 2007 9:01 am

Kenneth, would ODBC help by any chance in this case. I am as curious as OP.

kcbland · Post by **kcbland** » Fri Mar 09, 2007 9:04 am

There are two choices for "talking" to Oracle: OCI or ODBC. Choose one, follow the configuration/compatibility rules.

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

Does ODBC require Oracle client installation default folders to establish connection. As I could see that dsenv should be set with same Lib path.

ray.wurlod · Post by **ray.wurlod** » Fri Mar 09, 2007 10:12 am

As far as I am aware most ODBC drivers for Oracle end up using the OCI (that is, the "full client"). Certainly this is the case with the non-wire Data Direct drivers that ship with DataStage.

chulett · Post by **chulett** » Fri Mar 09, 2007 11:10 am

You can use the Oracle wire drivers that ship with the product, they do not require a client.