Posts

Oracle 19c bundle patch update

Install new versions of OPatch and MOPatch by replacing binaries. Actual versions should be included inside the patch so you can just extract them to $ORACLE_HOME. Example of UNIX commands: rm -Rf $ORACLE_HOME/OPatch rm -Rf $ORACLE_HOME/MOPatch unzip -qd $ORACLE_HOME /oracle/stage/SAP_102048_201107_HPUXIA64.zip 'SAP_102048_201107/OPatch/*' unzip -qd $ORACLE_HOME /oracle/stage/SAP_102048_201107_HPUXIA64.zip 'SAP_102048_201107/MOPatch/*' Stop all SAP and Oracle processes. Example of UNIX commands: stopsap all lsnrctl stop Installation steps Install SAP bundle patch with MOPatch tool. Example of UNIX commands: cd /oracle/stage /bin/sh $ORACLE_HOME/MOPatch/mopatch.sh -v -s SAP_102048_201107_HPUXIA64.zip Startup database by running following SQL command: startup Execute SQL script catsbp.sql which was delivered with database binaries by running following SQL command: @?/sapbundle/SAP_102048_201107/catsbp.sql Run catbundle.sql. While executing this step “_*_SPARE_PARAMETER” p...
Post a Comment
Read more

Oracle 12c to 19c Upgrade

In this article I will demonstrate an overview on manually upgrading Oracle database from 12.2.0.1 to 19.3.0.0 on Oracle Linux 7 64bit platform. As the source database version is 12.2.0.1, we can go for a direct upgrade to 19c. Below Oracle versions can be directly upgraded to 19c.  Refer this document 11.2.0.4 12.1.0.2 12.2.0.1 18c Below is the high level steps: Installing Oracle 19.3.0.0 binaries Executing the preupgrade jar tool Performing the preupgrade actions Backing up the database / Create a guaranteed restore point Upgrade the database Perform the postupgrade actions Environment Details: Source Hostname: new12c Database version: 12.2.0.1 Database Name: dev12c ORACLE_HOME: /u01/app/oracle/product/12.2.0/db_1 Target Hostname: new12c Databaes Version: 19.3.0.0 Database name: dev12c ORACLE_HOME: /u01/app/oracle/product/19.3.0/dbhome_1 1. Installing Oracle 19c binaries. I have already completed the installation of 19c, Refer  here  for step by...
Post a Comment
Read more