Concepts and Architecture - what is the difference between SID and Global Database Name ?

GeekInterview.com > Interview Questions > Oracle > Concepts and Architecture

Go To First | Previous Question | Next Question

Concepts and Architecture | Question 62 of 74

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.

Total Answers and Comments: 3

Last Update: October 23, 2007

Sponsored Links

Best Rated Answer

—

Submitted by: Ashu Shukla

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

Above answer was rated as good by the following members:
rnraomaddula

September 22, 2006 10:20:00

opbang

Member Since: March 2006 Contribution: 46

RE: what is the difference between SID and Global Dat...

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.

Is this answer useful? Yes | No

October 26, 2006 05:09:59

HImanshu

RE: what is the difference between SID and Global Dat...

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

Is this answer useful? Yes | No

October 23, 2007 05:15:49

Ashu Shukla

RE: what is the difference between SID and Global Dat...

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

Is this answer useful? Yes | No

1 0

Overall Rating: +1

Go To Top

User Name		Remember Me?
Password

Question Bank