1 Install Oracle by following the manufacturer’s instructions.
2 Open the Oracle Database Configuration Assistant.
3 Create a database schema for Focal Point®:
▪ Select Create a Database, and then click Next.
▪ Choose the General Purpose or Transaction Processing template, and then specify a name in the Global Database Name and the SID text boxes. For example, set the Global Database Name to focalpoint and SID to focalpoint. Click Next.
▪ In the Enterprise Manager tab, make sure that Configure Enterprise Manager is not selected. Click Next.
▪ Select Use the Same Administrative Password for All Accounts, and then specify a password. Enter the password again to confirm, and then click Next.
▪ Select Use Common Location for All Database files, and then browse to locate the database files. Click Next.
▪ Retain the default settings for the databases recover options. Click Next.
▪ To store the Unicode characters as supported in the product, make sure that the database is created with a Unicode character set: Select Use Unicode (AL32UTF8), and click Next.
▪ Click Next, and then click Finish.
4 Create a text file called create_focalpoint_oracle.sql that contains the SQL code that is shown in SQL code for Oracle.
Change the parameters to match your environment.
The table space can have:
▪ any name (it does not have to be oracle_tbs)
▪ any location (it can be in any directory
▪ any size (it can be bigger or smaller than 1 GB. For large installations, you must allocate more space).
5 In SQL*Plus, execute the create_focalpoint_oracle.sql file.
6 Locate the JDBC driver for JRE8 and the Oracle version that you are using. The JDBC driver is included with the Oracle database installation. You can also download the driver from the Oracle website.
▪ For Oracle 11g and 12c, you need the ojdbc6.jar driver
▪ For Oracle 18c, you need the ojdbc7.jar driver.
▪ For Oracle 19c, you need the ojdbc8.jar driver.
7 Add the JDBC driver to the library location.
▪ On Apache Tomcat server, add the JDBC driver to application server\common\lib.
▪ On WebSphere® Application Server, add the JDBC driver to application server\lib.
========================================================== ALTER SESSION SET NLS_SORT=BINARY_CI;
--- Ensure that the environment variable for the Oracle directory is set.
CREATE BIGFILE TABLESPACE FP_DATA DATAFILE '/home/oracle/RFP/FP_DATA.dbf' SIZE 1G AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE;
CREATE BIGFILE TABLESPACE FP_INDEX DATAFILE
'/home/oracle/RFP/FP_INDEX.dbf' SIZE 1G AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE;
CREATE BIGFILE TABLESPACE FP_BIGOBJ DATAFILE
'/home/oracle/RFP/FP_BIGOBJ.dbf' SIZE 1G AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE;
===========================
--Create a user to hold the schema for Focal Point
======================================
CREATE USER focalpointdbuser IDENTIFIED BY Unicom123; GRANT UNLIMITED TABLESPACE TO focalpointdbuser; GRANT ALTER Any INDEX TO focalpointdbuser;
GRANT ALTER Any TABLE TO focalpointdbuser; GRANT CREATE TABLESPACE TO focalpointdbuser; GRANT ALTER SESSION TO focalpointdbuser; GRANT CREATE TABLE TO focalpointdbuser; GRANT CREATE SESSION TO focalpointdbuser; GRANT CREATE VIEW TO focalpointdbuser;
GRANT CREATE SEQUENCE TO focalpointdbuser; GRANT CREATE PROCEDURE TO focalpointdbuser; ALTER USER focalpointdbuser DEFAULT ROLE ALL;