Ora-12154 TNS:Could not resolve service name - Urgent...
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Ora-12154 TNS:Could not resolve service name - Urgent...

  1. #1
    Join Date
    Jun 2002
    Posts
    88
    hi,

    How to find out ora-12154 : TNS could not resolve service name.

    Waiting for ur reply,

    Thanks,
    Iyyappan.M

  2. #2
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    Then resolve it!
    use net8 utility to test the service name. and then connect.
    although you haven't posted what you did in the configuration.
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Your tnsnames.ora file (on the client) is not configured correctly.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    May 2002
    Posts
    108

    Have you configured a connection to the database?

    What version of Oracle client are you using?

    Cheers
    Nandu

    Never give up !

    Nanda Kumar - Vellore

  5. #5
    Join Date
    May 2002
    Posts
    13
    The SID or Service_name in your tnsnames.ora file must match that of your database server. Depend on your oracle naming convention, you may also need to check your SQLnet.ora file and see if the correct domain name is appended to your service name. Good luck.

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