How SID is different from Service name in Oracle tnsnames.ora:
[url]http://stackoverflow.com/questions/43866/how-sid-is-different-from-service-name-in-oracle-tnsnames-ora[/url]
[quote]
[quote]In short: SID = the unique name of your DB, ServiceName = the alias used when connecting[/quote]
Not strictly true.. SID = unique name of the INSTANCE (eg the oracle process running on the machine). Oracle considers the "Database" to the be files.
Service Name = alias to an INSTANCE (or many instances). The main purpose of this is if you are running a cluster, the client can say "connect me to SALES.acme.com", the DBA can on the fly change the number of instances which are available to SALES.acme.com requests, or even move SALES.acme.com to a completely different database without the client needing to change any settings.
[/quote]
本地Net服务名 和 service_name 区别图例:
[img]http://dl.iteye.com/upload/attachment/112620/5d1ad90c-918b-3371-86a6-e9582e4dbfa5.png[/img]
[img]http://dl.iteye.com/upload/attachment/112622/9cb8b39a-4c16-36a8-a6e0-24fe4f394eae.png[/img]
[img]http://dl.iteye.com/upload/attachment/112624/1bf4ed50-94ae-3cbf-9975-f1c251d85b78.png[/img]
[url]http://stackoverflow.com/questions/43866/how-sid-is-different-from-service-name-in-oracle-tnsnames-ora[/url]
[quote]
[quote]In short: SID = the unique name of your DB, ServiceName = the alias used when connecting[/quote]
Not strictly true.. SID = unique name of the INSTANCE (eg the oracle process running on the machine). Oracle considers the "Database" to the be files.
Service Name = alias to an INSTANCE (or many instances). The main purpose of this is if you are running a cluster, the client can say "connect me to SALES.acme.com", the DBA can on the fly change the number of instances which are available to SALES.acme.com requests, or even move SALES.acme.com to a completely different database without the client needing to change any settings.
[/quote]
本地Net服务名 和 service_name 区别图例:
[img]http://dl.iteye.com/upload/attachment/112620/5d1ad90c-918b-3371-86a6-e9582e4dbfa5.png[/img]
[img]http://dl.iteye.com/upload/attachment/112622/9cb8b39a-4c16-36a8-a6e0-24fe4f394eae.png[/img]
[img]http://dl.iteye.com/upload/attachment/112624/1bf4ed50-94ae-3cbf-9975-f1c251d85b78.png[/img]