Part 1: Inventory application setup (low code) using apex

Objective: Setup an inventory application (low code) using Oracle APEX

Part 1: Downloading APEX binaries and Setting up the oracle DB for the APEX install

APEX Installation steps:

Step 1) 
Go to the following url & download the apex bin:
http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html
FileName: apex_22.2_en.zip

Step 2)
Copy the file to the Linux Server into some directory
I kept in /u01/app/oracle/APEXBIN [empty directory]

Step 3)
Unzip the apex_22.2_en.zip file

Step 4)
It should create the below directories and files

[oracle@vcentos79-oracle-sa1 APEXBIN]$ ls -altr
total 186012
drwxr-xr-x. 6 oracle oinstall      4096 Nov 11 19:38 apex
drwxr-xr-x. 9 oracle oinstall       112 Apr 19 20:26 ..
-rwxr-xr-x. 1 oracle oinstall 190469084 Apr 19 20:26 apex_22.2_en.zip
drwxr-xr-x. 2 oracle oinstall        64 Apr 19 20:26 META-INF
drwxr-xr-x. 4 oracle oinstall        58 Apr 19 20:26 .
[oracle@vcentos79-oracle-sa1 APEXBIN]$

Step 5) 
Create a pluggable database in 19c

CREATE PLUGGABLE DATABASE inventorypdb ADMIN USER inventoryadm IDENTIFIED BY inventoryadm;

Error:

SQL> CREATE PLUGGABLE DATABASE inventorypdb ADMIN USER inventoryadm IDENTIFIED BY inventoryadm;
CREATE PLUGGABLE DATABASE inventorypdb ADMIN USER inventoryadm IDENTIFIED BY inventoryadm
                                                                                        *
ERROR at line 1:
ORA-65016: FILE_NAME_CONVERT must be specified

SQL>

Because I didnt have either db_create_file_dest or db_file_name_convert params set

SQL> sho parameter convert;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert                 string
log_file_name_convert                string
pdb_file_name_convert                string
SQL> show parameter db_create
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_create_file_dest                  string
db_create_online_log_dest_1          string
db_create_online_log_dest_2          string
db_create_online_log_dest_3          string
db_create_online_log_dest_4          string
db_create_online_log_dest_5          string

Solution:

SQL> show parameter db_create;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_create_file_dest                  string      /oradata/

Now:

SQL> CREATE PLUGGABLE DATABASE inventorypdb ADMIN USER inventoryadm IDENTIFIED BY inventoryadm;
Pluggable database created.
SQL>

SQL> alter pluggable database INVENTORYPDB OPEN;
Pluggable database altered.

SQL> select name,open_mode from v$pdbs;
NAME            OPEN_MODE
--------------- ----------
PDB$SEED        READ ONLY
..
INVENTORYPDB    READ WRITE
SQL>