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

Thread: service name

  1. #1
    Join Date
    Apr 2002
    Posts
    135
    hai i am really confused .

    What is the exact difference between the Service name and the instance name in oracle.

    Should the both be same?
    Good Judgement comes from Experience.
    Experience comes from Bad Judgement

  2. #2
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    In my exoerience service_name has always been set to the ORACLE_SID.

    This service_name is also entered in listener.ora
    If a service_name is entered without correct service_name as it is in the listener.ora, you will NOT connect.

    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  3. #3
    Join Date
    Dec 2001
    Posts
    320
    hi sona,
    prior to 8i, you could've made a service with any name you want to connect to a database server, but in 8i and later your service name has to be the same as the instance name.

    i'm waiting for anyone to correct me if i'm wrong.

    Regards.

  4. #4
    Join Date
    Aug 2002
    Location
    Bangalore
    Posts
    52
    service_name has to the SID of the database and instance_name is the name of instance.If you are in OPS environment instance_name can be different.

    correct me if I am wrong.

  5. #5
    Join Date
    Jul 2002
    Location
    Lincolnshire, IL
    Posts
    203
    prior to Oracle 8i service name and Instance name could be different, but from 8i onwards service name and instance name should me same unless you are on multithreaded system where each instance of the same database will have different name.
    Hope it helps
    Sandy
    "Greatest Rewards come only with Greatest Commitments!"

  6. #6
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    Lemme throw in some more confusion what is the difference between db_name and sid???
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Originally posted by Tarry
    Lemme throw in some more confusion what is the difference between db_name and sid???
    you can have sid test1 and db_name test2 with no problems

    just naming conventions

  8. #8
    Join Date
    Jul 2002
    Location
    Lincolnshire, IL
    Posts
    203
    Dear Tarry,
    I think SID stands for session ID which is also same as your database name. Prior to Oracle 8i SID and database name could be different, but now they are suppose to be same.
    Plz correct me if I'm wrong...
    Sandy
    "Greatest Rewards come only with Greatest Commitments!"

  9. #9
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    Originally posted by sandycrab
    Dear Tarry,
    I think SID stands for session ID Sandy
    In naming terms it's Sys tem ID
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

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