Oracle Database - ORACLE_SID environment variable

> Database > Oracle Database

1 - About

ORACLE_SID is an environment variable which identify the System Identifier (SID) of the database.

Advertising

3 - At sign (@)

The at sign (@) represents the ORACLE_SID environment variable. For example, to indicate a file that belongs to the current instance, run the following command:

SQL> ALTER TABLESPACE tablespace_name ADD DATAFILE [email protected].dbf

You can create a syslog audit trail to track administrative activities.

4 - /etc/oratab

The oratab file matches the oracle_sid with an oracle_home

db/oracle/oracle_sid.txt · Last modified: 2017/09/06 19:28 by gerardnico