ORACLE12C Upgrade: Post Upgrade Tasks
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:
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)
Oracle> lsnrctl start
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