Oracle Database Architecture
A complete production-ready SOP covering Oracle Database architecture from the ground up. Covers physical and logical storage structures, Oracle instance components, SGA…
Oracle Network and Connectivity
A complete production-ready SOP for Oracle Network and Connectivity administration on Linux. Covers tnsnames.ora, listener.ora, sqlnet.ora management, SCAN listener configuration in RAC,…
Oracle Performance Tuning
A complete production-ready SOP for Oracle Database real-time performance tuning. Covers AWR, ADDM, ASH report generation and analysis, wait event analysis, SQL…
Oracle Database Upgrade to 19c
A complete production-ready SOP for upgrading Oracle Database from 11g/12c/18c to 19c on Linux. Covers pre-upgrade checks, preupgrade utility, upgrade methods, post-upgrade…
Oracle RMAN Backup and Recovery
A complete production-ready SOP for Oracle RMAN backup and recovery on Linux. Covers RMAN configuration, full and incremental backups, archivelog backups, backup…
Oracle TDE Wallet Configuration
A complete production-ready SOP for configuring Oracle Transparent Data Encryption (TDE) on Linux from scratch. Covers wallet creation, master encryption key generation,…
Oracle Enterprise Manager 19c Installation and Configuration
A complete production-ready SOP for installing and configuring Oracle Enterprise Manager Cloud Control 19c on Linux from scratch. Covers OMS prerequisites, repository…
Oracle GoldenGate 19c Installation and Configuration
A complete production-ready SOP for installing and configuring Oracle GoldenGate 19c on Linux from scratch. Covers GoldenGate architecture, source and target preparation,…
Oracle Data Guard 19c Patching
A complete production-ready SOP for patching Oracle Data Guard 19c on Linux. Covers the rolling patch method using the standby-first approach, Grid…
