Archive

Archive for the ‘VMware’ Category

Oracle 10g RAC on ESXi3 using SLES9 SP5 – Part 6

February 14th, 2009 Comments off

Linux OS Parameters

Here is the list of the required parameters for clusterware and oracle database 10g

Parameter Value File
semmsl semmns semopm semmni 25 032 000 100 128 /proc/sys/kernel/sem
shmmax The minimum of the following (4 GB – 1 byte), or half the size of physical memory (in bytes), whichever is lower. /proc/sys/kernel/shmmax
shmmni 4096 /proc/sys/kernel/shmmni
shmall 2097152 /proc/sys/kernel/shmall
file-max 65536 /proc/sys/fs/file-max
ip_local_port_range Minimum: 1024 Maximum: 65000 /proc/sys/net/ipv4/ip_local_port_range
rmem_default 262144 /proc/sys/net/core/rmem_default
rmem_max 4194304 /proc/sys/net/core/rmem_max
wmem_default 262144 /proc/sys/net/core/wmem_default
wmem_max 4194304 /proc/sys/net/core/wmem_max

In order to check the values in your system use the sysctl command.
You will probably get the following results from the default kernel configuration:

Read more…

Oracle 10g RAC on ESXi3 using SLES9 SP5 – Part 5

February 14th, 2009 Comments off

Configuring SSH access for the oracle user for Remote installation

Login as the oracle user and generate keys for ssh authentication without passwords.
I usually check the /etc/ssh/sshd_config file to make sure I have the proper configuration in place.
I usually disable the DNS check since it causes the ssh to timeout.

UseDNS no

Now I will generate the ssh keys with no password

Read more…

Oracle 10g RAC on ESXi3 using SLES9 SP5 – Part 4

February 13th, 2009 Comments off

Required UNIX groups and users. User environment and Shell Limits

1. Creating an oracle user, a dba and an oinstall group on each node.

# groupadd -g 500 oinstall
# groupadd -g 501 dba
# useradd -u 500 -d /home/oracle -g oinstall -G dba -m -s /bin/bash oracle

Reset the oracle user password to something you want

# passwd oracle
Changing password for oracle.
New password:
Re-enter new password:
Password changed

Check that the nobody user exists:

#grep nobody /etc/ passwd [I had to add space between the / and passwd since mod_security of this server would not allow me to post.. ]

Read more…

Categories: Database, ESX, ESXi, Linux, Oracle, SLES, VMware Tags: , , , ,

Oracle 10g RAC on ESXi3 using SLES9 SP5 – Part 3

February 13th, 2009 Comments off

Hardware and package requirements

1. Hardware

Here is a small list of hardware requirements that we have satisfied by creating our virtual machine as it is:
at least 1 GB of RAM
minimum of 1GB of swap space
/tmp directory is said to be minimum 400MB which we have spare in our / mount point

2. package requirements

Since time will be the most important variable for the Oracle RAC it is a must to have all nodes up to date using NTP deamon.
In my case I use a local ntp server and I configure the /etc/ntp.conf to poll that server on boot.
In addition to this I have added a cronjob as root to restart the xntpd service every hour at the twentieth minute, to make sure every node will be generally up to date even If I perform snaphosts and reverts forgetting about the time.

Read more…

Categories: Database, ESX, ESXi, Linux, Oracle, SLES, VMware Tags: , , , ,

Oracle 10g RAC on ESXi3 using SLES9 SP5 – Part 2

February 13th, 2009 Comments off

Network and hostname configuration of the nodes

Once you have converted the the first virtual machine that you have installed, you have a mirrored copy of it.
This means that the hostnames of the two machines will be identical and this has to be fixed.

Each Node must have at least 2 network adapters: one for the public and one for the private interconnect. In addition , the interface names associated with the network adapters for each network must be the same on all nodes.

For the public network each adapter must support TCP/IP. For the private network, the interconnect must support UDP for Linux. Gigabit ethernet or an equivalent is recommended.

Read more…

Categories: Database, ESX, ESXi, Linux, Oracle, SLES, VMware Tags: , , , ,

Oracle 10g RAC on ESXi3 using SLES9 SP5 – Part 1

January 21st, 2009 1 comment

Oracle 10g Real Application Cluster on SuSE Linux Enterprise Server virtualized with VMware ESXi 3

The purpose of this article is to help people deploy successfully Oracle Real Application Cluster consisting of two nodes
on a VMware ESXi host. The Operating system chosen for the Nodes is SLES9 x64 SP5.
In Part 1 of this article I will provide the steps to install the operating system for the two Nodes.

1. Pre-requisites

Read more…

Categories: Database, ESX, ESXi, Linux, Oracle, SLES, VMware Tags: , , , ,