Hello everyone. Today we will learn how to upgrade to Oracle 11g Oracle 12c. let's start.
Here, I am using CentOS 7 64-bit Linux distributions. I assume that you have installed on your system Oracle 11g.
Here, I'll show how to install Oracle 11g my steps.
I choose "Create and configure a database" on Oracle 11g
Then I chose to install Oracle 11g "Decktop Class". If this is a production environment, you must select the "Server Class".
Then you enter the installation of Oracle 11g various paths and password. Here is my own Oracle 11g installation configuration. Make sure you enter the correct password Oracle.
Next, I set as follows Inventory Directory.
Here, I have to show you install Oracle 11g my work done because we want to upgrade to begin 12c.
Let's upgrade to Oracle 11g Oracle 12c it.
You need to download two zip file from this link. Download and unzip the two files into the same directory. File name linuxamd6412cdatabase_1of2.zip & linuxamd6412cdatabase_2of2.zip. After extraction or decompression, it creates a file named database folder.
Note: Before you upgrade to 12c, make sure your CentOS all the necessary software has been installed, and all paths are correctly configured variables, there are other preconditions have been met.
Here are some packages must use the correct version is installed
Search for the correct rpm version on the Internet.
You can also use a plurality of query processing package, then look for the correct version in the output. For example, enter the following command in Terminal:
rpm -q binutils compat-libstdc ++ gcc glibc libaio libgcc libstdc ++ make sysstat unixodbc
Your system must be installed in the following packages (version may be old or new)
gcc-c ++ - 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
You also need unixODBC-2.3.1 or newer version of the driver.
I hope when you install Oracle 11g have created a user called oracle on your CentOS 7. Let us take the oracle user login CentOS. After a user to log on to the oracle CentOS, open a terminal on your CentOS.
Use Terminal to change the working directory and navigate to the directory you extracted two zip files. Enter the following command in the terminal to begin the installation 12c.
If all goes well, you'll see something like the screenshot below, has begun to install 12c.
Then you can choose to skip the update or download the most recent update. If the production server, we recommend that you have to update. I choose here to skip.
Now, choose to upgrade the existing database.
For the language, there have been English. Click Next to continue, or you can add the language according to your needs.
Now select Enterprise Edition. You can choose according to your needs.
Then select the software path to the location, which are self-evident.
For the seventh step, like this using the default option to continue.
In the ninth step, you will see a summary report similar to the following.
If all goes well, you can click on the ninth step of the install to start the installation, enter the tenth step.
Where you may encounter some errors, you need to find solutions to these errors by Google. Problems you may encounter will be a lot, so I did not cover in detail here.
Be patient, step by step down the final it will tell you success. Otherwise, a search on Google to make the necessary actions to resolve the problem. Again, due to an error you might encounter there are many, I can not provide all the details here.
Now, just you need to follow on-screen instructions to configure the Listener.
Database Upgrade Assistant
After configuring the listener, it will start the database upgrade assistant (Database Upgrade Assistant). Select Upgrade Oracle Database.
In the second step, you will find that it shows the location path 11g and the position of the path 12c. At the same time you will find that it directed that from the original Oracle Home Release 11 installed Oracle Home Release 12. Click Next to go to Step Three.
Follow the instructions on the screen to complete the installation.
In the last step, you will see a successful window, where you will see the successful upgrade oracle database.
A word of caution: for your production servers before you upgrade to 12c, make sure that you have tested on other platforms, so you can fix any errors encountered during the upgrade. Never try to know nothing about when to upgrade the production server.