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
Thanks for this information Vijay....
ReplyDelete