安装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)
成功
问题得以解决。