The Oracle Database configures two listener listeners on one machine.

Source: Internet
Author: User
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)
)
)

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.