Oracle Database 19c Installation and Configuration

Oracle Database Installation and Configuration Notes

Overview of Oracle Database 19c Installation

  • Oracle makes installing and configuring a database easier with tools like the RPM installer file (Red Hat Package Manager).

  • The installation will be demonstrated using a server with Oracle Linux as the operating system.

  • System state before installation:

    • No Oracle database components are installed.

System Check

  • Operating System Version Check:

    • Command: cat /etc/redhat-release

    • Output: Version obtained is 8.8.

  • Oracle Components Check:

    • Command: grep Oracle /etc/passwd

    • Result: No Oracle components found (nothing is returned).

Accessing System as Root

  • Root Login:

    • Use of sudo command to switch to root user.

Installation of Prerequisites

  • Installing Prerequisites:

    • Command: dnf -y install oracle-database-preinstall-19c

    • The -y option allows automatic confirmation for any prompts during installation.

  • Confirming Oracle User Creation:

    • Command: grep Oracle /etc/passwd

    • Result: Confirms that the Oracle user has been created successfully.

Installation of Oracle Database Media

  • Finding Installation Media:

    • Check local drive for the installation file.

  • Installing Oracle RPM:

    • Command: dnf -y install /media/SFTemp/oracle19c.rpm

    • Note: There’s no need to type out the full path if it’s clear.

Database Creation

  • Creating the Database:

    • Command to create the database: /etc/init.d/oracledb-orclcdb-19c configure

Connecting to Database and Environment Setup

  • Oracle User Login:

    • Command: su - Oracle

  • Set Oracle Environment:

    • Command: export ORAENV=ORCLCDB

  • Connecting with SQL Plus:

    • Use SQL Plus to connect to the database:

    • Command: sqlplus

Checking Database Status

  • Query Database Structure:

    • Command: SELECT name, open_mode FROM v$containers;

    • Expected results include:

    • Container Database (CDB)

    • Seed Pluggable Database (PDB)

    • Oracle Pluggable Database (PDB)

Post-Installation Recommendations

  • Apply any necessary patches and updates:

    • Recommendations may include:

    • Release Updates (RUs)

    • Merge Patch Releases (MRPs)

    • Other patches as suggested by Oracle.