DBA Hub

📋Steps in this guide1/4

Minimal Viable Oracle Database 19c Installation on Oracle Linux 8 (OL8)

This article gives the least steps necessary to get a working Oracle 9c database on Oracle Linux 8 (OL8).

oracle 19cconfigurationintermediate
by OracleDba
12 views
1

Download Software

Download the Oracle software RPM (oracle-database-ee-19c-1.0-1.x86_64.rpm) from here and place it in the "/tmp" directory on your server.
2

Database Installation and Creation

The following commands install the prerequisites, install the database software and create a new database.

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
cd /tmp

# Prerequisites.
sudo dnf install -y oracle-database-preinstall-19c

# Oracle software installation.
sudo dnf localinstall -y /tmp/oracle-database-ee-19c-1.0-1.x86_64.rpm

# Create a database.
sudo /etc/init.d/oracledb_ORCLCDB-19c configure
3

Test User Setup

Use the following commands to create a test user.

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
# Switch to the "oracle" user.
sudo su - oracle

# Set up your environment.
export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_SID=ORCLCDB

sqlplus / as sysdba <<EOF
alter session set container=ORCLPDB1;

create user testuser1 identified by testuser1 quota unlimited on users;
grant connect, resource to testuser1;

exit;
EOF
4

Connecting To The Database

To connect to the database using SQL*Plus we could do the following. Using SQLcl it would look like this. If you are connecting from another tool, or remote machine, you just need to remember the basic connection details. For more information see: Hope this helps. Regards Tim...

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
sqlplus testuser1/testuser1@//localhost:1521/ORCLPDB1

sql testuser1/testuser1@//localhost:1521/ORCLPDB1

Username: testuser1
Password: testuser1
Host    : {hostname of server running the database. "localhost" if you are on the machine}
Port    : 1521
Service : ORCLPDB1

Comments (0)

Please to add comments

No comments yet. Be the first to comment!