[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;
Read More:
- Error 1033 received logging on to the standby
- RAC Error is 16191 Error 1017 received logging on to the standby
- PING[ARC2]: Heartbeat failed to connect to standby ‘jzhddg’. Error is 16032.
- Oracle database missing init.ora Solutions
- Oracle Data Guard Ping [arc2]: heartbeat failed to connect to standby “. Error is 12514 fault analysis
- Error ora-00600 [ksfd] in logical standby database of DataGuard_ DECAIOPC]
- Solution to the exception of PEM file logging in EC2
- Sys.webforms.pagerequestmanagerparsererrorexception: unable to parse message received from server
- [error handling] when logging into MySQL with CentOS command, an error 1045 (28000) is reported
- [How to Fix] sslexeption: received fatal Alert: internal_ error
- RuntimeError: received 0 items of ancdata
- MacBook M1 Big Sur logging into forticlient SSL VPN
- error This is probably not a problem with npm. There is likely additional logging output above.
- Commit failed – exit code 1 received
- Putty encountered an error when logging into alicloud CentOS: dis connected:No supported authentication methods available
- GitHub desktop upload file error commit failed – exit code 1 received
- IntelliJ idea startup error: error statuslogger log4j2 could not find a logging implementation
- gnutls_handshake() failed: A TLS fatal alert has been received
- Ie8.0 reports Oracle error 1403 error after logging into Oracle EBS
- SFTP login error: fatal error: received unexpected end of file from SFTP server