Chinese

OS： SunOS 5.10

DB: 10205 单实例

症状： 实例明明已经open，且通过tnsname可以从客户端正常连接，但是本地采用sqlplus却无法登陆；

/ as sysdba显示登陆的是一个idle instance， 使用普通用户则直接报告memory not exist；

当使用sqlplus / as sysdba本地登陆并尝试mount时，则显示ORA-01102: cannot mount database in EXCLUSIVE mode；

该机器安装有11203和10205数据库若干，11203的均可以正常连接，但是10205都是显示此类错误
[oracle]/export/home/oracle> export ORACLE_HOME=/apps/oracle/product/102
[oracle]/export/home/oracle> export ORACLE_SID=prod
[oracle]/export/home/oracle> $ORACLE_HOME/bin/sqlplus / as sysdba
ld.so.1: sqlplus: fatal: relocation error: file /apps/oracle/product/102/lib/libnnz10.so: symbol nzdacvalue: referenced symbol not found
Killed
[oracle]/export/home/oracle> echo $LD_LIBRARY_PATH
/apps/oracle/product/11203/lib
[oracle]/export/home/oracle> echo $PATH
/apps/oracle/product/11203/bin:.:/usr/ccs/bin:/usr/sbin:/usr/bin:/bin:/usr/ucb:/usr/openwin/bin:/usr/local/bin:/opt/bin:/usr/dt/bin/:/usr/ccs/bin
[oracle]/export/home/oracle> export LD_LIBRARY_PATH=$ORACLE_HOME/lib
本地登陆

[oracle]/export/home/oracle> $ORACLE_HOME/bin/sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Fri Aug 31 04:11:27 2012
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL>
[oracle]/export/home/oracle> sqlplus system/******
SQL*Plus: Release 10.2.0.5.0 - Production on Fri Aug 31 04:12:55 2012
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
ERROR:

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory

使用tnsname则可以正常登陆

[oracle]/export/home/oracle> sqlplus system/******@prod
SQL*Plus: Release 10.2.0.5.0 - Production on Fri Aug 31 04:12:29 2012
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> show parameter db_name


NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

db_name string prod


SQL> select status from v$instance;
STATUS

------------

OPEN

使用truss跟踪

oracle]/export/home/oracle> truss -aefo tnsplus.log sqlplus system/******
SQL*Plus: Release 10.2.0.5.0 - Production on Fri Aug 31 04:24:26 2012
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.

ERROR:

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

SVR4 Error: 2: No such file or directory



Enter user-name: ^C

不知各位有何思路，麻烦解答一下

注：环境变量的设置是无误的；没发现上传文件的按钮，贴了原帖的链接，可以点进去下载一下truss的跟踪文件

Edited by: 956503 on 2012-9-2 上午7:41