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/

                                                  

Check ssh date on both 2 node RAC Server

• [grid@srv2 ~]$ cat /etc/hosts

#127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
#::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

127.0.0.1   localhost.localdomain localhost
# Public
192.168.56.71   srv1.example.com        srv1
192.168.56.72   srv2.example.com        srv2
192.168.56.73   srv3.example.com        srv3
# Private
192.168.10.1    srv1-priv.example.com   srv1-priv
192.168.10.2    srv2-priv.example.com   srv2-priv

# Virtual
192.168.56.81   srv1-vip.example.com    srv1-vip
192.168.56.82   srv2-vip.example.com    srv2-vip

# SCAN (in production this should be configured in DNS)
192.168.56.91   srv-scan.example.com    srv-scan
192.168.56.92   srv-scan.example.com    srv-scan
192.168.56.93   srv-scan.example.com    srv-scan

• [grid@srv2 ~]$ ssh srv1.example.com date;ssh srv2.example.com date

Wed Dec 11 12:59:04 IST 2019
Wed Dec 11 12:59:04 IST 2019
[grid@srv2 ~]$

NOTE : set date ===> date -s "2 OCT 2006 18:00:00"

ORA-00119: invalid specification for system parameter LOCAL_LISTENER

ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_SMRTESTENV'

• oracle@sgdcplm02:/u01/app/oracle/product/12.1.0/dbhome_1/dbs> sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Mon Dec 2 10:34:36 2019

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to an idle instance.

• SQL> startup nomount;

ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_SMRTESTENV'

• SQL> create pfile from spfile;

File created.

SQL> exit
Disconnected
oracle@sgdcplm02:/u01/app/oracle/product/12.1.0/dbhome_1/dbs> ll



oracle@sgdcplm02:> vi initSMRTESTENV.ora

#*.local_listener='LISTENER_SMRTESTENV'

SQL> startup pfile='/u01/app/oracle/product/12.1.0/dbhome_1/dbs/initSMRTESTENV.ora';
ORACLE instance started.

Total System Global Area 3154116608 bytes
Fixed Size                  3715784 bytes
Variable Size            1543507256 bytes
Database Buffers         1593835520 bytes
Redo Buffers               13058048 bytes
Database mounted.
Database opened.