Oracle Database 11g Release 1 (11.1) Installation on
Enterprise Linux 5.0


This article describes the installation of Oracle Database 11g Release 1 (11.1)
Enterprise Linux 5.0. Here I simulate the installation process based on my PC
server which has following hardware configuration:

1. Intel 2.4 GHz x86 Processor.
2. 80 GB SATA HDD
3. GB physical memory

To make an easy and convenient installation process we documented installat
in two phases. First of on we have to install Oracle Enterprise Linux Server 5
required package and system parameter. After that in the second phase we si
installation Process of Oracle 11g with respective screen shot which will help
beginner Administrator to understand their jobs easily. I hope, this article wil
novice and mid level Database/ System Administrator to understand what is t
production standard installation of Oracle 11g for mid level traffic processing
which will done by General Purpose or Transaction processing database temp

Its me a great pleasure if this installation cook help someone meet their comp
requirement.Part-1: Installing Oracle Enterprise Linux 5.0
Part-2: Configuring Linux for Oracle
1. Creating the Oracle Group and User Account
2. Creating Required Directories and Change the Owner Ship
3. Verify Hardware Requirements Main Memory Requirements Disk Space Requirements
4. Software Requirements Checking
Kernel Requirements
Package Requirements
5. Configuring Kernel Parameters
6. Configuring the oracle User's Environment
7. Installing Oracle Database
8. Post Instillation Task
Part-1: Installing Oracle Enterprise Linux 5.0

You may download Oracle Enterprise Linux 5.0 from oracle technology network. To
download Oracle Enterprise Linux 5.0 Enterprise Edition uses the following link.
http://edelivery.oracle.com/linux

Installation Process:
1. Boot the server using the first CD.
o You may need to change your BIOS settings to allow booting from the CD.
2. The boot screen appears with the boot: prompt at the bottom of the screen.
o Select Enter to continue with a graphical install on the console.
3. CD Found
o Skip these options.
4. Click on Next.
5. What language could you like to use during the installation process.
o Accept the default.
6. Select the appropriate keyboard for the system Configuration
o Accept the default. (U.S English).
7. Disk Portioning Step
o Select Remove all partition on Selected device and create default layout the
system and Click on Next
o The disk on the first controller (/dev/sda) will hold all Linux software and
contains the following partitions:
o /boot partition - 256MB
o Swap Partition -2 GB [Set this to at least twice the amount of RAM in the s
But if the Physical RAM equal to 4 GB or greater then choose swap size ex
as memory size.]
o root (/) partition - 19 GB This partition will be used for everything, includi
/usr, /tmp, /opt, /home, and more. This approach is purely to simplify instal
for the purposes of this guide. A more robust partitioning scheme would sep
these directories onto separate file systems.
o /u01 – 18 GB - For Oracle Home Directory
o /u02 - 18GB - For Oracle Data Directory.
o /var – 19 GB
o Click on Next
o Click on Next
8. Required installation media
o Three CD Required to Successful installation of Oracle Enterprise Linux.
o If you have three disk then Click on Continue
9. Boot Loader Configuration
o Accept the default and Click on Next.
10. Network Configuration
o It is usually best to configure database servers with a static IP address. To d
click on Edit.
o A pop-up window appears. Uncheck the Configure using DHCP box, and en
the IP Address and NetMask for the server. Be sure that Activate on boot is
checked, and click on OK.
o Enter Static IP Address , Prefix (Net Mask) in your required IP Block
o In the Hostname box, select manually and enter the hostname.
o In the Miscellaneous Settings box, enter the remaining network settings. Enter Geteway, Primary DNS , Secondary DNS Click on Next
1. Please Click into the map to chose a region
o Select Asia/Dhaka
o Click on Next
2. Provide Root Password and Conform
o Click on Next
3. Package Installation
o Chose Customize now and Click on Next.
4. Package Group Selection
o Desktop Environment GEOME Desktop Environment
o Applications Editor Graphical Internet Text-based Internet
o Development Development Libraries Development Tools
o Server Server Configuration Tools
o Base System Base Administration Tools System Tools X Window System
5. Click on Next.
6. Reboot The System
7. Welcome
o Click on Forward
o License Agreement Select Yes, I agree to the License Agreement and
o Firewall Chose Disabled Firewall and Click on Forward A Popup window will appear Click on Yes for Con
o SE Linux
o Chose Disabled to SELinux Settings.
o Click on Forward
o A Popup window will appear Click on Yes.
o Kdump Accept Default and Click on Forward
o Data and Time Set the Date Time and Click on Forward
o Create User Skip this options and Click on Forward

o Sound Card You may Test your sound card by playing a Test S Click on Forward
o Additional CD Skip this options and Click on Finish
8. Click on OK button to reboot the system
Part-2: Configuring Linux for Oracle
You may download Oracle 11g from oracle technology network. To download Oracle
Database 11g Release 1 (11.1.0.6.0)
Standard Edition, Standard Edition One, and Enterprise Edition use the following link.
http://www.oracle.com/technology/software/products/database/oracle11g/111060_linuxs
oft.html

1. Creating the Oracle Group and User Account Use the following command to add The Oracle Inventory group (oinstall) and
OSDBS (dba) Group:
[root@testdb ~]# groupadd oinstall
[root@testdb ~]# groupadd dba
Use the following command to add a user whish is The Oracle software owner
(oracle)
[root@testdb ~]# useradd oracle
Use the following command to specify oinstall as the primary group and dba as
the secondary group for oracle User.
[root@testdb ~]# usermod -g oinstall -G dba oracle
Finaly use the following command to Check the Oracle user and user group:
[root@testdb ~]# id oracle
uid=500(oracle) gid=500(oinstall) groups=500(oinstall),501(dba)
Use the following command to set the password of the oracle user:
[root@testdb ~]# passwd oracle
Changing password for user oracle.
New UNIX password:
Retype new UNIX password:
passwd:all authentication tokens updated successfully.
Use the Following Command determine whether the An unprivileged user
(nobody) user exists or Not :
[root@testdb ~]# id nobody
uid=99(nobody) gid=99(nobody) groups=99(nobody)
If this command displays information about the nobody user, then you do not
need to create the nobody user.
If the nobody user does not exist, then enter the following command to create it:
# useradd nobody
2. Creating Required Directories and Change the Owner Ship
Create directories with names similar to the following, and specify the correct
owner, group, and permissions for them:
1. The Oracle base directory (For Oracle Home directory)
2. An optional Oracle data file directory
Oracle Recommand that the base directory and data file directory will be different
mount point. if you do not create the mount point during the operation system
installation then use the following command to create a directory.
mkdir -p /mount_point/app/
For example :
[root@testdb ~]# mkdir -p /u01/app To set the appropriate owner, group use the following command :
[root@testdb ~]# chown -R oracle.oinstall /u01
[root@testdb ~]# chown -R oracle.oinstall /u02 To permissions on the directory use the following command :
[root@testdb ~]# chmod -R 775 /u01
[root@testdb ~]# chmod -R 775 /u02
. Verify Hardware Requirements Main Memory Requirements Disk Space Requirements
ain Memory Requirements At least 1 GB of Physical RAM Requirement , To determine the physical RAM
size, use the following command:
[root@testdb ~]# cat /proc/meminfo | grep Mem
MemTotal: 1018368 kB
MemFree: 43884 kB
Swap Spase
For 512 MB RAM,Swap Space Required Double the size of RAM
For 1024 MB RAM, Swap Space Required 1.5 times the size of RAM To determine the physical RAM size, use the following command:
[root@testdb ~]# cat /proc/meminfo | grep SwapTotal
SwapTotal: 2096472 kB
isk Space Requirements Oracle Recommend For Enterprise Edition you may need 3.47 GB, Enterprise
Edition require 1.5 GB of disk Space for Data file. To determine the amount of
free disk space in MB on the system, use the following command :

[root@testdb ~]# df -m /u01/
Filesystem 1M-blocks Used Available Use% Mounted on
/dev/hda7 17439 3624 12915 22% /u01

[root@testdb ~]# df -m /u02/
Filesystem 1M-blocks Used Available Use% Mounted on
/dev/hda6 17439 1777 14763 11% /u02
4. Software Requirements Checking

Kernel Requirements To determine whether the required kernel is installed, use the following
command. A sample output displayed by running this command on a Oracle
Enterprise Linux 5.0 system:
[root@testdb ~]# uname –r
2.6.18-8.el5


Package Requirements The following or later version of packages for Oracle Enterprise Linux 5.0

1. binutils-2.17.50.0.6-2.el5 Disk-01
2. compat-libstdc++-33-3.2.3-61 Disk-02
3. elfutils-libelf-0.125-3.el5 Disk-02
4. elfutils-libelf-devel-0.125 Disk-02
5. glibc-2.5-12 Disk-02
6. glibc-common-2.5-12 Disk-01
7. glibc-devel-2.5-12 Disk-02
8. gcc-4.1.1-52 Disk-02
9. gcc-c++-4.1.1-52 Disk-02
10. libaio-0.3.106 Disk-01
11. libaio-devel-0.3.106 Disk-02
12. libgcc-4.1.1-52 Disk-01
13. libstdc++-4.1.1 Disk-01
14. libstdc++-devel-4.1.1-52.e15 Disk-02
15. make-3.81-1.1 Disk-01
16. sysstat-7.0.0 Disk-03
17. unixODBC-2.2.11 Disk-02
18. unixODBC-devel-2.2.11 Disk-02
To determine whether the required packages are installed, use commands similar
to the following:

# rpm -qa | grep

Example:
[root@testdb ~]# rpm -qa | grep binutils
binutils-2.17.50.0.6-2.el5
To Find the Packege in the CD-ROM(Oracle Entriprece Linux) use the
Commands similer

# ls -la /media/cdrecorder/Server | grep
To install, use commands similar to the following:

# rpm -ivh
5. Configuring Kernel Parameters

[root@testdb ~]# sysctl -a | grep sem
kernel.sem = 250 32000 100 128

[root@testdb ~]# sysctl -a | grep shm
vm.hugetlb_shm_group = 0
kernel.shmmni = 4096
kernel.shmall = 268435456
kernel.shmmax = 4294967295

[root@testdb ~]# sysctl -a | grep file-max
fs.file-max = 6553600

[root@testdb ~]# sysctl -a | grep ip_local_port_rang
net.ipv4.ip_local_port_range = 1024 65000

[root@testdb ~]# sysctl -a | grep rmem_
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304

[root@testdb ~]# sysctl -a | grep wmem_
net.core.wmem_default = 262144
net.core.wmem_max = 262144
vm.lowmem_reserve_ratio = 256 256 32
Using any text editor, create or edit the /etc/sysctl.conf file, an
edit lines similar to the following:

kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 262144








Enter the following command to change the current values of the kerne
parameters:
[root@testdb ~]# /sbin/sysctl –p

Review the output from this command to verify that the values are correct.
N.B: For Safety to make sure the change effect you may restart the system.
6. Configuring the oracle User's Environment

Oracle Enterprise Linux 5.0 user environment is preconfigured. So skip this option.

If you are not disabling the firewall during the setup of Oracle Enterprise Linux 5.0 th
follow the following step to disable in GUI as root user.
For Oracle Enterprise Linux System -> Administration -> Security Level and Firewall
| Firewall Options -> Firewall: Disable
| SE Linux -> SE Linux Settings: Disable
7. Installing Oracle Database
1. Login in Oracle User in X Window System.

[root@testdb ~]$ hostname
testdb.dnsgroup.net
[root@testdb ~]$ xhost + testdb.dnsgroup.net
testdb.dnsgroup.net bigen added to access control list
[root@testdb ~]$ xterm



Figure: Xtrem Window

To Unzip the unzip the zip file use the following Command
# unzip linux_11gR1_database.zip


After unzip to run the Oracle Universal Installer use the following command

[oracle@testdb database]$./runInstaller


2. Select a Product to Install Select Advanced Installation Click on Next


Figure: Oracle Database 11g Installation – Select a Product to Install
3. Specify Inventory Directory and Credentials. Inventory Directory: /u01/app/oraInventory Operating System group name: oinstall Click on Next

Figure: Oracle Universal Installer: Specify Inventory Directory and Credentials

Query to get a date after 10 years

select ADD_Months(to_date('12/3/2008','dd/MM/yyyy'),120)from dual

Profiles commands in oracle

CREATE PROFILE

CREATE PROFILE agent LIMIT CONNECT_TIME 10;
ALTER PROFILE data_analyst LIMIT CONNECT_TIME UNLIMITED;

CREATE PROFILE agent LIMIT CPU_PER_CALL 3000;
ALTER PROFILE data_analyst LIMIT CPU_PER_CALL UNLIMITED;

IDLE_TIME
CREATE PROFILE agent LIMIT IDLE_TIME 10;
ALTER PROFILE daemon LIMIT IDLE_TIME UNLIMITED;



CREATE PROFILE agent LIMIT LOGICAL_READS_PER_CALL 2500;
ALTER PROFILE data_analyst LIMIT LOGICAL_READS_PER_CALL 1000000;


CREATE PROFILE agent LIMIT LOGICAL_READS_PER_SESSION 250000;
ALTER PROFILE data_analyst
LIMIT LOGICAL_READS_PER_SESSION 35000000;

PRIVATE sGA
CREATE PROFILE agent LIMIT PRIVATE_SGA 2500;
ALTER PROFILE data_analyst LIMIT PRIVATE_SGA UNLIMITED;



SESSIONS_PER_USER
CREATE PROFILE admin_profile LIMIT SESSIONS_PER_USER 2;
ALTER PROFILE data_analyst LIMIT SESSIONS_PER_USER 6;




CREATE PROFILE agent LIMIT
FAILED_LOGIN_ATTEMPTS 3
PASSWORD_LOCK_TIME 10/1440;
-- remove failed login restrictions
ALTER PROFILE student LIMIT FAILED_LOGIN_
-- manually unlock an account
ALTER USER scott ACCOUNT UNLOCK;



CREATE PROFILE agent LIMIT
PASSWORD_LIFE_TIME 90 - 14
PASSWORD_GRACE_TIME 14;
-- set no limit to password lifetime
ALTER PROFILE student LIMIT
PASSWORD_LIFE_TIME UNLIMITED
PASSWORD_GRACE_TIME DEFAULT;


CREATE PROFILE agent LIMIT
PASSWORD_REUSE_TIME 365
PASSWORD_REUSE_MAX 4;
-- remove password reuse constraints
ALTER PROFILE student LIMIT
PASSWORD_REUSE_TIME UNLIMITED
PASSWORD_REUSE_MAX UNLIMITED;



-- use a custom password function
CREATE PROFILE agent LIMIT PASSWORD_VERIFY_FUNCTION my_function;
-- disable use of a custom function
ALTER PROFILE student LIMIT PASSWORD_VERIFY_FUNCTION DEFAULT;

-- use a custom password function
CREATE PROFILE agent LIMIT PASSWORD_VERIFY_FUNCTION my_function;
-- disable use of a custom function
ALTER PROFILE student LIMIT PASSWORD_VERIFY_FUNCTION DEFAULT;

installing oracle 10g on linux

ORACLE 10g(10.2.0.1.) INSTALLATION ON RedHat Enterprise Linux [RHEL 4]

Minimum Hardware Configuration Required

Ram - 512 MB

Hard Disk space - 20 GB

Processsor - P IV / P III / ( PII IBM support)

Linux Installation

RHEL – 4 [ 4 CDs]

Insert Ist CD and boot from the boot drive, just press the Enter for installation

Manual Disk Partion (minimum)

1. boot 150 MB Fixed

2. / 4000MB Fixed

3. Swap 2xRAM Fixed

4. /home 3500MB Fixed

5. /user 4000MB Fixed

6. /tmp 1000MB fixed

7. /usrlocal 200MB fixed

8. /opt 200 MB fixed

Remaining Freespace create RAID 0

Select Raid

Mount point /oracle

Fill to maximum space

Packges Required For ORACLE 10g

binutils-2.15.92.0.2-13.EL4

compat-db-4.1.25-9

compat-libstdc++-296-2.96-132.7.2

control-center-2.8.0-12

gcc-3.4.3-22.1.EL4

gcc-c++-3.4.3-22.1.EL44

glibc-2.3.4-2.9

glibc-common-2.3.4-2.9

gnome-libs-1.4.1.2.90-44.1

libstdc++-3.4.3-22.1

libstdc++-devel-3.4.3-22.1

make-3.80-5

pdksh-5.2.14-30

sysstat-5.0.5-1

xscreensaver-4.18-5.rhel4.2

setarch-1.6-1

After Installation

Login as root

Insert CD3 , open terminal window , type the following

#rpm –Uvh libaio-0.3.96

#rpm –Uvh openmotif2l -2.1-30-11 RHEL4.2

1. # vi /etc/hosts

press ‘I’ for insert

add the following line below 127.0.0.1 localdoman.localhost local host

ip of the machine machinename.domain machine

eg: 192.168.10.1 lserver.datamate.com lserver

press ESC , Press Shift+: , curson on the bottom , type wq! , press enter for return to root.

2. # vi /etc/ sysconfig/network

press I for insert

add the following HOSTNAME=lserver [ press ESC , Press Shift+: , type

wq! And press Enter return to root

3. # service network restart
4. #hostname – i( checking the ipaddress)
5. #hostname (checking machine name)
6. #hostname –d (checking domainname)
7. #vi /etc/sysctl.conf

Add the following lines at a end of the last line , press I

kernel.shmall = 2097152

kernel.shmmax = 536870912

kernel.shmmni = 4096

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.wmem_default = 262144

net.core.rmem_max = 262144

net.core.wmem_max = 262144

press ESC , Press Shitft+:, type wq! , Press Enter to return root

8. # sysctl –p
9. vi /etc/pam.d/login

add the following lines at the bottom Press I

session required /lib/security/pam_limits.so

Press ESC , Press Shift+: , type wq! Press Enter to return to root

10. # vi /etc/security/limits.conf

add the following lines at the bottom Press I

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

Press ESC , Press Shift+: , type wq! , Press Enter to return root

11. #vi /etc/selinux/config

Check the line SELINUX = disabled

Oracle USER CREATION

#groupadd oinstall

#groupadd dba

#useradd -g oinstall –G dba oracle

#passwd oracle

type password for oracle user two times

#mkdir –p /oracle/u01/app/oracle

#chown –R oracle:oinstall /oracle/u01/app/oracle

#chmod –R 775 /oracle/u01/app/oracle

logout from user and login as oracle

Insert Oracle database 10g cd

Double click on the CD DRIVE

Open terminal

$ cd /database

$ . runistaller