You can set up an Oracle database to work with Rational® Focal Point™.
Before you begin
Install an Oracle database. For instructions, see your Oracle
documentation or consult an Oracle database administrator (DBA).
Procedure
- Create an Oracle instance. Make sure that the NLS_SORT parameter
is set to BINARY_CI.
- Create a database schema for Rational Focal Point. To store the Unicode characters as supported in the product,
ensure that the database is created with a Unicode character set;
for example, AL32UTF8.
- Create a user to hold the schema for Rational Focal Point.
For example, CREATE USER focalpoint IDENTIFIED BY focalpoint.
- Create three table spaces: FP_DATA, FP_INDEX and FP_BIGOBJ. Example : The example below shows a create statement executed
on a Windows® machine to create a tablespace
CREATE BIGFILE TABLESPACE FP_INDEX DATAFILE 'C:\oracle\oracle_tbs_windows\FP_INDEX.dbf' SIZE 1G AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE;
Note: The
tablespace can have any of these properties:
- A name other than oracle_tbs.
- A location in another directory.
- A size larger or less than 1GB.
- For large installations, you need to allocate more space.
- On the newly created table spaces, grant unlimited quota
to the focalpoint user.
- Create a file named create_focalpoint_oracle.sql that
contains the following code:
GRANT ALTER ANY INDEX TO &1;
GRANT ALTER ANY TABLE TO &1;
GRANT CREATE PROCEDURE TO &1;
GRANT CREATE SEQUENCE TO &1;
GRANT CREATE SESSION TO &1;
GRANT CREATE TABLE TO &1;
GRANT CREATE TABLESPACE TO &1;
GRANT CREATE VIEW TO &1;
- In SQL*Plus, enter create_focalpoint_oracle.sql as system with
the focalpoint user as the first parameter. For
example, @create_focalpoint_oracle.sql focalpoint.
- Add the JDBC driver to the library location.
- For example: On Apache Tomcat server, add the JDBC driver to <application
server>\common\lib location
- For example: On WebSphere® Application Server,
add the JDBC driver to <application server>\lib location
Note: The JDBC driver is included with the Oracle database installation.
You can also download it from the Oracle website.