OraFAQ Forum: Server Administration » How to set particular instance when we have two multilpe instances

Home » RDBMS Server » Server Administration » How to set particular instance when we have two multilpe instances

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

How to set particular instance when we have two multilpe instances [message #109929]

Wed, 02 March 2005 00:06

anmol1947
Messages: 34
Registered: February 2005
Location: Gurgaon

Member

hi,

i have created two databases orcl and oemrep
now whenever i started sql ,by default oemrep is started
now how i can change it to orcl..
confused..

Thanx In Adv...

Anmol

Report message to a moderator

Re: How to set particular instance when we have two multilpe instances [message #109943 is a reply to message #109929]

Wed, 02 March 2005 02:49

Frank
Messages: 7901
Registered: March 2000

Senior Member

set oracle_sid or two_task to your required instance-sid.

hth

Report message to a moderator

Re: How to set particular instance when we have two multilpe instances [message #110040 is a reply to message #109943]

Thu, 03 March 2005 00:10

anmol1947
Messages: 34
Registered: February 2005
Location: Gurgaon

Member

it is working only if do like this
d:>set oracle_sid=orcl
d:>sqlplus /nolog
d:>conn system/manager

but if i open sqlplus directly not from d:drive where orcale is loaded then it dint work and also ,
i want to set it permanent

so plz help

Report message to a moderator

Re: How to set particular instance when we have two multilpe instances [message #110041 is a reply to message #109943]

Thu, 03 March 2005 00:11

anmol1947
Messages: 34
Registered: February 2005
Location: Gurgaon

Member

Frank wrote on Wed, 02 March 2005 03:49

set oracle_sid or two_task to your required instance-sid.

hth

it is working only if do like this
Windows XP
d:>set oracle_sid=orcl
d:>sqlplus /nolog
d:>conn system/manager

but if i open sqlplus directly not from d:drive where orcale is loaded then it dint work and also ,
i want to set it permanent

so plz help

[Updated on: Thu, 03 March 2005 02:07]

Report message to a moderator

Re: How to set particular instance when we have two multilpe instances [message #110047 is a reply to message #109929]

Thu, 03 March 2005 01:29

Frank
Messages: 7901
Registered: March 2000

Senior Member

No version info given; never said you were on Windows.
Edit your registry (at your own risk of course):
Create a new string String value "LOCAL" in HKEY_LOCAL_MACHINE\SOFTWARE\Oracle
This should contain your preferred sid.

hth

Report message to a moderator

Re: How to set particular instance when we have two multilpe instances [message #110470 is a reply to message #109929]

Mon, 07 March 2005 16:39

vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad

Senior Member

I will go with frank ..
open registry - HKEY_LOCAL_MACHINE->SOFTWARE->ORACLE->HOME0->ORACLE_SID ->change the value of this to orcl ..

this should be the permanent fix.

-V

Report message to a moderator

Re: How to set particular instance when we have two multilpe instances [message #110471 is a reply to message #109929]

Mon, 07 March 2005 16:40

vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad

Senior Member

I will go with frank with a little modification ..

open registry - HKEY_LOCAL_MACHINE->SOFTWARE->ORACLE->HOME0->ORACLE_SID ->change the value of this to orcl ..

this should be the permanent fix.

-V

Report message to a moderator

Previous Topic:	How to Setup ???
Next Topic:	Windows XP with Oracle 8

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 10 14:24:33 CDT 2025