解決方法：

修改listener.ora后,10g和11g的連接即可恢復正常。

具體示例如下：

Oracle數據庫10g

cat listener.ora

LISTENER =

(DESCRipTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = oratest)(PORT = 1521))

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

)

)

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = /home/oracle/OraHome_1)

(PROGRAM = extproc)

)

(SID_DESC =

(ORACLE_HOME = /home/oracle/OraHome_1)

(SID_NAME = test)

)

)

Oracle數據庫11g

cat listener.ora

# listener.ora Network Configuration File: /home/daizy/OraHome_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.170)(PORT = 1522))

(ADDRESS = (PROTOCOL = IPC)(KEY = dzy))

)

)

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = /home/daizy/OraHome_1)

(PROGRAM = extproc)

)

(SID_DESC =

(ORACLE_HOME = /home/daizy/OraHome_1)

(SID_NAME = dzy)

)

)