ORACLE UPGRADE STEPS FROM 11g TO 12c FOR SAP SYSTEMS ON LINUX- PART II
Document creation date : 10th OCT 2015 | 09:30 AM INDIA
Document Part : 2nd
Document Author : Gaurav Rana
Referred SAP Guide : Database Upgrade Guide to Oracle database 12c Release 1 (12.1.0.2 ) UNIX
Referred SAP NOTES : 1. NOTE : 1914631 - Starting point for info about oracle 12c .
2. NOTE : 1915317-Migrating Software owner to 'oracle'
3. NOTE : 1915323 - OS User Concept for database release 12c.
4.NOTE : 819829 - Oracle Instant Client Installation and Configuration on Unix
Document in continuation : SAP ORACLE UPGRADE STEPS FROM 11g TO 12c FOR SAP SYSTEMS ON LINUX
Select Upgrade Oracle Database & proceed further.
During the Pre - upgrade activities i got warning related with invalid objects exists.
Troubleshooting for the issue (INVALID OBJECTS EXISTS :
You can find the invalid objects, package body by execution of script pre_upgrade_checks.sql or with SQL query SELECT OBJECT_NAME FROM DBA_OBJECTS WHERE STATUS = 'INVALID';
Resolution : To recompile invalid objects use SAP Transaction SE14 to reactive the views into database.In addition consider SAP Note 648203 - Database objects with status INVALID & suggests to consider SAP Note 1598594 - Br*Tools configurations for Oracle Installation using user "oracle" for successful generation of stats before the procedure at OS level.
You can Gather stats by opting Gather stats before upgrade,but recommends to check the proper database connectives,executions of database tools without any issue through new database software owner 'oracle' (Consider SAP Note 1598594 - Br*Tools configurations for Oracle Installation using user "oracle" ) & re verify the BR*tools configurations before the upgrade.
Deselect the EM database express from the Management Options
Do not select any options under Move database files.
Opt to migrate the LISTENER from source Oracle Home.
Recommends to have complete backup of the system for which we're going to perform the upgrade to avoid any type of issues during the upgrade in case of failures.I've my own backup strategy to choose.
POST UPGRADE STEPS
1.SQL*Net Configuration Files Update
Check for the following entries under tnsnames.ora file at <ORACLE_HOME>/network/admin or copy the tnsnames.ora,listener.ora files from the old ORACLE_HOME to verify or amend as per below if required.(If changes are already reflected with old tnsnames.ora & listener.ora files,then no need to amend.)
TNSNAMES.ORA File entries :
LISTENER.ORA file entries : Check for parameters SID_LIST_LISTENER & ADR_BASE_LISTENER are maintained under the file .
NOTE : ORACLE_HOME should be set for <NEW_ORACLE_HOME> (/oracle/<SID>/12102)
SYMBOLIC LINK FOR RUNTIME ORACLE HOME
STEPS :
1.Change to the directory cd /oracle/<DBSID>
2.Check for symbolic link with command ls -l /oracle/<DBSID>/121
3.If links not exists issue command ln -s /oracle/<DBSID>/12102 /oracle/<DBSID>/121
ENVIRONMENT OF <sapsid>adm & ora<dbsid> USER
We need to make environment variables permanent changes under profiles .dbenv_hostname.csh,.dbenv_hostname.sh & .dbenv.csh or .dbenv.shwith updated values of parameters ORACLE_HOME,ORACLE_BASE,PATH & oracle client.
You could check the variable values by following commands
env | grep ORACLE_HOME Result for the command should be ORACLE_HOME=/oracle/<SID>/12102
env | grep ORACLE_BASE Result for the command ORACLE_BASE=/oracle/<SID>
env | grep PATH Result for the command
PATH=/oracle/<SID>/12102/bin:/usr/lib64/qt-3.3/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/sap/<SID>/SYS/exe/uc/linuxx86_64:/usr/sap/<SID>/SYS/exe/run:/home/<sapsid>adm:.
MODULEPATH=/usr/share/Modules/modulefiles:/etc/modulefiles
RSEC_SSFS_DATAPATH=/usr/sap/<SID>/SYS/global/security/rsecssfs/data
RSEC_SSFS_KEYPATH=/usr/sap/<SID>/SYS/global/security/rsecssfs/key
LD_LIBRARY_PATH=/usr/sap/<SID>/SYS/exe/run:/usr/sap/<SID>/SYS/exe/uc/linuxx86_64:/oracle/client/12x/instantclient
NOTE : PATH should not contain any reference to 112_64
STARTING THE DATABASE LISTENER & DATABASE
1.Logon with new database software owner 'oracle' & start the listener with command lsnrctl start .
2.After successful startup of listener start the database with SQL command 'startup'
POST UPGRADE CHECKS
Refer SAP Note : 1915315 to execute the scripts utlu121s.sql, post_upgrade_tasks.sql & post_upgrade_checks.sql from the location <new_oracle_home>/sap/ora_upgrade/post_upgrade
POST UPGRADE TASKS
1.Gathering of Oracle optimizer stats as admin user <sapsid>adm :
brconnect -u / -c -f stats -t system_stats
brconnect -u / -c -f stats -t oradict_stats
2.Update database stats
brconnect -u / -c -f stats -t all -f collect -p 4
UPDATE OF ORACLE INSTANT CLIENT
After upgrade to 12c,recommends to install oracle client supported for Oracle 12c. Refer SAP Note 819829 - Oracle Instant Client Installation and Configuration on Unix or best to follow steps from Upgrade Guide to 12c .
Steps :
1.# mkdir -p /oracle/client/12x
2.# cd /oracle/client/12x
3.# Mount Oracle client DVD 12.1.0.2 and unzip the client software :
SAPCAR -xvf <client DVD>/OCL<AS per OS>/OCL12164.SAR
4.Create symbolic links
cd /oracle/client/12x
ln -s instantclient_12102 instantclient
5.Symbolic link for BR*Tools 7.40
# cd /oracle/client
# mv 11x_64 11x_64_save
6.Create symbolic link
# ln -s /oracle/client/12x /oracle/client/11x_64
UPDATE OF SAP KERNEL
Refer SAP Note 1716826 for supported SAP Kernel 7.21EXT & for SAP 7.41 downward compatible kernel refer Note 1994690 .
STARTING OF SAP
After completion of the upgrade steps it's time to start the SAP System
Steps to start the SAP
1.Logon with admin user <sapsid>adm
su - <sid>adm
> R3tarns -d
NOTE : If any issue persists refer trans.log file from the system to rectify (Sometimes issue could be as of non supported kernel usage with 12c.
On successful startup of sap (with command startsap r3) you could check the upgrade status from SAP System Status.
Thanks folks for referring the document & i hope the document will be helpful for other SCN members.Request experts to help me to make this document more responsive for up gradation of database from 11g to 12c.
Best Regards,
Gaurav Rana
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
13 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
2 | |
2 |