Protection Mode: MaxPerformance
Members:
proddg01 - Primary database
proddg02 - Physical standby database
Error: ORA-16664: unable to receive the result from a member
配置的状态反而报错，
Error: ORA-16664: unable to receive the result from a member
6.检查PRODDG02的状态
DGMGRL> show database proddg02 statusreport
Error: ORA-16664: unable to receive the result from a member
7.检查主库日志
[oracle@host01 trace]$ tail -10 alert_PRODDG.log
ALTER SYSTEM SET fal_server='' SCOPE=BOTH;
2023-11-18T16:49:18.630849+08:00
TT04 (PID:30951): SRL selected for T-1.S-32 for LAD:2
2023-11-18T16:49:21.473988+08:00
Thread 1 advanced to log sequence 33 (LGWR switch)
Current log# 5 seq# 33 mem# 0: /u01/app/oracle/oradata/PRODDG/std05.log
2023-11-18T16:49:21.562645+08:00
ARC2 (PID:30390): Archived Log entry 159 added for T-1.S-32 ID 0x3e283b54 LAD:1
2023-11-18T16:49:21.796144+08:00
TT03 (PID:30949): SRL selected for T-1.S-33 for LAD:2
没有看到什么错误
8.检查主库BROKER的日志
Data Guard Broker Status Summary:
Type Name Severity Status
Configuration ocm Warning ORA-16607: one or more members have failed
Primary Database proddg01 Success ORA-0: normal, successful completion
Physical Standby Database proddg02 Error ORA-16664: unable to receive the result from a member
*** 2023-11-18T16:57:23.251401+08:00 (CDB$ROOT(1))
krsu_wallet_pwd_connect: OCISessionBegin failed. Error -1
krsu_dump_oci_emsg: Detailed OCI error val is 1017 and errmsg is 'ORA-01017: invalid username/password; logon denied
'
NSV0: Connect descriptor used is: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=host01.example.com)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRODDG01.example.com)(INSTANCE_NAME=PRODDG)))
NSV0: Failed to connect to remote database proddg01. Error is ORA-1017
NSV0: Connect attempt to database proddg01 failed, status = ORA-1017.
Failed to send message to site proddg01. Error code is ORA-1017.
看来是PRODDG02访问PRODDG01，报口令错误 ORA-1017
10.检查备库DGBROKER的日志
[oracle@host02 trace]$ tail -20 drcPRODDG.log
。。。
2023-11-18T17:00:34.428+08:00
Connection to database proddg01 returns ORA-1017.
Please check if database proddg01 is using a remote password file,
its remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and the SYS or SYSDG password is the same as this database.
Failed to connect to remote database proddg01. Error is ORA-1017
Failed to send message to member proddg01. Error code is ORA-1017.
11.根据报错，检查对应参数
SYS@PRODDG> conn sys/oracle_4U@proddg01 as sysdba
Connected.
SYS@proddg01> show parameter remote_login_passwordfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile string EXCLUSIVE
SYS@proddg01>
SYS@proddg01> conn sys/oracle_4U@proddg02 as sysdba
Connected.
SYS@proddg02> show parameter remote_login_passwordfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile string EXCLUSIVE
SYS@proddg02>
看结果，参数都没有问题，密码也没有问题。
这个问题比较奇怪。日志也能过去，就是不能配DGBROKER
12.检查备库上的DGBROKER配置情况
DGMGRL> connect sys/oracle_4U@proddg02
Connected to "proddg02"
Connected as SYSDBA.
DGMGRL> show configuration;
检查两边该参数设置情况：
SYS@PRODDG>conn sys/oracle_4U@proddg01 as sysdba
Connected.
SYS@proddg01>show parameter redo_
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
redo_transport_user string
SYS@proddg01>conn sys/oracle_4U@proddg02 as sysdba
Connected.
SYS@proddg02>show parameter redo_
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
redo_transport_user string c##user1
SYS@proddg02>