[INS-41112] Specified network interface doesnt maintain connectivity across cluster nodes.

Cause - Installer has detected that network interface eth0 does not maintain connectivity on all cluster nodes.  Action - Ensure that the chosen interface has been configured across all cluster nodes.  Additional Information:
Summary of the failed nodes srv2  - PRVG-11850 : The system call "connect" failed with error "113" while executing exectask on node "srv2"
No route to host  - Cause:  An attempt to execute exectask on the specified node failed.  - Action:  Examine the accompanying error message for details or contact Oracle Support Services. srv1  - PRVG-11850 : The system call "connect" failed with error "113" while executing exectask on node "srv1"
No route to host  - Cause:  An attempt to execute exectask on the specified node failed.  - Action:  Examine the accompanying error message for details or contact Oracle Support Services.
#####################################################

Solution : This was the real time scenario  found during installation, No MAC address values defined by linux team on /etc/sysconfig/network/ ifcfg-em1 file  value HWADDR=xx:xx:xxx:xx:xx:xx

• Check MAC address by typing command on terminal : /sbin/ifconfig
• Add  HWADDR=xx:xx:xxx:xx:xx:xx  value  on /etc/sysconfig/network/ifcfg-em1 file  (on both nodes both NIC card)

oracle@sgdcplm01:/etc/sysconfig/network> cat ifcfg-p8p2

BOOTPROTO='static'
BROADCAST=''
ETHTOOL_OPTIONS=''
IPADDR='xx.xx.xx.xxx/xx'
MTU=''
NAME='Ethernet Controller X710 for 10GbE backplane'
NETWORK=''
REMOTE_IPADDR=''
STARTMODE='auto'
oracle@sgdcplm02:/etc/sysconfig/network> cat ifcfg-em2
BOOTPROTO='static'
BROADCAST=''
ETHTOOL_OPTIONS=''
IPADDR='xx.xxx.x.xxx/xx'
MTU=''
NAME='Ethernet Controller 10G X550T'
NETWORK=''
REMOTE_IPADDR=''

HWADDR=xx:xx:xxx:xx:xx:xx
STARTMODE='auto'

Oracle Database - Log Minor Examples

alter system set utl_file_dir='D:\63_archivelog\log_minor' scope=spfile;
D:\63_archivelog\log_minor
##############################################################################################################

EXECUTE DBMS_LOGMNR_D.BUILD('dictionary.ora', 'D:\63_archivelog\log_minor', DBMS_LOGMNR_D.STORE_IN_FLAT_FILE);

SQL> execute DBMS_LOGMNR.ADD_LOGFILE ('C:\ORACLE\ORADATA\ORDB1\REDO01.LOG');

SQL> execute DBMS_LOGMNR.ADD_LOGFILE ('C:\ORACLE\ORADATA\ORDB1\REDO02.LOG');

SQL> execute DBMS_LOGMNR.ADD_LOGFILE ('C:\ORACLE\ORADATA\ORDB1\REDO03.LOG');

SQL> execute DBMS_LOGMNR.ADD_LOGFILE ('C:\ORACLE\ORADATA\ORDB1\REDO04.LOG');
################################################################################################################


EXECUTE DBMS_LOGMNR.ADD_LOGFILE( LOGFILENAME => '/tmp/group_1.259.919359545', OPTIONS => DBMS_LOGMNR.NEW);

EXECUTE DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME => '/tmp/group_2.261.919359549',OPTIONS => DBMS_LOGMNR.ADDFILE);

execute DBMS_LOGMNR.ADD_LOGFILE (LOGFILENAME => 'D:\63_archivelog\1_230_1005460847.arc', OPTIONS => DBMS_LOGMNR.NEW);
execute DBMS_LOGMNR.ADD_LOGFILE (LOGFILENAME => 'D:\63_archivelog\1_231_1005460847.arc', OPTIONS => DBMS_LOGMNR.ADDFILE);
execute DBMS_LOGMNR.ADD_LOGFILE (LOGFILENAME => 'D:\63_archivelog\1_232_1005460847.arc', OPTIONS => DBMS_LOGMNR.ADDFILE);
execute DBMS_LOGMNR.ADD_LOGFILE (LOGFILENAME => 'D:\63_archivelog\1_233_1005460847.arc', OPTIONS => DBMS_LOGMNR.ADDFILE);
execute DBMS_LOGMNR.ADD_LOGFILE (LOGFILENAME => 'D:\63_archivelog\1_234_1005460847.arc', OPTIONS => DBMS_LOGMNR.ADDFILE);
execute DBMS_LOGMNR.ADD_LOGFILE (LOGFILENAME => 'D:\63_archivelog\1_235_1005460847.arc', OPTIONS => DBMS_LOGMNR.ADDFILE);
execute DBMS_LOGMNR.ADD_LOGFILE (LOGFILENAME => 'D:\63_archivelog\1_236_1005460847.arc', OPTIONS => DBMS_LOGMNR.ADDFILE);
execute DBMS_LOGMNR.ADD_LOGFILE (LOGFILENAME => 'D:\63_archivelog\1_237_1005460847.arc', OPTIONS => DBMS_LOGMNR.ADDFILE);


EXECUTE DBMS_LOGMNR.START_LOGMNR (DICTFILENAME => 'D:\63_archivelog\log_minor\DICTIONARY1.ORA');

SELECT scn, operation, sql_redo, sql_undo FROM v$logmnr_contents;

RAC - SYSDBA Connection Fails With ORA-01017 and ORA-17503 (Doc ID 2474161.1)

SYSDBA Connection Fails With ORA-01017 and ORA-17503 (Doc ID 2474161.1)

SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
oracle@sgdcplm01:~> sqlplus sys/sxxxxxxx@smrrac as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Mon Sep 30 16:08:51 2019

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

ERROR:
ORA-01017: invalid username/password; logon denied
ORA-17503: ksfdopn:2 Failed to open file
+DATA/SMRRAC/PASSWORD/pwdsmrrac.256.1020157701
ORA-12536: TNS:operation would block


Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name:

ERROR:
ORA-01017: invalid username/password; logon denied


SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
oracle@sgdcplm01:~>
oracle@sgdcplm01:~> sqlplus sys/sxxxxxxxx@smrrac as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Mon Sep 30 16:09:02 2019

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


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options

SQL> @d

NAME      INSTANCE_NAME    DB_UNIQUE_NAME                 OPEN_MODE            DATABASE_ROLE    CURRENT_SCN        FAILOVER_SCN
--------- ---------------- ------------------------------ -------------------- ---------------- ------------------ ----------------------------------------
SMRRAC    smrrac2          smrrac                         READ WRITE           PRIMARY          NO                 0

SQL> @d

NAME      INSTANCE_NAME    DB_UNIQUE_NAME                 OPEN_MODE            DATABASE_ROLE    CURRENT_SCN        FAILOVER_SCN
--------- ---------------- ------------------------------ -------------------- ---------------- ------------------ ----------------------------------------
SMRRAC    smrrac2          smrrac                         READ WRITE           PRIMARY          NO                 0

SQL> @tablespace

NAME      OPEN_MODE            DATABASE_ROLE    DB_UNIQUE_NAME
--------- -------------------- ---------------- ------------------------------
SMRRAC    READ WRITE           PRIMARY          smrrac


Tablespace                        Allocated      Current         Used    Available   %Used (vs)
Name                               Size(GB)     Size(GB)     Size(GB)     Size(GB)  (Allocated)
------------------------------ ------------ ------------ ------------ ------------ ------------
SYSAUX                                32.00          .83          .79        31.21         2.48
SYSTEM                                32.00          .78          .77        31.23         2.42
UNDOTBS1                              32.00          .13          .01        31.99          .02
UNDOTBS2                              32.00          .05          .01        31.99          .03
USERS                                 32.00          .00          .00        32.00          .00

SQL> sho parameter dump

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
background_core_dump                 string      partial
background_dump_dest                 string      /u01/app/oracle/product/12.1.0
                                                 /dbhome_2/rdbms/log
core_dump_dest                       string      /u01/app/oracle/diag/rdbms/smr
                                                 rac/smrrac2/cdump
max_dump_file_size                   string      unlimited
shadow_core_dump                     string      partial
user_dump_dest                       string      /u01/app/oracle/product/12.1.0
                                                 /dbhome_2/rdbms/log
SQL> exit