通常按网上各贴所言,配置对listener.ora和tnsnames.ora即可。然而我耐心的比较了几个小时- -,也没发现有什么不对的地方。
重点是这里
注意到了吗。监听的名字不知道什么时候变成了ORACLEOraDb11g_home1TNSListenerLISTENER1!(可能是使用oracle自带工具重新配置监听导致的)这意味着,此时listener.ora的配置需要相应调整如下:
# listener.ora Network Configuration File: D:\ORACLE\product\11.2.0\dbhome_1\network\admin\listener.ora # Generated by Oracle configuration tools. LISTENER1 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = che-PC)(PORT = 1521)) ) ) SID_LIST_LISTENER1 = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = ORCL) (ORACLE_HOME =D:\Oracle\product\11.2.0\dbhome_1) (SID_NAME = ORCL) ) (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = D:\ORACLE\product\11.2.0\dbhome_1) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=ONLY:D:\ORACLE\product\11.2.0\dbhome_1\bin\oraclr11.dll") ) )
LISTENER1和SID_LIST_LISTENER1都应该与服务名对应。