SERVICE_NAME versus SID
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: SERVICE_NAME versus SID

  1. #1
    Join Date
    Sep 2002
    Posts
    411

    SERVICE_NAME versus SID

    I have a quick question about SERVICE_NAME and SID.

    I have two instances on the same server. one instance was created by database configurantion assistant this instance called TEST, on the tnsnames oracle used SERVICE_NAME=TEST. I created another database and this new database called MYTEST manually, and I also used SERVICE_NAME=MYTEST. For some reason, when I connect to MYTEST database I got the error:


    ORA-12514: TNS listener could not resolve SERVICE_NAME given in connect

    why was that??? I aslo add MYTEST sid_name into the listener.log and that doesn't help

  2. #2
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    TNSNAMES is very particular about spaces brackets () etc must ensure grammaticaly correct. Oracle recommends DBCA but to tell you the truth I have added many services manually without a problem.

    Could also mean that a service name has been suppied that the listener is not listening for.

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

  3. #3
    Join Date
    Sep 2002
    Posts
    411
    I got it

    stop the listener and restart it to fix the problem

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