| Oracle_Sid [message #53347] |
Fri, 13 September 2002 14:24  |
Mlton
Messages: 1
Registered: September 2002
|
Junior Member |
|
|
|
How and where do I set the oracle_sid for multiple databases on my oracle server?
|
|
|
|
| Re: Oracle_Sid [message #53360 is a reply to message #53347] |
Mon, 16 September 2002 00:49  |
K.K. Raj kumar
Messages: 33
Registered: July 2002
|
Member |
|
|
Hello,
It is an Environment variable at OS level. For eg. In Unix at $ prompt the variable should be set.
If a user wants to connect to 2 Databases say db1 and db2
then at $ prompt
$ORACLE_SID=db1 (Assuming SID and DATABASE name are same)
after this command if the user uses sqlplus then the user will connect to db1 database.
and if at $ prompt $ORACLE_SID=db2 then the user will connect to db2 database
|
|
|
|
| Re: Oracle_Sid [message #53372 is a reply to message #53347] |
Mon, 16 September 2002 12:11 |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
When you are creating new database, you set the SID in the CREATE DATABASE ... command. You can change it of course, after that.
To set the SID on Windows:
c:>set oracle_sid=db1
c:>svrmgrl
then
c:>set oracle_sid=db1
c:>svrmgrl
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
