Skip to Content
Author's profile photo Naveen Garg

ORACLE12C Upgrade: Post Upgrade Tasks

Post-Upgrade Steps

1. Updating the SQL*Net Configuration Files


Copy back the content from old sqlnet file as per the parameters set in original file


2. Checking the Symbolic Link for Runtime Oracle Home



Change to the required directory:


cd /oracle/<DBSID>


Check that the following symbolic link exists:


ls -l /oracle/<DBSID>/121


If this link does not exist, create a symbolic link to the new Oracle home:


ln -s /oracle/<DBSID>/12102/oracle/<DBSID>/121

3. Adapting the Environment of the <sapsid>adm user



Log on as user <sapsid>adm and adapt the variables listed below in the .dbenv* files.

Set the ORACLE_HOME environment variable to new Oracle home, for example:


Set ORACLE_BASE to the new Oracle base /oracle/<DBSID>.

Adapt the PATH variable so that it no longer contains references to the old Oracle home.

Check the environment with:

$ env | grep ORACLE_HOME

$ env | grep ORACLE_BASE

$ env | grep PATH (this should no longer contain a reference to 112_64)

Start Listener

Oracle> lsnrctl start

Start DB

SQL> startup

4. Performing Post-Upgrade Checks


Log on as the current Oracle database administrator <ora_dba>.

Open a command prompt and change to the directory <new_Oracle_home>/sap/ora_upgrade/post_ugprade.

From the same directory, start sqlplus.exe and enter the following commands to run the post-upgrade scripts, referring to SAP Note 1915315:

sqlplus / as sysdba


SQL>@post_upgrade_tasks.sql (if you have not already executed this with DBUA)


This provides an overview of the status of the upgraded database.

Gather Oracle optimizer statistics by executing the following commands as the administration user <sapsid>adm:

brconnect -u / -c -f stats -t system_stats

brconnect -u / -c -f stats -t oradict_stats

Note you can perform this step later if required.

Check the Oracle database parameters against SAP Note 1888485 and adjust them if necessary.

Check  SAP Note 1171650 to see whether an automated script for Oracle 12c is already available. This helps you check whether your SAP system complies with the database parameter recommendations at any given point in time.

Update the Oracle database statistics with BRCONNECT as follows:

brconnect -u / -c -f stats -t all -f collect -p 4

5. Performing Post-Upgrade SBP tasks

Execute in the NEW environment AFTER upgrade:



Run SBP specific post upgrade scripts as well

Post upgrade activity for bundle patch

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Mohomad Swalay
      Mohomad Swalay

      Hi Naveen,

      Appreciated your work, I want to upgrade Oracle to 12C on Server 2008 R2 can your provide me the document how to upgrade the same on Windows Environment.