Installation of 18c oracle binaries and Database at same time

FacebooktwitterredditpinterestlinkedinmailFacebooktwitterredditpinterestlinkedinmail

In this Article you will se how to install oracle 18c binaries as well as Database

Step 1 :
Disable firewall and selinux:
first check the status of firewalld status weather is active or not:

[root@localhost /]# systemctl status firewalld
● firewalld.service – firewalld – dynamic firewall daemon
Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled; vendor preset: enabled)
Active: active (running) since Mon 2021-05-03 01:47:30 IST; 4h 12min ago
Docs: man:firewalld(1)
Main PID: 957 (firewalld)
Tasks: 2
CGroup: /system.slice/firewalld.service
└─957 /usr/bin/python2 -Es /usr/sbin/firewalld –nofork –nopid

May 03 01:47:28 localhost.localdomain systemd[1]: Starting firewalld – dynamic firewall daemon…
May 03 01:47:30 localhost.localdomain systemd[1]: Started firewalld – dynamic firewall daemon.

If it is active then disabled:

root@localhost /]# vi /etc/selinux/config
# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
# enforcing – SELinux security policy is enforced.
# permissive – SELinux prints warnings instead of enforcing.
# disabled – No SELinux policy is loaded.
SELINUX=disabled
# SELINUXTYPE= can take one of three values:
# targeted – Targeted processes are protected,
# minimum – Modification of targeted policy. Only selected processes are protected.
# mls – Multi Level Security protection.
SELINUXTYPE=targeted

~

~
“/etc/selinux/config” 14L, 542C

Step 2
create OS group and user :

[root@localhost /]# groupadd -g 1100 oinstall
[root@localhost /]# groupadd -g 1131 dba
[root@localhost /]# groupadd -g 1132 oper
[root@localhost /]# useradd -u 1101 -g oinstall -G dba,oper oracle

set the oracle password:

[root@localhost /]# passwd oracle
Changing password for user oracle.
New password:
BAD PASSWORD: The password is shorter than 8 characters
Retype new password:
passwd: all authentication tokens updated successfully.
[root@localhost /]#

create the directories for installing oracle binaries installation and permission and ownership :

[root@localhost /]# mkdir -p /dmarch01/app/oracle/product/18.3.0/dbhome_1
[root@localhost /]# chown -R oracle:oinstall /u01
[root@localhost /]# chmod -R 775 /u01
[root@localhost /]#

Set the host files in vi /etc/hosts :

192.168.100.10 testlab.com.bd testlab (this is for example ip address)

And run the following command from anywhere as root to install the oracle preinstalls:

[root@localhost /]# yum install oracle-database-preinstall-18c.x86_64

switch to the oracle user and set the bash_profile :

[root@localhost /]# su – oracle
[oracle@MiWiFi-R4CM-srv ~]$ vi .bash_profile
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/.local/bin:$HOME/bin

export PATH

TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOSTNAME=testlab.com.bd; export ORACLE_HOSTNAME
ORACLE_BASE=/dmarch01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/18.3.0/dbhome_1; export ORACLE_HOME
ORACLE_SID=orcl; export ORACLE_SID
ORACLE_UNQNAME=orcl; export ORACLE_UNQNAME
ORACLE_TERM=xterm; export ORACLE_TERM
BASE_PATH=/usr/sbin:$PATH; export BASE_PATH
PATH=$ORACLE_HOME/bin:$GRID_HOME/bin:$BASE_PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

Check the bash_profile status by using this command:

[oracle@MiWiFi-R4CM-srv ~]$ . .bash_profile

And check the oracle_home:

[oracle@MiWiFi-R4CM-srv ~]$ echo $ORACLE_HOME
/dmarch01/app/oracle/product/18.3.0/dbhome_1

And upload the zip file in this directory /u01/app/oracle/product/18.3.0/dbhome_1 through winScp software or any other which one you like:
Go to ORACLE_HOME directory and run this command:

./runInstaller

After ./runInstaller 18c wizard installation setup:

select option 1, as we will install Oracle binaries and Database creation at a time.

Select server class.

Select Advanced Install

Select Enterprise Edition

Mention oracle base

Select configuration type (we did General purpose)

Specify DB and SID name and select create container database name

Provide memory settings

Select character set details

Specify database file location

Specify Recovery Area settings

specify administrative passwords

Select groups for different database-related roles

Review the Summary details

Chose Install and monitor, If it asks for script execution with root privilege, do the same and proceed further

select instance_name,VERSION,VERSION_FULL,status ,EDITION ,DATABASE_TYPE from v$instance;

INSTANCE_NAME VERSION VERSION_FULL STATUS EDITION DATABASE_TYPE
---------------- ----------------- ----------------- ------------ ------- ---------------
ORA18C 18.0.0.0.0 18.3.0.0.0 OPEN EE SINGLE

One thought on “Installation of 18c oracle binaries and Database at same time”

Leave a Reply

Your email address will not be published.