How to configure multiple listeners

[Simon Qu]

We have one server, two databases: PROD and TEST. In our listener.ora file (below), the PROD database is configured. Now I set up a TEST database and want the TEST database to be listened too.
How to change listener.ora fiel to do that?

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PROD)
(ORACLE_HOME = /usr/oracle/product/8.1.7)
# (PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dr12w)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)

[Geoff Wild · Accepted solution]

Here's an example on one of my dev servers:

# cat /etc/listener.ora
LISTENERIE1 =
(ADDRESS_LIST =
(ADDRESS=
(PROTOCOL=IPC)
(KEY=IE1.world)
)
(ADDRESS=
(PROTOCOL=IPC)
(KEY= IE1)
)
(ADDRESS =
(COMMUNITY = sap.world)
(PROTOCOL = TCP)
(Host = svr1000)
(Port = 1527)
)
)
STARTUP_WAIT_TIME_LISTENERIE1 = 0
CONNECT_TIMEOUT_LISTENERIE1 = 10
TRACE_LEVEL_LISTENERIE1 = OFF
SID_LIST_LISTENERIE1 =
(SID_LIST =
(SID_DESC =
(SDU = 4096)
(SID_NAME = IE1)
(ORACLE_HOME = /oracle/IE1/920_64)
(PRESPAWN_MAX = 10)
)
(SID_DESC =
(SDU = 4096)
(SID_NAME = BW1)
(ORACLE_HOME = /oracle/BW1/920_64)
(PRESPAWN_MAX = 10)
)
)


Rgds...Geoff

[Simon Qu]

Thanks.