So i have been getting the below error and the MRP process will not start.
AL[client, USER]: Error 16191 connecting to DB for fetching gap sequence
Fri Oct 19 17:12:32 2018
Error 1017 received logging on to the standby
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
returning error ORA-16191
------------------------------------------------------------
FAL[client, USER]: Error 16191 connecting to DB for fetching gap sequence
Fri Oct 19 17:14:34 2018
RFS[10]: Selected log 102 for thread 1 sequence 998 dbid 817539321 branch 788971449
1. I verified i copy the password file from node 1 to all standby servers and password file exist on standby side.
2. I verified remote_login_passwordfile is set to Exclusive
I followed an article that the log is missing and read it from backup and then tried to cancel MRP and start again. Still this did not work.
SOLUTON:
The password file on primary node 1 and node 2 were different. I ran the diff command and saw there was difference.
I copied from node 1 and initially it did not work. So i backed node 1 file. Copied node 2 file to node 1. Also copied the same file to standby all nodes.
Restarted the MRP and it worked.
AL[client, USER]: Error 16191 connecting to DB for fetching gap sequence
Fri Oct 19 17:12:32 2018
Error 1017 received logging on to the standby
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
returning error ORA-16191
------------------------------------------------------------
FAL[client, USER]: Error 16191 connecting to DB for fetching gap sequence
Fri Oct 19 17:14:34 2018
RFS[10]: Selected log 102 for thread 1 sequence 998 dbid 817539321 branch 788971449
1. I verified i copy the password file from node 1 to all standby servers and password file exist on standby side.
2. I verified remote_login_passwordfile is set to Exclusive
I followed an article that the log is missing and read it from backup and then tried to cancel MRP and start again. Still this did not work.
SOLUTON:
The password file on primary node 1 and node 2 were different. I ran the diff command and saw there was difference.
I copied from node 1 and initially it did not work. So i backed node 1 file. Copied node 2 file to node 1. Also copied the same file to standby all nodes.
Restarted the MRP and it worked.
this helped me...thanks
ReplyDelete