Lesson 1Existing configuration parameters: spfile/pfile differences, memory, CPU, parallel settingsCheck current initialization parameters in spfile an pfile, write down memory an CPU allocations, an review parallel an optimizer settings fi spot risky customizations an gaps against Oracle 19c recommended practices.
Locating and backing up spfile and pfileComparing spfile and pfile parameter valuesSGA, PGA, and memory_target configuration reviewCPU_COUNT, parallelism, and resource manager useOptimizer, statistics, and cursor-related parametersLesson 2Workload characterization: OLTP vs reporting, peak windows, transaction rates, long-running jobsCheck di workload run pon Oracle 12c by separate OLTP an reporting patterns, spot peak windows, transaction volumes, an long-running jobs, fi inform sizing, indexing, an performance expectations in 19c.
Classifying OLTP, batch, and reporting workloadsCapturing AWR and ASH workload baselinesIdentifying peak usage windows and patternsAnalyzing transaction rates and SQL hotspotsReviewing long-running jobs and resource usageLesson 3Backup methods and retention: RMAN catalogs, scripts, third-party tools, backup validationReview backup strategies protectin Oracle 12c, includin RMAN catalogs, scripts, an third-party tools, an verify retention, recovery windows, an restore tests fi ensure reliable recovery during an after di 19c migration.
RMAN catalog configuration and maintenanceBackup schedules, levels, and compression useIntegration with third-party backup solutionsRetention policies and recovery window reviewRegular restore and validation test proceduresLesson 4Storage architecture: ASM, SAN, NFS, filesystem details and I/O characteristicsCheck current storage design fi Oracle 12c, includin ASM, SAN, NFS, an local filesystems, an measure I/O patterns an latency fi determine if di platform can sustain Oracle 19c performance an availability requirements.
ASM disk groups, redundancy, and templatesSAN LUN layout, RAID levels, and cachingNFS configuration, mount options, and lockingLocal filesystem choices and block size alignmentI/O throughput, latency, and queue depth metricsLesson 5High availability and DR topology: Data Guard, RAC, RMAN duplication, standby rolesWrite down di existing high availability an disaster recovery design, includin RAC, Data Guard, an RMAN duplication, an evaluate failover procedures, protection modes, an standby roles fi compatibility wid Oracle 19c.
Current RAC topology and node configurationPrimary and standby Data Guard relationshipsProtection modes, lag, and redo transport checksRMAN duplication and clone creation workflowsFailover, switchover, and DR test proceduresLesson 6Operating system and kernel settings relevant to Oracle (Linux/Unix/Windows specifics)Review OS platforms hostin Oracle 12c, validate kernel parameters, packages, an filesystem options, an compare Linux, Unix, an Windows specifics dat affect performance, stability, an supportability fi an Oracle 19c upgrade path.
Supported OS versions and certification checksLinux kernel parameters and hugepages tuningUnix resource limits, semaphores, and IPC settingsWindows services, registry, and memory settingsFilesystem mount options and I/O scheduler choicesLesson 7Security baseline: users, roles, profiles, network access, encryption, audit policiesCheck di current security posture of Oracle 12c by reviewin users, roles, profiles, network access controls, encryption, an auditing, identifyin gaps against organizational an regulatory requirements before movin to Oracle 19c.
User, role, and privilege model assessmentPassword policies, profiles, and lockout rulesNetwork access controls and SQL*Net hardeningTDE, data-at-rest, and data-in-transit encryptionUnified auditing configuration and log reviewLesson 8Inventory of database instances, Oracle versions, and patch levelsCompile a complete inventory of Oracle 12c databases, includin instance names, roles, versions, patch levels, an options in use, fi prioritize migration candidates an ensure licensing an support compliance fi Oracle 19c.
Discovering all Oracle homes and instancesRecording database roles and environmentsDocumenting exact versions and PSU/BP levelsCataloging installed options and feature usagePrioritizing databases for migration wavesLesson 9Dependency mapping: applications, middleware, JDBC/ODBC clients, scheduled jobs and ETL processesIdentify all upstream an downstream dependencies pon Oracle 12c, includin applications, middleware, client drivers, an scheduled jobs, fi avoid breakage during migration an fi plan coordinated testing an cutover activities.
Cataloging application schemas and ownersJDBC, ODBC, and Oracle client version reviewMiddleware connection pools and JNDI settingsBatch jobs, ETL tools, and data movement flowsDependency documentation and impact analysisLesson 10Test environment parity: cloning methods, dataset subset, masking, representative workload captureEvaluate how closely di test environment mirror production by reviewin cloning methods, data subsets, masking strategies, an workload capture, ensurin realistic performance, functional validation, an safe regression testing.
Physical and logical cloning options for 12cSubset strategies for large production datasetsData masking and anonymization requirementsCapturing and replaying representative workloadsValidating configuration parity across tiers