FAL[client, MRP0]: Error 12154 connecting to rac for fetching gap sequence

Preview Scenario:

• 2 Node RAC with standalone physical standby

• Error: FAL[client, MRP0]: Error 12154 connecting to rac for fetching gap sequence

Solution :

• Copy password file from ASM diskgroup to local disk than scp to standby DBS location.

Standby alert log below:

Tue Dec 10 13:53:19 2019

All non-current ORLs have been archived.

Media Recovery Waiting for thread 1 sequence 555

Fetching gap sequence in thread 1, gap sequence 555-555

Error 12154 received logging on to the standby

FAL[client, MRP0]: Error 12154 connecting to rac for fetching gap sequence

Tue Dec 10 13:53:19 2019

Errors in file /u01/app/oracle/diag/rdbms/stdrac/stdrac/trace/stdrac_mrp0_3806.trc:

ORA-12154: TNS:could not resolve the connect identifier specified

Completed:  alter database recover managed standby database disconnect from session

Tue Dec 10 13:53:29 2019

Error 12154 received logging on to the standby

FAL[client, MRP0]: Error 12154 connecting to rac for fetching gap sequence

Tue Dec 10 13:53:29 2019

Errors in file /u01/app/oracle/diag/rdbms/stdrac/stdrac/trace/stdrac_mrp0_3806.trc:

ORA-12154: TNS:could not resolve the connect identifier specified

Tue Dec 10 13:53:39 2019

Error 12154 received logging on to the standby

FAL[client, MRP0]: Error 12154 connecting to rac for fetching gap sequence

Tue Dec 10 13:53:39 2019

Errors in file /u01/app/oracle/diag/rdbms/stdrac/stdrac/trace/stdrac_mrp0_3806.trc:

ORA-12154: TNS:could not resolve the connect identifier specified

Tue Dec 10 13:53:49 2019

Error 12154 received logging on to the standby

FAL[client, MRP0]: Error 12154 connecting to rac for fetching gap sequence

Tue Dec 10 13:53:49 2019

Errors in file /u01/app/oracle/diag/rdbms/stdrac/stdrac/trace/stdrac_mrp0_3806.trc:

ORA-12154: TNS:could not resolve the connect identifier specified

Tue Dec 10 13:53:59 2019

Error 12154 received logging on to the standby

FAL[client, MRP0]: Error 12154 connecting to rac for fetching gap sequence

Tue Dec 10 13:53:59 2019

Errors in file /u01/app/oracle/diag/rdbms/stdrac/stdrac/trace/stdrac_mrp0_3806.trc:

ORA-12154: TNS:could not resolve the connect identifier specified

Tue Dec 10 13:54:09 2019

Error 12154 received logging on to the standby

FAL[client, MRP0]: Error 12154 connecting to rac for fetching gap sequence

Tue Dec 10 13:54:09 2019

• Login to asmcmd diskgroup

[grid@srv2 ~]$ . oraenv

ORACLE_SID = [+ASM2] ? +ASM2

The Oracle base remains unchanged with value /u01/app/grid

[grid@srv2 ~]$ asmcmd

ASMCMD> lsdg

State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name

MOUNTED  NORMAL  N         512   4096  1048576     36852    27526            12284            7621              0             Y  CRS/

MOUNTED  EXTERN  N         512   4096  1048576     20473    10150                0           10150              0             N  DATA/

MOUNTED  EXTERN  N         512   4096  1048576     20473    15734                0           15734              0             N  FRA/

ASMCMD>

ASMCMD> cd RAC

ASMCMD> ls
CONTROLFILE/
DATAFILE/
ONLINELOG/
PARAMETERFILE/
PASSWORD/
TEMPFILE/
ASMCMD> cd PASSWORD/
ASMCMD> ls
pwdrac.269.1020351483
ASMCMD> pwcopy pwdrac.269.1020351483 /u01/grid
copying +DATA/RAC/PASSWORD/pwdrac.269.1020351483 -> /u01/grid/pwdrac.269.1020351483
ASMCMD> exit
[grid@srv1 ~]$ cd /u01/grid/