ITPub博客

首页 > Linux操作系统 > Linux操作系统 > alter system register的用法

alter system register的用法

原创 Linux操作系统 作者:paulyibinyi 时间:2009-03-31 19:44:10 0 删除 编辑

   今天一个同事问到我,有没动态注册监听的命令,查了下,找到了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 。
通过手动实现:

sys@ORA10G>alter system register;

System altered.

这个时候没有自动的Dynamic Instance Registration 。
通过手动实现:

sys@ORA10G>alter 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(s
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

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7199859/viewspace-582492/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
学习数据库

注册时间:2007-12-11

  • 博文量
    902
  • 访问量
    6552235