Symptom

When trying to connect to an Oracle database, you may receive the following error message:

Error Connecting: ORA-12154: TNS:could not resolve the connect identifier specified

Applicable to 

Connecting to an Oracle database

• Cloud storage in the Administration Console
• BarTender Designer database connection dialog
• Database actions for Form Actions, Document Actions, Process Builder, Integration Builder

Solution

If the Oracle database is available and the user is able to access the database by other means, it is likely that the syntax for specifying the Oracle server does not match what BarTender is expecting when designating a server.

The syntax for specifying the server is as follows:

<IP>/<sid>

<IP> is the IP address of the Oracle server.
<sid> is the Oracle instance name.

e.g. 192.168.0.21/orclexample