OraFAQ Forum: SQL & PL/SQL » How to change default Instance (SID) ?

Home » SQL & PL/SQL » SQL & PL/SQL » How to change default Instance (SID) ?

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

How to change default Instance (SID) ? [message #22863]

Sat, 02 November 2002 08:01

nat
Messages: 11
Registered: March 2002

Junior Member

I have 2 instances A and B. A was created first and then B. Now, when I go to C:> sqlplus, it always goes to instance B. How to make it go to A by default?

Report message to a moderator

Re: How to change default Instance (SID) ? [message #22870 is a reply to message #22863]

Sun, 03 November 2002 06:43

sai sreenivas jeedigunta
Messages: 370
Registered: November 2001

Senior Member

Hi , for this u need to set the value of ORACLE_HOME in your o/s registry, try setting this in OraTAb file incase of UNIX, in case of Windows use REGEDIT->HKEY_LOCAL_MACHINE->SOFTWARE->ORACLE->HOME0 in that set the Corresponding value for ORACLE_SID parameter.

sai

Report message to a moderator

Re: How to change default Instance (SID) ? [message #22872 is a reply to message #22863]

Sun, 03 November 2002 10:52

nat
Messages: 11
Registered: March 2002

Junior Member

Thanks a lot Sai. I really appreciate this.

Report message to a moderator

Previous Topic:	Help installing oracle 9i
Next Topic:	update using multiple tables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Apr 28 17:39:03 CDT 2024