监听器问题 请问各位为什么我的数据库每次开起来都说没有监听器去配制后,进入lsnrctl开起来都提示协议适配器出错会不会有其它什么原因呢??? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 看看tnsnames.ora 和listener.ora里面的配置信息是否一致lsnrctl status看看当前instance的listener的状态 tnsnames.ora 和listener.ora不一样当前壮态就是说没有协议适配器高手们啊好急啊 不一样,配置成一样的啊,网上资料很多,利用好google和baidu 配置的监听端口和tnsname里面使用的端口是一致的吗?还有tnsname中相联接的数据库是不是指派到了你打开的监听? tnsname文件# TNSNAMES.ORA Network Configuration File: d:\oracle\ora92\network\admin\tnsnames.ora# Generated by Oracle configuration tools.XIEXIN_XIEXIN = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = xiexin)(PORT = 1521)) ) (CONNECT_DATA = (SID = xiexin) (SERVER = DEDICATED) ) )TEST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = xiexin10-2e7e75)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = test) ) )INST1_HTTP = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = xiexin10-2e7e75)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = SHARED) (SERVICE_NAME = MODOSE) (PRESENTATION = http://HRService) ) )EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) )listener.ora文件# LISTENER.ORA Network Configuration File: d:\oracle\ora92\network\admin\listener.ora# Generated by Oracle configuration tools.LISTENER1 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = xiexin10-2e7e75)(PORT = 1522)) ) ) )LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = xiexin10-2e7e75)(PORT = 1521)) ) ) )SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = d:\oracle\ora92) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = test) (ORACLE_HOME = d:\oracle\ora92) (SID_NAME = test) ) ) 你在计算机的服务中,先启动oracle 监听服务,如果不能正确启动,或者启动一会儿就停了,那就要具体分析了,计算机名称的改动也会 导致此,如果是,请看http://hi.baidu.com/zhao_e893/blog/item/7b0dac0926b29e246b60fb80.html,如果这里的服务能启动,那就是你建立网络连接名称时有问题,这里需要注意的是,保证数据库服务器的名字和sid指定正确。 是test不行还是xinxin不行?linster里面没有对应LISTENER1的sid的配置。 执行.sql脚本 显示“未连接”是什么错误? 紧急请教高手 存储过程效率问题 存储过程调用存储过程的问题 是否有专用工具,可将sqlserver的数据实时更新到oracle的表中?? oracle 数据的导出问题 求一个巨简单的查询(但对速度有严格要求)求SQL急速圣手指点! 请教? 求一PL/SQL语句??? 基础版没人理我,只好来这!奇怪问题,望大侠指教!!! ORACLE中的SID是个什么概念呀 如何根据oracle已排好序的树,返回每个结点对应的诸如1.1,1.11,1,2之类的序号 这个日期怎么插?高手指点!
当前壮态就是说没有协议适配器高手们啊
好急啊
还有tnsname中相联接的数据库是不是指派到了你打开的监听?
# TNSNAMES.ORA Network Configuration File: d:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.XIEXIN_XIEXIN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xiexin)(PORT = 1521))
)
(CONNECT_DATA =
(SID = xiexin)
(SERVER = DEDICATED)
)
)TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xiexin10-2e7e75)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test)
)
)INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xiexin10-2e7e75)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)listener.ora文件# LISTENER.ORA Network Configuration File: d:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.LISTENER1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xiexin10-2e7e75)(PORT = 1522))
)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xiexin10-2e7e75)(PORT = 1521))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = test)
(ORACLE_HOME = d:\oracle\ora92)
(SID_NAME = test)
)
)
如果这里的服务能启动,那就是你建立网络连接名称时有问题,这里需要注意的是,保证数据库服务器的名字和sid指定正确。
linster里面没有对应LISTENER1的sid的配置。