ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

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

  1. #11
    Join Date
    Jan 2002
    Posts
    96
    This is becoming kinda urgent, my box has been down for 3 days!
    Please help!

  2. #12
    Join Date
    May 2002
    Posts
    2,645
    Check the sqlnet.ora file for names.default_domain. If that entry is present (company.com, for example), then your tnsnames.ora entry must be cimdb.company.com, not just cimdb.

    My guess is that your setting is ZA.TISCALI.COM, which is why a connection to DEV.ZA.TISCALI.COM would work, but one to CIMDB.ZA.TISCALI.COM would not because all you have is CIMDB in the tnsnames.ora file. Plain and simple, that's what it is.

  3. #13
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    Why dont you open a tar with Oracle if you need urgent help?
    "High Salaries = Happiness = Project Success."

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