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: 

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

1 Comment
Labels in this area