DSXchange

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.

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.

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.

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.

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

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

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

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.

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