ORACLE_SID

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