OraFAQ Forum: Server Administration » 2 same Oracle SID on a same server having two versions of oracles.

Home » RDBMS Server » Server Administration » 2 same Oracle SID on a same server having two versions of oracles.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

2 same Oracle SID on a same server having two versions of oracles. [message #250779]

Wed, 11 July 2007 05:32

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

Report message to a moderator

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

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

Michel Cadot
Messages: 68686
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

Report message to a moderator

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

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

Report message to a moderator

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 22:58:37 CDT 2024