Home » RDBMS Server » Server Administration » 2 same Oracle SID on a same server having two versions of oracles.
2 same Oracle SID on a same server having two versions of oracles. [message #250779] Wed, 11 July 2007 05:32 Go to next message
salano21
Messages: 2
Registered: July 2007
Junior Member
HI folks,

Could you please tell me ,whether its possible to run two Oracle SID having same name one for Oracle 9.0.0.8 and one for 9.0.0.6. on the same unix machine.

Please let me know how to do that, and what would be the impact if we do so.

Regards
Salano
Re: 2 same Oracle SID on a same server having two versions of oracles. [message #250780 is a reply to message #250779] Wed, 11 July 2007 05:33 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Yes, it's possible, but I wouldn't recommend it.

There isn't anything really special that is needed to actual do it, you just create a database in each ORACLE_HOME with the same SID.

[Updated on: Wed, 11 July 2007 05:34]

Report message to a moderator

Re: 2 same Oracle SID on a same server having two versions of oracles. [message #250786 is a reply to message #250779] Wed, 11 July 2007 06:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Actually it depends on your OS.
On some it is possible, on others it not possible.
On some, you have to warp the standard creation of instance and so it is risky.

Regards
Michel
Re: 2 same Oracle SID on a same server having two versions of oracles. [message #250790 is a reply to message #250780] Wed, 11 July 2007 06:09 Go to previous messageGo to next message
salano21
Messages: 2
Registered: July 2007
Junior Member
Thanks ebrian,

When the client will connect to respective e SID, what setting they have to do in their tnsnames.ora file. Since both sid are running on the same host.

Could you please help me out.
Your help is appreciated.

Thanks
Salano
Re: 2 same Oracle SID on a same server having two versions of oracles. [message #250791 is a reply to message #250790] Wed, 11 July 2007 06:14 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
One option would be that you could create two listeners that listen on different ports, specifying the appropriate ORACLE_HOME when configuring the SID_LIST for the listener. Therefore, the tnsnames file would have the appropriate port specified for connection.

[Updated on: Wed, 11 July 2007 06:16]

Report message to a moderator

Previous Topic: How ro migrate scheduled jobs ?
Next Topic: Ip address of the host cannot be determined
Goto Forum:
  


Current Time: Tue Dec 06 04:25:57 CST 2016

Total time taken to generate the page: 0.13330 seconds