Error running sqlldr

[jbarnhar]

We have recently upgraded our system from 9i to 10g......I can access our instances fine and do all necessary work that I'ved tested so far....I was testing to see if I can remove the 9i software when I ran into a problem....

I renamed our /u01/oracle directory to /u01/oracle_bak so that during testing if any environment variables are still pointing to the old Oracle home, i'd see a problem....During running a shell script that works on our Oracle application, I got the following error:

/usr/lib/pa20_64/dld.sl: Unable to find library 'libwtc9.sl'.
/sdw/massload/script/olap_load_tab_new.sh[17]: 4617 Killed
SQL*Loader-500: Unable to open file (qtblvquery0.int)
SQL*Loader-553: file not found
SQL*Loader-509: System error: No such file or directory
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.
It appears that the sqlldr executable in our 10g directory is somehow calling the 9i lib's.....I did an ldd on our new Oracle home directory and everything looks good....See below

/U03/app/oracle/product/10.2.0/bin>ldd -s sqlldr

find library=libclntsh.sl.10.1; required by sqlldr
search path=/U03/app/oracle/product/10.2.0/rdbms/lib/:/U03/app/oracle/produ)
trying path=/U03/app/oracle/product/10.2.0/rdbms/lib//libclntsh.sl.10.1
trying path=/U03/app/oracle/product/10.2.0/lib//libclntsh.sl.10.1
libclntsh.sl.10.1 => /U03/app/oracle/product/10.2.0/lib//libclntsh.s1

find library=libnnz10.sl; required by sqlldr
search path=/U03/app/oracle/product/10.2.0/rdbms/lib/:/U03/app/oracle/produ)
trying path=/U03/app/oracle/product/10.2.0/rdbms/lib//libnnz10.sl
trying path=/U03/app/oracle/product/10.2.0/lib//libnnz10.sl
libnnz10.sl => /U03/app/oracle/product/10.2.0/lib//libnnz10.sl

find library=libcl.2; required by sqlldr
search path=/U03/app/oracle/product/10.2.0/rdbms/lib/:/U03/app/oracle/produ)
trying path=/U03/app/oracle/product/10.2.0/rdbms/lib//libcl.2
trying path=/U03/app/oracle/product/10.2.0/lib//libcl.2
trying path=/usr/lib/pa20_64/libcl.2
libcl.2 => /usr/lib/pa20_64/libcl.2

find library=librt.2; required by sqlldr
search path=/U03/app/oracle/product/10.2.0/rdbms/lib/:/U03/app/oracle/produ)
trying path=/U03/app/oracle/product/10.2.0/rdbms/lib//librt.2
trying path=/U03/app/oracle/product/10.2.0/lib//librt.2
trying path=/usr/lib/pa20_64/librt.2
librt.2 => /usr/lib/pa20_64/librt.2

find library=libpthread.1; required by sqlldr
search path=/U03/app/oracle/product/10.2.0/rdbms/lib/:/U03/app/oracle/produ)
trying path=/U03/app/oracle/product/10.2.0/rdbms/lib//libpthread.1
trying path=/U03/app/oracle/product/10.2.0/lib//libpthread.1
trying path=/usr/lib/pa20_64/libpthread.1
libpthread.1 => /usr/lib/pa20_64/libpthread.1

find library=libnss_dns.1; required by sqlldr
search path=/U03/app/oracle/product/10.2.0/rdbms/lib/:/U03/app/oracle/produ)
trying path=/U03/app/oracle/product/10.2.0/rdbms/lib//libnss_dns.1
trying path=/U03/app/oracle/product/10.2.0/lib//libnss_dns.1
trying path=/usr/lib/pa20_64/libnss_dns.1
libnss_dns.1 => /usr/lib/pa20_64/libnss_dns.1

find library=libdl.1; required by sqlldr
search path=/U03/app/oracle/product/10.2.0/rdbms/lib/:/U03/app/oracle/produ)
trying path=/U03/app/oracle/product/10.2.0/rdbms/lib//libdl.1
trying path=/U03/app/oracle/product/10.2.0/lib//libdl.1
trying path=/usr/lib/pa20_64/libdl.1
libdl.1 => /usr/lib/pa20_64/libdl.1

find library=libnsl.1; required by sqlldr
search path=/U03/app/oracle/product/10.2.0/rdbms/lib/:/U03/app/oracle/produ)
trying path=/U03/app/oracle/product/10.2.0/rdbms/lib//libnsl.1
trying path=/U03/app/oracle/product/10.2.0/lib//libnsl.1
trying path=/usr/lib/pa20_64/libnsl.1
libnsl.1 => /usr/lib/pa20_64/libnsl.1

find library=libm.2; required by sqlldr
search path=/U03/app/oracle/product/10.2.0/rdbms/lib/:/U03/app/oracle/produ)
trying path=/U03/app/oracle/product/10.2.0/rdbms/lib//libm.2
trying path=/U03/app/oracle/product/10.2.0/lib//libm.2
trying path=/usr/lib/pa20_64/libm.2
libm.2 => /usr/lib/pa20_64/libm.2

find library=libc.2; required by sqlldr
search path=/U03/app/oracle/product/10.2.0/rdbms/lib/:/U03/app/oracle/produ)
trying path=/U03/app/oracle/product/10.2.0/rdbms/lib//libc.2
trying path=/U03/app/oracle/product/10.2.0/lib//libc.2
trying path=/usr/lib/pa20_64/libc.2
libc.2 => /usr/lib/pa20_64/libc.2

find library=libnnz10.sl; required by /U03/app/oracle/product/10.2.0/lib//lib1
search path=/U03/app/oracle/product/10.2.0/lib (RPATH)
trying path=/U03/app/oracle/product/10.2.0/lib/libnnz10.sl
libnnz10.sl => /U03/app/oracle/product/10.2.0/lib/libnnz10.sl

find library=librt.2; required by /U03/app/oracle/product/10.2.0/lib//libclnt1
search path=/U03/app/oracle/product/10.2.0/lib (RPATH)
trying path=/U03/app/oracle/product/10.2.0/lib/librt.2
search path=/lib/pa20_64:/usr/lib/pa20_64 (default)
trying path=/lib/pa20_64/librt.2
librt.2 => /lib/pa20_64/librt.2

find library=libpthread.1; required by /U03/app/oracle/product/10.2.0/lib//li1
search path=/U03/app/oracle/product/10.2.0/lib (RPATH)
trying path=/U03/app/oracle/product/10.2.0/lib/libpthread.1
search path=/lib/pa20_64:/usr/lib/pa20_64 (default)
trying path=/lib/pa20_64/libpthread.1
libpthread.1 => /lib/pa20_64/libpthread.1

find library=libnss_dns.1; required by /U03/app/oracle/product/10.2.0/lib//li1
search path=/U03/app/oracle/product/10.2.0/lib (RPATH)
trying path=/U03/app/oracle/product/10.2.0/lib/libnss_dns.1
search path=/lib/pa20_64:/usr/lib/pa20_64 (default)
trying path=/lib/pa20_64/libnss_dns.1
libnss_dns.1 => /lib/pa20_64/libnss_dns.1

find library=libdl.1; required by /U03/app/oracle/product/10.2.0/lib//libclnt1
search path=/U03/app/oracle/product/10.2.0/lib (RPATH)
trying path=/U03/app/oracle/product/10.2.0/lib/libdl.1
search path=/lib/pa20_64:/usr/lib/pa20_64 (default)
trying path=/lib/pa20_64/libdl.1
libdl.1 => /lib/pa20_64/libdl.1

find library=libnsl.1; required by /U03/app/oracle/product/10.2.0/lib//libcln1
search path=/U03/app/oracle/product/10.2.0/lib (RPATH)
trying path=/U03/app/oracle/product/10.2.0/lib/libnsl.1
search path=/lib/pa20_64:/usr/lib/pa20_64 (default)
trying path=/lib/pa20_64/libnsl.1
libnsl.1 => /lib/pa20_64/libnsl.1

find library=libm.2; required by /U03/app/oracle/product/10.2.0/lib//libclnts1
search path=/U03/app/oracle/product/10.2.0/lib (RPATH)
trying path=/U03/app/oracle/product/10.2.0/lib/libm.2
search path=/lib/pa20_64:/usr/lib/pa20_64 (default)
trying path=/lib/pa20_64/libm.2
libm.2 => /lib/pa20_64/libm.2

find library=libc.2; required by /U03/app/oracle/product/10.2.0/lib//libclnts1
search path=/U03/app/oracle/product/10.2.0/lib (RPATH)
trying path=/U03/app/oracle/product/10.2.0/lib/libc.2
search path=/lib/pa20_64:/usr/lib/pa20_64 (default)
trying path=/lib/pa20_64/libc.2
libc.2 => /lib/pa20_64/libc.2

find library=libcl.2; required by /U03/app/oracle/product/10.2.0/lib//libclnt1
search path=/U03/app/oracle/product/10.2.0/lib (RPATH)
trying path=/U03/app/oracle/product/10.2.0/lib/libcl.2
search path=/lib/pa20_64:/usr/lib/pa20_64 (default)
trying path=/lib/pa20_64/libcl.2
libcl.2 => /lib/pa20_64/libcl.2

find library=libdl.1; required by /usr/lib/pa20_64/libcl.2
search path=/usr/lib/pa20_64:/usr/ccs/lib/pa20_64 (RPATH)
trying path=/usr/lib/pa20_64/libdl.1
libdl.1 => /usr/lib/pa20_64/libdl.1

find library=libxti.2; required by /usr/lib/pa20_64/libnsl.1
search path=/usr/lib/pa20_64: (RPATH)
trying path=/usr/lib/pa20_64/libxti.2
libxti.2 => /usr/lib/pa20_64/libxti.2

If i rename the /u01/oracle_bak directory back to /u01/oracle, everything works fine....So somewhere 10g is pointing at the old 9i lib directory for running the 10g sqlldr executable....I've shutdown the databases and relinked all libs with the old software still named /u01/oracle_bak hoping that would correct the problem, but it didn't.....

any ideas????????

[davey23uk]

your SHLIB_PATH (assuming you are on HPUX)

also you cannot just rename directories, you mess up the inventory

[jbarnhar]

Here are the SHLIB_PATH and LD_LIBRARY_PATH variables that are set in the shell script during execution.....

Renaming the 9i directory shouldn't matter to the inventory since the 9i instances are all shutdown.....I'm just trying to ensure that nothing is pointing to the OLD Oracle home /u01/oracle/product/9.2.0

export SHLIB_PATH=/U03/app/oracle/product/10.2.0/lib:/usr/lib:/opt/image/lib:/opt/audio/lib

export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/lib

export LD_LIBRARY_PATH=/U03/app/oracle/product/10.2.0/lib:/usr/lib

[waitecj]

Log on as the user who executes the script, export the environment variables that are set in the script at the command line, then "env". Chances are something like this:

export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/lib

is the problem ($ORACLE_HOME still pointing to 9i home).

[jbarnhar]

Yeah, I thought of that......But no such luck.....All the current environment variables are set looking at the new 10.2.0 directory and not the old 9i directories.....

[ixion]

Do you have the shared flag enabled on sqlldr ? If not, it won't access the shlib_path environement variables. To see the state, run chatr command against the binary.

To enable it run chatr +s enable