4 Replies Latest reply: Jan 1, 2012 2:16 AM by 907806 RSS

    TNS-03505:Failed to resolve name in oracle 11g.

    907806
      i install oracle 11g client in my pc.i want to connect to the server i also used and install Toad Tools. i have server ip address.192.168.1.162 and userid and password and port number-1521

      when i connect to the toad and its make error like that

      ORA-12541TNS- no listener.

      and this is my tnsnames.ora file ,

      # tnsnames.ora Network Configuration File: E:\app\IT\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
      # Generated by Oracle configuration tools.

      ERP =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = IT-PC)(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = erp)
      )
      )

      ORACLR_CONNECTION_DATA =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      )
      (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
      )
      )

      ORCL =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST =IT-PC)(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
      )
      )



      mlmdb =
           (DESCRIPTION =
           (ADDRESS_LIST =
           (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.8.162)(PORT = 1521))
           )
           (CONNECT_DATA =
           (SERVICE_NAME = mlmdb)
           )
           )
      and i want to connect mlmdb from server.


      and this is my listner.ora file

      # listener.ora Network Configuration File: E:\app\IT\product\11.2.0\dbhome_1\network\admin\listener.ora
      # Generated by Oracle configuration tools.

      SID_LIST_LISTENER =
      (SID_LIST =
      (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = E:\app\IT\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:E:\app\IT\product\11.2.0\dbhome_1\bin\oraclr11.dll")
      )
      )

      LISTENER =
      (DESCRIPTION_LIST =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST =IT-PC)(PORT = 1521))
      )
      )


      ADR_BASE_LISTENER = E:\app\IT

      and this is my sqlnet.ora file

      # sqlnet.ora Network Configuration File: E:\app\IT\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
      # Generated by Oracle configuration tools.

      # This file is actually generated by netca. But if customers choose to
      # install "Software Only", this file wont exist and without the native
      # authentication, they will not be able to connect to the database on NT.

      SQLNET.AUTHENTICATION_SERVICES= (NTS)

      NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

      when i connect form the run--cmd--tnsping mlmdb
      its make error likes this
      TNS-03505 : failed to resolve name ,

      can anyone help me how can i find this solution

      thanks in advance.
        • 1. Re: TNS-03505:Failed to resolve name in oracle 11g.
          orafad
          You are showing client net config files from what looks like server home, "dbhome_1".

          What Instant Client package did you install (url)? And what OS, complete edition and version, is on your pc?

          Test connectivity with sqlplus, before you involve the toad.
          • 2. Re: TNS-03505:Failed to resolve name in oracle 11g.
            743319
            904803 wrote:
            i install oracle 11g client in my pc.i want to connect to the server i also used and install Toad Tools. i have server ip address.192.168.1.162 and userid and password and port number-1521

            when i connect to the toad and its make error like that

            ORA-12541TNS- no listener.

            and this is my tnsnames.ora file ,

            # tnsnames.ora Network Configuration File: E:\app\IT\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
            # Generated by Oracle configuration tools.

            ERP =
            (DESCRIPTION =
            (ADDRESS = (PROTOCOL = TCP)(HOST = IT-PC)(PORT = 1521))
            (CONNECT_DATA =
            (SERVER = DEDICATED)
            (SERVICE_NAME = erp)
            )
            )

            ORACLR_CONNECTION_DATA =
            (DESCRIPTION =
            (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
            )
            (CONNECT_DATA =
            (SID = CLRExtProc)
            (PRESENTATION = RO)
            )
            )

            ORCL =
            (DESCRIPTION =
            (ADDRESS = (PROTOCOL = TCP)(HOST =IT-PC)(PORT = 1521))
            (CONNECT_DATA =
            (SERVER = DEDICATED)
            (SERVICE_NAME = orcl)
            )
            )



            mlmdb =
                 (DESCRIPTION =
                 (ADDRESS_LIST =
                 (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.8.162)(PORT = 1521))
                 )
                 (CONNECT_DATA =
                 (SERVICE_NAME = mlmdb)
                 )
                 )
            and i want to connect mlmdb from server.


            and this is my listner.ora file

            # listener.ora Network Configuration File: E:\app\IT\product\11.2.0\dbhome_1\network\admin\listener.ora
            # Generated by Oracle configuration tools.

            SID_LIST_LISTENER =
            (SID_LIST =
            (SID_DESC =
            (SID_NAME = CLRExtProc)
            (ORACLE_HOME = E:\app\IT\product\11.2.0\dbhome_1)
            (PROGRAM = extproc)
            (ENVS = "EXTPROC_DLLS=ONLY:E:\app\IT\product\11.2.0\dbhome_1\bin\oraclr11.dll")
            )
            )

            LISTENER =
            (DESCRIPTION_LIST =
            (DESCRIPTION =
            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
            (ADDRESS = (PROTOCOL = TCP)(HOST =IT-PC)(PORT = 1521))
            )
            )


            ADR_BASE_LISTENER = E:\app\IT

            and this is my sqlnet.ora file

            # sqlnet.ora Network Configuration File: E:\app\IT\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
            # Generated by Oracle configuration tools.

            # This file is actually generated by netca. But if customers choose to
            # install "Software Only", this file wont exist and without the native
            # authentication, they will not be able to connect to the database on NT.

            SQLNET.AUTHENTICATION_SERVICES= (NTS)

            NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

            when i connect form the run--cmd--tnsping mlmdb
            its make error likes this
            TNS-03505 : failed to resolve name ,

            can anyone help me how can i find this solution

            thanks in advance.
            looks like listener is not running on the database server you are trying to connect to *(ORA-12541TNS- no listener)*. even though you have configured both tnsnames and lisnterner.ora files, you have to start listener for clients to make connections to db. hope this helps. set your oracle home and then type as below. these commands are very simple and I don't think I need to explain them.

            cmd> lsnrctl status
            cmd> lsnrctl start
            cmd> lsnrctl stop
            • 3. Re: TNS-03505:Failed to resolve name in oracle 11g.
              Vishalp-Oracle
              when i connect to the toad and its make error like that

              ORA-12541TNS- no listener.
              As suggested check whether the listener is running on server by doing lsnrctl status

              >
              when i connect form the run--cmd--tnsping mlmdb
              its make error likes this
              TNS-03505 : failed to resolve name ,
              For this one check whether you have TNS_ADMIN set. If yes, make sure you add mlmdb entry in the tnsnames.ora file placed at that location.

              Also do:
              set PATH=<Oracle_client_home>/bin
              tnsping mlmdb
              • 4. Re: TNS-03505:Failed to resolve name in oracle 11g.
                907806
                thanks all of frd, i solved my problem.