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!

oracle sid and database name

OracleGuy777Nov 2 2008 — edited Nov 3 2008

hi guys,

I am getting a bit confused by the ORACLE_SID and database name. I understand that an instance can be attached to just one database, and that a database can be attached to many instances.

Basically, when we are setting the values in our init.ora, are we setting values for the instance, or the database, or is it a mixture? i.e. the instance, and the database to which it can connect?

Also, is it the DB_NAME parameter that specifies which database the instance can connect to?

And why does it say in the [Oracle documentation |http://download.oracle.com/docs/cd/B10501_01/server.920/a96521/create.htm#1003921] that The value of the DB_NAME initialization parameter should match the SID setting. I thought they did not have to be the same?

thanks

This post has been answered by 26741 on Nov 2 2008

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 1 2008

Added on Nov 2 2008

#general-database-discussions

4 comments

1,534 views