If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Error running sqlldr

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

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

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