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 Reply

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

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s