Wednesday, June 3, 2020

Oracle Home Installation on Oracle Linux || 11g Release 2 (11.2)

Please refer the below YouTube channel for detailed explanation:

https://www.youtube.com/watch?v=azzh8khOUyM&t=151s

1.       Build or Installation Linux Server

Oracle linux is ready and it is update and running

2.       Download Oracle software and unzip

#11.2.0.4

unzip p13390677_112040_Linux-x86-64_1of7.zip

unzip p13390677_112040_Linux-x86-64_2of7.zip


3.       Hostname verification 

192.168.0.101   OEL58.localdomain    OEL58

4.       Verify the system pre-configuration

/sbin/sysctl -a

/etc/sysctl.conf

/etc/security/limits.conf

oracle              soft    nproc   16384

oracle              hard    nproc   16384

oracle              soft    nofile  4096

oracle              hard    nofile  65536

oracle              soft    stack   10240

 

Creating the Oracle user and groups

groupadd -g 54321oinstall

groupadd -g 54322 dba

groupadd -g 54323 oper

groupadd -g 54324asmadmin

groupadd -g 54325 asmdba

groupadd -g 54326 asmoper

 

useradd -u 54321 -g oinstall -G dba,asmdba,oper oracle

passwd oracle

>>> Welcome2020


Creating the directories

mkdir -p /u01/app/oracle/product/11.2.0.4/dbhome_1

chown -R oracle:oinstall /u01

chmod -R 775 /u01

 

Setting up the .bash_profile for oracle user

# Oracle Settings

TMP=/tmp; export TMP

TMPDIR=$TMP; export TMPDIR

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE

ORACLE_HOME=$ORACLE_BASE/product/11.2.0.4/dbhome_1; export ORACLE_HOME

TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN

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

 

5.       Oracle Home Installation

Go to the software location and launch the GUI screen for Installation

./runInstaller

Follow the installation screen and installation wizard

 

6.       Post Oracle Home Installation

Verify the /etc/oratab

Apply the Latest OPatch and Latest BP/CPU/PSU


Regards,
Mallik

No comments:

Post a Comment

Automation Script | Archivelog Generation Hourly Monitoring

1. List out all the running databases and pic one database where we want to monitore the archive log generation from last 1 month. [oracle@o...