Home » RDBMS Server » Networking and Gateways » Maintaining a single listener in a multi-instance dB server w/ 3 different Oracle home (Oracle 9i R1/10g R2/11g R2, Solaris 10)
Maintaining a single listener in a multi-instance dB server w/ 3 different Oracle home [message #525089] Thu, 29 September 2011 00:26 Go to next message
reym21
Messages: 241
Registered: February 2010
Location: Philippines
Senior Member
Gurus,

We've been administering a multiple instance production dB server with 3 different versions of Oracle installed.
Currently, each of Oracle version had corresponding listener.
Oracle 9i had 2 instances, 10g 6 instances & 11g 2 instances also.

I'm seeking your assistance in giving me procedures on how I can integrate this 3 listeners into 1.

Thanks in advance.

Report message to a moderator

Re: Maintaining a single listener in a multi-instance dB server w/ 3 different Oracle home [message #525098 is a reply to message #525089] Thu, 29 September 2011 01:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68774
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
8 instances on a single what a waste of resources!

Just move the lines of SID_LIST_<listener> entry you have in each listener.ora to the latest one.

Regards
Michel

Report message to a moderator

Re: Maintaining a single listener in a multi-instance dB server w/ 3 different Oracle home [message #525100 is a reply to message #525098] Thu, 29 September 2011 01:22 Go to previous message
reym21
Messages: 241
Registered: February 2010
Location: Philippines
Senior Member
Thanks for this.

Btw, the said dB server is a Sun SPARC Enterprise M9000 with 32Gb of RAM.

Regards.

Report message to a moderator

Previous Topic: listener error
Next Topic: ORA-12514: TNS:listener does not currently know of service requested in connect
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 11 18:31:58 CST 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.