What is the difference between SID and Global Database Name ?

SID (System Identifier)  :  A SID (almost) uniquely identifies an instance.  Actually, $ORACLE_HOME, $ORACLE_SID and $HOSTNAME identify an instance uniquely. The SID is 64 characters, or less; at least on Oracle 9i. The system identifier is included in the CONNECT_DATA parts of the connect descriptors in a tnsnames.ora file. The SID defaults to the database name.

Global Database Name : A database is uniquely identified by a global database name. Usually, a global database name has the form somename.domain. The global database name is the composit of db_domain and db_name.

Showing Answers 1 - 3 of 3 Answers

opbang

  • Sep 22nd, 2006
 

system identifier (SID) of a database instance.

 

Oracle recommends that you choose a database SID that will not be managed using

Enterprise Manager repository.

 

Global Database Name  The full name of the database which uniquely identifies it from any other database. The global database name is of the form "database_name.database_domain", for example, oemrep.us.ovenbird.com. The database name portion, oemrep, is a simple name you wish to call your database. The database domain portion, us.ovenbird.com, specifies the database domain in which the database is located, making the global database name unique. When possible, Oracle recommends that your database domain mirror the network domain.

 

The global database name is the default service name of the database, as specified by the SERVICE_NAMES parameter in the initialization parameter file.

 

SID The Oracle System Identifier (SID). A name that identifies a specific instance of a running Oracle database. For any database, there is at least one instance referencing the database.

 

  Was this answer useful?  Yes

HImanshu

  • Oct 26th, 2006
 

Oracle System Identifier (SID)

A name that identifies any instance of runnin pre release8.1.oracle database. For any database ther is atleast one instance refering the database...

For pre-release 8.1 databases, SID is used to identify the database.

ISD is included in the connect discriptor of the tnsnames.ora file and in the definition of the listemer in the listener.ora file..

Global Database name:

The full name of the database which uniwuely identifies it from any other database. The global database name is of the form database_name.database_domain, for ex; sales.us.acme.com

  Was this answer useful?  Yes

Ashu Shukla

  • Oct 23rd, 2007
 

SID is used when we want to login as a local user
Global Database name is used when we want to login as a remote login user

SID = identifies the database instance (database name + instance number). So if your database name is somedb and your instance number is 3, then your SID is somedb3.

DB Name = Name of the database (database can be shared b/t multiple instances)

DB Domain = Usually the same as your company domain (somecompany.com)

Global Database Name = Database name + database domain (somedb.somecompany.com)

 

Hannan,OCA

  Was this answer useful?  Yes

pavan

  • Jul 4th, 2017
 

Can a database name can be same across multiple instances, and can the instances number be same? If yes what is SID in that case?

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions