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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
37 | |
10 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 | |
2 | |
2 |