This post will tell you how to prepare your system for installing Oracle 11g Database.
Before I continue, please download all the softwares from the previous post (Oracle 11g database installation part 2 - Requirement Analysis)
I assume the following points
- You have create a VM emulating Oracle Linux 5 / Oracle Linux 6.
- Your VM has a minimum of 2~3gb RAM (i have used 4gb RAM)
- You have given the number of cores as 2with a single processor or 2 processor with each having a single core
- You have a minimum of 50GB hard disk space (i have used 200GB hard disk space)
- You have created a user called "oracle"
- You have given a valid host name to your VM (eg: oracle.demo.com)
1. Login as root
2. Find your ip of the VM
- command : ifconfig
3. Adding Server IP and server name to the Hosts file
- command : vi /etc/hosts
- add the system ip and fully qualified host name
EXAMPLE:
<ip_address> <fully qualified host name> <host_name> 192.168.1.12 oracle.demo.com oracle4. Change the User limits
- command : vi /etc/security/limits.conf
- enter the below lines and save the file:
oracle hard nproc 16384
oracle soft nofile 4096
oracle hard nofile 65536
oracle soft stack 10240
4. Create new groups and users
- command:
groupadd -g 501 oinstallgroupadd -g 502 dbagroupadd -g 503 opergroupadd -g 504 asmadmingroupadd -g 506 asmdbagroupadd -g 505 asmoper
5. Adding users to the group:
- command : useradd -u 502 -g oinstall -G dba,asmdba,oper oracle
6. Disable SELinux
- command : SELINUX=disabled
7. Increase 90-Nproc file limit
- command : vi /etc/security/limits.d/90-nproc.conf
- change the value from " * soft nproc 1024 " to " * - nproc 16384 "
8. Disable the Firewall by navigating to System > Administration > Firewall > Disable > Apply > Exit
9. Creating the Directory Structure:
- command :
mkdir -p /u01/app/oracle/product/11.2.0/dbhome_1
mkdir -p /u01/app/oraInventory
chown -R oracle:oinstall /u01
chmod -R 775 /u01
10. Setting the bash Profile
- login as "oracle" user
- command : vi ~/.bash_profile
- enter and paste the below lines
# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOSTNAME=oaim.demo.com; 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=orcl; export ORACLE_SID
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
- make the changes to the bash profile permanent by using the below command
command : source ~/.bash_profile
11. Install the packages and RPMs which are required for the database. Please check out this post to see how to update the required packages for Oracle 11g Database:
12. Edit the "SYSCTL.conf" fileat the location "/etc/sysctl.conf" and enter the below lines and save the file.
fs.suid_dumpable = 1
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
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=1048586
To make the above parameters to reflect on the Linux, use the below command to reflect the changes:
- command : /sbin/sysctl -p
This post concludes the preparation of the Linux System to accommodate the installation of Oracle 11g Database
Continue to Oracle 11g database installation part 3 - Installing the Software
0 comments