Home » RDBMS Server » Server Administration » Installaing two Oracle Homes
Installaing two Oracle Homes [message #62891] Sun, 22 August 2004 21:06 Go to next message
Kumar
Messages: 115
Registered: December 1998
Senior Member
Hello All,

we have to install two Oracle homes(We have already 9.2.0,but we have to install 8.1.7 now for different application which will support that) on the same server.Is it possible to install it.If yes How to configure the Listner.do we have to run two different Listner or can we run on same Listner.

Can any body help us.

Thanks,

Kumar

 
Re: Installing two Oracle Homes [message #62897 is a reply to message #62891] Mon, 23 August 2004 01:51 Go to previous messageGo to next message
BThiru
Messages: 7
Registered: August 2004
Junior Member
Kumar,

1. That (two ORACLE_HOMEs) is very much possible and is the case in most Oracle installations.
2. Two Listeners? : No, You can configure the Oracle9 Listener to 'listen' to requests coming from 8.x .

Bthiru
Re: Installing two Oracle Homes [message #62901 is a reply to message #62897] Mon, 23 August 2004 04:55 Go to previous messageGo to next message
Kumar
Messages: 115
Registered: December 1998
Senior Member
Hello Bthiru,

Could you give me the procedure if you have for this.
It willl be help ful for me.

Thanks,
Re: Installing two Oracle Homes [message #62921 is a reply to message #62901] Tue, 24 August 2004 11:31 Go to previous message
Girdhari Choudhary
Messages: 18
Registered: March 2002
Junior Member
if you are running listener on same machine where your database server is running than you need to change your listener.ora in $ORACLE_HOME/network/admin.
this file keeps the section SID_DESCRIPTION. here we need to specify the databases for which this listner has to listen. so just copy and paste the entry of you existing database and change it as ur new datbase names and all.
if it does not work, send me the listner.ora and new database name and other detail, I will explain it in more detail
Previous Topic: ORA-12560: TNS:protocol adapter error
Next Topic: Database running OR not
Goto Forum:
  


Current Time: Thu Jan 09 14:18:36 CST 2025