| Add 2nd listener to same host [message #405346] |
Wed, 27 May 2009 07:19  |
dirkm
Messages: 86
Registered: November 2008
Location: Centurion - South Africa
|
Member |
|
|
I am a little pushed for time, so if you will please allow me to ask this question:
I need to add a 2nd listener to a host where I have 3 databases / instances running. How do I do this manually ?
(PS. I would like it to run on a different port, so that 1 of the 3 instances has its own listener and port, unless I can run 2 listeners on the same port, and have 1 of the instances running on its own dedicated listener)
I know I have to edit the listener.ora, and the tnsnames.ora, but what do I edit ?
1. Do I copy & paste the current listener in the listener.ora, and change the name & port (basically add a 2nd entry) ?
2. And what do I add to the tnsnames.ora ?
Dirk
|
|
|
|
|
|
| Re: Add 2nd listener to same host [message #405457 is a reply to message #405346] |
Wed, 27 May 2009 22:35  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
>I need to add a 2nd listener to a host where I have 3 databases / instances running.
I doubt you need to run another listener.
What problem will the 2nd listener solve?
For which DBs will the 2nd listener handle?
>How do I do this manually ?
Use vi or editor of choice.
Please realize that any listener is NEVER involved with any SQL activity against the DB.
Good Luck with your emergency.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
