案例:
在windows的oracle实例orcl中可以正常添加linux中oracle的dblink
在linux中编辑tnsnames.ora后无法tnsping通windows中的实例orcl
[oracle@rac1 admin]$ tnsping orcl
TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 04-FEB-2015 21:25:01
Copyright (c) 1997, 2013, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = orcl)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.digitalchina.com)))
TNS-12541: TNS:no listener
报错内容显示在windwos服务端中没有监听程序
此时检查windows端的监听程序显示正常
C:\Users\zhaixya>lsnrctl status
LSNRCTL for 64-