ORA-00141: all addresses specified for parameter REMOTE_LISTENER are invalid

GDSCTL> add gsm -gsm gsznode1 -catalog gdsrac
        "gsmcatuser" password:
GSM-45029: SQL error
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_CLOUDADMIN", line 1999
ORA-00119: invalid specification for system parameter _GSM
ORA-00141: all addresses specified for parameter REMOTE_LISTENER are invalid
ORA-00130: invalid listener address '(ADDRESS=(HOST=gsm)(PORT=1522)(PROTOCOL=tcp))'
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_COMMON", line 1547
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_COMMON", line 1580
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_COMMON", line 1564
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_COMMON", line 1037
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_CLOUDADMIN", line 1987
ORA-06512: at line 1
GDSCTL>

原因是:监听参数配置错误

Posted in 学习 | ORA-00141: all addresses specified for parameter REMOTE_LISTENER are invalid已关闭评论

阉割18C集群配置

srvctl  remove  network -netnum 2
srvctl  remove mgmtdb -f
srvctl  stop MGMTLSNR
srvctl  remove MGMTLSNR
crsctl  modify resource ora.crf -attr "AUTO_START=never" -init
srvctl  stop  cha
srvctl  disable cha
srvctl  remove  cha
Posted in 18c | 阉割18C集群配置已关闭评论