静态注册和动态注册

--整理以前的学习笔记

相关文章：http://blog.itpub.net/26524307/viewspace-1061151/

1、动态注册
实例启动的时候会进行动态注册，alter system register也是动态注册，动态注册不需要listener.ora，如果

local_listener参数为空，则默认注册到本机的1521端口

2、静态注册
先把实例关闭
在netmgr启动net manager，在net manager-local-listeners下，对于这个默认监听器listener,
选择database services-add database,输入
Global Database Name:aa(可以是任意的名字)
Oracle Home Directory:/u01/oracle
SID:ORCL

保存之后，发现listener.ora中多了下面一项（这就是静态注册要配置的东西，是可以通过net manager来配置的）
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = aa)
      (ORACLE_HOME = /u01/oracle)
      (SID_NAME = ORCL)
    )
  )

重新启动listener:lsnrctl start（此时就可以看到静态注册的服务了，unknown状态的就是静态注册的）
[oracle@mylinux admin]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 08-APR-2012 20:27:20
Copyright (c) 1991, 2009, Oracle.  All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=mylinux)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                08-APR-2012 20:25:49
Uptime                    0 days 0 hr. 1 min. 30 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/oracle/network/admin/listener.ora
Listener Log File         /u01/diag/tnslsnr/mylinux/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=mylinux)(PORT=1521)))
Services Summary...
Service "AA" has 1 instance(s).
  Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

此时如果再启动实例（启动实例的过程中PMON会根据local_listener动态注册到相应的监听）
[oracle@mylinux admin]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 08-APR-2012 20:28:21
Copyright (c) 1991, 2009, Oracle.  All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=mylinux)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                08-APR-2012 20:25:49
Uptime                    0 days 0 hr. 2 min. 32 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/oracle/network/admin/listener.ora
Listener Log File         /u01/diag/tnslsnr/mylinux/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=mylinux)(PORT=1521)))
Services Summary...
Service "AA" has 1 instance(s).
  Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
发现既有动态注册的服务（ready状态的），也有静态注册的服务（unknown状态的）

如果已经静态注册，但是实例并没有启动的话，在客户端用tnsping可以通，
C:\Documents and Settings\Administrator>tnsping orcllx
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 08-4月 -
2012 22:21:05
Copyright (c) 1997, 2005, Oracle.  All rights reserved.
已使用的参数文件:
D:\oracle\product\10.2.0\client_1\network\admin\sqlnet.ora
已使用 TNSNAMES 适配器来解析别名
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 192.168.1.10)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = AA)))
OK (100 毫秒)

使用SQLPLUS连接，提示连接到空闲例程：
C:\Documents and Settings\Administrator>sqlplus sys/oracle@orcllx as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on 星期日 4月 8 22:21:16 2012
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
已连接到空闲例程。

SQL>

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

转载于:http://blog.itpub.net/26524307/viewspace-1061237/