Thursday , September 29 2022

Oracle Database 19c Installation Guide

This article contains information about Oracle Database 19c Installation Guide. I will explain the installation and configuration of Oracle 19c on Oracle Linux 7.

I will install using VirtualBox.

Install Oracle Database 19c

First, we write server informations into the /etc/hosts

Then we write hostname into the /etc/hostname                      

Since we will do automatic installation in this article, we will install the “oracle-database-preinstall-19c” package , then we will do the update process.

After the above processes are completed, we will determine the password for the ‘oracle’ user.

Adding /etc/selinux/config to see if SELINUX is as follows.

SELINUX = permissive

After the above process is completed, the machine is rebooted and the following command is run.

setenforce permissive

Linux security is disabled by forwarding the following commands.

systemctl stop firewalld

systemctl disable firewalld

The directories where Oracle will be installed are created and the oracle user is given the necessary privileges.

Log in as root and enter the following command.

We will create a directory for the scripts we will use.

A script file named “setEnv.sh” is created.

A reference to the file “/home/oracle/.bash_profile” is added from the file “setEnv.sh”.

 

We switch to the Oracle user and set the DISPLAY variable.

We download the Oracle software from the link below.

 

Go to the $ORACLE_HOME directory and unzip the downloaded Oracle software. The Oracle Universal Installer (OUI) software is then started.

After the software is started, the following screen will appear. Proceed by selecting Set Up Software Only.

Set Up Software Only selection

Continue by selecting Single Instance database option.

Database Installation Options

Continue after Enterprise Edition is selected.

 

Database Edition

Since the bash_profile settings were made before, it does not need to be done again. Proceed by clicking Next.

Installation Location

This step continues without changing anything.

Operating System Groups

Proceed by clicking Next.

Root script execution

Clicking Install starts the installation.

Summary

After the installation is finished, the following command is run on the root user.

 

After the installation is completed successfully, the screen is closed by clicking close.

Finish

After the Oracle software installation is finished, the Oracle Net Configuration Assistant software is started by typing net on the command line for the listener configuration. Proceed by selecting Listener configuration on the screen that comes up.

Listener configuration

Proceed by selecting the Add option to create a Listener.

After the listener name is determined, it proceeds.

Specifying a listener name

The default settings are continued without changing.

Protocol selection

Continue by selecting the standard port number option.

Continue by clicking Next.

After the Listener configuration is done successfully, click Next.

Netcat is closed by clicking Finish.

After the Listener configuration process is completed, the database must be created. Database Configuration Assistant is started by typing dbca on the command screen. On the screen that comes up, the Create a database option is selected and proceeds.

Create a database

As we move forward, we are asked whether we want to continue with the settings set by default or in advanced mode. Continue by selecting Advanced mode.

Creation Mode

After selecting the database type and database template to be created, it continues.

Deployment Type

Continue after entering the database name and SID.

The place where the database files will be saved is selected and proceeded.

Storage Option

The backup area is selected for the database. Specifically, the Fast Recovery Area is selected and proceeded.

Fast Recovery Option

Here, the previously created listener is selected. If desired, a new listener can be created by selecting create.

Network Configuration

In this step, proceed by clicking next.

Data Vault Option

Continue by selecting Automatic Memory Management.

Configuration Option

Since the data to be saved in the database will be in Turkish, the Turkish character set is selected and continued.

Character sets

Since Enterprise Manager can be installed later, it is continued without selecting it. Optionally, this step can also be selected.

Management Options

A password is required to be assigned to SYS and users for the database. Instead of giving a password to both of them separately, the option to give a single password is selected and the password is entered.

User credentials

Continue by selecting the database creation option.

Build Option

The summary contains the information of the database to be monitored. Clicking Finish starts the installation process.

summary

The database was created successfully. By clicking the Close button, dbca is closed.

Finish

When logging in with SQLplus, a connection to the database can be made.

The following command checks whether the database is open or not.

 

 

Hope it is useful.

Melek Durdu
Author: Melek Durdu

About Melek Durdu

Leave a Reply

Your email address will not be published. Required fields are marked *