kstirman

# Install **unzip** tool

sudo yum install unzip

# Unzip downloaded **Oracle** distribution

unzip oracle_distrib.zip

# Change unzipped distribution folder owner

kstirman

# Backup default response file

cp database/response/db_install.rsp database/response/db_install.rsp.bck

# Open db_install.rsp file

vi database/response/db_install.rsp

# Set the following parameters, it is assumed, that we only install software.

kstirman

# Change current folder

cd /home/oracle/database

# Run installer

./runInstaller -silent -responseFile /home/oracle/database/response/db_install.rsp

kstirman

sudo su root

/u01/app/oraInventory/orainstRoot.sh   

/u01/app/oracle/product/12.2.0/dbhome_1/root.sh

kstirman

# Login as oracle

sudo su - oracle

# Change current folder

cd /home/oracle/database/response

# Run Net Configuration Assistant

kstirman

lsnrctl start

kstirman

mkdir /u01/app/oracle/oradata
mkdir /u01/app/oracle/flash_recovery_area

kstirman

dbca -silent \
       -createDatabase \
       -templateName General_Purpose.dbc \
       -gdbname cdb1 \
       -sid cdb1 \
       -characterSet AL32UTF8 \
       -sysPassword OraPasswd1 \
       -systemPassword OraPasswd1 \
       -createAsContainerDatabase true \
       -numberOfPDBs 1 \

kstirman

lsnrctl start
sqlplus / as sysdba
startup;
alter session set container=pdb1;
alter database open;

kstirman

-- 1. Add new Oracle user DREMIO.

CREATE USER dremio IDENTIFIED BY pass;

GRANT DBA TO dremio;

-- 2. Create TEST table in DREMIO schema.

CREATE TABLE dremio.test
(test varchar(2000));