Oracle Database - System Identifier (SID)

Card Puncher Data Processing


The System Identifier (SID) identifies a specific database instance. The SID uniquely distinguishes the instance from any other instance on the same computer. Each database instance requires a unique SID and database name. In most cases, the SID is the same as the database name portion of the global database name.

A name that identifies a specific instance of a running pre-release 8.1 Oracle database. For any database, there is at least one instance referencing the database.

For pre-release 8.1 databases, SID is used to identify the database. The SID is included in the connect descriptor of a tnsnames.ora file and in the definition of the listener in the listener.ora file.

Oracle Database File Location Variable

Each instance have an unique name :

SID or service name

If the destination service is:

  • an Oracle8i or later release database, then use Service Name
  • an Oracle release 8.0 database, then use the SID

Sid Or Service Name

How to

change it

To change the name of an existing database, you must use the CREATE CONTROLFILE statement to re-create your control files and specify a new database name.

See it

select * from V$SERVICES;

Discover More
Card Puncher Data Processing
Oracle Database - Automating Shutdown and Startup on Linux

Automating database startup and shutdown guards against incorrect database shutdown. Since the version 11.2, it's recommended to use Oracle Restart but a single database installation doesn't install it....
Card Puncher Data Processing
Oracle Database - Connect Descriptor (TNS Connect String)

The Connect Descriptor (known also as TNS Connect String) is a type of connect identifier. It defines the parameters that need the Oracle Net Service to connect to a database service : the protocol...
Oracle Database Db Unique Name
Oracle Database - DB_UNIQUE_NAME parameter

DB_UNIQUE_NAME = DB_UNIQUE_NAME is a database parameter which specifies a globally unique name for the database. Databases with the same DB_NAME within the same DB_DOMAIN (for example, copies of a database...
Card Puncher Data Processing
Oracle Database - Gateway (Heterogeneous services)

Gateway (Or Heterogeneous Services before 11g) make a non-Oracle system appear as a remote Oracle Database server through program that are called agent. The Oracle ODBC agent acts as an ODBC client and...
Card Puncher Data Processing
Oracle Database - Global Database Name (GLOBAL_NAME)

The Oracle Database (11g) software identifies a database by its global database name. A global database name consists of the database name and database domain. Usually, the database domain is the same...
Hs Odbc Excel Define Name
Oracle Database - How to read data through an ODBC connection with Gateway (Heterogeneous services)

This article is aimed to show how you can access data from oracle database via an odbc connection direct by using the gateway odbc agent (or program) generic connectivity. In this example, an odbc connection...
Card Puncher Data Processing
Oracle Database - How to retrieve the connect descriptor parameters? (host, port, service name and SID)

When you need to install, configure a new software, you need to give a connect descriptor in order to connect to a database. The connect descriptor contains parameters such as hostname, port, service name...
Card Puncher Data Processing
Oracle Database - INSTANCE_NAME parameter

Instances are identified by an instance name. The instance name is specified by the INSTANCE_NAME initialization parameter. The instance name defaults to the Oracle system identifier (SID) of the database...
Card Puncher Data Processing
Oracle Database - ORACLE_SID environment variable

ORACLE_SID is an environment variable which identify the System Identifier (SID) of the database. The at sign (@) represents the ORACLE_SID environment variable. For example, to indicate a file that...
Sid Or Service Name
Oracle Database - Service name

service name is an identifier of a database service. The service name is specified by the SERVICE_NAMES initialization parameter. sidglobal database name If the destination service is: an...

Share this page:
Follow us:
Task Runner