Oracle数据库数据恢复、性能优化»论坛 › Oracle › Oracle数据库管理 › 『紧急』sqlplus 问题

baolei

36 积分	0 好友	14 主题

发消息

『紧急』sqlplus 问题

1^#

发表于 2012-5-17 08:59:12 | 查看: 7742| 回复: 14

在aix上部署数据库监控，非oracle用户时，登录时报：

sqlplus watch/****

exec(): 0509-036 Cannot load program oracleJSNPRD because of the following errors:
      0509-150 Dependent module libjox9.a(shr.o) could not be loaded.
      0509-022 Cannot load module libjox9.a(shr.o).
      0509-026 System error: A file or directory in the path name does not exist.
ERROR:
ORA-12547: TNS:lost contact

分享0

收藏0 回复只看该作者道具举报

baolei

2^#

发表于 2012-5-17 09:11:26

数据库是9206的

回复只看该作者道具举报

dai_xuej

3^#

发表于 2012-5-17 09:37:15

从这几个方面检查下先

异步io设置、limits、.profile、以及hosts文件有没问题

回复只看该作者道具举报

Maclean Liu(刘相兵

4^#

发表于 2012-5-17 10:33:00

action plan:

贴出以下命令在你当前用户的输出

id

echo $ORACLE_HOME

ls -ld $ORACLE_HOME
ls -ld $ORACLE_HOME/lib
ls -ld $ORACLE_HOME/network/admin

回复只看该作者道具举报

baolei

5^#

发表于 2012-5-17 10:46:35

toptea@xxxx:/toptea>id
uid=206(toptea) gid=203(bomc) groups=1(staff)
toptea@misp6:/toptea>echo $ORACLE_HOME
/ora/jsnprd/jsnprddb/9.2.0
toptea@misp6:/toptea>ls -ld $ORACLE_HOME
drwxr-xr-x 66 oranprd  dba          2048 Apr 12 22:45 /ora/jsnprd/jsnprddb/9.2.0
toptea@misp6:/toptea>ls -ld $ORACLE_HOME/lib
drwxr-xr-x 2 oranprd  dba          5120 May 16 15:26 /ora/jsnprd/jsnprddb/9.2.0/lib
toptea@misp6:/toptea>ls -ld $ORACLE_HOME/network/admin
drwxr-xr-x 4 oranprd  dba          1024 Apr 12 22:44 /ora/jsnprd/jsnprddb/9.2.0/network/admin

回复只看该作者道具举报

Maclean Liu(刘相兵

6^#

发表于 2012-5-17 10:59:31

action plan:

export LIBPATH=/ora/jsnprd/jsnprddb/9.2.0/lib:/ora/jsnprd/jsnprddb/9.2.0/lib32

sqlplus /nolog

贴出以上命令的输出

回复只看该作者道具举报

Maclean Liu(刘相兵

7^#

发表于 2012-5-17 11:17:52

ODM FINDING:

Cannot connect to 9.2 database - Dependent module libjox9.a(shr.o) could not be loaded

Fact(s)
~~~~~~~

  Attempting to connect to a 9i(9.2) database.
  Environment variables are set to point to the 9.2 database.
  ORACLE_HOME, ORACLE_SID are set correctly.

Symptom(s)
~~~~~~~~~~

When connecting we get the following errors:

  $ sqlplus system/rem920
  SQL*Plus: Release 9.2.0.1.0 - Production on Thu Aug 29 14:48:55 2002
  Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
  exec(): 0509-036 Cannot load program oracleREM920 because of the following
  errors:
      0509-150 Dependent module libjox9.a(shr.o) could not be loaded.
      0509-022 Cannot load module libjox9.a(shr.o).
      0509-026 System error: A file or directory in the path name does
               not exist.
  ERROR:
ORA-12547: TNS:lost contact

Change(s)
~~~~~~~~~

However, while connecting if connect string is given it connects fine.
  Eg:
   $ sqlplus system/rem920@connect_string

Cause
~~~~~

The LIBPATH / LD_LIBRARY_PATH environment variable is not set properly.

Fix
~~~

Add the following: $ORACLE_HOME/lib to the LIBPATH environment variable.
( as per the OS you may need to check LD_LIBRARY_PATH & to it add $ORACLE_HOME/lib )

For eg:
      LIBPATH=$ORACLE_HOME/lib32:$JAVA_HOME/lib:$ORACLE_HOME/lib

回复只看该作者道具举报

baolei

8^#

发表于 2012-5-17 11:19:28

sqlplus /nolog 是可以进去的！，但是你watch用户连接的时候还是报刚才的错！

回复只看该作者道具举报

Maclean Liu(刘相兵

9^#

发表于 2012-5-17 11:46:22

action plan:

echo $LIBPATH

ls -l  $ORACLE_HOME/lib/libjox*
ls -l  $ORACLE_HOME/lib32/libjox*

ls -l  $ORACLE_HOME/network/admin

truss -o sqlplus.log sqlplus watch/xxxx

回复只看该作者道具举报

baolei

10^#

发表于 2012-5-17 12:19:39

[email=toptea@misp6:/toptea]toptea@misp6:/toptea>echo[/email] $LIBPATH
/ora/jsnprd/jsnprddb/9.2.0/lib:/ora/jsnprd/jsnprddb/9.2.0/lib32
[email=toptea@misp6:/toptea]toptea@misp6:/toptea>ls[/email] -l $ORACLE_HOME/lib/libjox*
-rwxr-xr-x 1 oranprd  dba       7726252 May 16 14:50 /ora/jsnprd/jsnprddb/9.2.0/lib/libjox9.a
-rw-r--r-- 1 oranprd  dba       7726252 Apr 23 11:23 /ora/jsnprd/jsnprddb/9.2.0/lib/libjox9.a.20120423
-rw-rw-r-- 1 oranprd  dba       7726252 Apr 12 22:43 /ora/jsnprd/jsnprddb/9.2.0/lib/libjox9.a.old
[email=toptea@misp6:/toptea]toptea@misp6:/toptea>ls[/email] -l $ORACLE_HOME/lib32/libjox*
ls: 0653-341 The file /ora/jsnprd/jsnprddb/9.2.0/lib32/libjox* does not exist.
[email=toptea@misp6:/toptea]toptea@misp6:/toptea>ls[/email] -l $ORACLE_HOME/network/admin
total 169400
drwxr-xr-x 2 oranprd  dba          1024 Apr 12 22:44 JSNPRD_misp6
-rw-r--r-- 1 oranprd  dba       84948928 May 17 12:16 jsnprd.log
drwxr-xr-x 2 oranprd  dba             96 Apr 12 22:44 samples
-rw-r--r-- 1 oranprd  dba          130 Apr 12 22:44 shrept.lst
-rw-r--r-- 1 oranprd  dba             24 Apr 12 22:44 snmp_ro.ora
[email=toptea@misp6:/toptea]toptea@misp6:/toptea>which[/email] truss
/usr/bin/truss
[email=toptea@misp6:/toptea]toptea@misp6:/toptea>truss[/email] -o sqlplus.log sqlplus watch/mkijy3d3
Second
truss: 0915-026 Cannot open /proc/586728/as.
as    cred ctl    cwd    fd    lwp    map    object  psinfo  sigact  status  sysent
truss: 0915-015 Cannot create subject process.
wait4all: i: 0, status: 589833, pid: 586728, created: 0

回复只看该作者道具举报

Maclean Liu(刘相兵

11^#

发表于 2012-5-17 13:05:18

-rwxr-xr-x 1 oranprd dba 7726252 May 16 14:50 /ora/jsnprd/jsnprddb/9.2.0/lib/libjox9.a
-rw-r--r-- 1 oranprd dba 7726252 Apr 23 11:23 /ora/jsnprd/jsnprddb/9.2.0/lib/libjox9.a.20120423

似乎有人为移动过 libjox9.a 建议你尝试还原该库文件

回复只看该作者道具举报