Saturday, 25 May 2019

Install Oracle Database 11g on Oracle Linux.


How to install Oracle database 11g on Oracle Linux 5.5

From Step 1 to Step 11 command run from root user.

Step 1
Edit Hosts File:
#vi /etc/hosts       (hit enter then press i for insert mode then edit it)
For Example.
192.168.179.132    OEL511G    OEL511G
After update this file press Esc then shif+: then wq  then Enter.

Step 2
#vi /etc/sysctl.conf
 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=262144
 net.core.rmem_max=4194304vi
 net.core.wmem_default=262144
 net.core.wmem_max=1048586
After update this file press Esc then shif+: then wq  then Enter.
After that run below command for applying changes of sysctl file.
#/sbin/sysctl -p

Step 3.
Now Edit /etc/security/limits.conf and add following lines in end of this file.
#vi /etc/security/limits.conf
oracle              soft    nproc   2047
oracle              hard    nproc   16384
oracle              soft    nofile  4096
oracle              hard    nofile  65536
oracle              soft    stack   10240
After update this file press Esc then shif+: then wq  then Enter.

Step 4.
Now Edit /etc/pam.d/login file and end following parameter
#vi /etc/pam.d/login
session    required     pam_limits.so
After update this file press Esc then shif+: then wq  then Enter.

Step 5
Create groups and user
#groupadd oinstall
#groupadd dba
#groupadd oper

#useradd -g oinstall -G dba,oper oracle
#passwd oracle

Step 6
Now create a Directory and change  directory permissions
#mkdir -p /u01/app/oracle/product/11.2.0/dbhome_1
#chown -R oracle:oinstall /u01
#chmod -R 775 /u01

Step 7
Now set selinux=permissive
#vi /etc/selinux/config
selinux=permissive
After update this file press Esc then shif+: then wq  then Enter.

Step 8
Now make firewall disabled using setup command. Following below steps.
#setup -- firewall configuration--disable

Step 9
# unzip linux.x64_11gR2_database_1of7.zip -d/u01
# unzip linux.x64_11gR2_database_2of7.zip -d/u01
Now you have a single Database folder which is have runInstaller file.

Step 10
Update profile.
#vi /etc/profile
if [ $USER = "oracle" ]; then
 if [ $SHELL = "/bin/ksh" ]; then
 ulimit -p 16384
 ulimit -n 65536
 else
 ulimit -u 16384 -n 65536
 fi
 fi

Step 11
#cd/media/Enterprise Linux dvd 20100405/Server
[root@onenode Server]# pwd
/media/Enterprise Linux dvd 20100405/Server
rpm -Uvh binutils* --nodeps
rpm -Uvh compat* --nodeps
rpm -Uvh gcc* --nodeps
rpm -Uvh glibc* --nodeps
rpm -Uvh ksh* --nodeps
rpm -Uvh libgcc* --nodeps
rpm -Uvh libstdc* --nodeps
rpm -Uvh libaio* --nodeps
rpm -Uvh libXext* --nodeps
rpm -Uvh libXtst* --nodeps
rpm -Uvh libX11* --nodeps
rpm -Uvh libXau* --nodeps
rpm -Uvh libxcb* --nodeps
rpm -Uvh libXi* --nodeps
rpm -Uvh make* --nodeps
rpm -Uvh sysstat* --nodeps
rpm -Uvh unixODBC* --nodeps
rpm -Uvh zlib-devel* --nodeps
rpm -Uvh elfutils* --nodeps

Step 12.
Now reboot your pc and login with Oracle user and follow below steps.
$cd /u01/database
./runInstaller

No comments:

Post a Comment

Rename Oracle database using NID

  SQL> set pages 999 lines 999; col instance_name for a10; col host_name for a20; col startup_time for a30; set colsep | set underline = ...