Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Please ask technical questions in the appropriate category. Thank you!

Oracle Form Builder / ORA-12154: TNS : could not resolve the connect identifier specified

MoslemFeb 14 2022 — edited Feb 14 2022

I'm getting the error message below when trying to connect to database in the Data Block Wizard (in Oracle Form Builder):
ORA-12154: TNS : could not resolve the connect identifier specified
In order to fix that, I set the TNS_ADMIN environment variable to the directory path where the tnsnames.ora file exists. In addition, I have changed the tnsnames.ora file content like so:

DEV = (DESCRIPTION =(ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)
          (HOST = localhost)(PORT = 1521)))
          (CONNECT_DATA = (SID = DEV)))

However, I still get the same error message. Any idea how to fix that?

Comments
Post Details