Page Comparison

rpm -ivh oracle-instantclient18.3-basic-18.3.0.0.0-1.x86_64.rpm
rpm -ivh oracle-instantclient18.3-devel-18.3.0.0.0-1.x86_64.rpm
rpm -ivh oracle-instantclient18.3-sqlplus-18.3.0.0.0-1.x86_64.rpm
yum -y install libnsl

sh -c "echo /usr/lib/oracle/19.5/client64/lib > /etc/ld.so.conf.d/oracle-instantclient.conf";
ldconfig

sudo su
su - oracle
sqlplus / as sysdba

ALTER SESSION SET NLS_LENGTH_SEMANTICS = 'CHAR';
CREATE USER pcr360_prod IDENTIFIED BY <password>;
CREATE USER pcr360_prod_archive IDENTIFIED BY password1<password>;
CREATE USER pcr360_prod_metadata IDENTIFIED BY password2<password>;  
  
GRANT CREATE TABLE TO pcr360_prod;
GRANT CREATE SEQUENCE TO pcr360_prod;
GRANT CREATE ANY INDEX TO pcr360_prod;
GRANT CREATE PROCEDURE TO pcr360_prod;
GRANT CREATE VIEW TO pcr360_prod;
GRANT CREATE SESSION TO pcr360_prod;
GRANT ALTER ANY TABLE TO pcr360_prod;
GRANT ALTER SESSION TO pcr360_prod;
GRANT LOCK ANY TABLE TO pcr360_prod;
GRANT DROP ANY SEQUENCE TO pcr360_prod;
GRANT SELECT ON V_$SESSION TO pcr360_prod;
GRANT UNLIMITED TABLESPACE TO pcr360_prod;

GRANT CREATE TABLE TO pcr360_prod_archive;
GRANT CREATE SEQUENCE TO pcr360_prod_archive;
GRANT CREATE ANY INDEX TO pcr360_prod_archive;
GRANT CREATE PROCEDURE TO pcr360_prod_archive;
GRANT CREATE VIEW TO pcr360_prod_archive;
GRANT CREATE SESSION TO pcr360_prod_archive;
GRANT ALTER ANY TABLE TO pcr360_prod_archive;
GRANT ALTER SESSION TO pcr360_prod_archive;
GRANT LOCK ANY TABLE TO pcr360_prod_archive;
GRANT DROP ANY SEQUENCE TO pcr360_prod_archive;
GRANT SELECT ON V_$SESSION TO pcr360_prod_archive;
GRANT UNLIMITED TABLESPACE TO pcr360_prod_archive;

GRANT CREATE TABLE TO pcr360_prod_metadata;
GRANT CREATE SEQUENCE TO pcr360_prod_metadata;
GRANT CREATE ANY INDEX TO pcr360_prod_metadata;
GRANT CREATE PROCEDURE TO pcr360_prod_metadata;
GRANT CREATE VIEW TO pcr360_prod_metadata;
GRANT CREATE SESSION TO pcr360_prod_metadata;
GRANT ALTER ANY TABLE TO pcr360_prod_metadata;
GRANT ALTER SESSION TO pcr360_prod_metadata;
GRANT LOCK ANY TABLE TO pcr360_prod_metadata;
GRANT DROP ANY SEQUENCE TO pcr360_prod_metadata;
GRANT SELECT ON V_$SESSION TO pcr360_prod_metadata;
GRANT UNLIMITED TABLESPACE TO pcr360_prod_metadata;