Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
Showing results for 
Search instead for 
Did you mean: 

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



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



SBP 201503 for Linux x86-64

Bundle patches

Executing Pre-Installation Instructions

Set environment variable s:


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 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:


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/ -v -s SAP12102P_1503-20012300.ZIP

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

SQL> Startup


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


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

sqlplus / as sysdba


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 <<====


1. Review results of the pre-upgrade checks:


2. Execute in the SOURCE environment BEFORE upgrade:


3.Execute in the NEW environment AFTER upgrade:




Pre-Upgrade Checks in SID Completed.


Pre ugrade tasks

Execute in the SOURCE environment BEFORE upgrade:


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

1 Comment
Labels in this area