Select Page

Upgrading from Oracle 11g to 19c: What You Need to Know

Author: Zane Warton | | October 11, 2023

Oracle 11g reached the end of its Premier Support on December 31, 2021. This means if you are still running Oracle Database 11g, it is now crucial to upgrade to a supported version like 19c.

Why Upgrade from Oracle 11g Now?

Here are some key reasons you should upgrade from Oracle 11g:

  • Security vulnerabilities: Oracle 11g will no longer receive regular security patches and fixes, leaving your system vulnerable to hackers.
  • Lack of new features: By upgrading to 19c, you gain access to improved performance, scalability, and new capabilities not present in 11g.
  • Avoid compliance issues: Many regulations require keeping systems updated. Running 11g may lead to audit issues.
  • Limited support: Upgrading provides full access to Oracle bug fixes, patches, and other support.
  • Cost savings: Maintaining outdated systems gets more expensive over time. Upgrading can reduce maintenance costs.
  • Cloud enablement: 19c makes it easier to move Oracle databases to the cloud when you are ready.

Upgrade Path from Oracle 11g to 19c

If your Oracle database uses version, you can skip this step, as you have a direct upgrade path to 19c. Otherwise, you need to upgrade to either, or one of the terminal 12c releases, Oracle Database 12c release 1, or You can use Oracle’s in-place upgrade utility for this process.

After this, you can upgrade directly to 19c, which doesn’t reach end of extended support until at least April 2027.

Preparing for the Oracle 11g Upgrade

Here are some tips to help you execute a smooth Oracle database upgrade.

  • Assess existing hardware and infrastructure for compatibility with 19c.
  • Review licensing and support costs for newer versions.
  • Test upgrades thoroughly in staging environments before production.
  • Develop a backup/rollback strategy in case issues arise.
  • Check application compatibility and make any needed changes beforehand.
  • Validate data integrity and performance post-upgrade.
  • Leverage an experienced Oracle Partner that has handled database upgrades and migrations for 100s of customers.

The upgrade from 11g to 19c enables you to modernize your Oracle databases with the latest features and security. Get our guide “How to Handle Oracle 11g, 12c, and 18c End of Life” to learn more about this process.

How to Solve the Oracle Error ORA-12154: TNS:could not resolve the connect identifier specified

The “ORA-12154: TNS Oracle error message is very common for database administrators. Learn how to diagnose & resolve this common issue here today.

Vijay Muthu | February 4, 2021

Data Types: The Importance of Choosing the Correct Data Type

Most DBAs have struggled with the pros and cons of choosing one data type over another. This blog post discusses different situations.

Craig Mullins | October 11, 2017

How to Recover a Table from an Oracle 12c RMAN Backup

Our database experts explain how to recover and restore a table from an Oracle 12c RMAN Backup with this step-by-step blog. Read more.

Megan Elphingstone | February 2, 2017

Subscribe to Our Blog

Never miss a post! Stay up to date with the latest database, application and analytics tips and news. Delivered in a handy bi-weekly update straight to your inbox. You can unsubscribe at any time.

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.


Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.