8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23ai | Misc | PL/SQL | SQL | RAC | WebLogic | Linux
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...