Oracle

Oracle 9 databases must be operated using the client for Oracle 10. Please observe the following:

The LD_LIBRARY_PATH of the database user needs to point to the oracle10/lib directory. If this environment variable contains the library paths of more than one Oracle client versions, oracle10/lib must be found first.
Please check whether the database configuration file pointed to from within instance/instance_name/config/server.xml (mostly <database fileName="oracle.xml" />) has the proper format. When using the Oracle 10 client, it should look as follows (and contain the correct login data):
```
<?xml version="1.0"?>
<configuration>
    <adaptor>oracle</adaptor>
    <version>10</version>
    <server>ORACLE</server>
    <user>user</user>
    <password>pass</password>
    <storeBlobsInDatabase>...</storeBlobsInDatabase>
</configuration>
```

The Oracle database client must have been installed on the system on which the CMS is to be or has been installed. This includes the installation of sqlplus on the CMS system and of the Oracle Listener on the database system. The CMS system user must be able to run sqlplus. This needs to be checked prior to installing the CMS or switching to an Oracle database by executing the following command:

sqlplus system/password@ServerId

Enter as password the password of the database user system and as ServerId the Oracle SID.

Please make sure that the required services such as the Listener or the local database are started automatically after a server restart.

Furthermore, the database server needs to be configured to use the UTF-8 character set. Prior to installing the CMS, the value of the database parameter NLS_LENGTH_SEMANTICS must have been set to CHAR (instead of BYTE) so that sufficient space is allocated for strings.

Also, for the CMS to work properly and to cooperate with the database, the environment variable ORACLE_HOME must be set correctly. The environment variable NLS_LANG needs to be set to Language_Country.UTF8. In this string, Language and Country are placeholders for valid combinations of identifiers specifying the language and the country, for example GERMAN_GERMANY.UTF8. For the valid combinations, please refer to the database documentation.
From Fiona 6.5.0, you can also use the AL32UTF8 character set, if UTF8 must not be used in your Oracle environment.

The Tcl scripts with which the databases are installed are located in share/dbInstall. Please note that no optimization parameters are used when the databases are installed. If required, they can be added manually to the respective Tcl script. For example, the operation for creating an Oracle database can be extended in share/dbInstall/oracle.tcl to control memory allocation:

DEFAULT STORAGE (INITIAL 10M NEXT 5M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0)

For further details please refer to your database documentation.

Good database performance requires that the indexes of all tables are updated regularly.

ANALYZE TABLE table_name COMPUTE STATISTICS FOR ALL
INDEXED COLUMNS FOR ALL INDEXES;