1.直接改写 G:\app\zhixian\product\11.1.0\db_1\network\admin\listener.ora文件,添加以下内容。
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = G:\app\zhixian\product\11.1.0\db_1)
(SID_NAME = orcl)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = G:\app\zhixian\product\11.1.0\db_1)
(SID_NAME = orcl)
)
)
2.重新启动监听服务