CSE Installation and Configuration › Prerequisites for CSE Configuration › Configuring Databases › New Encyclopedia and Coordination Databases

New Encyclopedia and Coordination Databases

During installation, CA Gen copies files from the installation media into the directory. The CSE installation and database installation can occur in any order. However, the databases that the CSE Servers use must be running and accessible by the account executing CSE configuration before CSE configuration starts.

The CSE installation kit includes sample files to create Oracle database instances. When you plan a CSE Server installation using an Oracle database, install the CSE Server software and review these files before creating the Oracle database instance.

To maintain security, CSE configuration does not perform operations that require DBA privileges, including creating an empty database, providing file system space for the database, and authorizing user access to the database. Meet these requirements or secure assistance from the Database Administrator of the system. CSE configuration verifies it can access the database while it collects the configuration information.

CSE configuration supports configuring the Coordination tables and the Encyclopedia tables in the same database or in separate databases. Configuring both sets of tables in the same database reduces system overhead and has some advantages in a single encyclopedia configuration.

The disadvantage of putting the Coordination Tables and Encyclopedia tables in the same database in a multiple encyclopedia configuration is that if you shutdown that database, the entire CSE Server network shuts down because the Coordination Server loses access to the Coordination tables.

When configuring a simple single Encyclopedia network, create one database for the encyclopedia and put Coordination and Encyclopedia tables in that database. When configuring a multiple encyclopedia network, create separate databases for the Coordination and Encyclopedia tables.

You can change the database configuration later. Use the CSE configuration tool after the initial configuration is complete to create tables in a different database. Be familiar with the database tools for exporting and importing data to complete the process.