DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Diff between SERVICE_NAME vs SID!

  1. 11-17-2001, 12:24 PM #1
    amitstora
    amitstora is offline Senior Member
    Join Date
    Feb 2001
    Posts
    286
    Hi all!

    Query:

    1.I would like to know the diff between SERVICE_NAME VS SID!

    Thanks&Regards,

    Amit.
    Reply With Quote Reply With Quote
  2. 11-17-2001, 01:34 PM #2
    julian
    julian is offline Senior Advisor
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Prior to Oracle 8i, clients connected to a database by specifying the Oracle SID (system identifier) in the connect descriptor. SID, or SID_NAME is now called SERVICE_NAMES. The SERVICE_NAMES is used to identify a database service. This parameters defaults to DB_NAME.DB_DOMAIN (the global database name). A database can be identified by more than one service name. Now INSTANCE_NAME identifies an instance of a database. This parameter is analagous to the SID of an instance, that is "SID_NAME" is now "SERVICE_NAME". Again, an instance can have only one "INSTANCE_NAME," but more than one "SERVICE_NAMES" .
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width