tnsping 报错Message 3511 not found; No message file for product=network, facility=TNSTNS-03505:

本文主要是介绍tnsping 报错Message 3511 not found; No message file for product=network, facility=TNSTNS-03505:，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！



安装oraclientlite11g，安装形式:Administrator

安装完成后测试tnsping vsjck，vsjck已在tnsnames.ora中配置。报以下错误：
Message 3511 not found; No message file for product=network,facility=TNSTNS-03505: Message 3505 not found; No message file forproduct=network, facility=TNS

解决办法：
在环境变量新增用户变量。变量名：ORACLE_HOME，路径C:\Oracle\product\11.2.0\client_lite（对应安装路径）

重新打开cmd

再次尝试 tnsping vsjck

C:\Users\LL>tnsping vsjck

TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 13-DEC-2
017 09:49:55

Copyright (c) 1997, 2010, Oracle.  All rights reserved.

Used parameter files:
C:\Oracle\product\11.2.0\client_lite\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = XXX.XXX.XXX.XXX)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = VSJCK1)))
OK (110 msec)

成功

问题得以解决。

 

这篇关于tnsping 报错Message 3511 not found; No message file for product=network, facility=TNSTNS-03505:的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---