Simpler Navigation coming for Servers and Operating Systems
Coming soon: a much simpler Servers and Operating Systems section of the Community. We will combine many of the older boards, and you won't have to click through so many levels to get at the information you need. If you are looking for an older board and do not find it, check the consolidated boards, as the posts are still there.
Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

How to configure multiple listeners

SOLVED
Go to solution
Simon Qu
Frequent Advisor

How to configure multiple listeners

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))
)
)
)
2 REPLIES
Geoff Wild
Honored Contributor
Solution

Re: How to configure multiple listeners

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
Proverbs 3:5,6 Trust in the Lord with all your heart and lean not on your own understanding; in all your ways acknowledge him, and he will make all your paths straight.
Simon Qu
Frequent Advisor

Re: How to configure multiple listeners

Thanks.