| URGENT_multi - listeners [message #50058] |
Tue, 26 February 2002 11:12  |
Ed
Messages: 24
Registered: November 1999
|
Junior Member |
|
|
|
I need to have 2 listeners configured for the database in case of failover. I need to know how to do this... step by step. Thanks
|
|
|
|
| Re: URGENT_multi - listeners [message #50060 is a reply to message #50058] |
Tue, 26 February 2002 18:04  |
seng
Messages: 191
Registered: February 2002
|
Senior Member |
|
|
Below is the step to configure listener. Edit listener.ora file ($ORACLE_HOME/network/admin) and save
1. Edit the listener.ora. e.g
*************** sample listener.ora
<<new listenr name>>=
(ADDRESS_LIST=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=<<IP>>)
(PORT=<<Port>>)
)
)
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=<<SID>>)
(ORACLE_HOME=<<ORACLE_HOME>>)
)
)
*************** sample
Note: - make sure the port is not used by other services (SERVICES in /etc)
2. start new listener.
- start listener
lsnrctl>
- check status, list the activate listener.
lsnrctl>status
- start new listner.
lsnrctl> start <new listner name>
- check again listner, list the activate listener.
lsnrctl> status
Note: - This step is for UNIX only.
- New configuration tnsname for client to connect to this new listener.
Hope this will help you. thanks
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
