Workflow Builder - Cannot Connect To Database, ORA-1215

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/appsc0n@devcon01' ('ORA-12154: TNS:could not resolve service name').

Solution

To implement the solution, please execute the following steps:

On Windows, set the TNS_ADMIN environment variable as follows:

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 that you wish to use. You can include other TNSNAMES.ORA files with the INAME command inside the TNSNAMES.ORA file.