ORACLE12C Upgrade: Preupgrade steps

[naveegarg]

ORACLE 12C Pre Upgrade steps

1.0  Extracting Oracle Software

1. mkdir -p /oracle/stage/12102

chmod 755 /oracle/stage/12102

2. To upgrade a single instance database on the file system, you only need to extract the database software that is contained in the first 2 SAR  files OR112164.SAR and OR212164.SAR

Move these to location stage

2 Installation of Oracle Database Software

2.1 Backing Up the Central Oracle Inventory

oracle> more /etc/oraInst.loc

inventory_loc=/opt/oracle/oraInventory

inst_group=dba

2.2 Check and Update the SAP RUNINSTALLER Scripts if required

Install database

Call RUNISTALLER and follow the instructions as per the screens you are getting

Check SAP Note 1914631 to find a cross-reference to the current SAP Note with the list of required patches to be installed

oracle> unzip -z SAP12102P_1503-20012300.ZIP

Archive:

SAP12102P_1503-20012300.ZIP

SBP 12.1.0.2.2 201503 for Linux x86-64

Bundle patches

Executing Pre-Installation Instructions

Set environment variable s:

DISPLAY

OHRDBMS = /oracle/SID/121

IHRDBMS= /oracle/SID/12102

Unless otherwise stated, you can execute the following pre-installation instructions before you shut down the
database applications or the database instances.

1. Download file SAP12102P_1503-20012300.ZIP (this SBP) to the database host.
2. If required, update the OPatch and MOPatch utilities to OPatch version 12.1.0.1.6 and MOPatch
   version 2.1.20

   Extract OPatch and MOPatch and install them in the Oracle Home:

unzip -qd $IHRDBMS/sapbundle SAP12102P_1503-20012300.ZIP 'SBP_121022_201503/OPatch/*'

mv $IHRDBMS/OPatch $IHRDBMS/OPatch-pre-SBP_121022_201503

mv $IHRDBMS/sapbundle/SBP_121022_201503/OPatch $IHRDBMS/OPatch

unzip -qd $IHRDBMS/sapbundle SAP12102P_1503-20012300.ZIP 'SBP_121022_201503/MOPatch/*'

test -d $IHRDBMS/MOPatch && mv $IHRDBMS/MOPatch $IHRDBMS/MOPatch-pre-SBP_121022_201503

mv $IHRDBMS/sapbundle/SBP_121022_201503/MOPatch $IHRDBMS/MOPatch

mv $IHRDBMS/sapbundle/SBP_121022_201503/MOPatch $IHRDBMS/MOPatch

Installing the SAP Bundle Patch

Follow the steps below.

1. Stop all database applications, in particular all SAP applications.
2. Shut down the database instances, the listeners, and other processes running from the Oracle Home.
3. After having shut down all database processes as described in the previous step, use the fuser OS command to check
   for stale SQL*Plus sessions:

$SBPFUSER $IHRDBMS/bin/oracle

If that command reports running processes, these are stale SQL*Plus sessions, which you can safely terminate with the kill command.

Install the SAP Bundle Patch as follows:

env ORACLE_HOME=$IHRDBMS $IHRDBMS/MOPatch/mopatch.sh -v -s SAP12102P_1503-20012300.ZIP

Start up the database instances, the listener, and other processes running from the Oracle Home

SQL> Startup

Listener

oracle> lsnrctl start LISTENER

2.4 Running the Pre-Upgrade Scripts

Check that the environment variables ORACLE_HOME and ORACLE_SID are set. For user oracle, you can set the environment with oraenv (sh
shell) or coraenv (csh shell). Make sure that ORACLE_HOMEis set to the value of the current Oracle home, <old_Oracle_home>.

Change to the correct directory by entering the relevant command:

cd /oracle/<DBSID>/12102/sap/ora_upgrade/pre_upgrade

Execute the following commands to perform pre-upgrade tasks, which can improve the performance of the upgrade process:

sqlplus / as sysdba

SQL>@pre_upgrade_tasks.sql

Execute the following commands to check the pre-upgrade status of your database:

sqlplus / as sysdba

SQL>@pre_upgrade_checks.sql

Check the results of pre_upgrade_checks.sql and take actions as suggested in the log.

Below were the actions suggested by run of : pre_upgrade_checks.sql

      ************************************************************

      ************************************************************

                ====>> PRE-UPGRADE RESULTS for SID <<====

ACTIONS REQUIRED:

1. Review results of the pre-upgrade checks:

/oracle/cfgtoollogs/SID/preupgrade/preupgrade.log

2. Execute in the SOURCE environment BEFORE upgrade:

/oracle/cfgtoollogs/SID/preupgrade/preupgrade_fixups.sql

3.Execute in the NEW environment AFTER upgrade:

/oracle/cfgtoollogs/SID/preupgrade/postupgrade_fixups.sql

  ************************************************************

***************************************************************************

Pre-Upgrade Checks in SID Completed.

*******************************************************************

Pre ugrade tasks

Execute in the SOURCE environment BEFORE upgrade:

/oracle/cfgtoollogs/SID/preupgrade/preupgrade_fixups.sql

Now you are done with preupgrade tasks on source Database and you can proceed to upgrade the Database to ORACLE12C