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
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:
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:
Then start listener. Example of UNIX command:
Test DB connection with following UNIX command:
Start SAP wit following UNIX command: