在一台板滞设置装备铺排两个listener(Oracle)

   滥觞：网海拾贝

---

 

成效：一台板滞同古装两套数据库时（实例名o8161,o8151)，无法同时启动两个listener，

当启动第二个listener时，袒露体现错误。

 $ lsnrctl start

LSNRCTL for IBM/AIX RISC System/6000: Version 8.1.5.0.0 - Production on 14-SEP-00 09:25:17

(c) Copyright 1998 Oracle Corporation. All rights reserved.

TNS-01106: Listener using listener name LISTENER has already been started

 $ oerr tns 1106

01106, 00000, "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.

成效迸发启事：

两个实例的LISTENER.ORA中IPC和谈的KEY是相反，而一集零碎中KEY必需是唯一的. 

拾掇递次递次递次递次：

修正key的值即可。修正后的文件信息：

o8161实例：（没有修正)

# LISTENER.ORA Configuration File:/oracle/dbs/opstemp/szpcac1/network/admin/listener.ora

# Generated by Oracle configuration tools.

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS_LIST =

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

)

(ADDRESS_LIST =

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

)

)

(DESCRIPTION =

(PROTOCOL_STACK =

(PRESENTATION = GIOP)

(SESSION = RAW)

)

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

)

)

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = /oracle)

(PROGRAM = extproc)

)

(SID_DESC =

(ORACLE_HOME = /oracle)

(SID_NAME = o8161)

)

)

08151实例：（颠末修正)

# LISTENER.ORA Configuration File:/ora815/network/admin/listener.ora

# Generated by Oracle Net8 Assistant

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = TESTo815))

)

(ADDRESS_LIST =

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

)

)

)

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = ora8151)

(ORACLE_HOME = /ora815)

(PROGRAM = extproc)

)

)




版权声明： 原创作品，剖析转载，转载时请务必以超链接体式幻术标明文章 原始启事 、作者信息和本声明。否则将清查纪律责任。

转载于:https://www.cnblogs.com/zgqjymx/archive/2011/03/07/1976358.html