| Changing SQL instances in Windows [message #100448] |
Mon, 06 January 2003 06:27  |
Tim Vistisen Baldwin
Messages: 3
Registered: June 2002
|
Junior Member |
|
|
|
I am just converting from ORACLE on Unix to Oracle on Windows. I often use telnet connections to my database servers to run sqlplus locally. On my unix boxes I choose which instance to connect to by changing my ORACLE_SID parameter. How do I do this from a command line in Windows? The only way I can think of is creating a batch file that inports a registry change and changes the ORACLE_SID values in the appriopiate ORACLE home. Is there no better way?
|
|
|
|
| Re: Changing SQL instances in Windows [message #100464 is a reply to message #100448] |
Thu, 09 January 2003 23:46  |
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
|
Senior Member |
|
|
hello,
b4 starting the database u can say
set oracle_sid=sid_name at the command prompt.
or else
go to regedit -> hkey_local_machine ->
get into oracle corner
and set the oracle_sid parameter to u r database name... search for my posting in the oracle server forum.
sai
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
