Oracle Database - System Identifier (SID)

目录(?) [+]

1. SID or service name
2. How to change it ?

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 :

• When a database is created, a name is associated with it and stored in its control files.
• When an heterogeneous services source is created, an SID refer to it
  
  
  
  
  
  

  SID or service name

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

  

  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.