Tag Archives: PWDorcl.ora

【ORA】Error 1031 received logging on to the standby

[ORA] Error 1031 Received logging on to the standby

Scene:
When building Windows Server 2008 R2 single-instance DG connected to Linux RAC (11.2.0.3), an error was reported on node 2:
Error 1031 received logging on to the standby

Solution:
The password file will be the same if you use Oracle as the password, but it turns out that you still need to recreate the password file, and the password file will be identical in all three places.

orapwd file=orapworcl password=oracle;
generated the password file; So just copy the password file from node 1 to node 2 and DG (change the file name to PWD instance name.ora, in this case pwdorcl.ora). If you check the alter log and it still gives an error, you need to redistribute and cancel the log application before starting the application log.
*** stop redo logging application
SQL> alter database recover managed standby database cancel;

*** open real-time logging application
SQL> alter database recover managed standby database using current logfile disconnect;