Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Basic question re database name vs SID vs Global db name

433880Jun 26 2006 — edited Jun 27 2006

When installing Oracle Database, you are asked for a Global Database Name as the first part of the installation, and this is to be in the form database_name.domain.

What is the purpose of a "Global" Database Name? To be unique within one's own organisation? To be unique within the network from which it is visible?

The installation notes state that the installer "automatically populates the SID field with the database name, but you can change the SID to another name". It also states that the SID can be 64 characters long.

I entered a global database name of "MYMACHINENAME.orastarter". After installation I have a service called "OracleServiceMYMACHIN".

Why has the first 8 characters been used for the SID (I assume it is the SID rather than the database name)?

What is the database name - is it what I entered (MYMACHINENAME.orastarter), or is it just MYMACHINENAME?

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 25 2006

Added on Jun 26 2006

#general-database-discussions

3 comments

1,108 views