Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: NT - starting another separate listener for a new instance

Re: NT - starting another separate listener for a new instance

From: Vitaliy Mogilevskiy <vit100gain_at_earthlink.net>
Date: Wed, 17 Feb 1999 10:38:23 -0800
Message-ID: <36CB0C9F.9A79ED62@earthlink.net>


You don't need separate listener for a new database you can use one listener for multiple database as long as you include info about your new DB in LISTENER.ORA file. Here is an example:


#
# Installation Generated Net8 Configuration
# Version Date: Jun-17-97
# Filename: Listener.ora
#

LISTENER =
 (ADDRESS_LIST =
 (ADDRESS= (PROTOCOL= IPC)(KEY= PROD))
 (ADDRESS= (PROTOCOL= IPC)(KEY= TEST01))
 (ADDRESS= (PROTOCOL= IPC)(KEY= VIS11))
 (ADDRESS= (PROTOCOL= TCP)(Host= rainbow)(Port= 1521))
  )
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(GLOBAL_DBNAME= rainbow)
(ORACLE_HOME= /d04/app/oracle/product/8.0.5)
(SID_NAME = PROD)

    )
    (SID_DESC =
(GLOBAL_DBNAME= rainbow)
(ORACLE_HOME= /d04/app/oracle_t01/product/8.0.5)
(SID_NAME = TEST01)

    )
    (SID_DESC =
(GLOBAL_DBNAME= rainbow)
(ORACLE_HOME= /d02/app/oracle/product/8.0.4)
(SID_NAME = VIS11)

    )
  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF Vitaliy Mogilevskiy Received on Wed Feb 17 1999 - 12:38:23 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US