主页 / dba / 问题 / 285566
Accepted
r0tt
Asked: 2021-02-18 08:13:05 +0800 CST

更改 Oracle 数据库机 X8-2M 的网格侦听器端口

  • 772

我需要添加一个额外的端口：1522

Listener Parameter File   /u01/app/19.0.0.0/grid/network/admin/listener.ora
Listener Log File         /u01/app/grid/diag/tnslsnr/xxxx/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxxx)(PORT=1521)))
Services Summary...
Service "xxxx" has 1 instance(s).

/u01/app/19.0.0.0/grid/network/admin/listener.ora->

LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))))            # line added by Agent
ASMNET1LSNR_ASM=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=ASMNET1LSNR_ASM))))              # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_ASMNET1LSNR_ASM=ON               # line added by Agent
VALID_NODE_CHECKING_REGISTRATION_ASMNET1LSNR_ASM=SUBNET         # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON              # line added by Agent
VALID_NODE_CHECKING_REGISTRATION_LISTENER=SUBNET                #

每次编辑 listener.ora 监听器启动失败：

我试过了：

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER))
      (ADDRESS = (PROTOCOL = TCP)(HOST = xxxx)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = xxxx)(PORT = 1522))
    )
  )
ASMNET1LSNR_ASM=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=ASMNET1LSNR_ASM))))              # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_ASMNET1LSNR_ASM=ON               # line added by Agent
VALID_NODE_CHECKING_REGISTRATION_ASMNET1LSNR_ASM=SUBNET         # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON              # line added by Agent
VALID_NODE_CHECKING_REGISTRATION_LISTENER=SUBNET                # line added by Agent

srvctl start listener PRCR-1079：无法启动资源 ora.LISTENER.lsnr CRS-5016：由代理“ORAAGENT”为操作“start”生成的进程“/u01/app/19.0.0.0/grid/bin/lsnrctl”失败： “/u01/app/grid/diag/crs/xxxx/crs/trace/crsd_oraagent_grid.trc”中“(:CLSN00010:)”的详细信息

侦听器无法启动。请参阅上面的错误消息...

2021-02-17 15:32:19.462 :CLSDYNAM:2613040896: [ora.LISTENER.lsnr]{1:35727:65428} [开始] (:CLSN00010:)Utils:execCmd scls_process_join() uret 1

2021-02-17 15:32:19.462 :CLSDYNAM:2613040896: [ora.LISTENER.lsnr]{1:35727:65428} [开始] clsnUtils::error 异常类型 = 2 字符串 = CRS-5016: 进程 "/u01 /app/19.0.0.0/grid/bin/lsnrctl”由代理“ORAAGENT”生成，用于操作“start”失败：“/u01/app/grid/diag/crs/etabonxrdbs0010/”中“(:CLSN00010:)”的详细信息crs/trace/crsd_oraagent_grid.trc"

2021-02-17 15:32:19.463 : AGFW:2610939648: [ INFO] {1:35727:65428} 代理发送回复：RESOURCE_START[ora.LISTENER.lsnr etabonxrdbs0010 1] ID 4098:1355034 2021-02-17 15 :32:19.463 :CLSDYNAM:2613040896: [ora.LISTENER.lsnr]{1:35727:65428} [start] LsnrAgent::Lsnrctl::start lsnrctl start complete lsnrname:LISTENER output: LSNRCTL for Linux: Version 19.0.0.0. 0 - 2021 年 2 月 17 日 15:32:19 生产

版权所有 (c) 1991, 2020，甲骨文。版权所有。

...

2021-02-17 18:19:34.200 :CLSDYNAM:2606737152: [ora.LISTENER.lsnr]{1:35727:1260} [检查] clsnUtils::error 异常类型 = 2 字符串 = CRS-5020：并非所有端点都是为听众 LISTENER 注册

I tried: srvctl modify listener -p "TCP:1521/TCP:1522"; 

srvctl config listener
Name: LISTENER
Type: Database Listener
Network: 1, Owner: grid
Home: <CRS home>
End points: TCP:1521, 1522
Listener is enabled.
Listener is individually enabled on nodes:
Listener is individually disabled on nodes:
oracle oracle-asm

1 个回答

  1. Best Answer

    该命令肯定是（用户网格）：

    srvctl modify listener listener -p "TCP:1522,4444,nnnn"

    我们的问题是我们想要使用的端口被 ODA 上的另一个服务（例如 ONS）使用。该命令完成，但侦听器忽略了端口。这可能解释了上面的日志。

    我们还需要在 ODA CDB/ASM 上输入 local_listener：

    alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1522))';

    我们在 Oracle 支持部门打开了 SR 并得到了反馈：

    现在 ODA 上的 dcs 代理不处理多个侦听器端口。我们可以将侦听器配置为使用 ODA 上的多个端口。但是我们在创建数据库、注册数据库期间遇到问题。已针对此类问题记录了增强功能，这些问题将在未来版本中修复 Enh 30095060 - ODACLI 无法注册数据库 目前我不建议向侦听器添加多个端口。

    • 0

相关问题