oracle监听 注册,oracle监听的动态注册和静态注册

参考资料：

现象1：

1、动态注册

参数文件中指定service_names(多个服务名vmdb,sn01,sn02)，8i以后数据库实例启动后，会根据参数文件的service_names以及instance_name动态注册到监听器：

1 SQL>show parameter service_names;2

3 NAME TYPE VALUE4 ------------------------------------ ----------- ------------------------------

5 service_names string vmdb,sn01,sn026 SQL>show parameter instance_name;7

8 NAME TYPE VALUE9 ------------------------------------ ----------- ------------------------------

10 instance_name string vmdb

2、静态注册

实例启动时读取文件$ORACLE_HOME/network/admin/listener.ora文件的配置，将实例和服务注册到监听程序。listener.ora文件配置如下：

1 SID_LIST_LISTENER =

2 (SID_LIST =

3 (SID_DESC =

4 (GLOBAL_DBNAME =sn03)5 (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)6 (SID_NAME =vmdb)7 )8 )9

10 LISTENER =

11 (DESCRIPTION =

12 (ADDRESS = (PROTOCOL = TCP)(HOST = CentOS)(PORT = 1521))13 )14

15 ADR_BASE_LISTENER = /u01/app/oracle

3、先启动数据库再启动监听

1 SQL>startup2 ORACLE instance started.3

4 Total System Global Area 776646656bytes5 Fixed Size 2217384bytes6 Variable Size 583010904bytes7 Database Buffers 188743680bytes8 Redo Buffers 2674688bytes9 Databasemounted.10 Database opened.

启动数据库