Install Oracle12c on centos8.1|rhel|oracle database|Linux OS|VM|centos|Installation|DB|Server|RDBMS
Hello and welcome back to the channel.
This tutorial video covers step by step installation of oracle 12c on Linux Operating System and configuration of database.Fo this demo purpose I am using virtualization VM.If you guys wants to know how to install Virtual machine using VMware or oracle virtual box. Please do check my previous video. So guys don't forget to subscribe and comment your views.
So let's get started with our today's topic on oracle installation on Linux Platform.Also, note that an Oracle account is required to download the Oracle Database 12c (3.2 GB) installation file . However, don't worry about this, as you can create an account for free.
Finally, make sure your server has at least 2GB of RAM and 30GB of available disk space.These hardware requirements are safe for a test environment like ours, but should increase if you consider using Oracle in production.
Do check Video Link for creating VM
• Video
Create user
https://profile.oracle.com/myprofile/...
#oralce12c installer
https://www.oracle.com/database/techn...
STEP1: CHECK STATUS OF THE GUEST(VM)MACHINE.
hostnamectl status
Disable Selinux and Firewall.
Set secure Linux to permissive by editing vi /etc/selinux/config file
Run the following commands as root
firewall-cmd --state
running
systemctl disable firewalld
systemctl stop firewalld
firewall-cmd --state
not running
Update the complete System i.e packages to their latest version by using below command.
yum update -y
yum -y groupinstall "Development Tools"
RPM install for installing oracle software.
yum install -y libnsl
yum install -y ksh
yum install -y libaio-devel
yum install -y libaio
yum install -y numactl-libs
yum install -y numactl-devel
yum install -y redhat-lsb-core
yum install -y motif
yum install -y libXp
yum install -y xorg-x11-xbitmaps
yum install -y mod_ssl
yum install -y zlib-devel
yum install -y xorg-x11-server-Xvfb
yum install -y xorg-x11-server-common
yum install -y xorg-x11-server-Xorg
rpm -Uvh compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm
https://rpmfind.net/linux/rpm2html/se...
STEP2:Add the following kernel parameters to below: vi /etc/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2147483648
kernel.shmmax = 12640366592
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 = 1048586
Then run the following command to take the change effect
/sbin/sysctl -p
/sbin/sysctl -a
Set limits for Oracle in the vi /etc/security/limits.conf
oracle soft nproc 16384
oracle hard nproc 16384
oracle soft nofile 8192
oracle hard nofile 65536
oracle soft stack 10240
oracle hard stack 32768
Create the following OS groups.
groupadd -g 501 oinstall
groupadd -g 502 dba
groupadd -g 503 oper
groupadd -g 504 backupdba
groupadd -g 505 dgdba
groupadd -g 506 kmdba
groupadd -g 507 asmdba
groupadd -g 508 asmoper
groupadd -g 509 asmadmin
useradd -g oinstall -g dba -g oper -g backupdba -g dgdba -g kmdba -g asmoper -g asmadmin oracle
Changing oracle user password
passwd oracle
Modify oracle user (the owner of Oracle Software)
usermod -g oinstall -G dba,oper,backupdba,dgdba,asmdba,asmoper,asmadmin,kmdba oracle
STEP3:Create directory for installing Oracle Software
cd /
mkdir app
chmod -R 777 app
cd /app
mkdir -p ./oracle/product/12.2.0.1/db_1
chown -R oracle:oinstall ./oracle
Add environment variables in oracle user profile
vi /home/oracle/.bash_profile
*******************************
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOSTNAME=YOUR_HOSTNAME; export ORACLE_HOSTNAME
ORACLE_UNQNAME=MYDB; export ORACLE_UNQNAME
ORACLE_BASE=/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/db_1; export ORACLE_HOME
ORACLE_SID=YOUR_SID; 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:/usr/local/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
*******************************
Unzip and run the installer.
./runInstaller
Check listener status and ping to the oracle database.
lsnrctl status
tnsping YOUR_SID
Login to database with sqlplus and alter user profile. This step is mandatory because by default the oracle system user password will expire after 180 days(6months).So need to set password expiry for unlimited time.
sqlplus / as sysdba
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
Thank for reading descriptions and watching videos.
Please don't forget to subscribe my channel and comment down for any question.
#oralce12c #LinuxOS #centos8 #rhel8 #vmware #rdbms
Stay safe guys.