Document toolboxDocument toolbox

ORACLE: Connection fails


Summary

The initial Oracle database connection fails.

Cause

Missing authorization.

Solution

Start the PerformerSuite.exe as Administrator.


Error (could not resolve the connect identifier specified)

ORA-12154: TNS: could not resolve the connect identifier specified
ORA-12154: TNS: Angegebener Connect Identifier konnte nicht aufgelöst werden

Cause

The Performer Suite 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, Performer Suite cannot use this file.

Solution

  1. Try to enter the real IP as "server name", e.g. 12.345.678.910:1521
  2. If it still does not connect 12.345.678.910:1521/<ServiceName>
  3. 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)

Error, the connection could not be established.
'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 Performer Suite BIT-version is incompatible with your Oracle Client.

Solution

Install the same BIT-version for the Performer Suite and the Oracle Client.
i.e. 64-bit Performer Suite ↔ 64-bit Oracle Client



Error (requires Oracle client software version 8.1.7 or greater)

PerformerSuite.log (C:\Users\<USER>\Documents\Performer Suite\Log)
writes the following line:

'System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.

Cause

Oracle Client folder missing permissions.

Solution

  1. Go to the Oracle Client folder.
  2. Right-click on the folder → Properties → Security
  3. Add “Authenticated Users” and give this account Read & Execute permission.
  4. Apply this security for all folders, subfolders, and files (IMPORTANT).
  5. 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


© 2024 bluetelligence GmbH. All rights reserved.
No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of bluetelligence GmbH. The information contained herein may be changed without prior notice. bluetelligence and Performer Suite and their respective logos are trademarks or registered trademarks of bluetelligence GmbH. SAP, ABAP, BAPI, SAP NetWeaver, SAP BI, SAP BW, SAC, and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany or an SAP affiliate company. All other product and service names mentioned are the trademarks of their respective companies.
Impressum – Legal Notice: https://bluetelligence.de/en/imprint
Privacy policy: https://performersuite.de/en/privacy-policy
Atlassian privacy policy: https://www.atlassian.com/legal/privacy-policy