Exadata Simulation on VMWare Part-1

Hi Guys,

After long time blogging new post, this time we will see how to simulate Exadata environment in vmware.

Note :

This is for learning purpose and a simulation to practice the commands but the actual performance and other features can only be experienced on real exadata machines.

My environment going to be:

Storage cell servers:

1. Exacel01.hussain.net = 192.168.0.130 (Public)

                                                    10.0.0.100 (Private)

     2. Exacel02.hussain.net = 192.168.0.131 (Public)                                                                                                    10.0.0.101(Private)

Database Compute nodes:

1. Exadb01.hussain.net = 192.168.0.133 (Public)                                                                                          10.0.0.50 (Private)

     2. Exadb02.hussain.net = 192.168.0.134 (Public)                                                                                                   10.0.0.51 (Private)

Virtual ip’s:

192.168.0.152 = exadb01-vip.hussain.net

192.168.0.153= exadb02-vip.hussain.net

Scan ip’s:

Exa-scan.hussain.net =   192.168.0.163

                                             192.168.0.164

                                             192.168.0.165

Operating system: Oracle Enterprise Linux 5.8

Exadata storage software version: 11.2.3.2.1 and zip file is V36290-01.zip (Download from oracle edelivery)

Grid and Database version : 11.2.0.3

Now, will create a VM and will clone the same for the rest of three servers.

Please follow below screenshots and install OS OEL 5.8

After rebooting system, login into the system using root credentials.

And setup network ipaddress, install VMware tools.

In my case: Ip address 192.168.0.130 (Public) and 10.0.0.100 (Private)

Configure yum repository, actually it’s not needed for cell server, but I’m cloning the same server for database nodes right where I require yum repository to install database related rpm.

Update the /etc/hosts file with below information.

Update the below configuration files with specified parameter values.

vi /etc/sysctl.conf

fs.file-max = 655360

=============================================

vi /etc/security/limits.conf

* soft nofile 655360

* hard nofile 655360

==============================================

vi /etc/grub.conf

default=1

==============================================

vi /etc/bashrc

export DISPLAY=:0

===============================================

Vi ~/.rpmmacros

%_query_all_fmt %%{name}-%%{version}-%%{release}

================================================

mkdir /var/log/oracle

chmod 775 /var/log/oracle

================================================

Copy the Exadata storage software to /stage directory and extract it.

Now install JDK and cell software rpm which we extracted and restart the server.

Create the soft links for the extra added disks to use as celldisk.

fdisk -l 2>/dev/null |grep ‘B,’

mkdir -p /opt/oracle/cell11.2.3.2.1_LINUX.X64_130109/disks/raw

cd /opt/oracle/cell11.2.3.2.1_LINUX.X64_130109/disks/raw

ln -s /dev/sdb exacel01_DISK01

ln -s /dev/sdc exacel01_DISK02

ln -s /dev/sdd exacel01_DISK03

ln -s /dev/sde exacel01_DISK04

ln -s /dev/sdf exacel01_FLASH01

ln -s /dev/sdg exacel01_FLASH02

Check the services and we should have to configure cell(in my case) with eth1 ipaddress i.e 10.0.0.100.

Check the physical disk and Lun

By using celldisk create the griddisk and repeat the whole activity for exacel02 server as well, as we are going to have two Exadata storage servers.

And these grid disks are used to configure the diskgroups through ASM from database compute nodes.

In next post, will see how to install and configure Oracle Grid Infrastructure and RDBMS software.

Happy Learning,

Firoz K. Hussain.

Oracle ACE Associate.