Forum Stats

  • 3,873,311 Users
  • 2,266,532 Discussions
  • 7,911,502 Comments

Discussions

I have oracle 19c and the sql*plus is giving the error message ORA12154- TNS: could not resolve the

Answers

  • Sunny kichloo
    Sunny kichloo Member Posts: 2,460 Gold Trophy

    Check whether tnsname used is proper.Compare it with tnsnames.ora file and also see if tnsnames.ora file is aligned properly.

    If above mentioned two point are fine then do confirm whether listener.ora is using the same service/SID name as described in your connect descriptor.