Skip to main content

Posts

Featured

Upgrading Oracle Database 19.3 to 19.9

  Let us look at how to Upgrade Oracle 19.3 to 19.9 Database on. Description:- Below are the step-by-step method of upgrading Oracle Database Home from 19.3 to 19.9 on a latest Linux OS. Below are some of the prerequisites: 1. OPatch utility version should be 12.2.0.1.19 or later to apply this patch. If Opatch is lower version , then need to upgrade Opatch before proceeding for DB Upgrade. 2. DB home mount point should have atleast 6GB of free space. Step 1: Verify existing OPatch version. /opt/oracle/product/19.3.0/db_1/OPatch $ ./opatch version OPatch Version: 12.2.0.1.17 OPatch succeeded. Step 2: Install OPatch utility “6880880”: as the required OPatch(12.2.0.1.19 or later ) is not available in the above step. • Backup the Old OPatch utility $ cd $ORACLE_HOME $ mv OPatch/ OPatch_backup After this step there won’t be any OPatch folder present in $ORACLE_HOME. Step 3: Download the patch file (p6880880_190000_Linux-x86-64.zip ) from Oracle support site and copy it in ORACLE_HOME

Latest Posts

Move UNDO Tablespace from one location to another due to a mount point space constraint.

Checkpoints Due to MTTR - Automatic CKPT Tuning

Create SQL plan baseline to fix an optimal execution plan

Oracle 12cR2 : Optimizer Statistics Advisor