ORACLE SID
The Oracle System ID (SID) is used to uniquely identify a particular database on a system. For this reason, one cannot have more than one database with the same SID on a computer system. When using RAC, all instances belonging to the same database must have unique SID's.
Switching between databases
Set the ORACLE_SID environment variable (or ORA_SID on VMS systems) to work on a particular database. Remember that the SID is case sensitive in Unix / Linux environments.
How to set the variable on Windows:
set ORACLE_SID=orcl
How to set the variable on Unix/ Linux:
export ORACLE_SID=orcl
Below are some of the script files which are yet to be tested, to set the ORACLE_SID, will upload them soon!
Download SIDsid script file
Download sample SIDsid script file
Download sample oraarc111 script file
Download sample setpath script file
The Oracle System ID (SID) is used to uniquely identify a particular database on a system. For this reason, one cannot have more than one database with the same SID on a computer system. When using RAC, all instances belonging to the same database must have unique SID's.
Switching between databases
Set the ORACLE_SID environment variable (or ORA_SID on VMS systems) to work on a particular database. Remember that the SID is case sensitive in Unix / Linux environments.
How to set the variable on Windows:
set ORACLE_SID=orcl
How to set the variable on Unix/ Linux:
export ORACLE_SID=orcl
Below are some of the script files which are yet to be tested, to set the ORACLE_SID, will upload them soon!
Download SIDsid script file
Download sample SIDsid script file
Download sample oraarc111 script file
Download sample setpath script file
No comments:
Post a Comment