Skip to Content

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

  

Procedure

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

  

Procedure

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:

/oracle/<DBSID>/121

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

Procedure

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>@?\rdbms\admin\utlu121s.sql

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

SQL>@post_upgrade_checks.sql

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:

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

EXECUTE DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;

Run SBP specific post upgrade scripts as well

Post upgrade activity for bundle patch

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. Mohomad Swalay

    Hi Naveen,

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

    Regards

    Swalay

    (0) 

Leave a Reply