Specifies the default server instance for current connection.
Syntax:
ORACLE_SID={server_instance}
Usage:
The ORACLE_SID environment variable specifies the default server instance for current connection. ORACLE_SID is used to distinguish current instance from other Oracle Database instances that you may create later and run concurrently on the same host computer.
The ORACLE_SID value is case-sensitive in UNIX environments.
For information on when to set ORACLE_SID refer to Setting up Oracle Connection.
ORACLE_SID applies at runtime (inet.env) and at compilation (env.properties). You can set ORACLE_SID in system environment variables but it is not recommended unless you have experience in such modifications.
Example:
Specifies querix_tcp as the default server instance for current connection:
ORACLE_SID=querix_ora
Related articles: