Problem: When two databases (o8161 and o8151) are created on one machine at the same time, two listener instances cannot be started at the same time. When the second listener is started, an error is displayed. $ LsnrctlstartLSNRCTLforIBMAIXRISCSystem6000: Version8.1.5.0.0
Problem: When two databases (o8161 and o8151) are created on one machine at the same time, two listener instances cannot be started at the same time. When the second listener is started, an error is displayed. $ 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 199
Problem: When two sets of listeners (o8161 and o8151) are created on a single machine, two listener listeners cannot be started at the same time. When the second listener is started, an error is displayed.
$ 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,000 00, "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.
Cause:
The keys of the IPC protocol in LISTENER. ORA of the two instances are the same, and the keys in a system must be unique.
Solution:
Modify the key value. Modified file information:
O8161 instance: (not modified)
# 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 instance: (modified)
# 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)
)
)