Oracle监听器中的XDB、_XPT、_DGMGRL 、_DGB、PLSExtProc服务

数据库在shutdown状态下，仅有PLSExtProc服务，且处于未知状态。

数据库在nomount状态下，有SID、SIDXDB、SID_XPT、PLSExtProc服务，其中，SID、SIDXDB、SID_XPT服务处于

就绪/准备状态，PLSExtProc处于未知状态。

下面分别介绍各个服务的作用：

SID：启动数据库实例的服务

SIDXDB：高效处理XML数据的服务，默认会占用8080端口。

SID_XPT：Oracle 10g为DG准备的服务，DB BROKER会用到，如果不用DG可以删掉。

PLSExtProc：PL/SQL调用外部接口(C、JAVA编写的过程)的服务——容易受攻击

" _DGB ":的做用是dgmgrl直接通信用的。
"_DGMGRL" :静态监听的作用：

A static entry is needed for the Broker to be able to connect remotely to a database that has been shut down by the Broker during certain operations. They are required for the Broker to complete the following operations:

• Switchover from the Primary database to a Physical Standby database
• Reinstatement of failed Primary database after a manual or automatic failover has occurred.
• Conversion of a Snapshot Standby database back to a Physical Standby database

To access a database that has been shutdown in one of the above situations, the Broker uses a default name for the static entry using the information from the LOCAL_LISTENER parameter of the instance and the keyword "_DGMGRL" and stores that information in the broker StaticConnectIdentifier property associated with each instance of the database. As a best practice, users should not change the default values assigned to the Broker StaticConnectIdentifier property or to the database LOCAL_LISTENER initialization parameter as the value of the StaticConnectIdentifier property will be automatically updated by the Broker whenever the instance specified by the SidName property is started on a different host.

Note: Static entries are only used by the Broker itself via the Broker defined StaticConnectIdentifier property. They are NEVER to be used for any other purpose by the user. This includes using it for the normal DGConnectIdentifier, RMAN connections or anything else. Also note that you must never define a static entry for the Broker 'DGB' service. That service is for the Broker exclusive use. Also note that using the "_DGMGRL" or "_DGB" in your TNSNAMES definition is expressly forbidden.

================

11g:

后续精彩内容已被小麦苗无情隐藏，请输入验证码解锁本站所有文章

验证码：

请关注本站微信公众号，回复“小麦苗博客”，获取验证码。在微信里搜索“DB宝”或者“www_xmmup_com”或者微信扫描右侧二维码都可以关注本站微信公众号。