Monday, March 5, 2007

Oracle Unbreakable Enterprise Linux and Oracle Database 10g : 02 System Requirements

Click here to read the previous step.

Let's continue setting up the system requirement for our Oracle Database 10g installation.
First of all we have to edit the /etc/sysctl.conf file, so type
vi /etc/sysctl.conf
and then add the following lines:
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
Now we have to permanently change the current kernel parameters so we have to issue the following command:
/sbin/sysctl -p
Add the following lines to the /etc/security/limits.conf file:
* soft nproc 2047
* hard nproc 16384
* soft nofile 1024
* hard nofile 65536
Add the following line to the /etc/pam.d/login file, if it does not already exist:
session required /lib/security/
Some packages are required for Oracle Database 10g setup. Issue the following commands to see which versions of these packages are installed on our system:
rpm -q binutils compat-db control-center gcc gcc-c++ glibc glibc-common gnome-libs libstdc++ libstdc++-devel make pdksh sysstat xscreensaver openmotif21 libaio
Mount Enterprise-R4-U4-i386-disc3.iso into vmWare's CDROM device and then type:
cd /media/cdrom/Enterprise/RPMS
rpm -Uvh libaio-0*
rpm -Uvh openmotif21*
Issue the following commands as root user to create the Linux groups and user account that will be used to install and maintain the Oracle Database 10g software. The user account will be called oracle, and the groups will be oinstall and dba.
/usr/sbin/groupadd oinstall
/usr/sbin/groupadd dba
/usr/sbin/useradd -m -g oinstall -G dba -s /bin/ksh oracle
Then set the password for the oracle account:
passwd oracle
I will use oracle/oracle :)
Issue the following commands to create the directories in which the Oracle software will be installed:
mkdir -p /u01/app/oracle
chown -R oracle.oinstall /u01
chmod -R 775 /u01
Add at the end of the /etc/profile file the following command:
if [ \$USER = "oracle" ]; then
if [ \$SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
ulimit -u 16384 -n 65536
umask 022
Add at the end of the /etc/csh.login file the following command:
if ( \$USER == "oracle" ) then
limit maxproc 16384
limit descriptors 65536
umask 022
Type vi /home/oracle/.profile after logged in as oracle user and add the following lines at the end of the file:
# Oracle Settings
export ORACLE_SID=primary
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export PATH=$ORACLE_HOME/bin:/bin:
umask 022
Always as oracle user type:
mkdir -p $ORACLE_BASE/admin
mkdir -p $ORACLE_HOME
In the next step I will install the Oracle Database 10g, but before I would like to physically copy this machine to another locations.
This is useful because it is a faster way to create another Linux environments and another virtual machine that will be part of a future Data Guard configuration as standby database.

I created the primary database on the directory C:\EnterpriseLinux_Data, so create another directory (C:\EnterpriseLinux_Guard) and copy and paste all the files from C:\EnterpriseLinux_Data directory into C:\EnterpriseLinux_Guard directory

Now from your vmWare GSX server select File->Open Virtual Machine and then click on Browse button to add your future standby database (I selected the file C:\EnterpriseLinux_Guard\rhel4.vmx). Then click on Edit virtual machine settings and change the name of this "standby database" machine in guard.

At this point you will see two tabs on your vmWare GSX server, data and guard: now this time start the "standby database" machine (guard). The first time you will be asked if create a new identifier for this machine... You have to create a new identifier.
Finally you have to see a figure like this below.

You will see while your "standby database" machine is starting that a MAC address misconfiguration is detected: this is because you have to probe for new MAC address using system-config-network tool from a root terminal.
So as root user type on your terminal system-config-network and for each network device check for a new MAC address (see the figure below).

Change also your hostname from to
vi /etc/hosts
Save your network configuration and type
/etc/init.d/network restart
to see if you have written the right hostname for your "standby database" machine (you should see
Login as oracle user (su - oracle) and edit your .profile file, changing the ORACLE_SID variable in standby (see the figure below).

Click here to read the next step.

No comments: