oracle18c的rac启动,Oracle 18c RAC 环境 listener.ora 文件内容 格式化 说明

RAC 环境中，监听都是在GRID用户下配置的，但是默认文件listener.ora格式的可读性很差，如下：https://www.cndba.cn/dave/article/3022https://www.cndba.cn/dave/article/3022https://www.cndba.cn/dave/article/3022https://www.cndba.cn/dave/article/3022

[dave@www.cndba.cn admin]$ pwd

/u01/app/18.3.0/grid/network/admin

[dave@www.cndba.cn admin]$ ls

listener18090512AM5038.bak listener.ora.bak.rac1 samples sqlnet.ora

listener.ora listener.ora.bak.rac2 shrept.lst

[dave@www.cndba.cn admin]$ cat listener.ora

LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent

MGMTLSNR=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=MGMTLSNR)))) # line added by Agent

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 # line added by Agent

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_MGMTLSNR=ON # line added by Agent

VALID_NODE_CHECKING_REGISTRATION_MGMTLSNR=SUBNET # line added by Agent

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent

VALID_NODE_CHECKING_REGISTRATION_LISTENER_SCAN1=OFF # line added by Agent - Disabled by Agent because REMOTE_REGISTRATION_ADDRESS is set

[dave@www.cndba.cn admin]$

用grid用户打开netmgr工具做一点修改，在保存一下，在查看，内容格式就很清晰了。https://www.cndba.cn/dave/article/3022https://www.cndba.cn/dave/article/3022https://www.cndba.cn/dave/article/3022https://www.cndba.cn/dave/article/3022https://www.cndba.cn/dave/article/3022https://www.cndba.cn/dave/article/3022

[dave@www.cndba.cn admin]$ cat listener.ora

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

# Generated by Oracle configuration tools.

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1 = ON

VALID_NODE_CHECKING_REGISTRATION_MGMTLSNR = SUBNET

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = dave)

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

(SID_NAME = cndba)

)

)

VALID_NODE_CHECKING_REGISTRATION_LISTENER_SCAN1 = OFF

VALID_NODE_CHECKING_REGISTRATION_ASMNET1LSNR_ASM = SUBNET

ASMNET1LSNR_ASM =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = ASMNET1LSNR_ASM))

)

VALID_NODE_CHECKING_REGISTRATION_LISTENER = SUBNET

MGMTLSNR =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = MGMTLSNR))

)

ADR_BASE_MGMTLSNR = /u01/app/grid

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_MGMTLSNR = ON

LISTENER =

(DESCRIPTION =

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

)

ADR_BASE_LISTENER = /u01/app/grid

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_ASMNET1LSNR_ASM = ON

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON

ADR_BASE_ASMNET1LSNR_ASM = /u01/app/grid

LISTENER_SCAN1 =

(DESCRIPTION =

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

)

ADR_BASE_LISTENER_SCAN1 = /u01/app/grid

[dave@www.cndba.cn admin]$

版权声明：本文为博主原创文章，未经博主允许不得转载。