This discussion is archived
1 Reply Latest reply: Aug 11, 2013 6:05 AM by 95056019-c349-496b-ad9c-2202fc62e187 RSS

Connection to a database

95056019-c349-496b-ad9c-2202fc62e187 Newbie
Currently Being Moderated

Hello everyone,I'm new to Oracle database,and i want to know more about SID and service name tha appears when creating a new connection.

Thanks for your answers

  • 1. Re: Connection to a database
    Asif Muhammad Guru
    Currently Being Moderated

    Hi,

     

    SID is a unique name that is given to the database, and databases are identified using SID names. If for example you have 2 databases as TEST and PROD, you may set the SID name to switch between databases when connecting to them respectively.

     

    Service name is a logical representation of a database, which is the way a database is presented to clients. A database can be presented as multiple services and a service can be implemented as multiple database instances. The service name is a string that is the global database name, that is, a name comprising the database name and domain name, entered during installation or database creation. If you are not sure what the global database name is, you can obtain it from the value of the SERVICE_NAMES parameter in the initialization parameter file.


    Please also refer link:

    Thought! Mate..: Oracle - SID vs Service Name

    Oracle: SID vs. Service Name

    Oracle SID != Service_name


    Hope this answers!

    Best Regards

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points