Cannot connect to Oracle database

rupeshg · Post by **rupeshg** » Wed Jul 14, 2010 4:13 pm

DataStage 8.1
Redhat Linux 5
Oracle 10g Client

dsenv content:

ORACLE_HOME=/home/oracle/oracle/product/10.2.0/db_1; export ORACLE_HOME

LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$APT_ORCHHOME/lib; export LD_LIBRARY_PATH
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib32:$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib:$ORACLE_HOME/network/lib; export LD_LIBRARY_PATH

PATH=$PATH:$APT_ORCHHOME/bin; export PATH
PATH=$PATH:$ORACLE_HOME/bin; export PATH

Content of PXEngine/lib:

[root@Infosphere lib]# pwd
/opt/IBM/InformationServer/PXEngine/lib

[root@Infosphere lib]# ls -la orchoracle*
lrwxrwxrwx 1 root root 64 Jul 14 21:45 orchoracle.so -> /opt/IBM/InformationServer/Server/DSComponents/bin/orchoracle.so

Content of Oracle Home:

[root@Infosphere db_1]# pwd
/home/oracle/oracle/product/10.2.0/db_1

[root@Infosphere lib]# ls -la libclntsh*
lrwxrwxrwx 1 oracle oinstall 61 Jul 14 11:15 libclntsh.so -> /home/oracle/oracle/product/10.2.0/db_1/lib/libclntsh.so.10.1
-rwxrwxrw- 1 oracle oinstall 20706597 Jul 14 11:12 libclntsh.so.10.1

Content of DSComponent directory:

[root@Infosphere bin]# pwd
/opt/IBM/InformationServer/Server/DSComponents/bin

[root@Infosphere bin]# ls -la *orchorac*
-rwxr-xr-x 1 dsadm dstage 1022947 Jul 5 19:01 liborchoracle10gi686.so
-rwxr-xr-x 1 dsadm dstage 1022945 Jul 5 19:01 liborchoracle9ii686.so
lrwxrwxrwx 1 root root 23 Jul 14 16:50 orchoracle.so -> liborchoracle10gi686.so

Environment Variable:

PATH=
/usr/kerberos/bin:/usr/local/bin:/bin:/opt/IBM/InformationServer/Server/PXEngine/bin:/usr/bin:/opt/IBM/InformationServer/Server/DSComponents/bin:/usr/X11R6/b

in:/home/oracle/oracle/product/10.2.0/db_1/bin:.

LD_LIBRARY_PATH=
/usr/lib:/opt/IBM/InformationServer/Server/PXEngine/lib:/home/oracle/oracle/product/10.2.0/db_1/lib:.

User defined environment variable:

ORACLE_HOME=
/home/oracle/oracle/product/10.2.0/db_1

ORACLE_SID=
XE

Login User added:

dsusr1 with dsadm user credentials.

Description:

Cannot connect to Oracle database.

Error: (same old error of orachoracle.so)

##I IIS-DSEE-TFCN-00001 22:53:59(000) <main_program>
IBM WebSphere DataStage Enterprise Edition 8.1.0.5447
Copyright (c) 2001, 2005-2008 IBM Corporation. All rights reserved

##I IIS-DSEE-TFCN-00006 22:53:59(001) <main_program> conductor uname: -s=Linux; -r=2.6.18-194.8.1.el5xen; -v=#1 SMP Thu Jul 1 19:41:05 EDT 2010; -

n=Infosphere.stirling.com; -m=x86_64
##I IIS-DSEE-TOSH-00002 22:53:59(002) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 22:53:59(003) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 22:54:00(000) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 22:54:00(001) <main_program> Parameter specified but not used in flow: DSProjectMapName
>##E IIS-DSEE-TOSH-00205 22:54:00(002) <main_program> PATH search failure:
>##E IIS-DSEE-TFOG-00006 22:54:00(003) <main_program> Error loading "orchoracle": Could not load "orchoracle": libclntsh.so.10.1: cannot open shared object

file: No such file or directory.
>##E IIS-DSEE-TOSH-00384 22:54:00(004) <main_program> Could not locate operator definition, wrapper, or Unix command for "oraread"; please check that all

needed libraries are preloaded, and check the PATH for the wrappers
>##E IIS-DSEE-TCOS-00029 22:54:00(005) <main_program> Creation of a step finished with status = FAILED.

Additional:

I have already ran the install.liborchoracle under DSComponents/install directory, didn't work.

Could someone tell me if I am missing something here, to work it right?

Thanks in advance.

lstsaur · Post by **lstsaur** » Wed Jul 14, 2010 4:54 pm

Did it work when you ran the install.liborchoracle?

rupeshg · Post by **rupeshg** » Wed Jul 14, 2010 4:58 pm

As I mentioned earlier, it didn't work.

Thanks for your quick reply though.

lstsaur · Post by **lstsaur** » Wed Jul 14, 2010 11:15 pm

So that means the script install.liborchoracle has not been fixed since 8.0.
You have two options to fix this problem:

1. Fix the logic for handling "10g" in the script. In the past I have walked somebody through where the logic needed to be modified. So do a search on "orchoracle".
OR
2. Deinstall your 10g client and install the 9i client and then run the same install.liborchoracle.

Entries in the dsenv and environment variables are correct.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Jul 15, 2010 7:18 am

Does the datastage user have permission to access the library directories ?

Did you bounce DataStage after installing the libraries ? Did you check whether the libraries reside in the right place ?

chulett · Post by **chulett** » Thu Jul 15, 2010 7:49 am

I'd wager you are missing a soft link from where the file actually is to where DataStage is expecting to find it. I've seen it, the solution is posted here somewhere or you can involve your official support provider.

rupeshg · Post by **rupeshg** » Thu Jul 15, 2010 9:11 am

Does the datastage user have permission to access the library directories ?

Yes, dsadm user belongs to dstage group for datastage and oinstall group for oracle access. I did not use dba group because oracle client was installed using oinstall group and hence the oracle libraries are owned by oracle:oinstall.

Did you bounce DataStage after installing the libraries ?

As mentioned earlier, datastage engine was not running when libraries were installed. Engine was started after the installation of libraries.

Did you check whether the libraries reside in the right place ?

Yes, they so reside in proper directory - under /opt/IBM/InformationServer/Server/DSComponents/bin

..you are missing a soft link from where the file actually is to where DataStage is expecting to find it..

I have posted all the symbolic links that are there in current setup, don't think anything is missing.

Also, trying to get IBM tech support involved in this, along side.

Thanks for your replies.