ORA-12162:TNS:net service name is incorrectly specified
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ORA-12162:TNS:net service name is incorrectly specified

  1. #1
    Join Date
    Sep 2002
    Posts
    376

    ORA-12162:TNS:net service name is incorrectly specified

    I am executing the below command as Oracle owner user, on the same host. But getting the following error.


    SQL> connect / as sysdba
    ERROR:
    ORA-12162: TNS:net service name is incorrectly specified
    ------------------------------------------------------------------------
    The most enjoyable things in the world are either Immoral or too Expensive or otherwise Inaccessible anyway

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    12162, 00000, "TNS:service name is incorrectly specified"
    // *Cause: The connect descriptor corresponding to the service name in
    // TNSNAMES.ORA is incorrectly specified.
    // *Action: Make sure there are no syntax errors in the connect descriptor.
    // Particularly look for unmatched parentheses or stray characters.
    // Any error in a TNSNAMES.ORA file makes it unusable. See Chapter 4
    // in the SQL*Net V2 Administrator's Guide.

  3. #3
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    Look into your environment. You may have set default tns string ( I remember that can be done)
    If not, trace the client and see what happens

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    TNS_ADMIN would be that parameter

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