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!
cancel
Showing results for 
Search instead for 
Did you mean: 
prathapnaidu09
Participant
Hello,

I am writing this blog, to describe the steps how you upgrade the Oracle database of your SAP system to Oracle Database 19c

 

Preparations



  • Supported upgrade path to 19c?
    To upgrade your database directly to Oracle Database 19c, your source database release must be Oracle 11.2.0.4, Oracle 12.1.0.2 or Oracle 12.2.0.1.


from 12.1.0.1, 11.2.0.3, 11.2.0.2, 11.2.0.1, 11.1, 10.2 or earlier - Direct upgrade is not supported.


Installation of oracle 19c database software


First backup the oracle inventory


 

  1. Log on as Oracle software owner, for eg: oracle or ora<sid>

  2. Install the new Oracle database software into the <ORACLE_HOME_NEW>, for eg: /oracle/SID/19.0.0



  • Set environment variables DISPLAY and DB_SID,

  • then start RUNINSTALLER. For RUNINSTALLER options, check SAP Note 2660017.
    OS> setenv DB_SID <DB_SID>
    OS> setenv DISPLAY <DISPLAY>
    OS> ./RUNINSTALLER







https://help.sap.com/viewer/08baebca0fef470389e4a4ebcb46b879/CURRENT_VERSION/en-US/68ef72fdd9314bd2b...

oracle base usually be : /oracle/SID









Now we will have to apply SAP Bundle Patch to new installed software oracle 19.0.0

(make sure you have downloaded these 3 files from service market place)


First extract SAP19P_XXX.ZIP file and copy Mopatch folder to new oracle home location (/oracle/SID/19.0.0/)



Second update the Opatch:

extract the OPATCH19P_XXX.ZIP file to oracle home (/oracle/SID/19.0.0/)

then Fianlly apply SBP using mopatch



 

 

Oracle 19c database upgrade



  • Run the pre-upgrade scripts

  • Please take backup of the listener configuration files


Login with ora<sid> with 11.2.0.4 oracle home



set the env variables


stop  SAP system

Check oratab entries

start DBUA













 

Post upgrade steps


After the Oracle database upgrade, you need to perform the steps described here.
1. Check oratab entries
2. Check the symbolic link for the runtime Oracle home.
3. Adapt the environment of the <sapsid>adm user (eg: oracle home, client)
4. Update the SQL*Net configuration files
5. Stop the old version listener and start the database listener of 19c
6. Start the database instance (make sure oracle home is pointing to right oracle home)
7. check the database parameters for 19c and implement recommended parameters from sap note 2470718 - Oracle Database Parameter 12.2 / 18c / 19c
8. Update the Oracle Instant Client if required
9. Update BR*Tools executables
10. Update Database Statistics
11. Backup the database
12. R3trans -d, make sure it returns 0000

Finally Start the SAP system

21 Comments
Labels in this area