Configuring Oracle
To use HCL Compass 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 HCL Compass
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.
| 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 HCL Compass data. The code set selected for your Oracle database must support the HCL Compass 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. |