Thursday, November 26, 2015

How to Install Oracle Database 11gR2 on Oracle Linux 7 VMware Workstation

We have installed Oracle Linux 7 in previous post. Now we are going to install Oracle database 11gR2 on Oracle Linux 7 for practice purpose.

First we need to install prerequisites for Oracle database 11gR2 on Oracle Linux 7.

Start your Oracle Linux 7 VM and login with the user oracle we have created during installation.

Open Terminal

Run Command. su root
Enter Root Password.
You will be in Shell for root user.

Now we have to update the Oracle Linux repo.

cd /etc/yum.repos.d/

Now run following command.

yum install oracle-rdbms-server-11gR2-preinstall

Press y and hit enter to install. This will take some time to complete. 

You will see following after completion 

Set selinux to permissive as root user.

vi /etc/selinux/config and change enforcing to permissive.

Stop the firewall service by running following command
[root@ol7 oracle]# systemctl disable firewalld

Now we have to create Directories where we have to install Oracle Database 11gR2
Run following commands as root.

mkdir -p /u01/app/oracle/product/11.2.0/db_1
chown -R oracle:oinstall /u01
chmod -R 775 /u01

Note that oracle is the user under which we are going to install database 11gR2. you can change your directory as per your user like "mkdir -p /u01/app/your-user/product/11.2.0/db_1"

Now edit bash profile for oracle user as oracle user.

[oracle@ol7 ~]$ vi .bash_profile

Insert following lines. Note that ol7.mydomain.local is hostname.  change it as your hostname is.

ORACLE_HOSTNAME=ol7.mydomain.local; export ORACLE_HOSTNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME


LD_LIBRARY=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY

Now we are ready to install oracle database 11gR2 on Oracle Linux 7.1

Download Oracle database 11gR2 for Linux x86-64 from Oracle, You need oracle account to download the database software.
If you have support account then you can download I recommend to install 11gR2 on Oracle Linux 7.1.

After Download extract 11gR2 files and you will have a folder named "database"

Open terminal and browse database folder. and run following command to start the installer.

[oracle@ol7 database]$ ./runInstaller

In few moment you will see following.  Enter your email address and password if you have Oracle support account. Click Next

Skip Software updates and Click Next

Select Create and configure a database and Click Next

Select Desktop Class and Click Next

Set Global database name : orcl.mydomain.local
Set Administrative Password: password

Set a strong password as per oracle recommendation. I am going to use "oracle" as we are installing in test environment.

Click Next

Oracle will check minimum requirements for database 11gR2 on target system. I have face 2 warnings. You may fix these warning by installing the missing packages or ignore all as this is just a test environment. I am going to ignore these 2 missing packages as they will not effect installation. Click Ignore all and click Next

Click Install

Setup started.

You may face error like following.

Error in invoking target 'agent nmhs' of makefile '/u01/app/oracle/product/'.
Following is the work around for above error.

In /u01/app/oracle/product/11.2.0/db_1/sysman/lib/
Look for the line $(MK_EMAGENT_NMECTL)
Change it to $(MK_EMAGENT_NMECTL) -lnnz11

Click Retry and setup will continue. After database creation you will see following. Click ok

Run following scripts as root

Click OK after running scripts and you will see

Click Close, We have successfully installed Oracle Database 11gR2 on Oracle Linux 7.1

To Use Default HR schema we have to connect to sqlplus. Open terminal as Oracle user and run following command to connect to database.  First we have to connect as SYSDBA to activate HR User.

[oracle@ol7 ~]$ sqlplus
Enter user-name: sys as sysdba
Enter password: 

we have set the password "oracle" during setup. Enter the password and you will see. 

Now unlock the HR user account and Set the password

 To connect to database with HR user type 

SQL> conn hr/oracle

Run a Simple query to check the schema

  2  FROM employees;

You will see all the columns in Employees table.

SQL> SELECT sysdate


In case you restarted your machine you have to start the database manually. just connect via sqlplus as sys as sysdba and run command as follows and you will see Database mounted

You can use SQL developer or Toad for Oracle instead of sqlplus to play with database. We will configure TOAD and SQL Developer in Next post. 


How to Install Oracle Linux 7 in VMware Workstation

We are going to install Oracle Linux 7 on VMware Workstation 12. Oracle Linux, formerly known as Oracle Enterprise Linux, is a Linux distribution based on Red Hat Enterprise Linux (RHEL).

You can download  Oracle Linux through Oracle's E-delivery service or from a variety of mirror sites, and can be deployed without cost. Commercial technical support is available through Oracle's Oracle Linux Support program.

Lets Start with Installation..................................
Download latest Oracle Linux release from Oracle E-delivery. Current release is Oracle Linux 7 Update-1.

Open VMware Workstation 12 -> File -> New Virtual Machine-> Typical
Click Next

Select Installer DISC image file and browse the path to Oracle Linux 7 .ISO. and Click Next

Enter the name for your Virtual Machine and browse the location where you want to save the Virtual Machine. Click Next

Set the maximum disk size and you can chose either split the virtual disk to store as single file. Click Next

Click Finish

Click on Edit Virtual Machine settings.

Set the Memory to 2GB, Processors as per your hardware recommendations and Network to bridged.

Power on the virtual machine. Select Install Oracle Linux 7.1 and hit Enter.

Select you preferred language and click Continue

Set your date and time zone, Set your Installation media i.e Local Media and click Software selection. Select Server with GUI and select following Add-Ons for Selected environment 

1. Java Platform
2. KDE
3. Compatibility Libraries 

You can chose what ever you want in your environment. I am choosing what ever i need in my environment. Click Done.

Now Click Installation Destination. Click I will configure partitioning and click Done

Select Standard Partition and click + button to dd mount point. I am going to set Mount Point / with capacity 37500 Click Add mount point

Set the File system to ext4

Add Swap Mount point for the rest of disk space and Click Done.

Accept changes.

Click Begin Installation.

Set the root password on next screen. 

Create a User by clicking USER CREATION.  Click done.

You can see Installation Progress. It will take some time to complete. 

Click Reboot to finish the Installation.

Accept the licensing and Click Done. Click Finish Configuration.

Select No, I prefer to register at a later time. Click Forward,  Click No Thanks I'll Connect later and Click Forward

Enter your password to Sign In. Click Sign In

Click Next, Next

Click Start using Oracle Linux Server

Enable Network Wired.

You will see Internet is working if you are connected to a rite bridged network on your physical machine.

That's all, Next we will install Oracle database 11gR2 on Oracle Linux 7.

Cheers :-)