alert 中一堆这个保存一新
*********************************************************************** Fatal NI connect error 12504, connecting to: (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=)(INSTANCE_NAME=hrz)(CID=(PROGRAM=oracle)(HOST=sd4)(USER=oracle)))(ADDRESS=(PROTOCOL=tcp)(HOST=172.31.5.203)(PORT=1521))) VERSION INFORMATION: TNS for Linux: Version 19.0.0.0.0 - Production TCP/IP NT Protocol Adapter for Linux: Version 19.0.0.0.0 - Production Version 19.11.0.0.0 Time: 11-OCT-2024 22:54:01 Tracing not turned on. Tns error struct: ns main err code: 12564 TNS-12564: TNS:connection refused ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 2024-10-11T22:54:31.805738+08:00 ALTER SYSTEM SET fal_server='(DESCRIPTION=(ADDRESS=(HOST=sd3)(PORT=1521)(PROTOCOL=tcp))(CONNECT_DATA=(SERVICE_NAME=hrz)))' SCOPE=BOTH;
dgmgrl sys/oracle show configuration; 报错信息 1. ORA-16664 with ORA-12514. 解决办法 edit database <standby> set property StaticConnectIdentifier='<Static Address>'; 例如: edit database hrz set property StaticConnectIdentifier='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sd3)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=hrz_DGMGRL.sd3)(INSTANCE_NAME=hrz)(SERVER=DEDICATED)))'; edit database hrz set property DGConnectIdentifier='(DESCRIPTION=(ADDRESS=(HOST=sd3)(PORT=1521)(PROTOCOL=tcp))(CONNECT_DATA=(SERVICE_NAME=hrz)))'; edit database hrzs set property StaticConnectIdentifier='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sd4)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=hrz_DGMGRL.sd4)(INSTANCE_NAME=hrz)(SERVER=DEDICATED)))'; edit database hrzs set property DGConnectIdentifier='(DESCRIPTION=(ADDRESS=(HOST=sd4)(PORT=1521)(PROTOCOL=tcp))(CONNECT_DATA=(SERVICE_NAME=hrzs)))';标签:NAME,16664,hrz,tcp,HOST,报错,1521,ADDRESS,ORA From: https://www.cnblogs.com/dbahrz/p/18459521