Oracle Instance and Database Startup and Shutdown
A complete production-ready SOP for Oracle Database startup and shutdown procedures on Linux. Covers all startup modes, all shutdown modes, pfile vs spfile startup,…
CATEGORY
Oracle SOP
16 articles
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 and its…
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, connection pooling…
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 tuning with…
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 tasks, timezone…
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 to tape,…
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, tablespace and…
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 database preparation,…
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, Manager configuration,…
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 Infrastructure patching…
Oracle Data Guard 19c Configuration
A complete production-ready SOP for configuring Oracle Data Guard 19c from scratch. Covers primary database preparation, standby database creation using RMAN active duplicate, Data…
Oracle RAC 19c Patching
A complete production-ready SOP for patching Oracle RAC 19c on Linux. Covers both rolling and non-rolling patch methods, Grid Infrastructure patching, ASM patching, database…