Configuring an Oracle database

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.

  1. Create an Oracle instance. Make sure that the NLS_SORT parameter is set to BINARY_CI.
  2. 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.
  3. Create a user to hold the schema for Rational Focal Point. For example: CREATE USER focalpoint IDENTIFIED BY focalpoint.
  4. 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.
  5. On the newly created table spaces, grant unlimited quota to the focalpoint user.
  6. 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;
  7. 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.
  8. 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.

Feedback