Cannot connect to Oracle database
Posted: 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.
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.