Pre-Requisites for installing Oracle Database Enterprise Edition 11g
Pre-Requisites for installing Oracle Database Enterprise Edition 11g
1.
Create user oracle and group oinstall (group for installing database
and dba to manage the files after installation(if required)
Command to create oinstall
and dba groups:
groupadd oinstall
groupadd dba
Command to create oracle
user:
useradd oracle -g oinstall -G dba, root
2.
After creating the user , create password for the user using passwd
command
Command: passwd oracle
New Unix password :<
Type your password>
Retype Unix password :<
Type your password which was typed in previous step>
3.
Add the user oracle to sudoers list
Login as root user in terminal and type visudo
It will open a page where
the list of groups will be listed
Search for line root ALL=(ALL) ALL and type the following below that
oinstall ALL=(ALL) ALL
dba ALL=(ALL) ALL
4.
Now check for the hosts either by typing hostname in terminal or type vi /etc/hosts
(This will list all the
hosts in the machine)
By default we should have 127.0.0.1 localhost.localdomain localhost
5.
Now change all the kernel parameters to the following under
/etc/sysctl.conf
Command: vi /etc/sysctl.conf
At the last paste the
following
kernel.shmall = 2097152
kernel.shmmax = 2147483648 #
Smallest of -> (Half the size of the physical memory) or (4GB - 1 byte)
kernel.shmmni = 4096
# semaphores: semmsl, semmns,
semopm, semmni
kernel.sem = 250 32000 100 128
fs.file-max = 6815744 # 512 *
PROCESSES
fs.aio-max-nr=1048576
net.ipv4.ip_local_port_range =
9000 65500
net.core.rmem_default=4194304
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=1048576
Save it using the
following keys one by one esc : wq
The above are the system
parameters which will be checked by installer before installing and they are
required for the database to be functional.
6.
Type the following command after saving the file
/sbin/sysctl –p
7.
Type the following command to check for the changes
/sbin/sysctl -a | grep <param-name>
8.
Now change the hard and soft limits under /etc/security/limits.conf
Command : vi /etc/security/limits.conf
Check for the existing
values and modify the below mentioned value . If not found paste the following
values.
oracle soft nproc
2047
oracle hard nproc
16384
oracle soft nofile
1024
oracle hard nofile
65536
Save it using the
following keys one by one esc : wq
9.
Now change pam limits
Command : vi /etc/pam.d/login
Paste the following
session required
pam_limits.so
Save it using the
following keys one by one esc : wq
10. Now change the firewall
settings
Command :vi /etc/selinux/config
Change the value from
enabled to disabled
SELINUX=disabled
Save it using the
following keys one by one esc : wq
11. Install the following
packages
yum install binutils-2.*
yum install elfutils-libelf-0.*
yum install glibc-2.*
yum install glibc-common-2.*
yum install libaio-0.*
yum install libgcc-4.*
yum install libstdc++-4.*
yum install make-3.*
yum install
compat-libstdc++-33*
yum install
elfutils-libelf-devel-0.*
yum install glibc-devel-2.*
yum install gcc-4.*
yum install gcc-c++-4.*
yum install libaio-devel-0.*
yum install libstdc++-devel-4.*
yum install unixODBC-2.*
yum install unixODBC-devel-2.*
yum install sysstat*
rpm -ivh pdksh*
12. Create the following
folder structure and provide necessary
privileges
mkdir -p /u01/app/oracle
chmod -R 777 /u01
13.
xhost +<computer name>
14. Add the following in
bash_profile
Command:
cd /home/oracle
vi .bash_profile
Copy the following into
.bash_profile
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOSTNAME=localhost.localdomain; export
ORACLE_HOSTNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1; export
ORACLE_HOME
ORACLE_SID=DB11G; 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
if [ $USER = "oracle" ]; then
if [ $SHELL =
"/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384
-n 65536
fi
fi
Save it using the
following keys one by one esc : wq
15. Download the zip files
from the http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
(Linux x86 File1 and File2).
16. After download there are
two zip files linux_11gR2_datase_1of2.zip , linux_11gR2_datase_2of2.zip.
17. Copy both zip files to a
folder and unzip both the zip files.
18. By default both zip files
will get unzipped to database folder .
19. Now provide
access/privileges to all the files inside that directory to be executed under
the oracle user and oinstall group
chown -R oracle: oinstall database/
chmod -R 777 database/
Comments
Post a Comment