Oracle RAC修改监听端口号

目录
  • 修改OracleRAC监听端口号:
    • 1、查看当前数据库监听状态：
    • 2、修改集群监听端口：
    • 3、手动修改LOCAL_LISTENER：
    • 4、停止集群监听和SCAN：
    • 5、修改listener.ora文件：
    • 6、启动集群监听和SCAN：
    • 7、验证数据库监听端口状态：

修改OracleRAC监听端口号:

修改前一定要查看修改后的端口有没有被占用：

# netstat -an|grep

1、查看当前数据库监听状态：

（grid用户执行）

$ lsnrctl status

$ srvctl config listener

示例：

[+ASM1][grid@ceshi1 ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 05-APR-2022 06:34:12

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

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date                05-APR-2022 06:18:47
Uptime                    0 days 0 hr. 15 min. 25 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/11.2.0.4/grid/network/admin/listener.ora
Listener Log File         /u01/app/grid/diag/tnslsnr/ceshi1/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.48.130)(PORT=1522)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.48.132)(PORT=1522)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
  Instance "orcl1", status BLOCKED, has 1 handler(s) for this service...
Service "test" has 1 instance(s).
  Instance "orcl1", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully

[+ASM1][grid@ceshi1 ~]$ srvctl config listener
Name: LISTENER
Network: 1, Owner: grid
Home: 
End points: TCP:1522

2、修改集群监听端口：

  1. 修改监听端口：（grid用户单节点执行）

    $ srvctl modify listener -l LISTENER -p "TCP:"

  2. 修改scan端口：（grid用户单节点执行）

    $ srvctl modify scan_listener -p

示例：

[+ASM1][grid@ceshi1 ~]$ srvctl modify listener -l LISTENER -p "TCP:1533"

[+ASM1][grid@ceshi1 ~]$ srvctl modify scan_listener -p 1533

3、手动修改LOCAL_LISTENER：

（oracle用户所有节点执行）

SQL> alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=))))' scope=both sid='[ | * ] '

注意:按照实例所在节点修改"IP"和"实例名"

示例：

节点一：

#修改LOCAL_LISTENER
[orcl1][oracle@ceshi1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Tue Apr 5 07:26:34 2022

Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> alter system set local_listener ="(ADDRESS=(PROTOCOL=TCP)(HOST= 192.168.48.130)(PORT=1533))" SID='orcl1';

System altered.

#查看LOCAL_LISTENER
SQL> show parameter LOCAL_LISTENER

NAME				     TYPE	 VALUE
------------------------ ------- ------------------------------
local_listener			 string	 (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.48.130)(PORT=1533))

节点二：

#修改LOCAL_LISTENER
[orcl2][oracle@ceshi2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Apr 6 02:50:46 2022

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

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> alter system set local_listener ="(ADDRESS=(PROTOCOL=TCP)(HOST= 192.168.48.131)(PORT=1533))" SID='orcl2';

System altered.

#查看LOCAL_LISTENER
SQL> show parameter LOCAL_LISTENER

NAME				     TYPE	 VALUE
------------------------ ------- ------------------------------
local_listener			 string	 (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.48.131)(PORT=1533))

若移除监听（REMOTE_LISTENER）也需要进行类似更改

4、停止集群监听和SCAN：

停止监听和scan：（grid用户单节点执行）

$ srvctl stop listener [-l ] [-n ] [-f]
$ srvctl stop scan [-i ] [-f]
$ srvctl stop scan_listener [-i ] [-f]

示例：

$ srvctl stop listener -l LISTENER
$ srvctl stop scan_listener

5、修改listener.ora文件：

修改listener.ora文件中的端口信息：（grid用户所有节点执行）

$ vi $GRID_HOME/network/admin/listener.ora

LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))            # line added by Agent
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1))))                # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON                # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON              # line added by Agent

LISTENER =
    (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.48.130)(PORT = 1522))
    )

将默认侦听器配置文件下的（端口=1521）更改为所需的值。如果您没有此文件，则可以使用以下示例：

LISTENER =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(ADDRESS = (PROTOCOL = TCP)(HOST = myhostname)(PORT = myport))
)

若配置了$GRID_HOME/network/admin/tnsnames.ora文件也需要进行端口调整

6、启动集群监听和SCAN：

启动监听和scan：（grid用户所有节点执行）

$ srvctl start listener [-l ] [-n ]
$ srvctl start scan [-i ] [-n ]
$ srvctl start scan_listener [-n ] [-i ]

示例：

#启动集群监听和SCAN
$ srvctl start listener -l LISTENER
$ srvctl start scan_listener

7、验证数据库监听端口状态：

（grid用户执行）

$ lsnrctl status

$ srvctl config listener

示例：

节点一：

[+ASM1][grid@ceshi1 /u01/app/11.2.0.4/grid/network/admin]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 06-APR-2022 06:24:25

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

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date                06-APR-2022 06:24:16
Uptime                    0 days 0 hr. 0 min. 8 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/11.2.0.4/grid/network/admin/listener.ora
Listener Log File         /u01/app/grid/diag/tnslsnr/ceshi1/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.48.130)(PORT=1533)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.48.132)(PORT=1533)))
Services Summary...
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...
Service "test" has 1 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
The command completed successfully

[+ASM1][grid@ceshi1 /u01/app/11.2.0.4/grid/network/admin]$ srvctl config listener -a
Name: LISTENER
Network: 1, Owner: grid
Home: 
  /u01/app/11.2.0.4/grid on node(s) ceshi2,ceshi1
End points: TCP:1533

节点二：

[+ASM2][grid@ceshi2 /u01/app/11.2.0.4/grid/network/admin]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 07-APR-2022 02:01:14

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

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date                07-APR-2022 01:48:13
Uptime                    0 days 0 hr. 13 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/11.2.0.4/grid/network/admin/listener.ora
Listener Log File         /u01/app/grid/diag/tnslsnr/ceshi2/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.48.131)(PORT=1533)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.48.133)(PORT=1533)))
Services Summary...
Service "orcl" has 1 instance(s).
  Instance "orcl2", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
  Instance "orcl2", status READY, has 1 handler(s) for this service...
Service "test" has 1 instance(s).
  Instance "orcl2", status READY, has 1 handler(s) for this service...
The command completed successfully

[+ASM2][grid@ceshi2 /u01/app/11.2.0.4/grid/network/admin]$ srvctl config listener -a
Name: LISTENER
Network: 1, Owner: grid
Home: 
  /u01/app/11.2.0.4/grid on node(s) ceshi2,ceshi1
End points: TCP:1533

For RAC and/or SCAN please see:Changing Listener Ports On RAC/EXADATA (Doc ID 1473035.1)

Oracledatabaselistener_ports

相关

Oracle表空间数据文件迁移

Oracle关于导入导出

OracleDataReader.Read()耗时过高问题的解决办法

Oracle JDK与OpenJDK对比

oracle索引操作

oracle查询死锁

oracle 11g修改自动收集统计信息计划任务的执行时间

Oracle "HASH GROUP BY"和"SORT GROUP BY"区别以及"无法使用"HASH GROUP BY"的情况

Oracle报错：无监听程序

oracle--用户，权限，角色的管理

oracle--序列的使用，介绍

Entity Framework 6.x Code Frist For Oracle 实践与注意点

标签