"TNS-03505: Failed to resolve name" error when trying to connect to database. (4260578)

Tchater maintenant avec le support

Retour

Titre

"TNS-03505: Failed to resolve name" error when trying to connect to database.
Description

I am having an issue connecting to a database with the error "ORA-12154 TNS:could not resolve the connect identifier". I have copied over the entry in tnsnames.ora entry from the $ORACLE_HOME/network/admin/tnsname.ora to the tnsnames file that Spotlight or Toad for Oracle uses, but with no success.

I am able to connect to another database on the same server without any issue, but if I try to tnsping this database from Command Prompt or Line, I encounter the following message:

G:\>tnsping ASPROD
TNS Ping Utility for 32-bit Windows: Version 10.1.0.2.0 - Production on 07-MAR-2
Copyright (c) 1997, 2003, Oracle. All rights reserved.
Used parameter files:
TNS-03505: Failed to resolve name

Connexion requise

Vous devez être connecté et disposer d'un contrat de maintenance en cours pour afficher les  articles de la base de connaissances avancés.

Contenu recommandé

Produit(s) :: Spotlight on Oracle
7.1, 7.0, 6.1, 6.0, 5.0.1, 4.5.1, 4.5.2, 5.0, 4.0.4, 4.0.3, 4.5, 4.0.2, 3.10 Stand, 3.10, 3.8, 3.6, 3.5, 4.0, 3.0, 2.2c5, 2.2c4, 2.2c1, 2.1c3, 2.1c2, 2.1c1, 2.0d4, 2.0d5, 2.0d3, 2.0d2, 2.0d1, 2.0c2, 2.0c1, 1.0c2, 1.0c1; Toad for Oracle

Historique de l’article :: Créé le : 3/19/2008
Dernière mise à jour le : 5/7/2023