Pages

Tuesday, January 16, 2007

Installing Oracle Database 10g: System Requirement

Click here for the previous step.

Let's continue setting up the system requirement for our Oracle Database 10g installation.
First of all we have to edt 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
net.core.rmem_default=262144
net.core.rmem_max=262144
net.core.wmem_default=262144
net.core.wmem_max=262144


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/pam_limits.so


We have to disable secure linux by editing the /etc/selinux/config file and set;
SELINUX=disabled


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 libaio
As you can see we miss libaio and sysstat packages.


Mount CentOS-4.3-i386-bin3of4.iso into vmWare's CDROM device and then type:
cd /media/cdrom/CentOS/RPMS
rpm -Uvh libaio-0*
rpm -Uvh sysstat-5*


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 oracle
Then set the password for the oracle account:
passwd 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/app/oracle
chmod -R 775 /u01/app/oracle


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
else
ulimit -u 16384 -n 65536
fi
umask 022
fi


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
endif


We have to move the Database zip file on root's Desktop to the oracle user's home directory.
Just issue the following commands:
cd
cd Desktop
mv database/ /home/oracle/
cd /home/oracle/
chown -R oracle.oinstall database/


As root user edit the /etc/hosts file; it must contain a fully qualified name for our server, for example:
10.5.140.108 test01 test01 localhost


As root user, issue the following command:
xhost +
Then login as oracle user and set your DISPLAY variable:
DISPLAY=test01:0.0; export DISPLAY


















Type vi .bash_profile after logged in as oracle user and add the following lines at the end of the file:
# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME
ORACLE_SID=ORCL; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
#LD_ASSUME_KERNEL=2.4.1; export LD_ASSUME_KERNEL
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi


















On your terminal window, type xclock to verify you are able to redirect X output on your display.


















Next time we will continue with the Oracle RunInstaller...

Click here to see how to execute Oracle runInstaller. It's a step taken from the Oracle Unbreakable Enterprise Linux and Oracle Database 10g R2 installations. Thanks Eric :)