3 Replies Latest reply: Mar 15, 2012 4:04 PM by Christian.Shay -Oracle RSS

    Can't connect TNS 12154

    922566
      Hi,
      I installed the lastest ODT 11g and I have a 10g database, I configured the tnsnames.ora (for the 11g) as below:
      ONDA =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ONDA)
      )
      )

      because my database is nammed ONDA

      then I tried to connect with asp.net

      data source name :ONDA
      user name : SYS
      password: manager
      role: SYSDBA

      but I got the error ??? (I don't understand)
        • 1. Re: Can't connect TNS 12154
          922566
          here what I get:
          Microsoft Windows XP [version 5.1.2600]
          (C) Copyright 1985-2001 Microsoft Corp.


          C:\Documents and Settings\yashiro>lsnrctl status

          LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 14-MARS -2012 06:42:40

          Copyright (c) 1991, 2005, Oracle. All rights reserved.

          Connexion Ó (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
          STATUT du PROCESSUS D'ECOUTE
          ------------------------
          Alias LISTENER
          Version TNSLSNR for 32-bit Windows: Version 9.0.1.1.1 - Production
          Date de dÚpart 13-MAR-2012 22:50:36
          DurÚe d'activitÚ 0 jours 7 heures 52 min. 4 sec
          Niveau de trace off
          SÚcuritÚ OFF
          SNMP OFF
          Fichier journal du processus d'Úcoute C:\oracle\ora90\network\log\listener.log
          RÚcapitulatif d'Úcoute des points d'extrÚmitÚ...
          (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=acer-ef3cbdce91)(PORT=1521)))
          Le processus d'Úcoute ne prend en charge aucun service
          La commande a rÚussi


          C:\Documents and Settings\yashiro>lsnrctl service

          LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 14-MARS -2012 06:43:40

          Copyright (c) 1991, 2005, Oracle. All rights reserved.

          Connexion Ó (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
          Le processus d'Úcoute ne prend en charge aucun service
          La commande a rÚussi
          • 2. Re: Can't connect TNS 12154
            orafad
            Please refrain from duplicating threads. {thread:id=2357257}

            Instead continue in your original thread, so to not waste efforts.
            • 3. Re: Can't connect TNS 12154
              Christian.Shay -Oracle
              Please read this link (you will need to copy the tnsnames.ora)
              http://www.oracle.com/technetwork/topics/dotnet/odt-faq-085407.html#ORA-12154:_TNS:could_not_resolve_the