oracle alter database register,alter system register的用法

今天一个同事问到我,有没动态注册监听的命令,查了下,找到了alter system register的用法

1 Static Registration via set the listener.ora

2 Dynamic Instance Registration via the PMON

At instance startup time, the PMON process will use this parameter to locate a listener and

inform. it of the INSTANCE_NAME and SERVICE_NAMES.

1 At any time subsequent to instance startup, you can force a re-registration by executing the command

SQL> alter system register;

2 You will need to re-register your instance with the listener with “alter system” if you have restarted the listener, or if you started the database instance before starting the listener。(例如，数据库还启动着，这时stop listener,然后启动，就需要手动注册)

eg：

LSNRCTL> stop

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=htsolaris.ht.com)(PORT=1521)))

The command completed successfully

database is still running... then

LSNRCTL> start

Starting /export/home/oracle/product/10.2/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 10.2.0.2.0 - Production

System parameter file is /export/home/oracle/product/10.2/network/admin/listener.ora

Log messages written to /export/home/oracle/product/10.2/network/log/listener.log

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=htsolaris.ht.com)(PORT=1521)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=htsolaris.ht.com)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Solaris: Version 10.2.0.2.0 - Production

Start Date                15-OCT-2008 16:35:24

Uptime                    0 days 0 hr. 0 min. 0 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /export/home/oracle/product/10.2/network/admin/listener.ora

Listener Log File         /export/home/oracle/product/10.2/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=htsolaris.ht.com)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))

Services Summary...

Service "orcl" has 1 instance(s).-----Static Registration via set the listener.ora

Instance "orcl", status UNKNOWN, 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

这个时候没有自动的Dynamic Instance Registration 。

通过手动实现：

system register;

System altered.

这个时候没有自动的Dynamic Instance Registration 。

通过手动实现：

system register;

System altered.

LSNRCTL> status

...

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=htsolaris.ht.com)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))

Services Summary...

Service "ora10g" has 1 instance(s).

Instance "ora10g", status READY, has 4 handler(s) for this service...  ).------------------Dynamic Instance Registration

Service "ora10g_XPT" has 1 instance(s).

Instance "ora10g", status READY, has 4 handler(s) for this service...

Service "orcl" has 1 instance(sInstance "orcl", status UNKNOWN, 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