Forum Stats

  • 3,826,790 Users
  • 2,260,707 Discussions
  • 7,897,074 Comments

Discussions

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

Moslem
Moslem Member Posts: 39 Green Ribbon
edited Feb 14, 2022 9:02AM in SOA Suite Discusssions

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