oracle客户端 tsnping时出现TNS-03505:无法解析名称

1.检测服务端的监听器有没有启动？ lsnrctl status

2.检测E:\oracle\oracle10g\NETWORK\ADMIN是否存在 tnsnames.ora 和sqlnet.ora 两个文件,文件内容分别是

 

# tnsnames.ora Network Configuration File: E:\oracle\product\10.2.0\client_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL_10.166.253.19 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.166.253.19)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = orcl)
      (SERVER = DEDICATED)
    )
  )

 

-------------------------------------------------------------------------------------

 

 

# listener.ora Network Configuration File: E:\oracle\product\10.2.0\client_1\NETWORK\ADMIN

\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = LYR)(PORT = 1521))
    )
  )

 

 

 

转载于:https://www.cnblogs.com/longlongway/archive/2012/02/18/2356864.html