sqlplus problem

kshkid · 05-07-2007, 02:50 AM

Hi,

Am trying to run sqlplus

it complains the following

./sqlplus: error while loading shared libraries: libclntsh.so.8.0: cannot open shared object file: No such file or directory

though I have added $ORACLE_HOME/lib in my LD_LIBRARY_PATH

Could you please show some pointers ?

Thanks

kstan · 05-07-2007, 04:03 AM

u install both server and client in same pc?

kshkid · 05-07-2007, 07:42 AM

No,

both of them are in different nodes!

kstan · 05-07-2007, 07:52 PM

Previously work successfully?

goto your $ORACLE_HOME/lib
type this command to check whether the file still there.

ls libclntsh*

kshkid · 05-07-2007, 11:47 PM

This is the first time am configuring

files are very much available at $ORACLE_HOME/lib

Code:

ls libclntsh.so.8.0
libclntsh.so.8.0

jim mcnamara · 05-09-2007, 06:33 AM

Is $ORACLE_HOME/lib (or ..lib32) in your PATH variable? It should be.

Do you have ORACLE_SID and TWO_TASK defined? TWO_TASK needs to be "aimed" at the remote SID. Define ORACLE_SID: it should be aimed at the remote SID as well.

If that didn't help please post:
When you do ldd $ORACLE_HOME/bin/sqlplus what is the default path shown for libclntsh?

kstan · 05-09-2007, 09:01 AM

Quote:

Originally Posted by jim mcnamara

Is $ORACLE_HOME/lib (or ..lib32) in your PATH variable? It should be

please add $ORACLE_HOME/bin into $PATH too.

jim mcnamara · 05-09-2007, 01:33 PM

Think $ORACLE_HOME/bin is there already in PATH since sqlplus starts up, but you're right: it does need to be in there.

kstan · 05-09-2007, 07:20 PM

erm.. u use oracle 8 or oracle 9?