Oracle 9 databases must be operated using the client for Oracle 10. Please observe the following:
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
<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
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
password the password of the database
system and as
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
NLS_LENGTH_SEMANTICS must have been set
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
Language_Country.UTF8. In this
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
must not be used in your Oracle environment.
The Tcl scripts with which the databases are installed are located
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
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;