You can set up an Oracle database to work with Rational® Focal Point™.
Before you begin
An Oracle database version that is supported by
Rational Focal Point must
be installed. For instructions, see your Oracle documentation or consult
an Oracle database administrator (DBA).
Procedure
Before you install Rational Focal Point,
make sure that the following database configurations are completed.
For instructions to configure the database, see the Oracle database
documentation.
- 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,
make sure 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. In the following example, a create statement is entered on
a Windows machine to create a table space:
CREATE BIGFILE TABLESPACE FP_INDEX DATAFILE 'C:\oracle\oracle_tbs_windows\FP_INDEX.dbf' SIZE 1G AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE;
Note: The
table space can have any of these properties:
- A name other than oracle_tbs.
- A location in another directory.
- A size larger or less than 1 GB. For large installations, you
must 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. The
JDBC driver is included with the Oracle database installation. You
can also download it from the Oracle website.
- For example, on Apache Tomcat server, add the JDBC driver to application
server\common\lib. You must add ojdbc14.jar driver
for Oracle 10g and ojdbc6.jar driver for Oracle
11g.
- For example, on WebSphere® Application Server,
add the JDBC driver to application server\lib.
You must add ojdbc6.jar from Oracle 11g for both
Oracle 10g and Oracle 11g versions.