Upgrade from Oracle 9.0 to Oracle 10.0 SunOS, fatal: libclntsh.so.9.0: open failed

Question

We upgraded our DB Server from Oracle 9.0 to Oracle 10.0 under SunOS, but there is something wrong with linkage, since a lot of application stop working with libclntsh.so.9.0 error.

ldd sqlplus 

shows

libclntsh.so.9.0 =>       (file not found)

I tried to create a symbolic link but nothing seems to be working

ln -s $ORACLE_HOME/lib32/libclntsh.so.10.1 /usr/bin/libclntsh.so.9.0

Any Idea ?

Answer 1

It was an architectural problem since I installed Oracle 10.0 64Bit and our applications compiled for 32Bit architecture, so I recompiled Oracle client.

Answer 2

The solution is as follows:

a. Run the changePerm.sh script.

b. bounce LISTENER

c. bounce SID

Answer 3

Is it complaining about a new and unresolved variable ? If not check your LD_LIBRARY_PATH.