This blog describes the installation of Oracle Database 11g Release 2 (64-bit) on RHEL 6 (64-bit). The blog is based on a server installation with a minimum of 2G swap, with SELinux set to permissive and the firewall disabled.
Installation of Oracle 11gR2 in silent mode is much easier as people use to think. There are many ways to install 11gR2 Oracle Home in silent mode, whether you can go with response and you can also install directly just by passing all information in one liner.Below this blog I also updated all the issues which I faced in my installation.
Installation of Oracle 11gR2 in silent mode is much easier as people use to think. There are many ways to install 11gR2 Oracle Home in silent mode, whether you can go with response and you can also install directly just by passing all information in one liner.Below this blog I also updated all the issues which I faced in my installation.
- Installation of all Oracle Prerequisite:
- Add or amend the following lines in the "/etc/sysctl.conf" 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
- Run the following command to change the current kernel parameters.
/sbin/sysctl -p
- Add the following lines to the "/etc/security/limits.conf" file.
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 4096
oracle hard nofile 65536
oracle soft stack 10240
- Install the following packages from root user if they are not already present.
rpm -Uvh binutils-2*x86_64*
rpm -Uvh glibc-2*x86_64* nss-softokn-freebl-3*x86_64*
rpm -Uvh glibc-2*i686* nss-softokn-freebl-3*i686*
rpm -Uvh compat-libstdc++-33*x86_64*
rpm -Uvh glibc-common-2*x86_64*
rpm -Uvh glibc-devel-2*x86_64*
rpm -Uvh glibc-devel-2*i686*
rpm -Uvh glibc-headers-2*x86_64*
rpm -Uvh elfutils-libelf-0*x86_64*
rpm -Uvh elfutils-libelf-devel-0*x86_64*
rpm -Uvh gcc-4*x86_64*
rpm -Uvh gcc-c++-4*x86_64*
rpm -Uvh ksh-*x86_64*
rpm -Uvh libaio-0*x86_64*
rpm -Uvh libaio-devel-0*x86_64*
rpm -Uvh libaio-0*i686*
rpm -Uvh libaio-devel-0*i686*
rpm -Uvh libgcc-4*x86_64*
rpm -Uvh libgcc-4*i686*
rpm -Uvh libstdc++-4*x86_64*
rpm -Uvh libstdc++-4*i686*
rpm -Uvh libstdc++-devel-4*x86_64*
rpm -Uvh make-3.81*x86_64*
rpm -Uvh numactl-devel-2*x86_64*
rpm -Uvh sysstat-9*x86_64*
rpm -Uvh compat-libstdc++-33*i686*
rpm -Uvh compat-libcap*
- Create the new 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
Note. We are not going to use the "asm" groups, since this installation will not use ASM.
- Set the password for the "oracle" user.
passwd oracle
- Amend the "/etc/security/limits.d/90-nproc.conf" file as described below.
# Change this
* soft nproc 1024
# To this
* - nproc 16384
- Set secure Linux to permissive by editing the "/etc/selinux/config" file, making sure the SELINUX flag is set as follows.
SELINUX=permissive
Note: Once the changes are completed, restart the server.
- Create the directories in which the Oracle software will be installed.
mkdir -p /p02/app/oracle/product/11.2.0/db01
chown -R oracle:oinstall /p02
chmod -R 775 /p02
- Login as the oracle user and add the following lines at the end of the ".bash_profile" file.
# Oracle Settings
umask 022
TMP=/tmp; export TMP
TMPDIR=/tmp; export TMPDIR
ORACLE_UNQNAME=DEV1; export ORACLE_UNQNAME
ORACLE_HOSTNAME=db-dev.mmi.local; export ORACLE_HOSTNAME
ORACLE_BASE=/p02/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db01; export ORACLE_HOME
ORACLE_SID=DEV1; export ORACLE_SID
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/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
2. Install Oracle 11gR2 software:
Login to oracle user, check the environment have been set correctly or not. Go to the location of runInstaller and execute below command.
./runInstaller -silent -debug -force \
FROM_LOCATION=/p01/Media/database/stage/products.xml \
oracle.install.option=INSTALL_DB_SWONLY \
UNIX_GROUP_NAME=oinstall \
ORACLE_HOME=/p02/app/oracle/product/11.2.0/db01 \
INVENTORY_LOCATION=/p02/app/oracle/oraInventory \
ORACLE_HOME_NAME="OraDEV1_Home" \
ORACLE_BASE=/p02/app/oracle \
oracle.install.db.InstallEdition=EE \
oracle.install.db.isCustomInstall=false \
oracle.install.db.DBA_GROUP=dba \
oracle.install.db.OPER_GROUP=dba \
DECLINE_SECURITY_UPDATES=true
output:
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 120 MB. Actual 3474 MB Passed
Checking swap space: must be greater than 150 MB. Actual 4094 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2013-04-30_11
password entered does not conform to the Oracle recommended standards.
CAUSE: Oracle recommends that the password entered should be at least 8 charait [0-9].
ACTION: Provide a password that conforms to the Oracle recommended standards.
[WARNING] [INS-13014] Target environment do not meet some optional requirements.
CAUSE: Some of the optional prerequisites are not met. See logs for details.
ACTION: Identify the list of failed prerequisite checks from the log: /tmp/Or the log file or from installation manual find the appropriate configuration
You can find the log of this install session at:
/p02/app/oraInventory/logs/installActions2013-04-30_11-57-29AM.log
[oracle@localhost database]$ The installation of Oracle Database 11g was successful.
Please check '/p02/app/oraInventory/logs/silentInstall2013-04-30_11-57-29AM.log' for more details.
[oracle@localhost database]$
As a root user, execute the following script(s):
1. /p02/app/oraInventory/orainstRoot.sh
2. /p02/app/oracle/product/11.2.0/db01/root.sh
Successfully Setup Software.
3. Open one terminal and execute the follwing scripts
[root@localhost ~]# sh /p02/app/oraInventory/orainstRoot.sh
Changing permissions of /p02/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.
Changing groupname of /p02/app/oraInventory to oinstall.
The execution of the script is complete.
[root@localhost ~]# sh /p02/app/oracle/product/11.2.0/db01/root.sh
Check /p02/app/oracle/product/11.2.0/db01/install/root_localhost.localdomain_2013-04-30_12-16-52.log for the output of root script
[root@localhost ~]
4. Check the log file
[oracle@localhost ~]$ cat /p02/app/oraInventory/logs/silentInstall2013-04-30_11-57-29AM.log
5. Create Database using dbca utility:
Go to $ORACLE_HOME/bin and execute below command:
./dbca -silent -createDatabase -templateName /p02/app/oracle/product/11.2.0/db01/assistants/dbca/templates/General_Purpose.dbc \
-gdbname dev1 -sid prdtmp -sysPassword secret -systemPassword secret2 \
-totalMemory 4096
The installation of Oracle Database 11g was successful.
6. Check the Database status
[oracle@localhost ~]$ ps -ef | grep pmon
oracle 5121 5074 0 04:56 pts/0 00:00:00 grep pmon
oracle 21286 1 0 Nov10 ? 00:00:34 ora_pmon_dev1
[oracle@localhost ~]$
Hi All,
ReplyDeleteIt's very nice post...and good for everyone...Please keep update some more as it awesome tech TWICKS...!!!
Thanks Prakash for your valuable comments...
Delete