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????????