Oracle Database Preinstallation check

We can use RDA tool to Health Check/Validation for "Oracle Database Preinstallation "

[oracle@cloud1 rda]$ perl rda.pl -T hcve
Processing HCVE tests ...
Available Pre-Installation Rule Sets:
   1.  Oracle Database 10g R1 (10.1.0) Preinstall (Linux)
   2.  Oracle Database 10g R2 (10.2.0) Preinstall (Linux)
   3.  Oracle Database 11g R1 (11.1) Preinstall (Linux)
   4.  Oracle Database 11g R2 (11.2.0) Preinstall (Linux)
   5.  Oracle Database 12c R1 (12.1.0) Preinstallation (Linux)
   6.  Oracle Identity and Access Management PreInstall Check: Oracle Identity
       and Access Management 11g Release 2 (11.1.2) Linux
   7.  Oracle JDeveloper PreInstall Check: Oracle JDeveloper 11g Release 2
       (11.1.2.4) Linux
   8.  Oracle JDeveloper PreInstall Check: Oracle JDeveloper 12c (12.1.3)
       Linux
   9.  OAS PreInstall Check: Application Server 10g R2 (10.1.2) Linux
  10.  OAS PreInstall Check: Application Server 10g R3 (10.1.3) Linux
  11.  OFM PreInstall Check: Oracle Fusion Middleware 11g R1 (11.1.1) Linux
  12.  OFM PreInstall Check: Oracle Fusion Middleware 12c (12.1.3) Linux
  13.  Oracle Forms and Reports PreInstall Check: Oracle Forms and Reports 11g
       Release 2 (11.1.2) Linux
  14.  Portal PreInstall Check: Oracle Portal Generic
  15.  IDM PreInstall Check: Identity Management 10g (10.1.4) Linux
  16.  BIEE PreInstall Check: Business Intelligence Enterprise Edition 11g
       (11.1.1) Generic
  17.  EPM PreInstall Check: Enterprise Performance Management Server (11.1.2)
       Generic
  18.  Oracle Enterprise Manager Cloud Control PreInstall Check: Oracle
       Enterprise Manager Cloud Control 12c Release 4 (12.1.0.4) Linux
  19.  Oracle E-Business Suite Release 11i (11.5.10) Preinstall (Linux x86 and
       x86_64)
  20.  Oracle E-Business Suite Release 12 (12.1.1) Preinstall (Linux x86 and
       x86_64)
  21.  Oracle E-Business Suite Release 12 (12.2.0) Preinstall (Linux x86_64)

Available Post-Installation Rule Sets:
  22.  RAC 10G DB and OS Best Practices (Linux)
  23.  Data Guard Postinstall (Generic)
  24.  WLS PostInstall Check: WebLogic Server 11g (10.3.x) Generic
  25.  WLS PostInstall Check: WebLogic Server 12c (12.x) Generic
  26.  Portal PostInstall Check: Oracle Portal Generic
  27.  OC4J PostInstall Check: Oracle Containers for J2EE 10g (10.1.x) Generic
  28.  SOA PostInstall Check: Service-Oriented Architecture 11g and Later
       Generic
  29.  OSB PostInstall Check: Service Bus 11g and Later Generic
  30.  Oracle Forms 11g Post Installation (Generic)
  31.  Network Charging and Control Database Post Installation (Generic)

Enter the HCVE rule set number or 0 to cancel the test
Press Return to accept the default (0)
> 5

Performing HCVE checks ...
Enter value for < Planned ORACLE_HOME location >
Press Return to accept the default (/u01/app/oracle/product/12.1.0)
>

Enter value for < JDK Home >
> /u01/app/oracle/product/12.1.0/jdk


Test "Oracle Database 12c R1 (12.1.0) Preinstallation (Linux)" executed at 09-Jun-2015 18:21:56

Test Results
~~~~~~~~~~~~

ID     NAME                 RESULT  VALUE
====== ==================== ======= ==========================================
A00100 OS Certified?        PASSED  Adequate
A01020 User in /etc/passwd? PASSED  userOK
A01040 Group in /etc/group? PASSED  GroupOK
A01050 Enter ORACLE_HOME    RECORD  /u01/app/oracle/product/12.1.0
A01060 ORACLE_HOME Valid?   PASSED  OHexists
A01070 O_H Permissions OK?  PASSED  CorrectPerms
A01210 Enter JDK Home       RECORD  /u01/app/oracle/product/12.1.0/jdk
A01220 JDK Version          PASSED  Adequate
A01410 oraInventory Permiss PASSED  oraInventoryOK
A01420 Other OUI Up?        PASSED  NoOtherOUI
A01430 Got Software Tools?  PASSED  ld_nm_ar_make_found
A01440 Other O_Hs in PATH?  FAILED  OratabEntryInPath
A02010 Umask Set to 022?    PASSED  UmaskOK
A02030 Limits Processes     PASSED  Adequate
A02040 Limits Stacksize     PASSED  Adequate
A02050 Limits Descriptors   PASSED  Adequate
A02100 LDLIBRARYPATH Unset? FAILED  IsSet
A02170 JAVA_HOME Unset?     PASSED  UnSet
A03100 RAM (in MB)          PASSED  2952
A02210 Kernel Parameters OK PASSED  KernelOK
A02300 Tainted Kernel?      PASSED  NotVerifiable
A03010 Temp Adequate?       PASSED  TempSpaceOK
A03020 Disk Space OK?       FAILED  NoSpace
A03050 Swap (in MB)         RECORD  4255
A03100 RAM (in MB)          PASSED  2952
A03150 SwapToRam OK?        PASSED  SwapToRamOK
A03500 Network              PASSED  Connected
A03510 IP Address           RECORD  10.0.3.15
A03530 Domain Name          RECORD  domain.com
A03540 /etc/hosts Format    PASSED  Adequate IPv4 entry
A03550 DNS Lookup           FAILED  nslookup host.domain
A03600 ip_local_port_range  PASSED  RangeOK
A04301 OL5 Server RPMs OK?  SKIPPED NotOL5
A04302 OL5 32-bit Client RP SKIPPED NotOL5
A04303 OL6 Server RPMs OK?  FAILED  [unixODBC(x86_64)] not installed [uni...
A04304 OL6 32-bit Client RP FAILED  [compat-libstdc++-33(i686)] not insta...
A04305 OL7 Server RPMs OK?  SKIPPED NotOL7
A04311 RHEL5 Server RPMs OK SKIPPED NotRedHat
A04312 RHEL5 32-bit Client  SKIPPED NotRedHat
A04313 RHEL6 Server RPMs OK SKIPPED NotRedHat
A04314 RHEL6 32-bit Client  SKIPPED NotRedHat
A04315 RHEL7 Server RPMs OK SKIPPED NotRedHat
A04321 SLES11 Server RPMs O SKIPPED NotSuSE
A04322 SLES11 32-bit Client SKIPPED NotSuSE
Result file: output/collect/DB_HCVE_A_DB12R1_lin_res.htm

Datagurad Scripts

Check Last Applied Log:

select 'Last Log applied : ' Logs, to_char(next_time,'DD-MON-YY:HH24:MI:SS') Time
from v$archived_log
where sequence# = (select max(sequence#) from v$archived_log where applied='YES')
union
select 'Last Log received : ' Logs, to_char(next_time,'DD-MON-YY:HH24:MI:SS') Time
from v$archived_log
where sequence# = (select max(sequence#) from v$archived_log);

select to_char(max(FIRST_TIME),'hh24:mi:ss dd/mm/yyyy') FROM V$ARCHIVED_LOG where applied='YES';

Check Applied Rate:

select to_char(start_time, 'DD-MON-RR HH24:MI:SS') start_time,
item, round(sofar/1024,2) "MB/Sec"
from v$recovery_progress
where (item='Active Apply Rate' or item='Average Apply Rate');