Lesson 1Current setup details: spfile/pfile differences, memory, CPU, parallel settingsLook at the current setup files like spfile and pfile, write down how much memory and CPU it's using, and check parallel and optimizer settings to spot any dangerous changes and missing parts compared to what Oracle 19c suggests.
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 types: quick transactions vs reports, peak times, transaction numbers, long jobsFigure out the kind of work on Oracle 12c by telling apart quick transaction work from reports, finding busy times, how many transactions, and jobs that take long, to help plan size, indexes, and speed for 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 ways and keeping data: RMAN lists, scripts, outside tools, backup checksCheck backup plans that keep Oracle 12c safe, like RMAN lists, scripts, and outside tools, and make sure they keep data long enough, can recover in time, and test restores to make sure you can get back during and after moving to 19c.
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 setup: ASM, SAN, NFS, file details and input/output traitsCheck your storage setup for Oracle 12c, like ASM, SAN, NFS, and regular files, and measure input/output patterns and delays to see if it can handle Oracle 19c speed and uptime 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 uptime and disaster recovery setup: Data Guard, RAC, RMAN copies, standby jobsWrite down your current high uptime and disaster recovery plan, like RAC, Data Guard, and RMAN copies, and check switch procedures, protection ways, and standby jobs to see if they work with 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 for Oracle (Linux/Unix/Windows details)Check operating systems running Oracle 12c, make sure kernel settings, packages, and file options are good, and compare Linux, Unix, Windows details that affect speed, steadiness, and support for moving to Oracle 19c.
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 base: users, roles, profiles, network access, encryption, check rulesCheck the security state of Oracle 12c by looking at users, roles, profiles, network controls, encryption, and checks, finding gaps against company and rule needs before going 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 8List of database instances, Oracle versions, and patch levelsMake a full list of Oracle 12c databases, with instance names, jobs, versions, patches, and options used, to pick which to move first and make sure licensing 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: apps, middleware, JDBC/ODBC clients, scheduled jobs and ETL processesFind all things that depend on Oracle 12c from before and after, like apps, middleware, JDBC/ODBC clients, scheduled jobs, to avoid breaking 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 setup matching: copy methods, data parts, masking, real work captureSee how much the test setup matches real work by checking copy methods, data parts, masking ways, and work capture, to make sure real speed tests, function checks, and safe backward tests.
Physical and logical cloning options for 12cSubset strategies for large production datasetsData masking and anonymization requirementsCapturing and replaying representative workloadsValidating configuration parity across tiers