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” parameters MUST NOT be set. Example of SQL command:

@?/rdbms/admin/catbundle.sql psu apply

Run utlrp.sql.

@?/rdbms/admin/utlrp.sql psu apply

If any issues are detected during compilation try to resolve them and rerun the script afterwards.

Run compilation precheck script by running following SQL command:

@?/cpu/view_recompile/recompile_precheck_jan2008cpu.sql

Start database in UPGRADE mode by executing following commands:

shutdown immediate
startup upgrade

Execute recompile script by running following SQL command:

@?/cpu/view_recompile/view_recompile_jan2008cpu.sql

Startup database in NORMAL mode by running following commands:

shutdown immediate
startup

Run utlrp.sql script one more time by running following SQL commands:

@?/rdbms/admin/utlrp.sql psu apply

Run catsbp.sql script one more time by running following SQL command:

@?/sapbundle/SAP_102048_201107/catsbp.sql

Now you should see all steps in “COMPLETED” status.

Post-installation activities

Relink the database binaries with following UNIX command:

$ORACLE_HOME/bin/relink all

Start database by executing following SQL command:

startup

Then start listener. Example of UNIX command:

lsnrctl start

Test DB connection with following UNIX command:

R3trans -d

Start SAP wit following UNIX command:

startsap all