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.
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: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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
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.
Previous Topic: listener error
Next Topic: ORA-12514: TNS:listener does not currently know of service requested in connect
Goto Forum:
  


Current Time: Thu Mar 28 06:49:32 CDT 2024