熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

在一台機器配置兩個listener

2013-11-13 22:11:42  來源: Oracle 
問題一台機器同時裝兩套數據庫時(實例名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
    推薦文章
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.