Installing and Configuring Oracle 12c in RHEL/CentOS/Oracle Linux 6.5 – Part II

In our previous article, we’ve shown you how to setup prerequisites for Oracle 12c installation. In this article we will cover installation and configuration of Oracle 12c in RHEL/CentOS/Oracle Linux 6.5, along with some Oracle post installation instructions.

Oracle 12c Installation in Centos

Oracle 12c Installation

Requirements

  1. Installing Prerequisites for Oracle 12c in RHEL/CentOS/Oracle Linux 6.5 – Part I

Installing Oracle 12c Database in CentOS 6.5

1. After extracting, we will get database directory which has 2.6GB in size. So, next we can go-head and install the oracle. Let us start the installation by running runInstaller. Navigate the installer Directory and run the Installer.

# cd database/
# ./runInstaller

Our Installer has been launched here. For every steps we need to move forward by Clicking Next or OK.

Oracle 12c Installer in RHEL

Oracle 12c Installer

Configure Security Updates

2. I’m going to skip this step as I don’t want security updates. Un-check the check box and mark the checkbox that says “Wish to receive security updates via My Oracle Support“.

Oracle Security Updates

Security Updates

Click on Next, you will get a error saying that you’ve not provided and email address click Yes to continue.

Enter Email Address

Enter Email Address

Software Updates

3. While we skiped the email step by default it will choose skip software updates Click next to continue.

Skip Software Updates

Skip Software Updates

Here I have resolved every dependencies but still it says that I have not reached the minimum requirements. Don’t worry, you can move forward to choose Yes to continue.

Oracle Requirement Check

Oracle Requirement Check

Installation Option

4. Next, choose the type of installation, I’m choosing the first option to Create and configure a database.

Oracle Installer type

Oracle Installer type

System Class

5. I’m going to choose Server Class here. If we need to install in any Desktop machines we can choose the above Option as Desktop Class.

System Class Installation

System Class Installation

Grid Installation Options

6. We are going to setup only single instance database installation here. So, select the first option.

Single Instance Database

Single Instance Database

Install Type

7. Choose the Advance install option to get more option while going through Installation steps.

Select Oracle Advance Install

Select Advance Install

Product Languages

8. By Default Language will be chooses as English. If you need to change according to your language, choose from the below list.

Select Oracle Language Type

Select Language Type

Database Edition

9. Time to choose which edition of database installation we looking for. For large scale Productions we can use Enterprise or if we need standard edition or we can choose the options as mentioned there. We need more than 6.5 GB space for Enterprise installation because database Population will grow soon/increase.

Select Oracle Database Edition

Select Database Edition

Installation Location

10. Enter the Oracle base installation location, here all installed configurations files will be stored. Here you need to define the location of oracle installation path, as we created the location in step #12 in the first part of this article.

Select Oracle Installation Location

Select Oracle Installation Location

Creating Inventory

11. For the first time installation, every Inventory files will be created under ‘/u01/app/oralnventory‘ directory. We have created the group oracle for installation. So now the oracle group has permission to access Inventory Directory. Let us choose the Oracle as the Group for Operating system group.

Create Oracle Inventory

Create Inventory

Configuration Type

12. Select the type of database, you want to create. Since, we are using for General purpose, so choosing general from the below options and click Next.

Oracle Configuration Type

Configuration Type

Database identifiers

13. Specify the Global Database name for uniquely identified and un-check the Create as Container database, as here we are not going to create multiple databases.

Database Identifiers

Database Identifiers

Configuration Options

14. In my installation, I have assigned 4GB of Memory to my virtual machine, but this is not enough for Oracle. Here we need to Enable allocate memory automatically for the use of system global Area.

Check the box that says Enable Automatic Memory Management and keep the default allocate memory. If we need some sample schema’s we can check and continue for installation.

Oracle Configuration Options

Configuration Options

Database Storage

15. We need to choose the location to store the database storage. Here I’m going to assign ‘/u01/app/oracle/oradata‘ location to save the databases and Click Next to continue to installer steps.

Define Database Storage

Define Database Storage

Management Options

16. I don’t have a Cloud control manager credentials from oracle, so I have to skip this step.

Management Options

Management Options

Recovery Options

17. If we have to Enable recovery options, then we have to check the Enable Recovery. In real environment these options are Compulsory to setup. Here to enable this option we need to add separate group and we need to define one of the file system location rather than default location where our database save.

Recovery Options

Recovery Options

Schema Passwords

18. We need to define the password for starter database which is all pre-loaded while the installations. Password must contain alphanumeric, upper_case and lower_case. For example, my password is Redhat123. This password we will use in web interface login too.

Set Password

Set Password

Operating system Groups

19. We need to provide system privileges to create database for that we need to choose the oracle group. Choose oracle for every options.

Select Oracle Group

Select Oracle Group

Summary

20. At last we can review every settings before database population. If we need any changes we can edit the settings.

Review Summary

Review Summary

Install Product

21. Installation started to Preparation and copying files. This will take long time to complete according to our Hardware Resource.

Oracle Installation Process

Oracle Installation Process

22. During setup process, it will ask to run two scripts as a root user as shown in the below picture.

Run Configuration Scripts

Run Configuration Scripts

Login into your Oracle Server as root user and switch to ‘/‘ partition and execute below scripts as shown.

# cd /
# ./u01/app/oralnventory/orainstRoot.sh
# ./u01/app/oracle/product/12.1.0/db_1/root.sh

During the script execution process, might it will ask you to enter the full path-name of the local bin directory, just enter the path as shown below and press Enter.

/usr/bin
Script Execution Process

Script Execution Process

23. After successfully execution of above two scripts, we need to move forward by clicking on OK.

Copying Database Files

Copying Database Files

24. After finishing all the above tasks successfully, we will receive the Database Configuration Assistant window with the all the details and it will show you the EM Database Express URL. Click OK to move forward.

https://oracle12c.tecmint.local:5500/em
Database Configuration Assistant

Database Configuration Assistant

If you wish to change the database accounts password, you can use the password management.

Password Management

Password Management

That’s it! We’ve successfully completed Database Configuration, now click Next to continue installation process.

Database Configuration Completed

Database Configuration Completed

Finally Oracle Database installation was successfully completed. Click on Close to quit the Oracle Installer.

Oracle Installation Completed

Oracle Installation Completed

25. After completing the Database installation, now move ahead to do some Post installation configuration. Open file ‘oratab‘ using vi editor.

# vim /etc/oratab

After opening file, search for the the following line.

orcl:/u01/app/oracle/product/12.1.0/db_1:N 

And change the parameter N to Y as shown.

orcl:/u01/app/oracle/product/12.1.0/db_1:Y

Restart the machine to take new changes.

26. After restarting machine, verify that the listener is up and running using ‘lsnrctl status‘ command.

# lsnrctl status
Verify Oracle Listener

Verify Oracle Listener

If it does not start automatically, you will need to start it manually using ‘lsnrctl start‘ command.

# lsnrctl start
Start Oracle Listener

Start Oracle Listener

Note: If the lsnrctl does not start, read the troubleshooting step (mentioned at the end of the article) to get fix the errors if any and try to start the listener.

27. Next login into Oracle database as a Operating system user using sysdba and start-up the database.

# sqlplus / as sysdba
# startup
Connect Oracle Database

Connect Oracle Database

28. Now it’s time to access Oracle Web interface at the following addresses.

https://oracle12.tecmint.local:5500/em

OR

https://192.168.0.100:5500/em

When EM Express prompts you for your username and password, Use to log in as a user with DBA privilege such as SYS or SYSTEM and use the password which we used for Schema password.

Login User = SYSTEM
Password   = Redhat123
Login Oracle Web

Login Oracle Web

29. After login into the Oracle panel, you can see the main interface as Database Home and few screen shot as shown below.

Oracle Database Home

Oracle Database Home

Oracle Memory Management

Oracle Memory Management

Tablespaces

Tablespaces

Performance Hub

Performance Hub

Step: Troubleshooting Oracle

30. If listener does not start, you need to replace the domain name with local IP address 127.0.0.1 in below file.

/u01/app/oracle/product/12.1.0/db_1/network/admin/listener.ora
Troubleshooting Listener

Troubleshooting Listener

That’s it! Finally we’ve successfully completed Oracle 12c installation and configuration in CentOS 6.5. If in-case any errors you get while setting up Oracle database 12c, feel free to drop your comments.

Best Affordable Linux and WordPress Services For Your Business
Outsource Your Linux and WordPress Project and Get it Promptly Completed Remotely and Delivered Online.

If You Appreciate What We Do Here On TecMint, You Should Consider:

  1. Stay Connected to: Twitter | Facebook | Google Plus
  2. Subscribe to our email updates: Sign Up Now
  3. Get your own self-hosted blog with a Free Domain at ($3.45/month).
  4. Become a Supporter - Make a contribution via PayPal
  5. Support us by purchasing our premium books in PDF format.
  6. Support us by taking our online Linux courses

We are thankful for your never ending support.

Babin Lonston

I'm Working as a System Administrator for last 10 year's with 4 years experience with Linux Distributions, fall in love with text based operating systems.

Your name can also be listed here. Got a tip? Submit it here to become an TecMint author.

RedHat RHCE and RHCSA Certification Book
Linux Foundation LFCS and LFCE Certification Preparation Guide

You may also like...

48 Responses

  1. CHETAN LOHAR says:

    I was facing following error,

    “Error in invoking target ‘irman ioracle’ of makefile ‘/u01/app/oracle/product/12.1.0/db_1/rdbms/lib/ins_rdbms.mk’ “

    I resolved this by copying libjavavm12.a to $ORACLE_HOME/llib directory.

    # cp /u01/app/oracle/product/12.1.0/db_1/javavm/jdk/jdk6/lib/libjavavm12.a /u01/app/oracle/product/12.1.0/db_1/lib/

    Hope this will help someone.

    • Ravi Saive says:

      @Chetan,

      Thanks for sharing the tip, hope it will help other users who face similar issue while installing Oracle in CentOS.

  2. SysOwner says:

    The only tutorial helped me.

    Thanks a lot!

  3. vijay says:

    Hello, I want to install oracle db 12c in active passive mode without grid is possible to in RHEL HA

  4. nla says:

    Hello,

    when I reboot the server I have to start the listner and DB manually, how we can start it automatically on boot !

  5. santu debnath says:

    before running ./runInstaller you need to do xhost + from root user

    • Karan Rajpoot says:

      If you logged in as Oracle user, then there is no need to run xhost + command, This is required when you login through root user and then switch the role to oracle user.

  6. Nagaraju says:

    Hi Babin,

    After successful installation of 12c I am not able to access em. Can you suggest how to troubleshoot it..

    Best Regards,
    Nagaraju

    • @Nagaraju,

      1. Please look into listener.ora host entry, Please add the host entry in the /etc/hosts if you don’t have a valid DNS server.
      2. If you have a valid DNS server please check the DNS address under /etc/resolv.conf.
      3. Check your iptables add a rule for web interface or flush it ( iptables -F), Check the lsnrctl status.

  7. Swathyprabhu says:

    Just completed installation of 12c on Oracle linux 7. This webpage (both part1 and part2) is authentic and error free as far as my needs are concerned.

Got something to say? Join the discussion.

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.