Error Oracle Connectivity

anguila09 · Post by **anguila09** » Thu Mar 22, 2012 9:30 am

[dsadm@XXXXXXXXXXXX ~]$ export
declare -x COPERR="/usr/lib"
declare -x COPLIB="/usr/lib"
declare -x G_BROKEN_FILENAMES="1"
declare -x HISTSIZE="1000"
declare -x HOME="/home/dsadm"
declare -x HOSTNAME="g500603sv458"
declare -x INCLUDE="/u03/sybaseiq/OCS-15_0/include:"
declare -x INPUTRC="/etc/inputrc"
declare -x LANG="en_US"
declare -x LD_LIBRARY_PATH="/u03/sybaseiq/OCS-15_0/lib:/u03/sybaseiq/OCS-15_0/lib3p:"
declare -x LESSOPEN="|/usr/bin/lesspipe.sh %s"
declare -x LIB="/u03/sybaseiq/OCS-15_0/lib:"
declare -x LOGNAME="dsadm"
declare -x MAIL="/var/spool/mail/dsadm"
declare -x OLDPWD
declare -x PATH="/u03/sybaseiq/OCS-15_0/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/bin:/home/dsadm/bin"
declare -x PWD="/home/dsadm"
declare -x SHELL="/bin/bash"
declare -x SHLVL="1"
declare -x SSH_ASKPASS="/usr/libexec/openssh/gnome-ssh-askpass"
declare -x SSH_CLIENT="10.30.229.90 1678 22"
declare -x SSH_CONNECTION="10.30.229.90 1678 172.18.148.212 22"
declare -x SSH_TTY="/dev/pts/2"
declare -x SYBASE="/u03/sybaseiq"
declare -x SYBASE_OCS="OCS-15_0"
declare -x TD_ICU_DATA="/opt/teradata/tdicu/lib"
declare -x TERM="xterm"
declare -x USER="dsadm"
[dsadm@XXXXXXXXXXXX~]$

qt_ky · Post by **qt_ky** » Thu Mar 22, 2012 8:27 pm

When you say "Ping to DB is ok" do you mean ping command to the database server? Make sure tnsping works too:

From the Linux command line, source your dsenv file as follows:

Code: Select all

. ./dsenv

Then try Oracle's tnsping command on the database name.

anguila09 · Post by **anguila09** » Fri Mar 23, 2012 6:01 am

tks for the answerd yes i do it that way

Code: Select all

[dsadm@XXXXXXXXXXXX ~]$ sudo su
[root@XXXXXXXXXXXXdsadm]# cd /u02/IBM/InformationServer/Server/DSEngine/
[root@XXXXXXXXXXXXDSEngine]# . ./dsenv
[root@XXXXXXXXXXXXDSEngine]# tnsping g100603sv242

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 23-MAR-2012 08:54:31

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

Used parameter files:

Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=g100603sv242.XXXXXXXXXXXX.corp))(ADDRESS=(PROTOCOL=TCP)(HOST=XX.XX.X.XXX)(PORT=XXXX)))
TNS-12541: TNS:no listener
[root@XXXXXXXXXXXXDSEngine]#

and

Code: Select all

[oracle@XXXXXXXXXXXX ~]$ tnsping g100603sv242:1550

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 23-MAR-2012 09:01:04

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

Used parameter files:

Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=g100603sv242.XXXXXXXXXXXX .corp))(ADDRESS=(PROTOCOL=TCP)(HOST=XX.XX.X.XXX)(PORT=XXXX)))
OK (70 msec)
[oracle@XXXXXXXXXXXX ~]$

and this is the error in ds Designer

ds_loadlibrary: error in dlopen of oraoci9.so - libclntsh.so.10.1: cannot open shared object file: No such file or directory

qt_ky · Post by **qt_ky** » Fri Mar 23, 2012 8:16 am

OK, take it one step at a time. Since your tnsping command produced this error: "TNS-12541: TNS:no listener"

...coming from the DataStage server, then don't bother trying to connect from DataStage just yet.

Either:
- the tnsnames.ora entry is incorrect and/or
- there is a firewall blocking the communication between the two servers

Check those next.

qt_ky · Post by **qt_ky** » Fri Mar 23, 2012 8:25 am

As far as your dsenv file goes, I have checked mine and see a few
small differences that should not matter.

The only Oracle settings I have in dsenv are:

export ORACLE_HOME=/opt/....
export NLS_LANG=<value> (don't see this one in yours)
$ORACLE_HOME/lib is the only Oracle setting in my library path.
$ORACLE_HOME/bin is the only Oracle setting in my PATH. You may have extra.

After making changes to dsenv, restart all the server processes
including the Node Agents (not only the DataStage engine).

I am guessing your dsenv file is fine and you have a firewall blockage.

anguila09 · Post by **anguila09** » Fri Mar 23, 2012 8:49 am

/u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora has the correct connection string for the database, i confirm this

mmm...
but if the "oracle user" does "tnsping" with the "user dsadm" not ... You think may be for firewall?

@edit

done!

Code: Select all

[root@XXXXXXXXXXXX DSEngine]# tnsping g100603sv242:1550

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 23-MAR-2012 11:44:06

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

Used parameter files:

Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=g100603sv242.XXXXXXXXXXXX .corp))(ADDRESS=(PROTOCOL=TCP)(HOST=XXXXXXXXXXXX )(PORT=1550)))
OK (70 msec)
[root@XXXXXXXXXXXX DSEngine]#

anguila09 · Post by **anguila09** » Fri Mar 23, 2012 9:01 am

sory but re-post ....

"Could not query forum moderator information"

in order .... I could not even fix

qt_ky · Post by **qt_ky** » Fri Mar 23, 2012 9:16 am

No, if all those tnsping outputs that worked you ran from the DataStage server, then the firewall should be OK.

Try the same working tnsping command from the dsadm ID.

I see you've got it to work as root and as the oracle user so far.

It's not clear yet if there is some permissions problem or something else.

What version of DataStage are you on?

Have you tried using the Oracle Connector stage?

qt_ky · Post by **qt_ky** » Fri Mar 23, 2012 9:21 am

By the way, your ulimit -n setting looks too low...

anguila09 · Post by **anguila09** » Fri Mar 23, 2012 9:32 am

tnsping whit "dsadm" result ok

the version of DataStage is 8.1.0.0

the Oracle Connector stage return:

ds_loadlibrary: error in dlopen of oraoci9.so - libclntsh.so.10.1: cannot open shared object file: No such file or directory

the same whit dinamic stage and odbc stage

qt_ky · Post by **qt_ky** » Fri Mar 23, 2012 9:49 am

There is a different IBM tech note about that error. Search on a few keywords from your error and post the link.

Basically it says the DataStage user has no read [or execute] permissions at all to the Oracle client
files and/or that the library path is not configured correctly.

I think your dsenv file is OK, but have you restarted all server processes?

In your Oracle client(s) bin and lib folders, make sure permissions
are open at the group and other level for read and execute.

anguila09 · Post by **anguila09** » Fri Mar 23, 2012 10:12 am

yes i restart the server.

Code: Select all

[dsadm@XXXXXXXXXXXX~]$ uptime
 13:09:04 up 2 days, 20:25,  6 users,  load average: 1.03, 1.07, 1.08

Code: Select all

[dsadm@XXXXXXXXXXXX~]$ ls -l
total 84
drwxr-xr-x 2 dsadm dstage  4096 Aug 26  2011 ArchivosMigracion
drwxr-xr-x 2 dsadm dstage  4096 Mar  2 12:50 copia
drwxr-xr-x 2 dsadm dstage  4096 Mar  2 12:50 de
-rw------- 1 dsadm dstage 49047 Mar  8 08:22 dead.letter
drwxrwxr-x 2 dsadm dstage  4096 Aug 31  2011 ds_logs
drwxr-xr-x 2 dsadm dstage  4096 Jun 14  2011 DTS
-rw------- 1 dsadm dstage  9766 Mar 13 17:23 mbox
drwxr-xr-x 2 dsadm dstage  4096 Mar  2 12:50 seguridad
[dsadm@XXXXXXXXXXXX~]$

Code: Select all

[dsadm@XXXXXXXXXXXX~]$ cd /u01/app/oracle/product/10.2.0/db_1
[dsadm@XXXXXXXXXXXXdb_1]$ ls -l
total 220
drwxr-x---  3 oracle oinstall 4096 Mar 24  2011 assistants
drwxr-xr-x  2 oracle oinstall 4096 Mar 24  2011 bin
drwxr-x---  3 oracle oinstall 4096 Mar 24  2011 cdata
drwxr-x---  4 oracle oinstall 4096 Mar 24  2011 cfgtoollogs
drwxr-x---  3 oracle oinstall 4096 Mar 24  2011 classes
drwxr-x---  6 oracle oinstall 4096 Mar 24  2011 crs
drwxr-x---  7 oracle oinstall 4096 Mar 24  2011 css
drwxr-x---  3 oracle oinstall 4096 Mar 24  2011 diagnostics
drwxr-x---  3 oracle oinstall 4096 Mar 24  2011 has
drwxr-x---  5 oracle oinstall 4096 Mar 24  2011 hs
drwxr-x---  3 oracle oinstall 4096 Mar 24  2011 install
-rw-r-----  1 oracle oinstall   37 Mar 24  2011 install.platform
drwxr-x---  3 oracle oinstall 4096 Mar 24  2011 instantclient
drwxr-x--- 12 oracle oinstall 4096 Mar 24  2011 inventory
drwxr-x---  2 oracle oinstall 4096 Mar 24  2011 jar
drwxr-x---  6 oracle oinstall 4096 Mar 24  2011 javavm
drwxr-x---  4 oracle oinstall 4096 Mar 24  2011 jdbc
drwxr-x---  9 oracle oinstall 4096 Mar 24  2011 jdk
drwxr-x---  2 oracle oinstall 4096 Mar 24  2011 jlib
drwxr-x---  3 oracle oinstall 4096 Mar 24  2011 jpub
drwxr-x---  3 oracle oinstall 4096 Mar 24  2011 jre
drwxr-x--- 14 oracle oinstall 4096 Mar 24  2011 ldap
drwxr-x---  3 oracle oinstall 4096 Mar 24  2011 lib
drwxr-x---  3 oracle oinstall 4096 Oct  3 19:04 lib32
drwxr-x--- 12 oracle oinstall 4096 Mar 24  2011 network
drwxr-x---  6 oracle oinstall 4096 Mar 24  2011 nls
drwxr-x---  6 oracle oinstall 4096 Mar 24  2011 odbc
drwxr-x---  7 oracle oinstall 4096 Mar 24  2011 olap
drwxr-x---  4 oracle oinstall 4096 Mar 24  2011 OPatch
drwxr-x---  7 oracle oinstall 4096 Mar 24  2011 opmn
drwxr-x---  4 oracle oinstall 4096 Mar 24  2011 oracore
-rw-r--r--  1 oracle oinstall   63 Mar 24  2011 oraInst.loc
drwxr-x---  5 oracle oinstall 4096 Mar 24  2011 ord
drwxr-x---  7 oracle oinstall 4096 Mar 24  2011 oui
drwxr-x---  4 oracle oinstall 4096 Mar 24  2011 owm
drwxr-x---  6 oracle oinstall 4096 Mar 24  2011 perl
drwxr-x---  7 oracle oinstall 4096 Mar 24  2011 plsql
drwxr-x---  9 oracle oinstall 4096 Mar 24  2011 precomp
drwxr-x---  4 oracle oinstall 4096 Mar 24  2011 racg
drwxr-x--- 10 oracle oinstall 4096 Mar 24  2011 rdbms
drwxr-x---  5 oracle oinstall 4096 Mar 24  2011 relnotes
-rwxr-xr-x  1 oracle oinstall 6040 Mar 24  2011 root.sh
-rwxr-xr-x  1 oracle oinstall    0 Jun  7  2005 root.sh.old
drwxr-x---  3 oracle oinstall 4096 Mar 24  2011 slax
drwxr-x---  4 oracle oinstall 4096 Mar 24  2011 sqlj
drwxr-x---  6 oracle oinstall 4096 Mar 24  2011 sqlplus
drwxr-x---  8 oracle oinstall 4096 Mar 24  2011 srvm
drwxr-x--- 11 oracle oinstall 4096 Mar 24  2011 sysman
drwxr-x---  3 oracle oinstall 4096 Mar 24  2011 tg4ifmx
drwxr-x---  3 oracle oinstall 4096 Mar 24  2011 tg4ingr
drwxr-x---  3 oracle oinstall 4096 Mar 24  2011 tg4sybs
drwxr-x---  3 oracle oinstall 4096 Mar 24  2011 tg4tera
drwxr-x---  4 oracle oinstall 4096 Mar 24  2011 uix
drwxr-x---  3 oracle oinstall 4096 Mar 24  2011 wwg
drwxr-x---  6 oracle oinstall 4096 Mar 24  2011 xdk
[dsadm@XXXXXXXXXXXXdb_1]$

Code: Select all

[dsadm@XXXXXXXXXXXXdb_1lib]$ pwd
/u01/app/oracle/product/10.2.0/db_1/lib
[dsadm@XXXXXXXXXXXXdb_1lib]$ ls -l
total 140244
-rw-r----- 1 oracle oinstall    45386 Oct 23  2001 activation.jar
-rw-r----- 1 oracle oinstall    37584 Sep 20  2005 classgen.jar
-rw-r----- 1 oracle oinstall  3365217 Mar 24  2011 clntsh.map
-rw-r----- 1 oracle oinstall     3007 Jun 13  2005 facility.lis
-rw-r----- 1 oracle oinstall    86093 Sep 19  2005 hsdb_odbc.so
-rw-r----- 1 oracle oinstall   170372 Sep 19  2005 hsdb_ora.so
-rw-r----- 1 oracle oinstall    56899 Sep 25  2000 jdev-rt.zip
-rw-r----- 1 oracle oinstall   241976 Oct 18  2005 lclasses12.zip
-rw-r----- 1 oracle oinstall      111 Mar 24  2011 ldflags
-rw-r----- 1 oracle oinstall      111 Mar 24  2011 ldflagsO
-rw-r----- 1 oracle oinstall  1109530 Sep 17  2005 libagent10.a
lrwxrwxrwx 1 oracle oinstall       15 Mar 24  2011 libagtsh.so -> libagtsh.so.1.0
-rwxr-x--- 1 oracle oinstall  4987412 Mar 24  2011 libagtsh.so.1.0
-rw-r----- 1 oracle oinstall  5645096 Oct 17  2005 libclient10.a
lrwxrwxrwx 1 oracle oinstall       57 Mar 24  2011 libclntsh.so -> /u01/app/oracle/product/10.2.0/db_1/lib/libclntsh.so.10.1
-rwxrwxrwx 1 oracle oinstall 20706597 Mar 24  2011 libclntsh.so.10.1
-rw-r----- 1 oracle oinstall        0 Oct 22  2005 libclntst10.a
-rw-r----- 1 oracle oinstall    61985 Oct 18  2005 libclsra10.so
-rw-r----- 1 oracle oinstall    26674 Oct 18  2005 libclsrx10.a
-rw-r----- 1 oracle oinstall  1850160 Sep 19  2005 libcommon10.a
-rw-r----- 1 oracle oinstall  3082954 Oct 20  2005 libcore10.a
-rw-r----- 1 oracle oinstall  1060988 Oct 18  2005 libcorejava.so
-rw-r----- 1 oracle oinstall  1353209 Oct 20  2005 libcoresh10.so
-rw-r----- 1 oracle oinstall  1048531 Aug 29  2005 libcprts.so.5
-rw-r----- 1 oracle oinstall     3848 Aug 29  2005 libcxaguard.so.5
-rw-r----- 1 oracle oinstall   241125 Jun 13  2005 libcxa.so.3
-rw-r----- 1 oracle oinstall   246079 Aug 29  2005 libcxa.so.5
-rw-r----- 1 oracle oinstall   147314 Oct 18  2005 libdbcfg10.a
-rw-r----- 1 oracle oinstall   120809 Oct 18  2005 libdbcfg10.so
-rw-r----- 1 oracle oinstall    58233 Oct 18  2005 libemmas10.so
-rwxr-xr-x 1 oracle oinstall   272682 Sep  2  2004 libexpat.a
-rwxr-xr-x 1 oracle oinstall      749 Sep  2  2004 libexpat.la
-rwxr-xr-x 1 oracle oinstall   243272 Sep  2  2004 libexpat.so
-rwxr-xr-x 1 oracle oinstall   243272 Sep  2  2004 libexpat.so.0
-rwxr-xr-x 1 oracle oinstall   243272 Sep  2  2004 libexpat.so.0.5.0
-rw-r----- 1 oracle oinstall 12178416 Oct 17  2005 libgeneric10.a
-rw-r----- 1 oracle oinstall  1745769 Oct 18  2005 libhasgen10.so
-rw-r----- 1 oracle oinstall    65193 Sep 17  2005 libheteroxa10.so
-rw-r----- 1 oracle oinstall  2385393 Sep 19  2005 libhsbase.so
-rw-r----- 1 oracle oinstall  2363045 Sep 19  2005 libhsnav.so
-rw-r----- 1 oracle oinstall  1572515 Oct 20  2005 libimf.so
-rw-r----- 1 oracle oinstall   331398 Aug 29  2005 libirc.a
-rw-r----- 1 oracle oinstall  1172074 Sep  9  2005 libldapclnt10.a
-rw-r----- 1 oracle oinstall    27994 Sep  9  2005 libldapjclnt10.a
-rw-r----- 1 oracle oinstall    74881 Sep 13  2005 libldapjclnt10.so
-rw-r----- 1 oracle oinstall    77800 Sep 10  2005 liblxled.a
-rw-r----- 1 oracle oinstall     2258 Sep 17  2005 libmm.a
-rw-r----- 1 oracle oinstall  3246298 Mar 24  2011 libn10.a
-rw-r----- 1 oracle oinstall  1325538 Sep 19  2005 libnavhoa.a
-rw-r----- 1 oracle oinstall    36926 Sep 17  2005 libnbeq10.a
-rw-r----- 1 oracle oinstall   176252 Oct 17  2005 libncrypt10.a
-rw-r----- 1 oracle oinstall     9218 Sep 17  2005 libnhost10.a
-rw-r----- 1 oracle oinstall  2361369 Oct 20  2005 libnjni10.so
-rw-r----- 1 oracle oinstall  2638009 Oct 20  2005 libnjssl10.so
-rw-r----- 1 oracle oinstall   592158 Sep 17  2005 libnl10.a
-rw-r----- 1 oracle oinstall   101488 Sep 17  2005 libnldap10.a
-rw-r----- 1 oracle oinstall  1904248 Oct 18  2005 libnls10.a
-rw-r----- 1 oracle oinstall  4509046 Sep  8  2005 libnmemso.so
-rw-r----- 1 oracle oinstall   138594 Sep  8  2005 libnmeoci.so
-rw-r----- 1 oracle oinstall    16692 Sep 17  2005 libnnet10.a
-rw-r----- 1 oracle oinstall    16692 Sep 17  2005 libnnetd10.a
-rw-r----- 1 oracle oinstall  7815540 Oct 17  2005 libnnz10.a
-rw-r----- 1 oracle oinstall  3803097 Oct 20  2005 libnnz10.so
-rw-r----- 1 oracle oinstall     5306 Sep 17  2005 libnoname10.a
-rw-r----- 1 oracle oinstall   606394 Sep 17  2005 libnro10.a
-rw-r----- 1 oracle oinstall    61560 Sep 17  2005 libnsgr10.a
-rw-r----- 1 oracle oinstall    61560 Sep 17  2005 libnsgrsh10.a
-rw-r----- 1 oracle oinstall     1508 Sep 17  2005 libnsslb10.a
-rw-r----- 1 oracle oinstall    73712 Sep 17  2005 libntcp10.a
-rw-r----- 1 oracle oinstall    91384 Sep 17  2005 libntcps10.a
-rw-r----- 1 oracle oinstall     2072 Sep 17  2005 libntcps10_std.a.dbl
-rw-r----- 1 oracle oinstall    13242 Sep 17  2005 libntns10.a
-rw-r----- 1 oracle oinstall    47246 Sep 17  2005 libnus10.a
-rw-r----- 1 oracle oinstall     4258 Sep 17  2005 libnzjs10.a
-rw-r----- 1 oracle oinstall  1752124 Oct  4  2005 libocci10_296.a
-rw-r----- 1 oracle oinstall  1259357 Oct  4  2005 libocci10_296.so.10.1
-rw-r----- 1 oracle oinstall  2425378 Oct 19  2005 libocci10.a
lrwxrwxrwx 1 oracle oinstall       15 Mar 24  2011 libocci.so -> libocci.so.10.1
-rw-r----- 1 oracle oinstall  1664132 Oct 20  2005 libocci.so.10.1
-rw-r----- 1 oracle oinstall   137905 Sep 17  2005 libocijdbc10.so
-rw-r----- 1 oracle oinstall   109742 Aug 31  2005 libocijdbcst10.a
-rw-r----- 1 oracle oinstall  1005278 Oct 18  2005 libocr10.a
-rw-r----- 1 oracle oinstall   636161 Oct 18  2005 libocr10.so
-rw-r----- 1 oracle oinstall   960126 Oct 18  2005 libocrb10.a
-rw-r----- 1 oracle oinstall   657825 Oct 18  2005 libocrb10.so
-rw-r----- 1 oracle oinstall   101700 Oct 18  2005 libocrutl10.a
-rw-r----- 1 oracle oinstall   513705 Oct 18  2005 libocrutl10.so
-rw-r----- 1 oracle oinstall  1544306 Oct 18  2005 liboevm.a
-rwxr-xr-x 1 oracle oinstall    83493 Sep 15  2005 libons.so
-rw-r----- 1 oracle oinstall    14769 Sep 13  2005 libOsUtils.so
-rw-r----- 1 oracle oinstall  2348601 Oct 20  2005 libowm2.so
-rw-r----- 1 oracle oinstall   159976 Sep 17  2005 libplc10.a
-rw-r----- 1 oracle oinstall  4808418 Sep 19  2005 libplp10.a
-rw-r----- 1 oracle oinstall  8658080 Oct 22  2005 libpls10.a
-rw-r----- 1 oracle oinstall   310888 Sep 17  2005 libpsa10.a
-rw-r----- 1 oracle oinstall     8545 Oct 20  2005 libskgxn2.so
-rw-r----- 1 oracle oinstall    10329 Oct 20  2005 libskgxp10.so
-rw-r----- 1 oracle oinstall    10329 Oct 20  2005 libskgxpd.so
-rw-r----- 1 oracle oinstall   173705 Sep 17  2005 libskgxpu.so
-rw-r----- 1 oracle oinstall    21240 Aug 30  2005 libslax10.a
-rw-r----- 1 oracle oinstall   222598 Sep 10  2005 libsnls10.a
-rw-r----- 1 oracle oinstall   835076 Aug 31  2005 libsql10.a
-rw-r----- 1 oracle oinstall  1572990 Sep  6  2005 libsqlplus.a
-rw-r----- 1 oracle oinstall   985473 Sep 13  2005 libsqlplus.so
-rw-r----- 1 oracle oinstall   835699 Sep 19  2005 libsqora.so.10.1
-rw-r----- 1 oracle oinstall    47473 Oct 18  2005 libsrvm10.so
-rw-r----- 1 oracle oinstall  1723529 Oct 18  2005 libsrvmhas10.so
-rw-r----- 1 oracle oinstall   659041 Oct 18  2005 libsrvmocr10.so
-rw-r----- 1 oracle oinstall    10182 Oct 18  2005 libuini10.a
-rw-r----- 1 oracle oinstall    40953 Oct 18  2005 libuini10.so
-rw-r----- 1 oracle oinstall   171246 Oct 18  2005 libunls10.a
-rw-r----- 1 oracle oinstall    46324 Aug 29  2005 libunwind.so.5
-rw-r----- 1 oracle oinstall     3074 Oct 20  2005 libvsn10.a
-rw-r----- 1 oracle oinstall     3050 Oct 20  2005 libvsn10_std.a.dbl
-rw-r----- 1 oracle oinstall   304176 Sep  2  2005 libwwg.a
-rw-r----- 1 oracle oinstall   372985 Sep 17  2005 libxdb.so
-rw-r----- 1 oracle oinstall  3758578 Oct 19  2005 libxml10.a
-rw-r----- 1 oracle oinstall   280984 Oct 23  2001 mail.jar
-rw-r----- 1 oracle oinstall     3064 Oct 20  2005 naect.o
-rw-r----- 1 oracle oinstall     1728 Oct 22  2005 naect_std.o.dbl
-rw-r----- 1 oracle oinstall     1370 Oct 20  2005 naedhs.o
-rw-r----- 1 oracle oinstall    12084 Oct 20  2005 naeet.o
-rw-r----- 1 oracle oinstall     6064 Oct 22  2005 naeet_std.o.dbl
-rw-r----- 1 oracle oinstall     1539 Sep 17  2005 nautab.o
-rw-r----- 1 oracle oinstall     1264 Sep 17  2005 nautab_std.o.dbl
-rw-r----- 1 oracle oinstall     8104 Sep 17  2005 nigcon.o
-rw-r----- 1 oracle oinstall     1934 Sep 17  2005 nigtab.o
-rw-r----- 1 oracle oinstall     1912 Mar 24  2011 nnfgt.o
-rw-r----- 1 oracle oinstall     2088 Mar 24  2011 ntcontab.o
-rw-r----- 1 oracle oinstall   148247 Sep 20  2005 oraclexsql.jar
-rw-r----- 1 oracle oinstall     1991 Sep 17  2005 osntabst.o
-rw-r----- 1 oracle oinstall     2688 Sep 17  2005 s0main.o
-rw-r----- 1 oracle oinstall     1486 Sep 17  2005 scorept.o
-rw-r--r-- 1 oracle oinstall    53389 Jan 14  2004 servlet.jar
-rw-r----- 1 oracle oinstall     1192 Sep 17  2005 sscoreed.o
drwxr-x--- 2 oracle oinstall     4096 Mar 24  2011 stubs
-rw-r----- 1 oracle oinstall       31 Oct 18  2005 sysliblist
-rw-r----- 1 oracle oinstall   102907 Sep 20  2005 transx.zip
-rw-r----- 1 oracle oinstall    11516 Sep 20  2005 xmlcomp2.jar
-rw-r----- 1 oracle oinstall    93098 Sep 20  2005 xmlcomp.jar
-rw-r----- 1 oracle oinstall   542864 Sep 20  2005 xml.jar
-rw-r----- 1 oracle oinstall   631000 Sep 20  2005 xmlmesg.jar
-rw-r----- 1 oracle oinstall  1210563 Sep 20  2005 xmlparserv2.jar
-rw-r----- 1 oracle oinstall   129375 Sep 20  2005 xschema.jar
-rw-r----- 1 oracle oinstall     3556 Sep 20  2005 xsqlserializers.jar
-rw-r----- 1 oracle oinstall   192572 Sep 20  2005 xsu12.jar
[dsadm@XXXXXXXXXXXXdb_1lib]$

Code: Select all

[dsadm@XXXXXXXXXXXXdb_1libbin]$ pwd
/u01/app/oracle/product/10.2.0/db_1/bin
[dsadm@XXXXXXXXXXXXdb_1libbin]$ ls -l
total 91212
-rwxr-xr-x 1 oracle oinstall    13093 Oct 20  2005 adapters
-rw-r----- 1 oracle oinstall     1566 Mar 24  2011 aqxmlctl
-rw-r----- 1 oracle oinstall     6768 Nov  4  2004 aqxmlctl.pl
lrwxrwxrwx 1 oracle oinstall       51 Mar 24  2011 awm -> /u01/app/oracle/product/10.2.0/db_1/olap/awm/awm.sh
-rwxr-xr-x 1 oracle oinstall     1687 Apr 28  2005 awm.bat
-rwxr-xr-x 1 oracle oinstall     1992 Mar 24  2011 bndlchk
-rwxr-xr-x 1 oracle oinstall     1692 Mar 24  2011 clscfg
-rwxr-xr-x 1 oracle oinstall   716367 Oct 20  2005 clscfg.bin
-rwxr-xr-x 1 oracle oinstall     1692 Mar 24  2011 clsfmt
-rwxr-xr-x 1 oracle oinstall   687684 Oct 20  2005 clsfmt.bin
-rwxr-xr-x 1 oracle oinstall     1692 Mar 24  2011 clsid
-rwxr-xr-x 1 oracle oinstall   613087 Oct 20  2005 clsid.bin
-rwxr-xr-x 1 oracle oinstall     2854 Jan  1  2000 coraenv
-rwxr-xr-x 1 oracle oinstall     1692 Mar 24  2011 crsctl
-rwxr-xr-x 1 oracle oinstall  3046447 Oct 20  2005 crsctl.bin
-rwxr-xr-x 1 oracle oinstall   364178 Oct 20  2005 csscan
-rwxr-xr-x 1 oracle oinstall        0 Jun 22  2005 csscanO
-rwxr-xr-x 1 oracle oinstall        0 Oct 22  2005 cursize
-rwxr-xr-x 1 oracle oinstall        0 Jun 22  2005 cursizeO
-rwxr-xr-x 1 oracle oinstall        0 Oct 22  2005 dbfsize
-rwxr-xr-x 1 oracle oinstall        0 Jun 22  2005 dbfsizeO
-rwxr-xr-x 1 oracle oinstall     2417 Jan  1  2000 dbhome
-rwxr-xr-x 1 oracle oinstall     4654 Jan  1  2000 dbshut
-rwxr-xr-x 1 oracle oinstall    10415 Jan  1  2000 dbstart
-rwxr-xr-x 1 oracle oinstall     1348 Mar 24  2011 deploync
-rwxr-x--x 1 oracle oinstall  2219579 Mar 24  2011 dgmgrl
-rwxr-xr-x 1 oracle oinstall        0 Oct 22  2005 dgmgrlO
-rwxr-xr-x 1 oracle oinstall      528 Mar 24  2011 dropjava
-rwxr-x--- 1 oracle oinstall   763215 Mar 24  2011 dsml2ldif
-rwxr-xr-x 1 oracle oinstall        0 Oct 22  2005 dumpsga
-rwxr-xr-x 1 oracle oinstall        0 Jun 22  2005 dumpsga0
-rwxr-xr-x 1 oracle oinstall      153 Jun 13  2005 echodo
-rwxr-xr-x 1 oracle oinstall     1812 Mar 24  2011 emca
-rwxr-xr-x 1 oracle oinstall     4234 Mar 24  2011 esm
-rwxr-x--x 1 oracle oinstall   696556 Mar 24  2011 exp
-rwxr-x--x 1 oracle oinstall   201895 Mar 24  2011 expdp
-rwxr-xr-x 1 oracle oinstall        0 Oct 22  2005 expdpO
-rwxr-xr-x 1 oracle oinstall        0 Oct 22  2005 expO
-rwxr-xr-x 1 oracle oinstall    52615 Oct 20  2005 extjob
-rwxr-xr-x 1 oracle oinstall    52615 Oct 20  2005 extjobo
-rwxr-xr-x 1 oracle oinstall        0 Jun 22  2005 extjobO
-rwxr-xr-x 1 oracle oinstall        0 Jun 22  2005 extjoboO
-rw-r----- 1 oracle oinstall    29753 Oct 20  2005 extproc32
-rwxr-xr-x 1 oracle oinstall     4865 Sep 23  2005 genagtsh
-rwxr-xr-x 1 oracle oinstall     9668 Sep 26  2005 genclntsh
-rwxr-xr-x 1 oracle oinstall     5146 Jun 23  2005 genclntst
-rwxr-x--x 1 oracle oinstall    64742 Mar 24  2011 genezi
-rwxr-xr-x 1 oracle oinstall    65476 Oct 20  2005 geneziO
-rwxr-xr-x 1 oracle oinstall     2893 Oct 20  2005 gennfgt
-rwxr-xr-x 1 oracle oinstall     4902 Oct 20  2005 gennttab
-rwxr-xr-x 1 oracle oinstall     2733 Sep 13  2005 genoccish
-rwxr-xr-x 1 oracle oinstall     9544 Sep 13  2005 genorasdksh
-rwxr-xr-x 1 oracle oinstall     2318 Jan  1  2000 gensyslib
-rwxr-xr-x 1 oracle oinstall   680610 Jun 22  2005 gsd
-rwxr-xr-x 1 oracle oinstall     4279 Mar 24  2011 gsdctl
-rwxr-xr-x 1 oracle oinstall     4716 Mar 24  2011 gsd.sh
-rwxr-xr-x 1 oracle oinstall     2134 Feb 16  2003 helpins
-rwxr-x--x 1 oracle oinstall   352898 Mar 24  2011 imp
-rwxr-x--x 1 oracle oinstall   206911 Mar 24  2011 impdp
-rwxr-xr-x 1 oracle oinstall        0 Oct 22  2005 impdpO
-rwxr-xr-x 1 oracle oinstall        0 Oct 22  2005 impO
-r-xr-xr-x 1 oracle oinstall     1586 Mar 24  2011 jpub
-rwxr-x--x 1 oracle oinstall   428694 Mar 24  2011 kgmgr
-rwxr-xr-x 1 oracle oinstall   443700 Oct 20  2005 kgmgrO
-rwxr-xr-x 1 oracle oinstall  3714174 Oct 20  2005 kgpmon
lrwxrwxrwx 1 oracle oinstall       57 Mar 24  2011 lbuilder -> /u01/app/oracle/product/10.2.0/db_1/nls/lbuilder/lbuilder
-rwxr-xr-x 1 oracle oinstall  1071118 Oct 20  2005 lcsscan
-rwxr-x--- 1 oracle oinstall   780021 Mar 24  2011 ldapadd
-rwxr-x--- 1 oracle oinstall   793376 Mar 24  2011 ldapaddmt
-rwxr-x--- 1 oracle oinstall   707333 Mar 24  2011 ldapbind
-rwxr-x--- 1 oracle oinstall   707263 Mar 24  2011 ldapcompare
-rwxr-x--- 1 oracle oinstall   707470 Mar 24  2011 ldapdelete
-rwxr-x--- 1 oracle oinstall   707090 Mar 24  2011 ldapmoddn
-rwxr-x--- 1 oracle oinstall   780021 Mar 24  2011 ldapmodify
-rwxr-x--- 1 oracle oinstall   793376 Mar 24  2011 ldapmodifymt
-rwxr-x--- 1 oracle oinstall   729235 Mar 24  2011 ldapsearch
-rwxr-xr-x 1 oracle oinstall     1875 Mar 24  2011 ldifmigrator
-rwxr-xr-x 1 oracle oinstall     1176 Jun 13  2005 linkshlib
-rwxr-xr-x 1 oracle oinstall   879853 Oct 20  2005 lmsgen
-rwxr-xr-x 1 oracle oinstall      569 Mar 24  2011 loadjava
-rwxr-x--x 1 oracle oinstall    16130 Mar 24  2011 loadpsp
-rwxr-xr-x 1 oracle oinstall    16784 Oct 20  2005 loadpspO
-rwxr-xr-x 1 oracle oinstall    21970 Mar 24  2011 localconfig
-rwxr-xr-x 1 oracle oinstall   538730 Oct 20  2005 lxchknlb
-rwxr-xr-x 1 oracle oinstall   927065 Oct 20  2005 lxegen
-rwxr-xr-x 1 oracle oinstall  2443419 Oct 20  2005 lxinst
-rwxr-xr-x 1 oracle oinstall        0 Oct 22  2005 mapsga
-rwxr-xr-x 1 oracle oinstall        0 Jun 22  2005 mapsga0
-rwxr-xr-x 1 oracle oinstall        0 Oct 22  2005 maxmem
-rwxr-xr-x 1 oracle oinstall        0 Jun 22  2005 maxmemO
-rwxr-xr-x 1 oracle oinstall     2230 Mar 24  2011 mkstore
-rwxr-xr-x 1 oracle oinstall   188278 Oct 20  2005 mkwallet
-rwxr-xr-x 1 oracle oinstall  6778983 Oct 20  2005 modada
-rwxr-xr-x 1 oracle oinstall     1347 Mar 24  2011 ncomp
-rwxr-xr-x 1 oracle oinstall     6417 Mar 24  2011 netca
-rwxr-xr-x 1 oracle oinstall      110 Mar 24  2011 netca_deinst.sh
-rwxr-xr-x 1 oracle oinstall     6229 Mar 24  2011 netmgr
-rwxr-xr-x 1 oracle oinstall   360891 Sep 11  2005 nmei
-rwxr-xr-x 1 oracle oinstall     1692 Mar 24  2011 oclsmon
-rwxr-xr-x 1 oracle oinstall   629312 Oct 20  2005 oclsmon.bin
-rwxr-xr-x 1 oracle oinstall      137 Mar 24  2011 ocm
-rwxr-xr-x 1 oracle oinstall       61 Mar  7  2002 ocm_oratclsh
-rwxr-xr-x 1 oracle oinstall     1692 Mar 24  2011 ocrcheck
-rwxr-xr-x 1 oracle oinstall   639760 Oct 18  2005 ocrcheck.bin
-rwxr-xr-x 1 oracle oinstall      584 Mar 24  2011 ocrconfig
-rwxr-xr-x 1 oracle oinstall   713619 Oct 18  2005 ocrconfig.bin
-rwxr-xr-x 1 oracle oinstall     1692 Mar 24  2011 ocrdump
-rwxr-xr-x 1 oracle oinstall   669384 Oct 18  2005 ocrdump.bin
-rwxr-xr-x 1 oracle oinstall     1692 Mar 24  2011 ocssd
-rwxr-xr-x 1 oracle oinstall  1380464 Oct 20  2005 ocssd.bin
-rwxr-xr-x 1 oracle oinstall     1005 Mar 24  2011 odisrvreg
-rwxr-xr-x 1 oracle oinstall     4968 Mar 24  2011 oemapp
-rwxr-xr-x 1 oracle oinstall     2365 Jan  1  2000 oerr
-rwxr-xr-x 1 oracle oinstall     2024 Mar 24  2011 oidadmin
-rwxr-xr-x 1 oracle oinstall     2176 Mar 24  2011 oidca
-rwxr-xr-x 1 oracle oinstall     2150 Mar 24  2011 oidprovtool
-rwxr-xr-x 1 oracle oinstall      524 Mar 24  2011 ojvmjava
-rwxr-x--- 1 oracle oinstall     9964 Mar 24  2011 okdstry
-rwxr-xr-x 1 oracle oinstall        0 Oct 22  2005 okdstry0
-rwxr-x--- 1 oracle oinstall     7630 Mar 24  2011 okinit
-rwxr-xr-x 1 oracle oinstall        0 Oct 22  2005 okinit0
-rwxr-x--- 1 oracle oinstall    13217 Mar 24  2011 oklist
-rwxr-xr-x 1 oracle oinstall        0 Oct 22  2005 oklist0
-rwxr-xr-x 1 oracle oinstall     1182 Mar 24  2011 olsadmintool
-rwxr-xr-x 1 oracle oinstall     1220 Mar 24  2011 olsoidsync
-rwx------ 1 oracle oinstall     2969 Mar 24  2011 onsctl
-rwxr-xr-x 1 oracle oinstall       46 Nov  7  2000 oracg
-rwxr-xr-x 1 oracle oinstall     2947 Jan  1  2000 oraenv
-rwxr-xr-x 1 oracle oinstall       44 Dec  4  2002 orajaxb
-rwxr-xr-x 1 oracle oinstall       59 Nov 25  2002 orapipe
-rwxr-xr-x 1 oracle oinstall     3192 Mar 24  2011 orapki
-rwxr-xr-x 1 oracle oinstall   360891 Sep 11  2005 oratclsh
-rwxr-xr-x 1 oracle oinstall       48 Sep 25  2000 oraxml
-rwxr-xr-x 1 oracle oinstall       48 Sep 25  2000 oraxsl
-rwxr-xr-x 1 oracle oinstall     7529 Oct 18  2005 osdbagrp
-rwxr-xr-x 1 oracle oinstall    10500 Oct 20  2005 osh
-rwxr-xr-x 1 oracle oinstall      965 Mar 24  2011 ott
-rwxr-xr-x 1 oracle oinstall     5444 Mar 24  2011 owm
-rwxr-xr-x 1 oracle oinstall  7362193 Mar 24  2011 proc
-rwxr-xr-x 1 oracle oinstall  7086938 Mar 24  2011 procob
-rwxr-xr-x 1 oracle oinstall  6771769 Mar 24  2011 profor
-rwxr-xr-x 1 oracle oinstall      691 Oct 22  2005 proxyserv
-rwxr-xr-x 1 oracle oinstall    53117 Oct 16  2005 proxyserv.bin
-rwxr-xr-x 1 oracle oinstall     1748 Feb 16  2003 pupbld
-rwxr-xr-x 1 oracle oinstall  1079140 Oct 20  2005 racgeut
-rwxr-xr-x 1 oracle oinstall  1211351 Oct 20  2005 racgmain
-rwxr-xr-x 1 oracle oinstall     1305 Jun  5  2005 racgwrap.sbs
-rwxr-xr-x 1 oracle oinstall   124637 Sep  9  2005 rawutl
-rwxr-xr-x 1 oracle oinstall     7769 Jun  7  2005 relink
-rwxr-x--x 1 oracle oinstall 12514692 Mar 24  2011 rman
-rwxr-xr-x 1 oracle oinstall        0 Oct 22  2005 rmanO
-rwxr-xr-x 1 oracle oinstall        0 Oct 22  2005 sbttest
-rwxr-xr-x 1 oracle oinstall        0 Jun 22  2005 sbttestO
-rwxr-xr-x 1 oracle oinstall  1544613 Sep  9  2005 schema
-rwxr-xr-x 1 oracle oinstall      940 Mar 24  2011 schemasync
-rwxr-xr-x 1 oracle oinstall    10166 Sep  1  2005 sqlj
-rwxr-x--x 1 oracle oinstall   726255 Mar 24  2011 sqlldr
-rwxr-xr-x 1 oracle oinstall        0 Oct 22  2005 sqlldrO
-rwxr-x--x 1 oracle oinstall     7343 Mar 24  2011 sqlplus
-rwxr-xr-x 1 oracle oinstall        0 Oct 22  2005 sqlplusO
-rwxr-xr-x 1 oracle oinstall     5793 Mar 24  2011 srvctl
-rwxr-xr-x 1 oracle oinstall     1347 Mar 24  2011 statusnc
-rwxr-xr-x 1 oracle oinstall     3261 Jun  7  2005 symfind
-rwxr-xr-x 1 oracle oinstall     3504 Mar 24  2011 targetdeploy.pl
-rwxr-x--x 1 oracle oinstall    62824 Mar 24  2011 tg4pwd
-rwxr-xr-x 1 oracle oinstall        0 Oct 22  2005 tg4pwdO
-rwxr-x--x 1 oracle oinstall   137968 Mar 24  2011 tkprof
-rwxr-xr-x 1 oracle oinstall        0 Oct 22  2005 tkprofO
-rwxr-xr-x 1 oracle oinstall        0 Oct 22  2005 tnnfg.dbl
-rwxr-x--x 1 oracle oinstall    13595 Mar 24  2011 tnsping
-rwxr-xr-x 1 oracle oinstall        0 Oct 22  2005 tnsping0
-rwxr-xr-x 1 oracle oinstall       45 Sep 25  2001 transx
-rwxr-xr-x 1 oracle oinstall     3014 Mar 24  2011 trcasst
-rwxr-x--x 1 oracle oinstall    21744 Mar 24  2011 trcroute
-rwxr-xr-x 1 oracle oinstall        0 Oct 22  2005 trcroute0
-rwxr-xr-x 1 oracle oinstall        0 Oct 22  2005 tstshm
-rwxr-xr-x 1 oracle oinstall        0 Jun 22  2005 tstshmO
-rwxr-xr-x 1 oracle oinstall     3196 Mar 24  2011 umu
-rwxr-xr-x 1 oracle oinstall   102612 Jan  1  2000 unzip
-rwxr-x--x 1 oracle oinstall  6097641 Mar 24  2011 wrap
-rwxr-xr-x 1 oracle oinstall  1901320 Sep  9  2005 xml
-rwxr-xr-x 1 oracle oinstall  2309476 Sep  9  2005 xmlcg
-rwxr-xr-x 1 oracle oinstall    39481 Sep  2  2004 xmlwf
-rwxr-xr-x 1 oracle oinstall  1800854 Sep  9  2005 xsl
-rwxr-xr-x 1 oracle oinstall      762 Jan 12  2004 xsql
-rwxr-xr-x 1 oracle oinstall  1703896 Sep  9  2005 xvm
-rwxr-xr-x 1 oracle oinstall    62748 Jan  1  2000 zip
[dsadm@XXXXXXXXXXXXdb_1libbin]$

anguila09 · Post by **anguila09** » Fri Mar 23, 2012 12:36 pm

log DS Director:

Oracle_OCI stage ==> Transformer_stage ==> Sequential_File_stage

Starting Job PruebaLecturaOracleJOB.

Environment variable settings:
_=/usr/bin/nohup
APT_ORCHHOME=/u02/IBM/InformationServer/Server/PXEngine
ASBHOME=/u02/IBM/InformationServer/ASBNode
BELL=^G
CONSOLE=/dev/pts/0
DS_ENABLE_RESERVED_CHAR_CONVERT=0
DS_TDM_PIPE_OPEN_TIMEOUT=720
DS_TDM_TRACE_SUBROUTINE_CALLS=0
DS_USERNO=-14606
DSHOME=/u02/IBM/InformationServer/Server/DSEngine
FLAVOR=-1
HOME=/home/dsadm
INCLUDE=/u03/sybaseiq/OCS-15_0/include:
INIT_VERSION=sysvinit-2.86
ISFSHMID=100696083
ISUSER=ergotest
LANG=en_US
LD_LIBRARY_PATH=<snip>
LDR_CNTRL=MAXDATA=0x60000000@USERREGS
LIB=/u03/sybaseiq/OCS-15_0/lib:
LOGNAME=dsadm
NLSPATH=/usr/tbuild/12.00.00.00/msg/%N
ODBCINI=/u02/IBM/InformationServer/Server/DSEngine/.odbc.ini
OLDPWD=/
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
PATH=<snip>
PATHSB=/u03/sybaseiq/OCS-15_0/bin:
PATHTWB=/usr/tbuild/12.00.00.00/bin:
PIDTOK=14305
PREVLEVEL=N
PWD=/u02/IBM/InformationServer/Server/DSEngine
PX_DBCONNECTHOME=/u02/IBM/InformationServer/Server/DSComponents
previous=N
RUNLEVEL=5
runlevel=5
SELINUX_INIT=YES
SHELL=/bin/bash
SHLVL=4
SYBASE=/u03/sybaseiq
SYBASE_OCS=OCS-15_0
TERM=
TNS_ADMIN=/u01/app/oracle/product/10.2.0/db_1/network/admin
TWB_ROOT=/usr/tbuild/12.00.00.00
UDTBIN=/u02/IBM/InformationServer/Server/DSEngine/ud41/bin
UDTHOME=/u02/IBM/InformationServer/Server/DSEngine/ud41
USER=dsadm
WHO=SAPFICOREGIONAL

PruebaLecturaOracleJOB: Set NLS locale to US-ENGLISH,US-ENGLISH,US-ENGLISH,US-ENGLISH,US-ENGLISH

ds_loadlibrary: error in dlopen of oraoci9.so - libclntsh.so.10.1: cannot open shared object file: No such file or directory

Attempting to Cleanup after ABORT raised in job PruebaLecturaOracleJOB..Transformer_3

Job PruebaLecturaOracleJOB aborted.

any idea ?

chulett · Post by **chulett** » Fri Mar 23, 2012 3:53 pm

anguila09 wrote:ds_loadlibrary: error in dlopen of oraoci9.so - libclntsh.so.10.1: cannot open shared object file: No such file or directory

At this point, that is your problem. It indicates that your LD_LIBRARY_PATH is not setup correctly in the dsenv file. Or you may need a soft link between client versions / locations. Best to contact your official support provider and get their help resolving this.