ORA-01017: invalid username/password on DB restart during RMAN Active Duplicate
I'm hitting an issue which I haven't be able to resolve. I'm creating DataGuard standby's on a host. There are 4 databases and I've done 2 successfully but the last two keep giving me the ORA-01017 error at the restart phase of the duplicate, after it's restored the control files.
The connection to target and auxiliary work fine. I have a static registration of the database. I have copied the password files from the source. I've tested them and performed md5sum on them.
Details: Oracle 19.14
Command:
rman
connect target sys/<password>@NMSPR1_SRC
connect auxiliary sys/<password>@NMSPR1_TGT
connected to target database: NMSPR1 (DBID=2108373096)