Connection error, "ORA-12154: TNS:Could not resolve connect identifier specified" or "ORA-06413: Connection not open" (4226183)

Tchater maintenant avec le support

Retour

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Titre

Connection error, "ORA-12154: TNS:Could not resolve connect identifier specified" or "ORA-06413: Connection not open"
Description

WORKAROUND 1:
Please ensure that SQL Optimizer, and SQL Optimizer Launcher exe files are run as Administrator by Windows. This can be set against Properties of the .exe files in Windows Explorer, so that it runs them as admin by default.

WORKAROUND 2:
If using an Oracle 11.2.0.1 client, download and install a 12.1.0.2 Instant Client and use to make a connection with SQL Optimizer.
Download from Oracle:
http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html
Cause

Can be caused by Windows permissions restrictions also
Résolution

WORKAROUND 1:
Please ensure that SQL Optimizer, and SQL Optimizer Launcher exe files are run as Administrator by Windows. This can be set against Properties of the .exe files in Windows Explorer, so that it runs them as admin by default.

WORKAROUND 2:
If using an Oracle 11.2.0.1 client, download and install a 12.1.0.2 Instant Client and use to make a connection with SQL Optimizer.
Download from Oracle:
http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Contenu recommandé

Historique de l’article :: Créé le : 1/12/2015
Dernière mise à jour le : 5/7/2023

Titre