Oracle Database - System Identifier (SID)

> Database > Oracle Database

1 - About

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.

Each instance have an unique name :

Advertising

3 - 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

4 - How to

4.1 - 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.

4.2 - See it

SELECT * FROM V$SERVICES;
db/oracle/sid.txt · Last modified: 2017/09/06 19:29 by gerardnico