How to Upgrade Oracle 11g to Orcale 12c

How to Upgrade Oracle 11g to Orcale 12c

Hello everyone. Today we will learn how to Upgrade Oracle 11g to Oracle 12c. Let's get started.

Here, I am using the CentOS 7 64-bit Linux release. I suppose you have installed Oracle 11g on your system.

 

Here I will show you how to install Oracle 11g.

On Oracle 11g, select "Create and configure a database", as shown in.

Then I chose to install Oracle 11g "Decktop Class ". In a production environment, You must select "Server Class ".

Enter the path and password for installing Oracle 11g. The following is my Oracle 11g installation configuration. Make sure that you have entered the correct Oracle password.

Next, configure Inventory Directory as follows.

Here, I have shown you how to install Oracle 11g, because we want to upgrade to 12c.

 

Let's Upgrade Oracle 11g to Oracle 12c.

You need to download two zip files from this link. Download and decompress the two files to the same directory. File Name: linuxamd6412cDatabase_1of2.zip & linuxamd6412cDatabase. After extraction or decompression, it creates a folder named database.

Note: Before upgrading to 12c, make sure that all necessary software packages have been installed on your CentOS, all PATH variables have been correctly configured, and other prerequisites have been met.

The following are some software packages that must be installed in the correct version.

• Binutils
• Compat-libstdc ++
• Gcc
• Glibc
• Libaio
• Libgcc
• Libstdc ++
• Make
• Sysstat
• Unixodbc

Search for the correct rpm version on the Internet.

You can also use one query to process multiple software packages, and then find the correct version in the output. For example, enter the following command in the terminal:

1. rpm -q binutils compat-libstdc++gcc glibc libaio libgcc libstdc++make sysstat unixodbc

The following software packages (versions may be new or old) must be installed in your system)

• Binutils-2.23.52.0.1-12.el7.x86_64
• Compat-libcap1-1.10-3.el7.x86_64
• Gcc-4.8.2-3.el7.x86_64
• Gcc-c ++-4.8.2-3. el7.x86 _ 64
• Glibc-2.17-36.el7.i686
• Glibc-2.17-36.el7.x86_64
• Glibc-devel-2.17-36.el7.i686
• Glibc-devel-2.17-36.el7.x86_64
• Ksh
• Libaio-0.3.109-9.el7.i686
• Libaio-0.3.109-9.el7.x86_64
• Libaio-devel-0.3.109-9.el7.i686
• Libaio-devel-0.3.109-9.el7.x86_64
• Libgcc-4.8.2-3.el7.i686
• Libgcc-4.8.2-3.el7.x86_64
• Libstdc ++-4.8.2-3. el7.i686
• Libstdc ++-4.8.2-3. el7.x86 _ 64
• Libstdc +-devel-4.8.2-3.el7.i686
• Libstdc +-devel-4.8.2-3.el7.x86_64
• LibXi-1.7.2-1.el7.i686
• LibXi-1.7.2-1.el7.x86_64
• LibXtst-1.2.2-1.el7.i686
• LibXtst-1.2.2-1.el7.x86_64
• Make-3.82-19.el7.x86_64
• Sysstat-10.1.5-1.el7.x86_64

You also need a unixODBC-2.3.1 or a newer version of the driver.

I hope that you have created a user named Oracle on your CentOS 7 when installing oracle 11g. Let's log on to CentOS with oracle. After logging on to CentOS as an oracle user, open a terminal on your CentOS.

Use the terminal to change the working directory and navigate to the directory where you extract the two zip files. Enter the following command in the terminal to install 12c.

1. ./runInstaller

If everything goes well, you will see 12c installation has started, similar to the following.

You can skip the update or download the latest update. If it is a production server, we recommend that you update it. Skip this step.

Now, select upgrade existing database.

For the language, English is already available. Click Next to continue, or you can add a language as needed.

Select Enterprise Edition. You can choose based on your needs.

Then select the software path, which is self-evident.

For step 7, use the default option as follows to continue the next step.

In step 9, you will see a summary report similar to the following.

If everything works, you can click install in Step 9 to start installation and enter step 10.

You may encounter some errors. You need to use Google to find a solution to these errors. You may encounter many problems, so I did not detail them here.

Be patient. It will tell you the success step by step. Otherwise, perform necessary operations on Google search to solve the problem. Once again, I cannot provide all the details here because you may encounter many errors.

Now, you only need to configure the listener according to the following instructions.

 

Database Upgrade Assistant

After the listener is configured, it starts the Database Upgrade Assistant ). Select Upgrade Oracle Database.

In step 2, you will find that it displays the 11g path and 12c path. At the same time, you will also find it indicates to install Oracle Home Release 12 from the original Oracle Home Release 11. Click Next To step 3.

Follow the instructions on the screen to complete the installation.

In the last step, you will see a success window, where you will see that the oracle database has been successfully upgraded.

One piece of advice: Before upgrading your production server to 12c, make sure you have tested it on other platforms so that you can fix all the errors encountered during the upgrade. Never upgrade the production server when you know nothing about it.