Wednesday, April 7, 2010

0509-130 Symbol resolution failed for /ora/product/920/lib/libjox9.a[shr.o] because

This the error we normally get on AIX when the evironment is not properly set . try connecting the database it will throw you this error

SQL> conn / as sysdba


exec(): 0509-036 Cannot load program oracle because of the following errors:

0509-130 Symbol resolution failed for /ora/product/920/lib/libjox9.a[shr.o] because:

0509-136 Symbol slmxnoop (number 423) is not exported from

dependent module oracle.

0509-136 Symbol sltsini (number 426) is not exported from

dependent module oracle.

0509-136 Symbol sltspsdestroy (number 427) is not exported from

dependent module oracle.

0509-136 Symbol sltspsinit (number 428) is not exported from

dependent module oracle.

0509-136 Symbol sltspspost (number 429) is not exported from

dependent module oracle.

0509-136 Symbol sltspswait (number 430) is not exported from

dependent module oracle.

0509-136 Symbol sltstcl (number 431) is not exported from

dependent module oracle.

0509-136 Symbol sltster (number 432) is not exported from

dependent module oracle.

0509-136 Symbol sltstgh (number 433) is not exported from

dependent module oracle.

0509-136 Symbol sltstkill (number 434) is not exported from

dependent module oracle.

0509-136 Symbol sltstspawn (number 435) is not exported from

dependent module oracle.

0509-192 Examine .loader section symbols with the

'dump -Tv' command.

ERROR:

ORA-12547: TNS:lost contact

Solution

The workaround is to set the correct enironment in the AIX

SQL> exit


althazar(fono001):/home/oracle>export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data

althazar(fono001):/home/oracle>export LIBPATH=[ORACLE_HOME]/lib:[ORACLE_HOME]/lib32:[ORACLE_HOME]/jdbc/lib

althazar(fono001):/home/oracle>sqlplus /nolog



SQL*Plus: Release 9.2.0.8.0 - Production on Wed Apr 7 08:13:48 2010



Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.



SQL> conn / as sysdba

Connected.

SQL> select name from v$database;



NAME

---------

FONO001

A permanent fix is to edit the .oraenv


althazar(fsce001):/usr/local/bin>vi oraenv
#


# Install any "custom" code here

#

export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data

export LIBPATH=[ORACLE_HOME]/lib:[ORACLE_HOME]/lib32:[ORACLE_HOME]/jdbc/lib

# Locate "osh" and exec it if found

ULIMIT=`LANG=C ulimit 2>/dev/null`

if [ $? = 0 -a "$ULIMIT" != "unlimited" ] ; then

"oraenv" 116 lines, 2683 characters

The reason for this error was at the time of running root.sh the the path was overrittens instead of taking default "NO"

 
Vijay Kumar