Upgrade from Oracle Database 11g to 19c (Non-CDB)

                     Upgrading your Oracle database is a crucial task that ensures your system is up-to-date and functioning properly. Oracle Database 19c is the latest version of the database software that offers many new features and improvements over its predecessors. In this blog, we will discuss how to upgrade from Oracle Database 11g to 19c (Non-CDB).

Before starting the upgrade process, it is essential to perform a thorough backup of your existing database. This will help you recover your data in case of any issues during the upgrade process. Once you have backed up your data, you can proceed with the following steps:

Step 1: Pre-Upgrade Tasks

Before upgrading to 19c, you need to perform some pre-upgrade tasks. These tasks include:

Checking the minimum requirements for the Oracle Database 19c installation.

Gathering information about the existing database, such as the version, patch level, and configuration details.

Ensuring that the existing database is compatible with 19c. You can use the pre-upgrade information tool to check for compatibility issues.

Resolving any compatibility issues that may be identified by the pre-upgrade information tool.

Step 2: Install Oracle Database 19c Software

Download and install the Oracle Database 19c software on your server. Ensure that you install the software for the same platform as the existing database.

Step 3: Upgrade the Database

To upgrade the database, follow these steps:

Connect to the existing database as a privileged user.

Start the Database Upgrade Assistant (DBUA) utility.

The DBUA will guide you through the upgrade process, including the upgrade options and parameters.

Once the upgrade process is complete, verify the upgraded database's functionality.

Step 4: Post-Upgrade Tasks

After upgrading to 19c, perform the following post-upgrade tasks:

Run the post-upgrade status tool to verify the upgraded database's status.

Ensure that all the required database parameters are correctly set.

Run the time zone script to update the database's time zone data.

If you are using Oracle Enterprise Manager, ensure that the agent and plug-ins are upgraded to 19c.

In conclusion, upgrading to Oracle Database 19c (Non-CDB) from 11g is a straightforward process that requires careful planning and execution. By following the steps outlined above, you can ensure a successful upgrade and take advantage of the new features and improvements offered by Oracle Database 19c. Remember always to back up your database before making any changes to your system to ensure that your data is secure.

Looking forward to your suggestions.. please feel free to write to me.. Your help would definitely help to improve our blog. Chetan Yadav