How to fix cannot load program when trying to run sqlplus when using local connection?

On AIX ran into the following issue where sqlplus generated the following error when using local connection (bequeath).

scott@localhost:/home/scott:$ sqlplus system

SQL*Plus: Release – Production on Fri Apr 1 15:47:21 2011

Copyright (c) 1982, 2010, Oracle. All Rights Reserved.

Enter password:
exec(): 0509-036 Cannot load program oracleTEST because of the following error
0509-150 Dependent module libjox10.a(shr.o) could not be loaded.
0509-022 Cannot load module libjox10.a(shr.o).
0509-026 System error: A file or directory in the path name does not exists
ORA-12547: TNS:lost contact

To fix the issue we had relink oracle by executing the following command.
scott@localhost:/home/oracle $ relink oracle
chmod 755 /orabin/TEST/bin

– Linking Oracle
rm -f /orabin/TEST/rdbms/lib/oracle
ld -b64 -o /orabin/TEST/rdbms/lib/oracle -L/orabin/TEST/rdbms/lib/ -L/orabin/TEST/lib/ -bnoerrmsg -bbigtoc -bnoipath -bI:/orabin/TESt/lib/ksms…

mv -f /orabin/TEST/bin/oracle /orabin/TEST/bin/oracleO
mv /orabin/TEST/rdbms/lib/oracle /orabin/TEST/bin/oracle
chmod 6751 /orabin/TEST/bin/oracle

After rebuilding “scott” user was able to execute sqlplus

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.