本文介绍如何修改Oracle数据库的listener.ora文件来添加一个新的SID实例。通过具体步骤和代码示例，帮助读者理解如何正确配置监听器以支持多个数据库实例。
[size=large]修改listener.ora如下：[/size]
[size=medium]SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = H:\Oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
[color=blue]#增加以下内容[/color]
[color=red](SID_DESC =
(GLOBAL_DBNAME = test)
(ORACLE_HOME = H:\Oracle\product\10.2.0\db_1)
(SID_NAME = test)
)[/color]
)[/size]
[size=medium]SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = H:\Oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
[color=blue]#增加以下内容[/color]
[color=red](SID_DESC =
(GLOBAL_DBNAME = test)
(ORACLE_HOME = H:\Oracle\product\10.2.0\db_1)
(SID_NAME = test)
)[/color]
)[/size]
扫一扫
7016
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
