This discussion is archived
4 Replies Latest reply: Jan 1, 2012 12:16 AM by 907806 RSS

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

907806 Newbie
Currently Being Moderated
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 Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    thanks all of frd, i solved my problem.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points