Here we are installing Oracle 11g Release-2 (11.2)(64-bit) on Oracle Linux release-6 (64-bit)
Kindly have a look on Pre-requisites before proceeding for oracle 11gR2 installation.
- Minimum 1 GB RAM, Recommended 2 GB or more than that.
- Following commands will helpyou to determine RAM of your system:
- # grep MemTotal /proc/meminfo
- # free -m // shows RAM + SWAP
- If RAM of your system does not meet minimum requirement than increase it.
- SWAP partition requirement for oracle installation is only depend on RAM installed in your system, according to oracle docs.
- If your RAM between 1 GB to 2 GB than your swap partition size should be 1.5 times the size of the RAM.
- If your RAM between 2 GB to 16 GB than your swap partition size should be equal to the size of the RAM.
- If your RAM more than 16 GB than your swap partition size should be 16 GB.
Disk space requirement:
- /tmp directory size would be at least 1 GB.
- Determine available disk space of /tmp directory with following command:
- # df -h /tmp
- Minimum requirement of total disk space of the system would directly depend upon size of your database, Oracle installation files take maximum 4.5 GB to 4.7GB of disk space.
- Determine total diskc space available with following:
- # df -h
Verify your system architecture with following command:
# uname -m
Update host file “/etc/hosts” with fully qualified name like below:
Ex: 115.xxx.xxx.xxx ol6.localdomain ol6
In my case “ol6.localdomain” is fully qualified name with machine name.
Update following entries in “/etc/sysctl.conf” file:
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 change kernel parameter, run following:
# /sbin/sysctl -p OR # sysctl -p
Update following entries in “/etc/security/limits.conf” file:
oracle soft nproc 16384 oracle hard nproc 16384 oracle soft nofile 4096 oracle hard nofile 65536 oracle soft stack 10240
Install following packages by yum or rpm:
binutils-18.104.22.168.2-5.11.el6 (x86_64) compat-libcap1-1.10-1 (x86_64) compat-libstdc++-33-3.2.3-69.el6 (x86_64) compat-libstdc++-33-3.2.3-69.el6.i686 gcc-4.4.4-13.el6 (x86_64) gcc-c++-4.4.4-13.el6 (x86_64) glibc-2.12-1.7.el6 (i686) glibc-2.12-1.7.el6 (x86_64) glibc-devel-2.12-1.7.el6 (x86_64) glibc-devel-2.12-1.7.el6.i686 ksh libgcc-4.4.4-13.el6 (i686) libgcc-4.4.4-13.el6 (x86_64) libstdc++-4.4.4-13.el6 (x86_64) libstdc++-4.4.4-13.el6.i686 libstdc++-devel-4.4.4-13.el6 (x86_64) libstdc++-devel-4.4.4-13.el6.i686 libaio-0.3.107-10.el6 (x86_64) libaio-0.3.107-10.el6.i686 libaio-devel-0.3.107-10.el6 (x86_64) libaio-devel-0.3.107-10.el6.i686 make-3.81-19.el6 sysstat-9.0.4-11.el6 (x86_64) unixODBC-2.2.14-11.el6 (x86_64) or later unixODBC-2.2.14-11.el6.i686 or later unixODBC-devel-2.2.14-11.el6 (x86_64) or later unixODBC-devel-2.2.14-11.el6.i686 or later
Determine required packages are installed or not with the help of following command:
# rpm -q package_name
Create oracle groups and users:
groupadd -g 501 oinstall groupadd -g 502 dba groupadd -g 503 oper groupadd -g 504 asmadmin groupadd -g 506 asmdba groupadd -g 505 asmoper
useradd -u 502 -g oinstall -G dba,asmdba,oper oracle passwd oracle
Set SELINUX flag ‘disable’ in “/etc/selinux/config” file.
Restart server after setting SELINUX disabled.
Create directory for oracle software to be installed:
# mkdir -p /u01/app/ # chown -R oracle:oinstall /u01/app/ # chmod -R 775 /u01/app/
Disable IP tables:
# service iptables stop # chkconfig iptables off //This command will make changes persistent over reboot.
Unzip installer and continue..
On GUI, open terminal prompt as a root user & issue the following command: xhost + su – oracle
Run universal installer and follow the steps by step installation of oracle 11gR2:
And follow the steps mentioned below:
You can directly create and configure a database by selecting first radio button, in my case first i will install database software only and than database.
Select single instance database installation radio button and continue, as we are installing single instance database:
Select Product Languages according to your convenience, in my case it is English, default language.
Select database edition as per your requirement, in my case it would be Standard Edition.
Provide path of oracle base and continue, In my case its default.
Provide ‘Inventory Directory’, ‘OraInventory group’ and continue.
Select ‘Database Administrator Group’ and ‘Database Operator Group’ and continue.
If your system already installed latest version of mentioned packages, then you can ignore and continue. In my case, latest version available.
Execute mentioned configuration script as root user and continue.
Software installation completed successfully.
Now database installation, for that i have instantiated DBCA from oracle_home/bin directory.
Provide ‘Global Database Name’, ‘SID’, and continue.
Checked ‘Configuration Enterprise Manager’ check box in case of you wanted to configure it, In my case, its not my requirement.
Provide SYS and SYSTEM user password, otherwise provide common password for the both user and continue.
Select Database file locations according to your requirements, in my case i am using default option, i.e. From Template.
Provide Flash Recovery Area path and its size according to your convenience. You can also enable Archive log mode.
Configure memory, sizing, character Sets and connection mode according to your convenience and continue.
Verify controlfile multiplexing, datafiles and redo log group and continue.
Cheers!! Oracle software and database creation successfully completed.
Stay tune. 🙂