Table of Contents
...
Summary
The initial Oracle database connection fails.
Error (could not resolve the connect identifier specified)
| Code Block | ||||
|---|---|---|---|---|
| ||||
ORA-12154: TNS: could not resolve the connect identifier specified ORA-12154: TNS: Angegebener Connect Identifier konnte nicht aufgelöst werden |
Cause
The Docu Performer cannot translate your entered Oracle hostname into an IP.
Normally the file TNSNAMES.ORA is responsible for this translation (path: $ORACLE_HOME/network/admin), but unfortunately, Docu Performer cannot use this file.
Solution
- Try to enter the real IP as "server name", e.g. 12.345.678.910:1521
- If it still does not connect 12.345.678.910:1521/<ServiceName>
- Or even the complete connection string. (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<host>) (PORT=<port>))(CONNECT_DATA=(SERVICE_NAME=<serviceName>))
Described in more detail here: ORACLE: Configure connection
...
Error (connection could not be established)
| Code Block | ||||
|---|---|---|---|---|
| ||||
Error, the connection could not be established. |
...
| Code Block | ||||
|---|---|---|---|---|
| ||||
'System.InvalidOperationException: Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed. |
Cause
Your Docu Performer BIT-version is incompatible with your Oracle Client.
Solution
Install the same BIT-version for the Docu Performer and the Oracle Client.
i.e. 64-bit Docu Performer ↔ 64-bit Oracle Client
...
Error (requires Oracle client software version 8.1.7 or greater)
DocuPerformer.log (C:\Users\<USER>\Documents\BI Docu Performer\Log)
writes the following line:
| Code Block | ||||
|---|---|---|---|---|
| ||||
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater |
Cause
Oracle Client folder missing permissions.
Solution
- Go to the Oracle Client folder.
- Right-click on the folder → Properties → Security
- Add “Authenticated Users” and give this account Read & Execute permission.
- Apply this security for all folders, subfolders, and files (IMPORTANT).
- REBOOT your machine (if you don't do this you will still face the same problem)
Solution 2
- Set your environment variable to the Oracle Client path
...