Oracle Database - ORACLE_SID environment variable

Card Puncher Data Processing

About

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

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]

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

/etc/oratab

The oratab file matches the oracle_sid with an oracle_home





Discover More
Oracle Registry Windows
Oracle Database - Environment Variables / Registry Values

To configure the database installation, Oracle provide several Environment variable / Registry Value. : oracle_sid is used for a local connection - direct to the server - without using a listener...
Oracle Home Location
Oracle Database - Oracle Home Directory (ORACLE_HOME|OH)

The Oracle home directory (ORACLE_HOME) is the directory where you choose to install the software for a particular Oracle product. You must install different Oracle products or different releases of the...
Card Puncher Data Processing
Oracle Database - Special Characters

In Oracle Database files and programs, a question mark (?) represents the value of the ORACLE_HOME environment variable. For example, Oracle Database expands the question mark in the following SQL statement...
Card Puncher Data Processing
Oracle Database - oraenv and coraenv script to set Linux environment variable

This section describes how to set a common operating system environment (environment variable) by using the oraenv or coraenv scripts, depending on the default shell: For the Bourne, Bash, or Korn shell,...
Card Puncher Data Processing
SQL Plus - How to connect to a particular oracle database instance ?

Before you attempt to use SQLPlus to connect locally to an Oracle instance, you must ensure that environment variables are set properly. When multiple database instances exist on one server, or when...



Share this page:
Follow us:
Task Runner