;这个错误是指监听程序出现了问题,而监听文件为listener.ora,在product\11.2.0\dbhome_1\NETWORK\ADMIN目录下。
按照下面方式修改
# listener.ora Network Configuration File: F:\app1\92306\product\11.2.0\dbhome_1\network\admin\listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER =(SID_LIST =(SID_DESC =(SID_NAME = CLRExtProc)(ORACLE_HOME = F:\app1\92306\product\11.2.0\dbhome_1)(PROGRAM = extproc)(ENVS = "EXTPROC_DLLS=ONLY:F:\app1\92306\product\11.2.0\dbhome_1\bin\oraclr11.dll"))(SID_DESC=(GLOBAL_DBNAME= orcl)(ORACLE_HOME = F:\app1\92306\product\11.2.0\dbhome_1)(SID_NAME = ORCL)))LISTENER =(DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))))ADR_BASE_LISTENER = F:\app1\92306
注意下面这部分
(SID_DESC=(GLOBAL_DBNAME= orcl)(ORACLE_HOME = F:\app1\92306\product\11.2.0\dbhome_1)(SID_NAME = ORCL))
然后重启监听:
lsnrctl stoplsnrctl start
文章转载自Oracle那些事,如果涉嫌侵权,请发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。




