| multiple sid's [message #57622] |
Thu, 26 June 2003 05:10  |
santh
Messages: 4
Registered: June 2003
|
Junior Member |
|
|
|
can we give multiple sid'in win2k server system properties same time or any alternative how tos et primary sid
|
|
|
|
| Re: multiple sid's [message #57630 is a reply to message #57622] |
Thu, 26 June 2003 07:31  |
ctg
Messages: 146
Registered: July 2002
|
Senior Member |
|
|
you can have multiple instances (sids), yes. the primary (default) would be whatever you ORACLE_SID environment variable would be set to. Because it can only be set to one name at a time.
Here is example i have:
C:>set ORACLE --check my env variable (this is the default value)
ORACLE_SID=PROD
C:>sqlplus /nolog
SQL*Plus: Release 9.2.0.1.0 - Production on Thu Jun 26 09:55:12 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect system/manager
Connected.
SQL> select instance_name, status from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
prod OPEN
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
C:>set ORACLE_SID=DBA -- change env variable to other instance name
C:>set ORACLE
ORACLE_SID=DBA
C:>sqlplus /nolog
SQL*Plus: Release 9.2.0.1.0 - Production on Thu Jun 26 09:55:12 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect system/manager
Connected.
SQL> select instance_name, status from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
dba OPEN
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
