RAC 添加监听，静态注册监听

最新推荐文章于 2023-08-09 11:40:25 发布

富士康质检员张全蛋

最新推荐文章于 2023-08-09 11:40:25 发布

阅读量3.5k

点赞数 1

分类专栏： ORACLE RAC+ASM

本文链接：https://blog.csdn.net/qq_34556414/article/details/82700316

版权

ORACLE RAC+ASM 专栏收录该内容

60 篇文章 22 订阅

订阅专栏

非默认端口添加监听静态注册服务

网上一大堆博客说如何在RAC环境中添加非默认1521端口监听的，并且静态注册服务，眼花缭乱，而且好多不靠谱，最近工作当中要求为生产库上面的一套RAC添加监听，端口为1522，即非默认1521端口，并且使用静态注册服务到监听当中。

由于我在生产环境上添加监听了，并且使用pl/sql工具测试了是可以正常连接的，下面是自己虚拟机上面还原这个过程，其实和生产环境没多大区别。

11GR2版本的RAC，监听默认是在grid用户下面，监听启停管理都是以grid用户身份而不是使用oracle用户。

[grid@RAC1 admin]$ cd $ORACLE_HOME/network/admin --这个位置是监听配置文件的位置

[grid@RAC1 admin]$ pwd

/u01/app/11.2.0/grid/network/admin

[grid@RAC1 admin]$ ls

endpoints_listener.ora listener1809122PM5417.bak shrept.lst sqlnet.ora

endpoints_listener.ora.bak.rac1 listener.ora sqlnet1809121PM3806.bak tnsnames.ora

listener1809121PM3806.bak listener.ora.bak.rac1 sqlnet1809121PM5137.bak

listener1809121PM5137.bak samples sqlnet1809122PM5417.bak

[grid@RAC1 admin]$ cat listener.ora --下面红色和蓝色是我在监听文件当中添加的内容，其余的是默认监听自带的，虽然是虚拟机其实和生产环境没多大区别。

# listener.ora Network Configuration File: /u01/app/11.2.0/grid/network/admin/listener.ora

# Generated by Oracle configuration tools.

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1 = ON

LISTENER =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER))

)

--这部分是添加的监听，监名可以随便取，但是下蓝色列表名不可以随便取，监听里面制定了节点1的VIP地址和端口号。（一般使用VIP，这样一节点宕机了，由于业务连接串配置failover机制，业务的连接会转移到2节点，因为一节点即故障节点VIP会转移到2节点，这样实现了高可用）

LISTENER_ORA=
(DESCRIPTION_LIST=
 (DESCRIPTION=
  (ADDRESS_LIST=
   (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.11)(PORT = 1522))
  )
 )
)

--这部分是服务名列表，要静态注册那些服务。SID_NAME是你想要静态注册的服务名，可以自己取名。

SID_LIST_LISTENER_ORA=
(SID_LIST=
 (SID_DESC =
  (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
   (SID_NAME = PLSExtProc)
  )
 )

这里要注意了：LISTENER_ORA监听名，SID_LIST_LISTENER_ORA是注册表，这里注册表的名字不能乱取名字，否者配置静态监听不会成功，会出现下面信息（The listener supports no services The command completed successfully），服务列表名字是：SID_LIST_加上监听名字，这样才正确的。

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_TWO = ON

LISTENER_SCAN1 =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER_SCAN1))

)

[grid@RAC1 admin]$ lsnrctl start LISTENER_ORA --上面修改了listener.ora里面的内容即添加监听和静态注册，将该监听启动。

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 14-SEP-2018 10:50:57

Starting /u01/app/11.2.0/grid/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.4.0 - Production

System parameter file is /u01/app/11.2.0/grid/network/admin/listener.ora

Log messages written to /u01/app/grid/diag/tnslsnr/RAC1/listener_ora/alert/log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.11)(PORT=1522)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.11)(PORT=1522)))

STATUS of the LISTENER

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

Alias LISTENER_ORA

Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production

Start Date 14-SEP-2018 10:50:57

Uptime 0 days 0 hr. 0 min. 0 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora

Listener Log File /u01/app/grid/diag/tnslsnr/RAC1/listener_ora/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.11)(PORT=1522)))

Services Summary...

Service "oradb1" has 1 instance(s).

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

The command completed successfully

可以看到新添加的1522端口非默认监听已经添加成功，并且服务oradb1静态注册了。

如果要静态注册多个服务在列表里面添加多个SID_DESC即可。

(SID_DESC =

(ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)

(SID_NAME = oradb2)

)

SID_LIST_LISTENER_ORA =

(SID_LIST =

(SID_DESC =

(ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)

(SID_NAME = oradb1)

)

(SID_DESC =

(ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)

(SID_NAME = oradb2)

)

[grid@RAC1 admin]$ lsnrctl start LISTENER_ORA

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 14-SEP-2018 10:58:25

Starting /u01/app/11.2.0/grid/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.4.0 - Production

System parameter file is /u01/app/11.2.0/grid/network/admin/listener.ora

Log messages written to /u01/app/grid/diag/tnslsnr/RAC1/listener_ora/alert/log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.11)(PORT=1522)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.11)(PORT=1522)))

STATUS of the LISTENER

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

Alias LISTENER_ORA

Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production

Start Date 14-SEP-2018 10:58:25

Uptime 0 days 0 hr. 0 min. 0 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora

Listener Log File /u01/app/grid/diag/tnslsnr/RAC1/listener_ora/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.11)(PORT=1522)))

Services Summary...

Service "oradb1" has 1 instance(s).

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

Service "oradb2" has 1 instance(s).

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

The command completed successfully

可以看到多个服务都注册到了1522端口上面的监听上了。到此如何添加非1521默认端口以及如何静态注册多个服务也成功完成，注意这只是在第一个节点添加的监听，第二个节点按照上面照葫芦画瓢即可。

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.4.41)(PORT = 1521)(IP = FIRST))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.4.40)(PORT = 1521)(IP = FIRST))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /home/u01/app/11.2.0/grid)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME  = +ASM)
      (SID_NAME       = +ASM2)
      (ORACLE_HOME    = /home/u01/app/11.2.0/grid)
    )
  )

富士康质检员张全蛋

关注

1
点赞
踩
10

收藏

觉得还不错? 一键收藏
0
评论
RAC 添加监听，静态注册监听

非默认端口添加监听静态注册服务网上一大堆博客说如何在RAC环境中添加非默认1521端口监听的，并且静态注册服务，眼花缭乱，而且好多不靠谱，最近工作当中要求为生产库上面的一套RAC添加监听，端口为1522，即非默认1521端口，并且使用静态注册服务到监听当中。由于我在生产环境上添加监听了，并且使用pl/sql工具测试了是可以正常连接的，下面是自己虚拟机上面还原这个过程，其实和生产...
复制链接

扫一扫

专栏目录