Home » RDBMS Server » Networking and Gateways » start listener from two different oracle homes
start listener from two different oracle homes [message #254365] Thu, 26 July 2007 10:33 Go to next message
Daxesh
Messages: 61
Registered: July 2004
Member
Hello,
Recently, I have installed Oracle 10g on my database server. At this point I am running two oracle homes.My default oracle home is Oracle 10g. Dbshut and dbstart scripts work fine for shuting down and starting up the databases from their default home. But Listener does not start for the Oracle 9i database. So somebody can please advice how do I set a listener file to start and stop for correct oracle home? Is anybody has written a script to set up this? If so are you willing to share with me?

Any help would be appreciated.

FYI.. Databases are running on LINUX

Thanks again....
Re: start listener from two different oracle homes [message #254368 is a reply to message #254365] Thu, 26 July 2007 10:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why do you want to use 2 listeners?
Just use 10g listener.

Regards
Michel
Re: start listener from two different oracle homes [message #254387 is a reply to message #254365] Thu, 26 July 2007 11:32 Go to previous messageGo to next message
Daxesh
Messages: 61
Registered: July 2004
Member
So you mean just change folloing in the listener.ora file for the Oracle 9i datbase?

SID_LIST_BAT_XXXX =
(SID_LIST =
(SID_DESC =
(SID_NAME = XXXX)
(ORACLE_HOME=/home/oracle/product/9.2.x)
)
)

Re: start listener from two different oracle homes [message #254391 is a reply to message #254387] Thu, 26 July 2007 11:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, add it in the sid list of your 10g listener giving the 9i Oracle home.

Regards
Michel
Re: start listener from two different oracle homes [message #254393 is a reply to message #254365] Thu, 26 July 2007 11:44 Go to previous message
Daxesh
Messages: 61
Registered: July 2004
Member
Thanks Michel...
Previous Topic: How do i update the listener.ora file with a parameter.
Next Topic: FAILOVER_MODE causes ORA-01012 and ORA-24313
Goto Forum:
  


Current Time: Fri Apr 19 20:56:07 CDT 2024