• oracle rac环境下修改1521集群端口

    文章目录

    一、修改前准备工作

    1.确认端口是否占用

    [grid@rac1 ~]$  netstat -an|grep 1521
tcp        0      0 192.168.221.125:1521    0.0.0.0:*               LISTEN     
tcp        0      0 192.168.221.123:1521    0.0.0.0:*               LISTEN     
tcp        0      0 192.168.221.88:1521     0.0.0.0:*               LISTEN     
tcp        0      0 192.168.221.123:1521    192.168.221.88:19402    ESTABLISHED
tcp        0      0 192.168.221.88:19100    192.168.221.123:1521    ESTABLISHED
tcp        0      0 192.168.221.123:1521    192.168.221.88:19100    ESTABLISHED
tcp        0      0 192.168.221.125:1521    192.168.221.88:11780    ESTABLISHED
tcp        0      0 192.168.221.88:19402    192.168.221.123:1521    ESTABLISHED
tcp        0      0 192.168.221.88:11780    192.168.221.125:1521    ESTABLISHED
unix  3      [ ]         STREAM     CONNECTED     61521    /var/tmp/.oracle/ora_gipc_agent_ag_CSSDAG_z
[grid@rac1 ~]$  netstat -an|grep 1551
[grid@rac1 ~]$ 

    • 1
    • 2
    • 3
    • 4
    • 5
    • 6
    • 7
    • 8
    • 9
    • 10
    • 11
    • 12
    • 13

    在这里插入图片描述

    2.grid确认监听状态以及名称

    [grid@rac1 ~]$ lsnrctl status

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 27-JUL-2022 18:24:03

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                27-JUL-2022 17:45:23
Uptime                    0 days 0 hr. 38 min. 40 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/grid/product/19.3.0/gihome_1/network/admin/listener.ora
Listener Log File         /u01/gridbase/diag/tnslsnr/rac1/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.221.88)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.221.123)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_DATA" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_RODATA" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "86b637b62fdf7a65e053f706e80a27ca" has 1 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "cxl" has 1 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "e3dd514189671de9e05363dda8c0ac6d" has 1 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
The command completed successfully
[grid@rac1 ~]$ srvctl config listener
名称: LISTENER
类型: Database Listener
网络: 1, 所有者: grid
主目录: <CRS home>
端点: TCP:1521
监听程序已启用。
监听程序已在以下节点上分别启用: 
监听程序已在以下节点上分别禁用: 
[grid@rac1 ~]$ 

    • 1
    • 2
    • 3
    • 4
    • 5
    • 6
    • 7
    • 8
    • 9
    • 10
    • 11
    • 12
    • 13
    • 14
    • 15
    • 16
    • 17
    • 18
    • 19
    • 20
    • 21
    • 22
    • 23
    • 24
    • 25
    • 26
    • 27
    • 28
    • 29
    • 30
    • 31
    • 32
    • 33
    • 34
    • 35
    • 36
    • 37
    • 38
    • 39
    • 40
    • 41
    • 42
    • 43
    • 44
    • 45
    • 46
    • 47
    • 48
    • 49
    • 50

    在这里插入图片描述
    在这里插入图片描述

    二、grid修改集群端口

    1.grid修改监听端口

    [grid@rac1 ~]$ srvctl modify listener -l LISTENER -p "TCP:1551"

    • 1

    在这里插入图片描述

    2.grid修改scan监听端口

    [grid@rac1 ~]$ srvctl modify scan_listener -p 1551

    • 1

    在这里插入图片描述

    3.双节点确认实例下local_listener、remote_listener(+ASM)

    SQL> show parameter LOCAL_LISTENER

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
local_listener			     string	  (ADDRESS=(PROTOCOL=TCP)(HOST=
						 192.168.221.123)(PORT=1551))

SQL> 
SQL> show parameter LOCAL_LISTENER

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
local_listener			     string	  (ADDRESS=(PROTOCOL=TCP)(HOST=
						 192.168.221.124)(PORT=1551))
SQL> 
SQL> show parameter remote_listener

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
remote_listener 		     string	 rac-scanip:1551

    • 1
    • 2
    • 3
    • 4
    • 5
    • 6
    • 7
    • 8
    • 9
    • 10
    • 11
    • 12
    • 13
    • 14
    • 15
    • 16
    • 17
    • 18
    • 19
    • 20

    在这里插入图片描述
    在这里插入图片描述
    在这里插入图片描述

    [grid@rac1 ~]$ sqlplus / as sysasm

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Jul 27 20:28:41 2022
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> show parameter local_listener

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
local_listener			     string	  (ADDRESS=(PROTOCOL=TCP)(HOST=
						 192.168.221.123)(PORT=1551))
SQL> 

    • 1
    • 2
    • 3
    • 4
    • 5
    • 6
    • 7
    • 8
    • 9
    • 10
    • 11
    • 12
    • 13
    • 14
    • 15
    • 16
    • 17
    • 18
    • 19

    在这里插入图片描述

    4.grid停止集群监听与scan

    #在生产环境下建议先停一个节点：
#[grid@rac1 ~]$ srvctl stop listener -l LISTENER -n rac1
#listener文件修改完成后启动
#[grid@rac1 ~]$ srvctl start listener -l LISTENER -n rac1

[grid@rac1 ~]$ srvctl stop listener -l LISTENER
[grid@rac1 ~]$ srvctl stop scan_listener
[grid@rac1 ~]$ 

[grid@rac2 ~]$ srvctl status listener
监听程序 LISTENER 已启用
监听程序 LISTENER 未运行
[grid@rac2 ~]$ srvctl status scan_listener
SCAN 监听程序 LISTENER_SCAN1 已启用
SCAN 监听程序 LISTENER_SCAN1 未运行
[grid@rac2 ~]$ 

    • 1
    • 2
    • 3
    • 4
    • 5
    • 6
    • 7
    • 8
    • 9
    • 10
    • 11
    • 12
    • 13
    • 14
    • 15
    • 16

    在这里插入图片描述

    5.grid修改listener文件

    [grid@rac1 ~]$ cd $ORACLE_HOME
[grid@rac1 gihome_1]$ cd network/admin/
[grid@rac1 admin]$ ll
总用量 20
-rw-r----- 1 grid oinstall  826 7月  16 00:58 listener22071612上午5819.bak
-rw-r--r-- 1 grid oinstall  826 7月  16 00:50 listener.ora
-rw-r--r-- 1 grid oinstall  588 7月  16 00:49 listener.ora.bak.rac1.grid
drwxr-xr-x 2 grid oinstall   64 4月  17 2019 samples
-rw-r--r-- 1 grid oinstall 1536 2月  14 2018 shrept.lst
-rw-r----- 1 grid oinstall  199 7月  16 00:58 sqlnet.ora
[grid@rac1 admin]$ pwd
/u01/grid/product/19.3.0/gihome_1/network/admin
[grid@rac1 admin]$ vi listener.ora

    • 1
    • 2
    • 3
    • 4
    • 5
    • 6
    • 7
    • 8
    • 9
    • 10
    • 11
    • 12
    • 13

    在这里插入图片描述

    6.grid启动集群监听与scan

    [grid@rac1 admin]$ 
[grid@rac1 admin]$ srvctl start listener -l LISTENER
[grid@rac1 admin]$ srvctl start scan_listener
[grid@rac1 admin]$ 

[grid@rac2 ~]$ 
[grid@rac2 ~]$ srvctl status listener
监听程序 LISTENER 已启用
监听程序 LISTENER 正在节点上运行: rac1,rac2
[grid@rac2 ~]$ srvctl status scan_listener
SCAN 监听程序 LISTENER_SCAN1 已启用
SCAN 监听程序 LISTENER_SCAN1 正在节点 rac2 上运行
[grid@rac2 ~]$ 

    • 1
    • 2
    • 3
    • 4
    • 5
    • 6
    • 7
    • 8
    • 9
    • 10
    • 11
    • 12
    • 13

    7.验证

    在这里插入图片描述
    在这里插入图片描述
    在这里插入图片描述

  • 相关阅读:
    Azure - 机器学习企业级服务概述与介绍
    易云维®产业电商APP提供适合楼宇自动化应用的HMD/W80系列温湿度传感器资料介绍
    verilog 内置语句
    NLP工具集：【doccano】——标注平台doccano使用手册
    工业RFID读写器选择指南
    东软云HIS医疗管理系统——技术栈【SpringBoot+Vue+MySQL+MyBatis】
    如何利用OpenGL巧妙实现GPU仿真
    dubbo从入门到精通
    将 Apache Kafka SASL OUTHBEARER 与 Python 一起使用
    电商数仓笔记7_数据仓库系统（数仓搭建-DWD层，数仓搭建-DWS层，数仓搭建-DWT层，数仓搭建-ADS层）
  • 原文地址：https://blog.csdn.net/weixin_41607523/article/details/126009146