listener的ORACLE_HOME配置出錯導致無法遠端登陸資料庫

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 available
ORA-27101: shared memory realm does not exist
Linux-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)
    )
  )