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

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;

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
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

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 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: 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
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME
PATH=/usr/sbin:$PATH; export PATH
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
ulimit -u 16384 -n 65536

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 :)


Anonymous said...


This tutorial has been terrific! It seems to have started back in December of 2006, and I have followed through on the instructions up until 1/16/2007.

The only problem is that I have not been able to find the portion that continues on with the "Oracle RunInstaller" portion. Can you tell me where to find it? If there was a link, it is not showing up on my browser.



Anonymous said...

This copy of Centos is great work, please provide me some more use full information
Thanks & Regards
Dated : 15/01/2009

oakleyses said...

oakley sunglasses, prada handbags, oakley sunglasses, longchamp handbags, longchamp handbags, louboutin shoes, louis vuitton handbags, coach factory outlet, tiffany and co, coach purses, louis vuitton outlet, polo ralph lauren outlet, air max, prada outlet, longchamp outlet, oakley sunglasses cheap, ray ban sunglasses, louboutin outlet, michael kors outlet, michael kors outlet, tiffany and co, burberry outlet, christian louboutin shoes, coach outlet store online, jordan shoes, polo ralph lauren outlet, louboutin, kate spade handbags, michael kors outlet, coach outlet, air max, gucci outlet, michael kors outlet, ray ban sunglasses, chanel handbags, michael kors outlet, tory burch outlet, nike free, kate spade outlet, louis vuitton outlet, burberry outlet, louis vuitton outlet stores, louis vuitton, nike shoes, michael kors outlet

oakleyses said...

air max, hollister, true religion outlet, nike blazer, louboutin, ray ban sunglasses, polo ralph lauren, michael kors, true religion jeans, sac guess, sac longchamp, hogan outlet, ralph lauren, vans pas cher, sac louis vuitton, air max pas cher, nike free pas cher, nike free, air max, mulberry, nike roshe run, sac burberry, hollister, vanessa bruno, louis vuitton, lululemon, michael kors pas cher, oakley pas cher, air jordan, ray ban pas cher, new balance pas cher, polo lacoste, converse pas cher, north face, sac louis vuitton, michael kors, sac hermes, nike tn, timberland, louis vuitton uk, longchamp, true religion jeans, nike air max, air force, north face

oakleyses said...

ugg, hollister, abercrombie and fitch, longchamp, nfl jerseys, lululemon outlet, nike trainers, abercrombie and fitch, soccer shoes, valentino shoes, nike roshe, birkin bag, reebok outlet, insanity workout, instyler, mont blanc, vans shoes, new balance shoes, beats by dre, uggs outlet, ugg australia, giuseppe zanotti, rolex watches, nike roshe run, herve leger, babyliss pro, marc jacobs, barbour, ghd, north face outlet, celine handbags, jimmy choo outlet, asics running shoes, mac cosmetics, north face jackets, bottega veneta, wedding dresses, soccer jerseys, ugg boots, chi flat iron, mcm handbags, p90x, ugg pas cher, nike huarache, ferragamo shoes

oakleyses said...

converse, air max, gucci, canada goose, juicy couture outlet, canada goose, wedding dresses, moncler, ralph lauren, lancel, montre homme, moncler, louboutin, oakley, karen millen, vans, coach outlet store online, air max, canada goose jackets, ugg, hollister clothing store, louis vuitton, baseball bats, hollister, rolex watches, juicy couture outlet, iphone 6 cases, canada goose uk, canada goose outlet, ugg, moncler, moncler outlet, timberland boots, hollister, supra shoes, moncler, canada goose, converse shoes, toms shoes, moncler, moncler, canada goose, ugg boots, ray ban, parajumpers, canada goose