StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Please see: <a href="http://www.sap-img.com/oracle-database/finding-oracle-sid-of-a-database.htm" rel="noreferrer">http://www.sap-img.com/oracle-database/finding-oracle-sid-of-a-database.htm</a></p> <blockquote> <p>What is the difference between Oracle SIDs and Oracle SERVICE NAMES. One config tool looks for SERVICE NAME and then the next looks for SIDs! What's going on?!</p> <p>Oracle SID is the unique name that uniquely identifies your instance/database where as Service name is the TNS alias that you give when you remotely connect to your database and this Service name is recorded in Tnsnames.ora file on your clients and it can be the same as SID and you can also give it any other name you want.</p> <p>SERVICE_NAME is the new feature from oracle 8i onwards in which database can register itself with listener. If database is registered with listener in this way then you can use SERVICE_NAME parameter in tnsnames.ora otherwise - use SID in tnsnames.ora.</p> <p>Also if you have OPS (RAC) you will have different SERVICE_NAME for each instance.</p> <p>SERVICE_NAMES specifies one or more names for the database service to which this instance connects. You can specify multiple services names in order to distinguish among different uses of the same database. For example:</p> <p>SERVICE_NAMES = sales.acme.com, widgetsales.acme.com</p> <p>You can also use service names to identify a single service that is available from two different databases through the use of replication.</p> <p>In an Oracle Parallel Server environment, you must set this parameter for every instance.</p> </blockquote> <p>In short: SID = the unique name of your DB instance, ServiceName = the alias used when connecting</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload