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

Thread: Services in ORACLE

  1. #1
    Join Date
    Nov 2000
    Posts
    169

    Question

    Hello,
    I have two questions and I will be glad if somebody can answer them accordingly and if possible with some explanations.

    1.In oracle what is a SERVICE NAME? Is it supposed to be the name of the database or it's different?

    2. On NT, the service name can be found in SERVICES in the control panel. At times it's specified in the init.ora file. How can I find the service name in UNIX if it's not specified in the init.ora file?

    thanks.

  2. #2
    Join Date
    Nov 2000
    Location
    Israel
    Posts
    268
    a service name is devided into 2:
    1) the unique identifier of a service provider on a client machine. i.e service
    DB1( ADDRESS = ....
    CONNECT_DATA = (SID = ...))

    this service is your connection to the remote database from a client.

    2) on windows nt a service is the component responsible for the Oracle Instance (OracleServiceXXXX)
    and for the database (OracleStartXXXX)
    It is better to ask and appear ignorant, than to remain silent and remain ignorant.

    Oracle OCP DBA 9i,
    C++, Java developer

Posting Permissions

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


Click Here to Expand Forum to Full Width