http://www.blogjava.net/freeman1984/archive/2011/04/15/348350.html
Network/admin目录下找到listener.ora打开,全文如下,其中
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = C:\app\Administrator\product\11.2.0\dbhome_1)
(SID_NAME = ORCL)
)
部分是添加上的,因为监听程序没有识别数据库的sid,所以就在监听程序的文件中手动添加了描述数据库sid的描述命令,这样之后监听程序就可以根据这个监听到数据库的sid。
# listener.ora Network Configuration File: C:\app\Administrator\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 = C:\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = C:\app\Administrator\product\11.2.0\dbhome_1)
(SID_NAME = ORCL)
)
)
本内容试读结束,登录后可阅读更多
下载后可阅读完整内容,剩余1页未读,立即下载