在一台機器配置兩個listener

問題一台機器同時裝兩套數據庫時（實例名oo)無法同時啟動兩個listener

當啟動第二個listener時顯示錯誤

　　$ lsnrctl start

　　LSNRCTL for IBM/AIX RISC System/: Version Production on SEP ::

　　(c) Copyright Oracle Corporation All rights reserved

　　TNS: Listener using listener name LISTENER has already been started

　　$ oerr tns

Listener using listener name %s has already been started

// *Cause: Another listener is already listening on one of the ADDRESSes

// specified

// *Action: Shutdown the previous listener specified by the listener name

// before starting this one

　　問題產生原因

兩個實例的LISTENERORA中IPC協議的KEY是相同而一個系統中KEY必須是唯一的 

　　解決辦法

修改key的值即可修改後的文件信息

o實例（沒有修改)

# LISTENERORA Configuration File:/oracle/dbs/opstemp/szpcac/network/admin/listenerora

# Generated by Oracle configuration tools

　　LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))

)

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = loopback)(PORT = ))

)

)

(DESCRIPTION =

(PROTOCOL_STACK =

(PRESENTATION = GIOP)

(SESSION = RAW)

)

(ADDRESS = (PROTOCOL = TCP)(HOST = loopback)(PORT = ))

)

)

　　SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = /oracle)

(PROGRAM = extproc)

)

(SID_DESC =

(ORACLE_HOME = /oracle)

(SID_NAME = o)

)

)

　　實例（經過修改)

　　# LISTENERORA Configuration File:/ora/network/admin/listenerora

# Generated by Oracle Net Assistant

　　LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = TESTo))

)

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = loopback)(PORT = ))

)

)

)

　　SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = ora)

(ORACLE_HOME = /ora)

(PROGRAM = extproc)

)

)

From:http://tw.wingwit.com/Article/program/Oracle/201311/18431.html