Sharing My Database Experience

Menu

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