Lesson 1Existing configuration parameters: spfile/pfile differences, memory, CPU, parallel settingsCheck current setup parameters in spfile and pfile, write down memory and CPU share, and look parallel and optimizer settings to find dangerous custom changes and gaps from Oracle 19c best ways.
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 jobsLook at de workload wey dey run on Oracle 12c by separate OLTP and reporting patterns, find peak times, transaction numbers, and long jobs, so to help size, index, and expect performance 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 validationCheck backup plans wey dey protect Oracle 12c, including RMAN catalogs, scripts, and outside tools, and make sure retention, recovery times, and restore tests good for sure recovery during and after 19c move.
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 for Oracle 12c, including ASM, SAN, NFS, and local filesystems, and measure I/O patterns and delay to see if de platform fit hold Oracle 19c performance and up-time needs.
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 de current high up-time and disaster recovery design, including RAC, Data Guard, and RMAN copy, and check failover steps, protection modes, and standby roles if dem fit wit 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)Check OS platforms wey dey host Oracle 12c, make sure kernel parameters, packages, and filesystem choices good, and compare Linux, Unix, Windows tings wey affect performance, steady, and support for Oracle 19c upgrade road.
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 current security stand of Oracle 12c by look users, roles, profiles, network access controls, encryption, and audit, find gaps from company and rule needs before go 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 levelsMake full list of Oracle 12c databases, including instance names, roles, versions, patch levels, and options wey dey use, to choose migration ones first and make sure license and support follow rules for 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 processesFind all up and down dependencies on Oracle 12c, including apps, middleware, client drivers, and scheduled jobs, to avoid break during move and plan joint testing and switch 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 captureCheck how close test environment look like production by look cloning ways, data parts, masking plans, and workload catch, make sure real performance, function check, and safe back-test.
Physical and logical cloning options for 12cSubset strategies for large production datasetsData masking and anonymization requirementsCapturing and replaying representative workloadsValidating configuration parity across tiers