First of all check the Hostname and IP on which we are going to install the Oracle Database.
Hostname: OEL64.localdomain
IP: 192.168.0.10
Confirm the bit version of Operating System:
[root@OEL64 ~]# uname -i
x86_64
[root@OEL64 ~]#
Download the 11.2.0.3 Database Files (p10404530_112030_Linux-x86-64_1of7.zip, p10404530_112030_Linux-x86-64_2of7.zip) from Oracle Site and put it on the server.
Now we will start configuring perquisite.
1. Hosts File
The “/etc/hosts” file must contain a fully qualified name for the server.
[root@OEL64 ~]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.0.10 OEL64.localdomain OEL64
[root@OEL64 ~]#
2. Oracle Installation Prerequisites
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 if they are not already present.
Go to media and go to the packages directory:
[root@OEL64 Packages]# pwd
/media/OL6.3 x86_64 Disc 1 20120626/Server/Packages
[root@OEL64 Packages]#
Install the below packages:
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*
If in case any package fails then use the –force option or sometime –nodeps can also help. take help from man page.
3. 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 passwd oracle
Note. We are not going to use the “asm” groups, since this installation will not use ASM.
Additional Setup
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
Once the change is complete, restart the server.
If you have the Linux firewall enabled, you will need to disable or configure it.
Create the directories in which the Oracle software will be installed.
mkdir -p /u01/app/oracle/product/11.2.0.3/db_1 chown -R oracle:oinstall /u01 chmod -R 775 /u01
Login as the oracle user and add the following lines at the end of the “.bash_profile” file.
# Oracle Settings TMP=/tmp; export TMP TMPDIR=$TMP; export TMPDIR ORACLE_HOSTNAME=OEL64.localdomain; export ORACLE_HOSTNAME ORACLE_UNQNAME=APEX; export ORACLE_UNQNAME ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/11.2.0.3/db_1; export ORACLE_HOME ORACLE_SID=APEX; 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
Installation:
Start the Oracle Universal Installer (OUI) by issuing the following command in the database directory.
./runInstaller
Follow the screen shot below to install the database:
Unchecked and then press Next.
Click Yes and press Next.
Select as per your requirement and press Next.
Select as per your choice for me: Create and configure the database, press Next.
Select the server class as per your choice. Press Next.
Here i am going to install single instance database and Press Next.
I selected the typical option, anyone can choose as per their choice. Press Next.
Correct and fill up the details and set the passwords accordingly. Press Next.
Put the typical password, as i gave the simple password so i got this error press yes. and Press next.
Nothing to change, press Next.
Verify the details and Press Install.
Wait till end and we will get the below one:
Save this information somewhere for the EM and press OK. We need to run the two scripts as per the below print screen from the root user.
Run the script from the root user:
[root@OEL64 ~]# /u01/app/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.
Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.
[root@OEL64 ~]#
[root@OEL64 ~]# /u01/app/oracle/product/11.2.0.3/db_1/root.sh
Performing root user operation for Oracle 11g
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/11.2.0.3/db_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:
Copying dbhome to /usr/local/bin …
Copying oraenv to /usr/local/bin …
Copying coraenv to /usr/local/bin …
Creating /etc/oratab file…
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
[root@OEL64 ~]#
And click OK on screen.
Press Close.
Verify the database:
$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Thu Oct 10 23:17:20 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
SQL>
SQL> show parameter db_name
NAME TYPE VALUE
———————————— ———– ——————————
db_name string APEX
SQL>
We are done with the installation.
Many Thanks for viewing.