OFSD Oracle File Server BG
RMON rolling migration monitor
IPC0 IPC Service 0
BW36 db writer process 36
BW99 db writer process 99
TMON Transport Monitor
RTTD Redo Transport Test Driver
TPZ1 Test Process Z1
TPZ2 Test Process Z2
TPZ3 Test Process Z3
LREG Listener Registration
AQPC AQ Process Coord
FENC IOServer fence monitor
VUBG Volume Driver Umbilical Background
SCRB ASM Scrubbing Master



可以看到这里LREG进程开始负责对Listener Registration监听器的注册:

Service registration enables the listener to determine whether a database service and its service handlers are available. A service handler is a dedicated server process or dispatcher that acts as a connection point to a database. During registration, the LREG process provides the listener with the instance name, database service names, and the type and addresses of service handlers. This information enables the listener to start a service handler when a client request arrives.

Figure 16-5 shows two databases, each on a separate host. The database environment is serviced by two listeners, each on a separate host. The LREG process running in each database instance communicates with both listeners to register the database.


截止目前12c的官方文档中的配图还有问题, 图示还是用PMON注册监听。

12c pmon LREG






扫码关注dbDao.com 微信公众号:


  1. trace lreg的动态注册过程:SQL> oradebug setospid 12652Oracle pid: 28, Unix process pid: 12652, image: oracle@maclean1.oracle.com (LREG)SQL> oradebug event 10257 trace name context forever,level 16;Statement processed.SQL> alter system register;System altered.SQL> oradebug event 10257 trace name context off;Statement processed.SQL> oradebug tracefile_name;/s01/diag/rdbms/mac/MAC_1/trace/MAC_1_lreg_12652.trc*** 2013-07-08 08:24:25.736kmlwait: status: succ=2, wait=0, fail=0*** 2013-07-08 08:24:26.528Last post from location=FILE:/ade/b/1635153616/oracle/rdbms/src/hdir/kml.h LINE:181 ID:kmmreg, process=2fkmlwait: status: succ=2, wait=0, fail=0kmmlrl: register nowkmmlrl: 89 processeskmmlrl: node load 7kmmlrl: instance load 4kmmgdnu: macc goodness=0, delta=1, pdb=3, flags=0x4:unblocked/not overloaded, update=0x6:G/D/-kmmgdnu: MACXDB goodness=0, delta=1, pdb=0, flags=0x5:unblocked/not overloaded, update=0x6:G/D/-kmmgdnu: MAC goodness=1, delta=1, pdb=0, flags=0x4:unblocked/not overloaded, update=0x6:G/D/-kmmlrl: nsgr update returned 0kmmlrl: nsgr register returned 0kmlwait: LREG woken up to process network events after 0 cskmlwait: status: succ=2, wait=0, fail=0

Speak Your Mind

沪公网安备 31010802001379号

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569