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 10.2.0.5.0 – 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
ERROR:
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 comment

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