.

  Oracle Exadata Patching (Oracle Homes) Task#1: patch the Grid Infrastructure (GI) and Oracle RDBMS homes Target Patches GI & RDBMS Home Patch: p37641958_190000_Linux-x86-64.zip OJVM Patch (if required): p37499406_190000_Linux-x86-64.zip Recommended DB Patches: p34774667_1927000DBRU_Linux-x86-64.zip p34672698_1927000DBRU_Linux-x86-64.zip Step 1: Configure SSH Equivalence from node1. ## dcli -g /u01/stage/target_Nodes -l root -k -s '-o StrictHostKeyChecking=no' ## dcli -g /u01/stage/target_Nodes -l root hostname Step 2: Prepare and Copy Patches ## dcli -g /u01/stage/target_Nodes -l root mkdir -p /u01/stage/GI_DB_OJVM_19c/ dcli -g /u01/stage/target_Nodes -l root -f /u01/stage/GI_DB_OJVM_19c/p37641958_190000_Linux-x86-64.zip -d /u01/stage/GI_DB_OJVM_19c/ ## dcli -g /u01/stage/target_Nodes -l root -f /u01/stage/GI_DB_OJVM_19c/p37499406_190000_Linux-x86-64.zip -d /u01/stage/GI_DB_OJVM_19c/ ## dcli -g /u01/stage/target_Nod...

  Recover Lost TDE Encryption Wallet Password   We can recover lost TDE Encryption wallet password if the auto-login wallet (cwallet.sso) is available and function. ·        ewallet.p12 – Oracle TDE password protected wallet/keystore file ·        cwallet.sso – Auto login wallet file   Steps for Recovery Step#1: Take backup of current DB wallet files ·        cd $TNS_ADMIN/db_wallet ·        cp ewallet.p12 ewallet.p12_bak ·        cp cwallet.sso cwallet.sso_bak   Step#2: Create a new TDE wallet/keystore ·        Sql> administer key management create keystore '/u01/app/oracle/db_temp_wallet' identified by "<new_password>";   Step#3: Merge existing keys into new wallet. ·        Sql> administer key management mer...

  Migration to Cloud (OCI / Hybrid)   ·       Lift-and-Shift RMAN backup to Object Storage and restore on OCI DBCS Oracle Zero Downtime Migration (ZDM) Data Guard setup to OCI followed by switchover   ·       Modernization Migration     Oracle Zero Downtime Migration (ZDM)   ·        Install ZDM on a ZDM host (separate from source and target) unzip zdm21.x.zip cd zdm21.x ./zdminstall.sh service ORAHOME=/u01/zdmhome ORABASE=/u01/zdmbase PORT=8895   ·        Initialize ZDM /u01/zdmhome/bin/zdmservice start   ·        Run pre-migration checks zdmcli migrate database -sourcenode    source-server -sourcedb       ORCL -srcauth        zdmauth -srcarg1        user:oracle ...

  Oracle GoldenGate – Setup & Near Zero-Downtime Migration     Extract Process: ·        Data capture engine ·        Runs on the source system ·        Reads committed changes directly from the Oracle redo logs and archive logs ·        Write logs on local trail files   Replicat Process: ·        Runs on the target system ·        Reads the trail files ·        Applies the changes in target DB   GoldenGate Installation and Basic Setup   # Unzip GoldenGate software unzip V982985-01.zip -d /u01/goldengate   # Run the installer (silent mode) cd /u01/goldengate ./runInstaller -silent -responseFile /tmp/gg_install.rsp   # Create the GoldenGate deployment directory mkdir -p /u01/gg/deployment mkdi...