Skip to Content
Technical Articles

Oracle 19c database upgrade of SAP system

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/68ef72fdd9314bd2b9964652bb279f31.html

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

6 Comments
You must be Logged on to comment or reply to a post.
  • Hi.

     

    Nice Blog.

    A small update regarding the SBP installation from me. If you stricktly follow the README of the SBP and the official SAP guides/notes there is no need to set ORACLE_HOME(s) additionally and you can install the SBP with one single command (in case of single instance).

  • Dear Pratap,

    Thanks, we have seen your post on blog. which is very nice. we are also trying to upgrade Oracle 12.2.0.1 to 19.0.0.1.we followed all your steps. but now when we start dbua upgrading from oracle user getting an error, which is attached in here

    db-12-19.png

    error- ” [DBT-20017] The database PRD is not in a READ/WRITE open mode.”

     

    dbua%20error

    As per some solutions we try to make DB in Read-Write mode but db is already in Read-Write mode also Opened

    OS – Release version as below.

    Operating System: SUSE Linux Enterprise Server 12 SP1

    Please Help us.

    Thanks & Regards,

    Shibaram Nayak./ Kuldeep Patil.

    dbua error

    /
    dbua%20error
    • Hello Shibaram,

      Have you overcome this error?

      Could you describe your path, we have the same probem right now 🙁

      Thank you

      UPDATED:

      Guys, we resolved it.

      What helped us is ORACLE_HOME linked to old home without link in its path (e.g. /oracle/SID/11204 but not /oracle/SID/112_64), also oratab string should contain the same path.

      We restarted DB then, and proceed with dbua successfully.

      good luck!

  • Hello Shibaram,

    Did you able to solve the above issue? if not please check if below points helpful

    1.Please check oratab file and make sure it has source database entry
    2. How did database is started as of now? please start the database with oracle database owner (orasid or oracle)
    3.Start the DBUA with oracle database owner (orasid or oracle) with all environment variables set

     

    Regards

    Pratap

  • Hi Pratap,

     

    Thanks for sharing such a great blog on 19c Upgrade, descriptive and detailed one.

    Wondering if have you come across Migration of Oracle from HPUX to Oracle Linux  (OS Change migration).

    I would be great if you can share, this blog help me to upgrade my Oracle from 18c to 19c

     

    Regards,

    Vivekanand Pandey

    • Hi Vivekanand Narsingh,

       

      If you are planning to perform a migration that involves a change in the Operating system, you should consider using the heterogeneous system copy approach using the Software Provisioning Manager, check our SAP Notes 1738258 or 2568783, to verify what is the most suitable scenario for you.

       

      With regards to the Oracle upgrade from 18c to 19c, check the detailed instructions included in the following URL:

       

      https://help.sap.com/doc/2570419c44414d1e9d83732636ed95e2/19c/en-US/Upgr_Ora_UX_Guide_19c.pdf

       

      Our general SAP Note with access to SAP Guides for Oracle Upgrade is also available in the SAP Note 2540847.

       

      Regards,

      Pedro Ruiz