8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Articles » 19c » Here

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

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

As the name suggests, this is probably the simplest way to install an Oracle 19c database and set up a test user. This is not something I would follow if I were doing a real server build. It's meant for someone who doesn't care about the build process, but just wants a working database to run some DDL and DML against.

Related articles.

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.

Database Installation and Creation

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

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

Test User Setup

Use the following commands to create a test user.

# 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

Connecting To The Database

To connect to the database using SQL*Plus we could do the following.

sqlplus testuser1/testuser1@//localhost:1521/ORCLPDB1

Using SQLcl it would look like this.

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

If you are connecting from another tool, or remote machine, you just need to remember the basic connection details.

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

For more information see:

Hope this helps. Regards Tim...

Back to the Top.