Oracle Database 19c Step by Step Installation On Oracle Linux 7.6

Download Software

Download the Oracle software from oracle edelivery.

Oracle Installation Prerequisites

Automatic Setup

Use the “oracle-database-preinstall-19c” package to perform all your prerequisite setup.

# yum install -y oracle-database-preinstall-19c

If you are using RHEL7 or CentOS7, you can pick up the PRM from the OL7 repository and install it. It will pull the dependencies from your normal repositories.

# yum install -y https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm

Hosts File

Set a fully qualified name for the server in the “/etc/hosts” file.

< IP-address >  < fully-qualified-machine-name >  < machine-name >

# vi /etc/hosts

Set the correct hostname in the “/etc/hostname” file.# vi /etc/hostname

arandy.cm

NB!! Make sure you can ping the hostname you added in the host file.

Additional Setup

Set the password for the “oracle” user.

# passwd oracle

Set secure Linux to permissive by editing the “/etc/selinux/config” file. # vi /etc/selinux/config

SELINUX=permissive

Once the change is complete, run the following command.

# setenforce Permissive

Disable the Linux firewall.

# systemctl stop firewalld
# systemctl disable firewalld

Create the directories in which the Oracle software will be installed.

mkdir -p /u01/app/oracle/product/19.3.0/dbhome_1
mkdir -p /u02/oradata
chown -R oracle:oinstall /u01 /u02
chmod -R 775 /u01 /u02

Reboot the server and login in with the oracle user using the password that we set above. Hope you haven’t forgotten your password if you have don’t worry just log in as the root user and reset the password again with passwd command.

# reboot

 Set Environment variables.

Add the following environment variables in the .bash_profile file.

$ vi .bash_profile

# Oracle Settingsexport TMP=/tmpexport TMPDIR=$TMP
export ORACLE_HOSTNAME=arandy.cmexport ORACLE_UNQNAME=cdb1export ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/19.3.0/dbhome_1export ORA_INVENTORY=/u01/app/oraInventoryexport ORACLE_SID=cdb1export PDB_NAME=pdb1export DATA_DIR=/u02/oradata
export PATH=/usr/sbin:/usr/local/bin:$PATHexport PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/libexport CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

$ . .bash_profile

Unzip the File 

Switch to the ORACLE_HOME directory and unzip the software directly into this path.Please note that after you must have downloaded the installation file you have to transfer them into the VM. This can be done with Filezilla or by using the scp command in the terminal.

$ cd $ORACLE_HOME
$ unzip -oq /home/oracle/LINUX.X64_193000_db_home.zip

Run the Installer

Log into the oracle user, start the Oracle Universal Installer (OUI) by issuing the following command and follow the GUI guided steps

$ cd $ORACLE_HOME
$ ./runInstaller

Select the install option Set Up Software Only and click Next:

Select the install option Single Instance database installation and click Next:

Select the install option Enterprise Edition and click Next:

 Click Next.

 Click Next.

 Click Next.

 Click Next.

 Click Next.Make sure all Prerequisite Checks Succeeded.

Click Install.

Run the root scripts when prompted.

As a root user, execute the following script(s):
# /u01/app/oraInventory/orainstRoot.sh
# /u01/app/oracle/product/19.0.0/dbhome_1/root.sh

Click Close.

You are now ready to create a database.

Database Creation

You create a database using the Database Configuration Assistant (DBCA). The interactive mode will display GUI screens to allow user input.
After successfully installing the database software, start the listener:

# Start the listener
$ lsnrctl start

To create the database using the interactive mode, start the Database Configuration Assistance (dbca) by issuing the following command and follow the GUI guided steps

# Interactive mode.
$ dbca

Click Next.

Typical configuration:Global database name: cdb1Storage type: File SystemDatabase file location: /u02/oradataFast Recovery Area (FRA): {ORACLE_BASE}/fast_recovery_area/{DB_UNIQUE_NAME}Database character set: AL32UTF8Adminitrative password: SysOracle_47   Pluggable database name: pdb1Click Next.

Click Finish.Database Summary.

Database creation finish.

Once the Database 19c successfully created, validate the database using the following command.

$ sqlplus / as sysdba
SQL> select banner_full from v$version;
SQL> select instance_name,status from v$instance;
SQL> select con_id, name, open_mode from v$pdbs;