Oracle version 12.1.0.2.0 (12c r1) or greater is required.
Install Notes
- Schema names are case sensitive as of Oracle 12 and need to be in all caps in the PCR-360 config file to avoid errors
- Included in the installation package is a file named oracle-create.sql; log into the main schema and execute these commands. Also included is a file named oracle-create-metadata.sql; log into the metadata schema and execute these commands.
Installation
We highly recommend installing Oracle on a dedicated database server. To communicate with Oracle on that server completing this installation will require the username, password, hostname, port (e.g. 1521) and SID.
Download and install the Oracle Instant Client on the PCR-360 application server. This is required before installing the PHP oracle driver (oci8).
Required to compile OCI8 PHP module:
oracle-instantclientxx.x-basic-xx.x.x.x.x-x.x86_64.rpm oracle-instantclientxx.x-devel-xx.x.x.x.x-x.x86_64.rpm
Required to use the sqlplus interface:
oracle-instantclientxx.x-sqlplus-xx.x.x.x.x-x.x86_64.rpm
Download each and install each using rpm:
rpm -ivh oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm rpm -ivh oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64.rpm rpm -ivh oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64.rpm
Install OCI8:
pecl install oci8
sqlplus Configuration
On the Oracle database server:
cd /home/oracle vi .profile
Paste in this data. Be sure to adjust for install directory and version.
ORACLE_HOME=/usr/lib/oracle/12.1/client64 PATH=$ORACLE_HOME/bin:$PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib export ORACLE_HOME export LD_LIBRARY_PATH export PATH
Save the file and enter the following command in the terminal:
source .profile
User Configuration
On the Oracle database server, create two Oracle users and two schema. These will hold the application data and the application metadata, the examples below use pcr360_prod and pcr360_prod_metadata.
Impersonate the oracle user and login to the database. This requires sqlplus to be installed and configured:
sudo su su oracle sqlplus / as sysdba
Grant the required permissions to the users. Be sure to modify the passwords.
CREATE USER pcr360_prod IDENTIFIED BY password1; CREATE USER pcr360_prod_metadata IDENTIFIED BY password2; 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_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;