EXADATA Complete Study Materiel

EXADATA Complete Study Materiel:

DB Nodes
========
What all commands to check on DB nodes?

Linux:    top , mpstat , vmstat , iostat , fdisk , ustat , sar , sysinfo
Exadata:    dcli
ASM:    asmcmd , asmca
Clusterware:    crsctl , srvctl

CELL Nodes
==========
What all commands to check on DB nodes?

Linux:    top , mpstat , vmstat , iostat , fdisk , ustat , sar , sysinfo
Cell Mgmt: cellcli , cellsrvstat


Below are the MOS documents which make you ZERO to HERO in EXADATA ;) 

Information Center
===============
1306791.2 – Oracle Exadata Database Machine

Master Note
=========
888828.1 – Exadata Database Machine and Exadata Storage Server Supported Versions

Best Practices
==========
757552.1  – Oracle Exadata Best Practices
1274318.1 – Oracle Sun Database Machine Setup/Configuration Best Practices
1244344.1 – Exadata Starter Kit

Operation Tasks
============
1473002.1 – Using dbserver_backup.sh to backup compute nodes
1538068.1 – Remove partition if dbserver_backup.sh fails
1428394.1 – Password stuff (pam_talley2)
1093890.1 – Shutdown and startup Exadata and Compute nodes on rack
1446274.1 – ILOM command reference (startup and shutdown Exadata from ILOM)
1520896.1 – DBFS Configuration Health Check
1054431.1 – Configure DBFS on Exadata Checklist
1553103.1 – latest dbnoteupdate.sh note
401749.1  – Shell Script to Calculate Values Recommended Linux HugePages / HugeTLB Configuration

Cell-Storage Server
==============
1921528.1 – SRDC – EEST Storage Cell General Issues
1306635.1 – Replacement of flash – how to check firmware and status. Resetting status
1188080.1 – Steps to shut down or reboot an Exadata storage cell without affecting ASM
1477020.1 – Exadata: ASM Diskgroup Showing Status Of _DROPPED_… After Storage Maintance
761868.1   – Oracle Exadata Diagnostic Information required for Disk Failures and some other Hardware issues

Patching
=======
1262380.1 – Master note on Exadata patching
1473002.1 – Using ULN to install server patches with YUM
1545789.1 – ISO install Cheat Sheets
1136544.1 – Relinking notes
1553103.1 – Exadata Database Server Patching using the DB Node Update Utility

Software Specific Release Notes
=======================
1537407.1 – Oracle 12c
1681467.1 – 11.2.0.2, 11.2.0.3, 11.2.0.4 or 12.1.0.1 to 12.1.0.2 Grid Infrastructure and Database Upgrade on Exadata Database Machine running Oracle Linux (Doc ID )

DB Nodes
========
How To: How To - Exadata - Configure YUM to connect to Oracle Public Repository [2160289.1]

CELL Nodes
==========
How To: Steps to shut down or reboot an Exadata storage cell without affecting ASM [1188080.1]

Patching/Upgrade/Cloning
====================
Reference: Critical Patch Update (CPU) Program April 2019 Patch Availability Document (PAD) [2498664.1]

Reference: Critical Patch Update (CPU) Program July 2019 Patch Availability Document (PAD) [2534806.1]

Problem: ODA: RMAN-11003 Duplicate Database Fails Due To DB_FLASH_CACHE_FILE Parameter ORA-2095 "initialization parameter cannot be modified" [2090646.1]

Problem: RMAN duplicate failed with RMAN-11003 when setting parameter "_cluster_flash_cache_slave_file" [2110649.1]

Problem: RMAN Duplicate for Standby From Active Database fails with ORA-02095 RMAN-11003 [1924740.1]

Problem: RMAN-11003 ORA-283 ORA-19909 during duplicate database [1913573.1]

Reference: 11.2.0.2, 11.2.0.3, 11.2.0.4 or 12.1.0.1 to 12.1.0.2 Grid Infrastructure and Database Upgrade on Exadata Database Machine running Oracle Linux [1681467.1]

Bulletin: Master Note For Oracle Database 12c Release 2 (12.2) Database/Client Installation/Upgrade/Migration Standalone Environment (Non-RAC) [2195547.1]

Bulletin: Master Note For Oracle Database Upgrades and Migrations [1152016.1]

Problem: When Cloning RC-00214: Warning: The database SID must be 8 characters or less and cannot begin with a numeral. Please reenter the incorrect SID [2312422.1]

Bulletin: Requirements for Installing Oracle 12.2 RDBMS on OL7 or RHEL7 64-bit (x86-64) [2197176.1]

Problem: 11gR2 DBUA Fails With "Null" and trace file shows "Could not launch SQLPLUS. Failed during initialization" [1384810.1]

Assistant: Download Reference for Oracle Database/GI Update, Revision, PSU, SPU(CPU), Bundle Patches, Patchsets and Base Releases [2118136.2]

Reference: Critical Patch Update (CPU) Program July 2018 Patch Availability Document (PAD) [2394520.1]

Reference: Master Note of Linux OS Requirements for Database Server [851598.1]

Bulletin: Master Note For Oracle Database Server Installation [1156586.1]

How To: Linux OS Installation with Reduced Set of Packages for Running Oracle Database Server [728346.1]

Reference: Patch Set Update and Critical Patch Update October 2017 Availability Document [2296870.1]

Douncement: Oracle Recommended Patches -- "Oracle JavaVM Component Database PSU and Update" (OJVM PSU and OJVM Update) Patches [1929745.1]

Douncement: Master Note for Database Proactive Patch Program [756671.1]

Readme: dbnodeupdate.sh and dbserver.patch.zip: Updating Exadata Database Server 

Software using the DBNodeUpdate Utility and patchmgr [1553103.1]

Bulletin: Oracle Database 12c Release 1 (12.1) Upgrade New Features [1515747.1]
Bulletin: Master Note For Oracle Database 12c Release 1 (12.1) Database/Client 

Installation/Upgrade/Migration Standalone Environment (Non-RAC) [1520299.1]

Regards,

Mallik