C:\Documents and Settings\test>sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on 星期五 10月 21 10:10:24 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ERROR:

ORA-01034: ORACLE not availableORA-27101: shared memory realm does not existLinux-x86_64 Error: 2: No such file or directory

C:\Documents and Settings\test>tnsping testdb2

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 21-10月-2011 10:05:26

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

已使用的参数文件:

c:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora

已使用 TNSNAMES 适配器来解析别名Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = *.*.*.*)(PORT = 1521)))(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = justin)))OK (40 毫秒)

经过一番仔细查看，发现listener.ora配置有误

SID_LIST_LISTENER =  (SID_LIST =    (SID_DESC =      (ORACLE_HOME = /home/oracle/product/11.2.0/db1)      (SID_NAME = justin)    )  )  目前系统使用11203版本，但是ORACLE_HOME却还是指向原来的11202修改一下ORACLE_HOME即可SID_LIST_LISTENER =  (SID_LIST =    (SID_DESC =      (ORACLE_HOME = /home/oracle/product/11.2.0/db1)      (SID_NAME = justin)    )  )

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15480802/viewspace-709640/，如需转载，请注明出处，否则将追究法律责任。