Workflow Builder - Cannot Connect To Database, ORA-12154

Workflow Builder - Cannot Connect To Database, ORA-12154 (Doc ID 435755.1)

APPLIES TO: Oracle Workflow - Version 11.5.10.2 to 12.2.3 [Release 11.5.10 to 12.2] Information in this document applies to any platform. Checked for relevance on 23-NOV-2013 SYMPTOMS The Following error occurs whilst trying to start the Workflow Builder 2.6.3.5 Error 1700: Could not connect with username/password'apps/<password>@test.com' (ORA-12154: TNS:could not resolve the connect identifier specified|'). . CAUSE This was reported in internal Bug 4912280 Issue occurs when one attempts to use a local TNSNAMES.ORA file on a Windows platform. SOLUTION To implement the solution, please execute the following steps: 1. Right-click My Computer and choose Properties. 2. On the Advanced tab, choose Environment Variables. 3. Add or edit TNS_ADMIN as a system environment variable so that it points to the directory that contains the TNSNAMES.ORA file used.  -ex: TNS_ADMIN = D:\OraHome1\network\ADMIN     also,  Add or edit ORACLE_HOME as a System environment variable so that it points to the directory where the Software is installed -- ex:  ORACLE_HOME=D:\OraHome1 4. Change the tnsmames.,ora connection string to include the fully qualified hostname.domain From: -------- <SID> =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = myoracle.com)(PORT = 1521))    )    (CONNECT_DATA =      (SERVICE_NAME = dhd01)    )  ) To: ----- <SID>.myoracle.com =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = .myoracle.com)(PORT = 1521))    )    (CONNECT_DATA =      (SERVICE_NAME = dhd01)    )  ) NOTE: If the Environment Variable settings interfere with other products that are installed on the PC, then do the following: Suggestions are: ---------------------- Leave the tnsames.ora change in place Unset the ORACLE_HOME & TNS_ADMIN System variable Reboot the Laptop Test the issue. *** One can include other TNSNAMES.ORA files with the INAME command inside the TNSNAMES.ORA file.

--------------------------------------------------------------------------------------------------------------------------

/u01/test/TEST/db/tech_st/10.2.0/network/admin/TEST_test

[oratest@test TEST_test]$ ls tnsnames.ora

tnsnames.ora

[test@test TEST_test]$ pwd

/u01/test/TEST/db/tech_st/10.2.0/network/admin/TEST_test

--------------------------------

copt tnsname.ora file from linux server from above directory and paset it into oracle wokflow biulder software installed directory

add two enviroment variables in my computer properties ->advanced tab->enviroment variables

variable                                               value

TNS_ADMIN                                      D:\Home_2\network\ADMIN

ORACLE_HOME                                D:\Home_2

connected to apps@TEST