Oracle bundle patch (SAP_102048_201107_HPUXIA64)

Pre-installation steps

Check for any uncompiled or wrongly compiled objects that might cause problems during installation. Look at article Compilation of objects to see how to do this.

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 LISTENER_YRS

wiki sap oracle bundle patch SAP_102048_201107_HPUXIA64
wiki sap oracle bundle patch SAP_102048_201107_HPUXIA64

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:

startupwiki sap oracle bundle patch SAP_102048_201107_HPUXIA64

Execute SQL script catsbp.sql which was delivered with database binaries by running following SQL command:

@?/sapbundle/SAP_102048_201107/catsbp.sqlwiki sap oracle bundle patch SAP_102048_201107_HPUXIA64

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 applywiki sap oracle bundle patch SAP_102048_201107_HPUXIA64

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.sqlwiki sap oracle bundle patch SAP_102048_201107_HPUXIA64

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.sqlwiki sap oracle bundle patch SAP_102048_201107_HPUXIA64

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 applywiki sap oracle bundle patch SAP_102048_201107_HPUXIA64

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

@?/sapbundle/SAP_102048_201107/catsbp.sqlwiki sap oracle bundle patch SAP_102048_201107_HPUXIA64

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:

startupwiki sap oracle bundle patch SAP_102048_201107_HPUXIA64

Then start listener. Example of UNIX command:

lsnrctl start LISTENER_YRSwiki sap oracle bundle patch SAP_102048_201107_HPUXIA64

Test DB connection with following UNIX command:

R3trans -dwiki sap oracle bundle patch SAP_102048_201107_HPUXIA64

Start SAP wit following UNIX command:

startsap allwiki sap oracle bundle patch SAP_102048_201107_HPUXIA64

Leave a Reply