启动监听时的XDB、XPT和PLSExtProc服务的介绍

观察监听在数据库每个状态下各个服务的启动情况和状态：

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

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

SQL> startup nomount;
ORACLE instance started.

Total System Global Area  826277888 bytes
Fixed Size      1222096 bytes
Variable Size    473958960 bytes
Database Buffers   348127232 bytes
Redo Buffers      2969600 bytes

Service "C2155" has 1 instance(s).
  Instance "C2155", status BLOCKED, has 1 handler(s) for this service...
Service "C2155_XPT" has 1 instance(s).
  Instance "C2155", status BLOCKED, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

注：数据库在nomount状态下，有SID、SID_XPT、PLSExtProc服务，其中，SID、SID_XPT服务处于封锁状态，PLSExtProc处于未知状态。

SQL> alter database mount;

Database altered.

Services Summary...
Service "C2155" has 1 instance(s).
  Instance "C2155", status READY, has 1 handler(s) for this service...
Service "C2155_XPT" has 1 instance(s).
  Instance "C2155", status READY, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

注：数据库在nomount状态下，有SID、SID_XPT、PLSExtProc服务，其中，SID、SID_XPT服务处于就绪/准备状态，PLSExtProc处于未知状态。

SQL> alter database open;

Database altered.

Services Summary...
Service "C2155" has 1 instance(s).
  Instance "C2155", status READY, has 1 handler(s) for this service...
Service "C2155XDB" has 1 instance(s).
  Instance "C2155", status READY, has 1 handler(s) for this service...
Service "C2155_XPT" has 1 instance(s).
  Instance "C2155", status READY, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

注：数据库在nomount状态下，有SID、SIDXDB、SID_XPT、PLSExtProc服务，其中，SID、SIDXDB、SID_XPT服务处于就绪/准备状态，PLSExtProc处于未知状态。

下面分别介绍各个服务的作用：
SID：启动数据库实例的服务
SIDXDB：高效处理XML数据的服务
SID_XPT：为DG准备的服务
PLSExtProc：PL/SQL调用外部接口(C、JAVA编写的过程)的服务——容易受攻击

如何在监听启动时不再启动PLSExtProc服务：直接从listerner.ora中移除该项。