Oracle监听的动态和静态注册

最新推荐文章于 2024-09-21 11:30:16 发布
最新推荐文章于 2024-09-21 11:30:16 发布
阅读量69 收藏
点赞数
文章标签： 数据库 网络

本文档讨论监听的动态注册和静态注册的问题

1.静态注册，由ORACLE PMON进程自动注册ORACLE 实例

查看$ORACLE_HOME/network/admin/listener.ora文件内容

oracle@RHEL5.4:/u01/app/oracle/products/10.2.0/db_1/network/admin>cat listener.ora

# listener.ora Network Configuration File: /u01/app/oracle/products/10.2.0/db_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

 

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = PLSExtProc)

      (ORACLE_HOME = /u01/app/oracle/products/10.2.0/db_1)

      (PROGRAM = extproc)

    )

  )

 

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = RHEL5.4)(PORT = 1521))

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

    )

  )

来看一个静态注册监听反馈出来的信息

SQL> select instance_name,status from v$Instance;

 

INSTANCE_NAME    STATUS

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

macdb            MOUNTED

 

oracle@RHEL5.4:/home/oracle>lsnrctl status

 

LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 07-MAY-2013 21:10:46

 

Copyright (c) 1991, 2006, Oracle.  All rights reserved.

 

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=RHEL5.4)(PORT=1521)))

STATUS of the LISTENER

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

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 10.2.0.3.0 - Production

Start Date                07-MAY-2013 21:10:23

Uptime                    0 days 0 hr. 0 min. 23 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/app/oracle/products/10.2.0/db_1/network/admin/listener.ora

Listener Log File         /u01/app/oracle/products/10.2.0/db_1/network/log/listener.log

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=RHEL5.4)(PORT=1521)))

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

Services Summary...

Service "PLSExtProc" has 1 instance(s).

  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

Service "macdb" has 1 instance(s).

  Instance "macdb", status READY, has 1 handler(s) for this service...

Service "macdb_XPT" has 1 instance(s).

  Instance "macdb", status READY, has 1 handler(s) for this service...

The command completed successfully

Service的值默认为service_names的值

 

当关闭掉实例之后监听里面就没有任何实例的信息了

 

SQL> shutdown immediate;

ORA-01109: database not open

 

 

Database dismounted.

ORACLE instance shut down.

SQL> !lsnrctl status

 

LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 07-MAY-2013 21:13:11

 

Copyright (c) 1991, 2006, Oracle.  All rights reserved.

 

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=RHEL5.4)(PORT=1521)))

STATUS of the LISTENER

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

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 10.2.0.3.0 - Production

Start Date                07-MAY-2013 21:10:23

Uptime                    0 days 0 hr. 2 min. 48 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/app/oracle/products/10.2.0/db_1/network/admin/listener.ora

Listener Log File         /u01/app/oracle/products/10.2.0/db_1/network/log/listener.log

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=RHEL5.4)(PORT=1521)))

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

Services Summary...

Service "PLSExtProc" has 1 instance(s).

  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

 

需要注意的是ORACLE PMON只能动态注册1521端口的监听，如果你用其他的端口，PMON不能完成静态注册。

 

修改监听的端口号为1531，则PMON不能自动注册

oracle@RHEL5.4:/u01/app/oracle/products/10.2.0/db_1/network/admin>cat listener.ora

#listener.ora Network Configuration File: /u01/app/oracle/products/10.2.0/db_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

 

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = PLSExtProc)

      (ORACLE_HOME = /u01/app/oracle/products/10.2.0/db_1)

      (PROGRAM = extproc)

    )

  )

 

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = RHEL5.4)(PORT = 1531))

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

    )

  )

 

 

 

启动监听查看状态

oracle@RHEL5.4:/u01/app/oracle/products/10.2.0/db_1/network/admin>lsnrctl status

 

LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 07-MAY-2013 21:37:36

 

Copyright (c) 1991, 2006, Oracle.  All rights reserved.

 

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=RHEL5.4)(PORT=1531)))

STATUS of the LISTENER

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

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 10.2.0.3.0 - Production

Start Date                07-MAY-2013 21:28:25

Uptime                    0 days 0 hr. 9 min. 11 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/app/oracle/products/10.2.0/db_1/network/admin/listener.ora

Listener Log File         /u01/app/oracle/products/10.2.0/db_1/network/log/listener.log

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=RHEL5.4)(PORT=1531)))

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

Services Summary...

Service "PLSExtProc" has 1 instance(s).

  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

 

这个时候需要对参数LOCAL_LISTENER做一些设置

我们先来看看这个参数官方是怎么说的

LOCAL_LISTENER specifies a network name that resolves to an address or address list

of Oracle Net local listeners (that is, listeners that are running on the same machine as

this instance). The address or address list is specified in the TNSNAMES.ORA file or

other address repository as configured for your system.

说的比较清楚了，这个参数是用来指定一个网络的名称这个名称必须在TNSNAME.ORA文件中存在。

oracle@RHEL5.4:/u01/app/oracle/products/10.2.0/db_1/network/admin>cat tnsnames.ora

# tnsnames.ora Network Configuration File: /u01/app/oracle/products/10.2.0/db_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

 

MACDB =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = RHEL5.4)(PORT = 1531))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = macdb)

    )

  )

 

设置LOCAL_LISTENER参数

SQL> show parameter local_listener

 

NAME                                 TYPE        VALUE

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

local_listener                       string

SQL> alter system set local_listener='macdb' scope=both;

 

System altered.

 

SQL> show parameter local_listener

 

NAME                                 TYPE        VALUE

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

local_listener                       string      macdb

 

查看监听状态

oracle@RHEL5.4:/u01/app/oracle/products/10.2.0/db_1/network/admin>lsnrctl status

 

LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 07-MAY-2013 21:47:36

 

Copyright (c) 1991, 2006, Oracle.  All rights reserved.

 

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=RHEL5.4)(PORT=1531)))

STATUS of the LISTENER

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

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 10.2.0.3.0 - Production

Start Date                07-MAY-2013 21:28:25

Uptime                    0 days 0 hr. 19 min. 11 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/app/oracle/products/10.2.0/db_1/network/admin/listener.ora

Listener Log File         /u01/app/oracle/products/10.2.0/db_1/network/log/listener.log

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=RHEL5.4)(PORT=1531)))

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

Services Summary...

Service "PLSExtProc" has 1 instance(s).

  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

Service "macdb" has 1 instance(s).

  Instance "macdb", status READY, has 1 handler(s) for this service...

Service "macdbXDB" has 1 instance(s).

  Instance "macdb", status READY, has 1 handler(s) for this service...

Service "macdb_XPT" has 1 instance(s).

  Instance "macdb", status READY, has 1 handler(s) for this service...

The command completed successfully

 

还原LOCAL_LISTENER参数

SQL> ALTER SYSTEM RESET LOCAL_LISTENER SCOPE=SPFILE SID='*';

 

System altered.

 

SQL> show parameter local_listener

 

NAME                                 TYPE        VALUE

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

local_listener                       string      macdb

 

oracle@RHEL5.4:/u01/app/oracle/products/10.2.0/db_1/network/admin>lsnrctl status

 

LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 07-MAY-2013 21:55:18

 

Copyright (c) 1991, 2006, Oracle.  All rights reserved.

 

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=RHEL5.4)(PORT=1531)))

STATUS of the LISTENER

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

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 10.2.0.3.0 - Production

Start Date                07-MAY-2013 21:28:25

Uptime                    0 days 0 hr. 26 min. 53 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/app/oracle/products/10.2.0/db_1/network/admin/listener.ora

Listener Log File         /u01/app/oracle/products/10.2.0/db_1/network/log/listener.log

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=RHEL5.4)(PORT=1531)))

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

Services Summary...

Service "PLSExtProc" has 1 instance(s).

  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

Service "macdb" has 1 instance(s).

  Instance "macdb", status READY, has 1 handler(s) for this service...

Service "macdbXDB" has 1 instance(s).

  Instance "macdb", status READY, has 1 handler(s) for this service...

Service "macdb_XPT" has 1 instance(s).

  Instance "macdb", status READY, has 1 handler(s) for this service...

The command completed successfully

 

注册的监听并没有被收回，重启监听失效

 

 

2.动态注册

bb

 

 

 

 

 

查看监听文件发现有些不一样的地方

oracle@RHEL5.4:/u01/app/oracle/products/10.2.0/db_1/network/admin>cat listener.ora

# listener.ora Network Configuration File: /u01/app/oracle/products/10.2.0/db_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

 

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = PLSExtProc)

      (ORACLE_HOME = /u01/app/oracle/products/10.2.0/db_1)

      (PROGRAM = extproc)

    )

    (SID_DESC =

      (GLOBAL_DBNAME = macdb)

      (ORACLE_HOME = /u01/app/oracle/products/10.2.0/db_1)

      (SID_NAME = macdb)

    )

  )

 

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = RHEL5.4)(PORT = 1531))

    )

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

    )

  )

 

当实例没有启动的时候监听里面也能看到相关注册实例的信息

oracle@RHEL5.4:/u01/app/oracle/products/10.2.0/db_1/network/admin>ps -ef | grep oracle

oracle    2747     1  0 21:08 ?        00:00:02 /u01/app/oracle/products/10.2.0/db_1/bin/ocssd.bin

root      3158  3124  0 21:10 pts/1    00:00:00 su - oracle

oracle    3159  3158  0 21:10 pts/1    00:00:00 -bash

oracle    3547     1  0 22:08 ?        00:00:00 /u01/app/oracle/products/10.2.0/db_1/bin/tnslsnr LISTENER -inherit

oracle    3552  3159  0 22:08 pts/1    00:00:00 ps -ef

oracle    3553  3159  0 22:08 pts/1    00:00:00 grep oracle

oracle@RHEL5.4:/u01/app/oracle/products/10.2.0/db_1/network/admin>lsnrctl status

 

LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 07-MAY-2013 22:09:05

 

Copyright (c) 1991, 2006, Oracle.  All rights reserved.

 

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=RHEL5.4)(PORT=1531)))

STATUS of the LISTENER

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

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 10.2.0.3.0 - Production

Start Date                07-MAY-2013 22:08:05

Uptime                    0 days 0 hr. 0 min. 59 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/app/oracle/products/10.2.0/db_1/network/admin/listener.ora

Listener Log File         /u01/app/oracle/products/10.2.0/db_1/network/log/listener.log

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=RHEL5.4)(PORT=1531)))

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

Services Summary...

Service "PLSExtProc" has 1 instance(s).

  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

Service "macdb" has 1 instance(s).

  Instance "macdb", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

 

 

fj.pngListerner1.jpg

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

转载于:http://blog.itpub.net/26169542/viewspace-765911/

cqc35195
关注
oracle监听 注册,oracle监听的动态注册和静态注册
weixin_29964507的博客
04-07 822
参考资料：现象1：1、动态注册参数文件中指定service_names(多个服务名vmdb,sn01,sn02)，8i以后数据库实例启动后，会根据参数文件的service_names以及instance_name动态注册到监听器：1 SQL>show parameter service_names;23 NAME TYPE VALUE4 ---...
Oracle静态注册与动态注册详解
09-10
Oracle数据库的注册方式主要包括静态注册和动态注册，这两种方式都是为了使得客户端能够通过服务名连接到数据库实例，而无需直接知道具体的数据库名和实例名。本文将深入解析这两种注册方式。 一、概述 Oracle...
Oracle 11gR2 RAC Listener - 多端口多监听
06-05 6462
Oracle单实例库，可以配置多个监听服务，同时监听同一个service，具体的步骤可以参考之前的文章。 Oracle RAC想使用多端口，多监听服务，来同时监听同一个service，也可以。 官方文档：http://docs.oracle.com/cd/B28359_01/network.111/b28317/listener.htm 例子-1 Oracle 11gR2 RAC安
oracle动态注册和静态注册,Oracle监听器的静态注册与动态注册
weixin_33961375的博客
04-03 270
在运行lsnrctl命令的status时，常会看到如下返回值：服务“test”包含1个例程。例程"mydata"，状态 UNKOWN，包含此服务的一个处理程序。。。服务"a"包含1个例程。例程"mydata"，状态 READY，包含此服务的一个处理程序。。。这里的，状态UNKOWN即表明为静态注册(手动填写参数)；状态为READY的记录，表明为动态注册(listener.ora参数由PMON进程自...
Oracle动态监听和静态监听的区别
JackieDYH的博客
09-06 646
一、什么是注册 注册就是将数据库作为一个服务注册到监听程序。 客户端不需要知道数据库名和实例名，只需要知道该数据库对外提供的服务名就可以申请连接到数据库。 这个服务名可能与实例名一样，也有可能不一样。 在数据库服务器启动过程中，数据库服务器会向监听程序注册相应的服务（无论何时启动一个数据库，默认地都有两条信息注册到监听器中：数据库服务器对应的实例和服务） 相当于是这样：在数据库服务器和客...
oracle注册静态监听,Oracle监听的静态注册和动态注册
weixin_29349409的博客
04-07 343
Oracle监听的静态注册和动态注册发布时间：2020-08-11 09:53:49来源：ITPUB博客阅读：99作者：张冲andy静态注册：通过解析listene.ora文件动态注册：由PMON进程动态注册至监听中在没有listener.ora配置文件的情况下，如果启动监听，则监听为动态注册。用图形化netca创建的监听，默认也为动态注册1.静态注册listener.ora文件，监听的配置文件，...
oracle动态注册和静态注册,Oracle Listener 动态注册 与 静态注册
weixin_33796288的博客
04-03 237
一．什么是注册注册就是将数据库作为一个服务注册到监听程序。客户端不需要知道数据库名和实例名，只需要知道该数据库对外提供的服务名就可以申请连接到数据库。这个服务名可能与实例名一样，也有可能不一样。在数据库服务器启动过程中，数据库服务器会向监听程序注册相应的服务(无论何时启动一个数据库，默认地都有两条信息注册到监听器中：数据库服务器对应的实例和服务。)相当于是这样：在数据库服务器和客户端之间有一监听程...
linux oracle 动态监听 静态监听,Oracle动态监听和静态监听的区别
weixin_32327999的博客
04-09 337
一、什么是注册注册就是将数据库作为一个服务注册到监听程序。客户端不需要知道数据库名和实例名，只需要知道该数据库对外提供的服务名就可以申请连接到数据库。这个服务名可能与实例名一样，也有可能不一样。在数据库服务器启动过程中，数据库服务器会向监听程序注册相应的服务(无论何时启动一个数据库，默认地都有两条信息注册到监听器中：数据库服务器对应的实例和服务)相当于是这样：在数据库服务器和客户端之间有一监听程序...
oracle动态监听和静态监听
thinklog2018的博客
06-08 3746
为Oracle数据单独设置静态监听、动态监听，以及动态和静态混合监听。
oracle动态库注册,Oracle监听的静态注册和动态注册
weixin_39747383的博客
04-12 289
静态注册：通过解析listene.ora文件动态注册：由PMON进程动态注册至监听中在没有listener.ora配置文件的情况下，如果启动监听，则监听为动态注册。用图形化netca创建的监听，默认也为动态注册1.静态注册listener.ora文件，监听的配置文件，静态注册读取该文件，动态注册，不必要可以通过netca工具创建，也可以手动编辑。典型的listener.ora文件内容：LISTEN...
ORACLE学习笔记-ORACLE动态监听和静态监听
gangma2
03-07 1194
ORACLE静态监听: listener静态注册，参数是手动静态添加，与数据库无关。数据库监听启动无法确是否正确配置（配置错误SID监听也可以正常启动）。因此，lsnrctl中的status显示状态为“UNKNOWN”。即不保证能连通数据库。listener启动时，根据配置listener.ora文件中配置信息进行实例注册。 静态监听配置如下： SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = ORACLE19C
Oracle静态监听注册详解
01-19
网上有很多关于oracle 监听静态注册的文章，但大多都是简单说说，并没有详细的例子，这里，将结合linux as4 下的oracle 10gR2.0.1 举一个具体的例子 　1、在 $ORACLE_HOME/network/admin/listener.ora 文件中加入一...
MySQL数据库的增删改查以及基本操作分享
最新发布
m0_57094953的博客
09-21 323
MySQL数据库基本操作分享，包括增删改查，登录退出，查看数据库、表等
Java项目: 基于SpringBoot+mybatis+maven课程答疑系统(含源码+数据库+毕业论文)
weixin_43860634的博客
09-14 917
Java项目: 基于SpringBoot+mybatis+maven课程答疑系统(含源码+数据库+毕业论文)
RedisTemplate混用带来的序列化问题
咖啡煮码
09-18 702
RedisTemplate 不要乱用哦，否则极易出现序列化问题
No operations allowed after statement closed
abments的博客
09-20 560
错误信息：参考解决方案 https://github.com/alibaba/druid/issues/5549如果修改socket-timeout不生效，可以尝试修改 socketTimeout。
大批量查询方案简记(Mybatis流式查询)
kay'blog
09-20 867
介绍使用mybatis流式查询解决大数据量查询问题.
MySQL数据库
kyrie_jie的博客
09-19 2124
1、计算机的资源有限，不可能把数据全部存储在内存中，且内存掉电后数据会丢失，为了能让程序在关机重启后继续使用，必须把数据保存到磁盘的文件中。2、随着程序的功能越来越复杂、数据量越来越大，从文件中读写数据需要大量的重复性操作，从文件中读取出指定的数据需要复杂的逻辑。3、不同的程序它的访问文件的操作不同，就意味着读写文件的代码无法复用。4、所以程序员非常需要一个统一的快速的访问磁盘数据的工具。
redis学习笔记（六）
小柒的博客
09-20 523
redis学习笔记（六）
Oracle监听器的静态与动态注册详解
"本文主要探讨了Oracle数据库中的静态注册和动态注册机制，涉及ORACLE_SID、INSTANCE_NAME、SERVICE_NAMES和DB_NAME等关键概念，并解释了监听器Listener在连接过程中的作用。" 在Oracle数据库系统中，静态注册和...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值