Configuring Oracle

To use Rational® ClearQuest® with Oracle databases, you must install a supported version of Oracle on your database server.

Tip: Oracle is a case-sensitive database. Case sensitivity applies to data only. If you are using Rational® ClearQuest® MultiSite or want to migrate to a different vendor database, evaluate your database case-sensitivity settings.
Note: For detailed instructions on completing the tasks in the following workflow, consult your Oracle software documentation.
Table 1.
Tasks Information
Install a supported version of Oracle
Create your Oracle databases

When you set up your Oracle databases, you must create an Oracle database instance or identify one to use for Rational® ClearQuest® data.

The code set selected for your Oracle database must support the Rational® ClearQuest® data code page value you intend to use for your database set. For more information, see Code pages and national language support
Log in to the Oracle Enterprise Manager Database Control page for the database you just created When you log in, select Normal in the Connect As field.
Create a permanent and temporary tablespace for the databases you have created The Permanent Tablespace stores your actual data such as user database records. The Temporary Tablespace is used for processing requests to the Permanent Tablespace.
Create User logins The schema repository and user database must each have its own user login.