Error 1033 received logging on to the standby

PRIMARY:

alert.log:

Error 1033 received logging on to the standby
Wed Jul 10 16:15:08 2019
Error 1033 received logging on to the standby
Wed Jul 10 16:16:11 2019
Error 1033 received logging on to the standby
Wed Jul 10 16:17:13 2019
Error 1033 received logging on to the standby

dr.log:

07/10/2019 16:19:57
Failed to connect to remote database TESTSTY. Error is ORA-01033
Failed to send message to site TESTSTY. Error code is ORA-01033.
Data Guard Broker Status Summary:
Type Name Severity Status
Configuration TESTDB Warning ORA-16607
Primary Database TESTDB Error ORA-16778
Physical Standby Database TESTSTY Error ORA-01033

STANDBY:

alert.log:

------------------------------------------------------------
FAL[client, ARC2]: Error 16191 connecting to (DESCRIPTION = (
LOAD_BALANCE = ON)(ADDRESS = (PROTOCOL = TCP)(HOST = ractest-scan)
(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = TESTDB))) 
for fetching gap sequence

dr.log:

07/10/2019 15:32:23
Connection to database TESTDB returns ORA-01017.
Please check database TESTDB is using a remote password file,
its remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and the SYS password is the same as this database.
Failed to connect to remote database TESTDB. Error is ORA-01017
Failed to send message to site TESTDB. Error code is ORA-01017.

SOLUTION

Copy database password file from primary to standby server.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.