Step#. Login as root user
Step#. Execute the following command
1. yum update
2. yum install kernel-uek-devel
3. go to the following locaiton
cd /etc/yum.repos.d/
(This will install the rpm files specificaly in the following location.)
(Please maintain this convention in every rpm download further.)
(Execute the following command.)
wget http://pkgs.repoforge.org/rpmforge-release/rpmforge-release-0.5.3-1.el6.rf.x86_64.rpm
5. rpm -Uvh rpmforge-release-0.5.3-1.el6.rf.x86_64.rpm
cd /etc/yum.repos.d
wget http://public-yum.oracle.com/public-yum-ol6.repo
or oracle linux 5
rpm -Uhv http://apt.sw.be/redhat/el5/en/x86_64/rpmforge/RPMS//rpmforge-release-0.3.6-1.el5.rf.x86_64.rpm
Step#. Create User Group and Set Password
/usr/sbin/groupadd oinstall
/usr/sbin/groupadd dba
/usr/sbin/groupadd oper
/usr/sbin/useradd -g oinstall -G dba,oper oracle
/usr/bin/passwd oracle
Step#. Directory Create.
Go to root Directory
mkdir -p oracleinstallations
chown -R oracle:oinstall /oracleinstallations
chmod -R 0775 /oracleinstallations
mkdir -p /home/oracle/app/oracle/product/11.2.0/db_1
chown -R oracle:oinstall /home/oracle
chmod -R 0775 /home/oracle
Step#. Copy Oracle11gR2-11.2.0.1-Linux-x86-64 installation file to oracleinstallations
Step#. Execute
chown -R oracle:oinstall /oracleinstallations
chmod -R 0775 /oracleinstallations
Step#.First we need to check up System Configurations which required for Oracle installation
-- Check Physical RAM. We need at least 1GB of physical RAM. In my case I have 2GB.
# grep MemTotal /proc/meminfo
output: MemTotal: 2075424 kB
-- Check Swap Space.
RAM between 1GB and 2GB then Swap = 1.5 times the size of RAM
RAM between 2GB and 16GB then Swap = equal to the size of RAM
RAM more than 16GB then Swap Size = 16GB
Since my RAM is 2GB, so I have 3GB of Swap Size.
# grep SwapTotal /proc/meminfo
output: SwapTotal: 3148732 kB
-- Check Shared Memory Space
What ever you are going to use your Automatic Memory Management
Targets later on this database, you need to have shared memory
file system size at lease equal to those settings. In my case I
have plans to use memory management targets lower then 1000M
so 1014 M of shared memory file system is sufficient for me.
But if you would like to have a bigger shared memory (/dev/shm)
size then do the following:
# df -h /dev/shm/
output: Filesystem Size Used Avail Use% Mounted on
tmpfs 1014M 0 1014M 0% /dev/shm
-- Check space available in /tmp
You need to have at least 1GB of space in the /tmp directory.
Make sure you have 1GB in the column "Avail" in the above output.
In my case I have 1.4G space available in /tmp.
# df -h /tmp
output: Filesystem Size Used Avail Use% Mounted on
/dev/sda5 1.5G 35M 1.4G 3% /tmp
Step# Incase if memory extention is required execute the below line, to mount any required memory,
a. mount -t tmpfs tmpfs -o size=1500m /dev/shm
b. df -h /dev/shm/
output: Filesystem Size Used Avail Use% Mounted on
tmpfs 1.5G 0 1.5G 0% /dev/shm
Step#--Check Kernel version (To install Oracle 11g Release 2 on RHEL 5 you should be running a kernel version 2.6.18 or later.)
a. uname -r
output: 2.6.18-194.el5
Step#. Open /etc/pam.d/login and add the following line if it is already not there.
session required pam_limits.so
Step#. Go to CD directory/packages and open terminal and execute following command from CD Packages
yum install binutils-* compat-libcap1-* compat-libstdc++-* compat-libstdc++-* gcc-* gcc-c++-* glibc-* glibc-devel-* glibc-devel-* ksh libgcc-* libgcc-* libstdc++-* libstdc++-* libstdc++-devel-* libstdc++-devel-* libaio-* libaio-* libaio-devel-* libaio-devel-* make-* sysstat-* -y
Step#. Now open the file in edit mode: /etc/hosts
--- Add this following lines
[IP-address] [fully-qualified-machine-name] [machine-name]
example: 192.168.0.161 univerge.spectrum-bd.com univerge
/*
Where "fully-qualified-machine-name" is your
"machine_name"."domain_name"
*/
Step#. Edit the /etc/sysctl.conf file and add the following lines and also need to check if those value is greater than
the given value then no need to change of the variable . kernel.shmmax value is greater then half of Ram size
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
-- To update this file
/sbin/sysctl -p
Step#. Edit the /etc/security/limits.conf file and add the following lines
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
Step#. create a file name .oracle. Put the file into /home/oracle directory.
Write put the following lines :
## Oracle settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
## If /tmp doesn't have 1G space free then you can workaround it by
# pointing the variables TMP AND TMPDIR to a location where you have
# sufficient space.
ORACLE_HOSTNAME=seclbidw.nbr.com; export ORACLE_HOSTNAME
ORACLE_BASE=/home/oracle/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME
ORACLE_SID=orcl; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=$ORACLE_HOME/bin:/usr/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
umask 022
Step#. Go to /etc/sysconfig/selinux
update the SELINUX=disabled in the line.
Step#. System>Administrator>Firewall disable
Step#. System>Administrator>Service ip6tables and iptable disable
Step#. Logout from root user from the system. Login to the system as oracle user
Step#. Go to /home/oracle
execute . .oracle
Step#. Put Oracle Linux installation zip file in oracleinstallations directory.The zip files will be:
linux.x64_11gR2_database_1of2.zip
linux.x64_11gR2_database_2of2.zip
Step#. Unzip these file by following commands one by one.
cd /oracleinstallations
unzip linux.x64_11gR2_database_1of2.zip
unzip linux.x64_11gR2_database_2of2.zip
Step#. To start installation run these following command.
a) cd /oracleinstallations/database
b) ./runInstaller.sh
Step#. find /etc/oratab file and change value equal to Y instead of N
Step#. Go to /home/oracle/app/oracle/product/11.2.0/db_1/dbs and open init.ora file and update processes and open_cursors value is 800(Describe in RCU setup)
Step#. Run Enterprize Manager
a) go to /home/oracle and execute
b) . .oracle
c) dbstart
d) lsnrctl start
e) emctl start dbconsole
Step# To see the dbconsole using mozilla browser go to the following address.
https://127.0.0.1:1158/dbconsole
If you see the dbconsole running and you can login appropriatly. The Db console is installed.
Step#. This is for Oracle DB stop.
a) go to /home/oracle and execute
b) . .oracle
c) emctl stop dbconsole
d) dbshut
e) lsnrctl stop
Step#. Execute the following command
1. yum update
2. yum install kernel-uek-devel
3. go to the following locaiton
cd /etc/yum.repos.d/
(This will install the rpm files specificaly in the following location.)
(Please maintain this convention in every rpm download further.)
(Execute the following command.)
wget http://pkgs.repoforge.org/rpmforge-release/rpmforge-release-0.5.3-1.el6.rf.x86_64.rpm
5. rpm -Uvh rpmforge-release-0.5.3-1.el6.rf.x86_64.rpm
cd /etc/yum.repos.d
wget http://public-yum.oracle.com/public-yum-ol6.repo
or oracle linux 5
rpm -Uhv http://apt.sw.be/redhat/el5/en/x86_64/rpmforge/RPMS//rpmforge-release-0.3.6-1.el5.rf.x86_64.rpm
Step#. Create User Group and Set Password
/usr/sbin/groupadd oinstall
/usr/sbin/groupadd dba
/usr/sbin/groupadd oper
/usr/sbin/useradd -g oinstall -G dba,oper oracle
/usr/bin/passwd oracle
Step#. Directory Create.
Go to root Directory
mkdir -p oracleinstallations
chown -R oracle:oinstall /oracleinstallations
chmod -R 0775 /oracleinstallations
mkdir -p /home/oracle/app/oracle/product/11.2.0/db_1
chown -R oracle:oinstall /home/oracle
chmod -R 0775 /home/oracle
Step#. Copy Oracle11gR2-11.2.0.1-Linux-x86-64 installation file to oracleinstallations
Step#. Execute
chown -R oracle:oinstall /oracleinstallations
chmod -R 0775 /oracleinstallations
Step#.First we need to check up System Configurations which required for Oracle installation
-- Check Physical RAM. We need at least 1GB of physical RAM. In my case I have 2GB.
# grep MemTotal /proc/meminfo
output: MemTotal: 2075424 kB
-- Check Swap Space.
RAM between 1GB and 2GB then Swap = 1.5 times the size of RAM
RAM between 2GB and 16GB then Swap = equal to the size of RAM
RAM more than 16GB then Swap Size = 16GB
Since my RAM is 2GB, so I have 3GB of Swap Size.
# grep SwapTotal /proc/meminfo
output: SwapTotal: 3148732 kB
-- Check Shared Memory Space
What ever you are going to use your Automatic Memory Management
Targets later on this database, you need to have shared memory
file system size at lease equal to those settings. In my case I
have plans to use memory management targets lower then 1000M
so 1014 M of shared memory file system is sufficient for me.
But if you would like to have a bigger shared memory (/dev/shm)
size then do the following:
# df -h /dev/shm/
output: Filesystem Size Used Avail Use% Mounted on
tmpfs 1014M 0 1014M 0% /dev/shm
-- Check space available in /tmp
You need to have at least 1GB of space in the /tmp directory.
Make sure you have 1GB in the column "Avail" in the above output.
In my case I have 1.4G space available in /tmp.
# df -h /tmp
output: Filesystem Size Used Avail Use% Mounted on
/dev/sda5 1.5G 35M 1.4G 3% /tmp
Step# Incase if memory extention is required execute the below line, to mount any required memory,
a. mount -t tmpfs tmpfs -o size=1500m /dev/shm
b. df -h /dev/shm/
output: Filesystem Size Used Avail Use% Mounted on
tmpfs 1.5G 0 1.5G 0% /dev/shm
Step#--Check Kernel version (To install Oracle 11g Release 2 on RHEL 5 you should be running a kernel version 2.6.18 or later.)
a. uname -r
output: 2.6.18-194.el5
Step#. Open /etc/pam.d/login and add the following line if it is already not there.
session required pam_limits.so
Step#. Go to CD directory/packages and open terminal and execute following command from CD Packages
yum install binutils-* compat-libcap1-* compat-libstdc++-* compat-libstdc++-* gcc-* gcc-c++-* glibc-* glibc-devel-* glibc-devel-* ksh libgcc-* libgcc-* libstdc++-* libstdc++-* libstdc++-devel-* libstdc++-devel-* libaio-* libaio-* libaio-devel-* libaio-devel-* make-* sysstat-* -y
Step#. Now open the file in edit mode: /etc/hosts
--- Add this following lines
[IP-address] [fully-qualified-machine-name] [machine-name]
example: 192.168.0.161 univerge.spectrum-bd.com univerge
/*
Where "fully-qualified-machine-name" is your
"machine_name"."domain_name"
*/
Step#. Edit the /etc/sysctl.conf file and add the following lines and also need to check if those value is greater than
the given value then no need to change of the variable . kernel.shmmax value is greater then half of Ram size
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
-- To update this file
/sbin/sysctl -p
Step#. Edit the /etc/security/limits.conf file and add the following lines
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
Step#. create a file name .oracle. Put the file into /home/oracle directory.
Write put the following lines :
## Oracle settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
## If /tmp doesn't have 1G space free then you can workaround it by
# pointing the variables TMP AND TMPDIR to a location where you have
# sufficient space.
ORACLE_HOSTNAME=seclbidw.nbr.com; export ORACLE_HOSTNAME
ORACLE_BASE=/home/oracle/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME
ORACLE_SID=orcl; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=$ORACLE_HOME/bin:/usr/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
umask 022
Step#. Go to /etc/sysconfig/selinux
update the SELINUX=disabled in the line.
Step#. System>Administrator>Firewall disable
Step#. System>Administrator>Service ip6tables and iptable disable
Step#. Logout from root user from the system. Login to the system as oracle user
Step#. Go to /home/oracle
execute . .oracle
Step#. Put Oracle Linux installation zip file in oracleinstallations directory.The zip files will be:
linux.x64_11gR2_database_1of2.zip
linux.x64_11gR2_database_2of2.zip
Step#. Unzip these file by following commands one by one.
cd /oracleinstallations
unzip linux.x64_11gR2_database_1of2.zip
unzip linux.x64_11gR2_database_2of2.zip
Step#. To start installation run these following command.
a) cd /oracleinstallations/database
b) ./runInstaller.sh
Step#. find /etc/oratab file and change value equal to Y instead of N
Step#. Go to /home/oracle/app/oracle/product/11.2.0/db_1/dbs and open init.ora file and update processes and open_cursors value is 800(Describe in RCU setup)
Step#. Run Enterprize Manager
a) go to /home/oracle and execute
b) . .oracle
c) dbstart
d) lsnrctl start
e) emctl start dbconsole
Step# To see the dbconsole using mozilla browser go to the following address.
https://127.0.0.1:1158/dbconsole
If you see the dbconsole running and you can login appropriatly. The Db console is installed.
Step#. This is for Oracle DB stop.
a) go to /home/oracle and execute
b) . .oracle
c) emctl stop dbconsole
d) dbshut
e) lsnrctl stop
কোন মন্তব্য নেই:
একটি মন্তব্য পোস্ট করুন