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...

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?

shaikhannan

 Profile Answers by shaikhannan Questions by shaikhannan

• Feb 3rd, 2010

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 (d...

Answer Question  Select Best Answer