CSE Installation and Configuration › Prerequisites for CSE Configuration › Configuring Databases › Create Oracle CSE Database

Create Oracle CSE Database

The following files are an example for creating an Oracle Coordination and Encyclopedia database. The files are also in the cse\cse_oracle directory in the installation directory.

• initdbdir.ora – coordination database parameter file
• crdbdir.sql – SQL command file to create the coordination database and tablespaces
• crdbdir.bat – Batch script file to execute crdbdir.sql, Windows only
• initdbcse.ora - Encyclopedia database parameter file
• crdbcse.sql – SQL command file to create the Encyclopedia database tablespaces
• crdbcse.bat – Batch script file to execute crdbcse.sql to create the Encyclopedia database and tablespaces (Windows only)

Note: For CSE Servers running on a 64-bit Oracle database, the 32-bit Oracle client software must also be installed with the 64-bit Oracle database software. Install the 32-bit Oracle client software after creating ORACLE CSE database to ensure that the Oracle client bin directory precedes the Oracle server bin directory in the PATH environment variable. In this case, the 64-bit database engine and the 32-bit client library have different ORACLE_HOME values.

The CSE Server to Oracle database connection typically uses the Bequeath protocol. When the Oracle client and server installations have different ORACLE_HOME values, the Bequeath protocol is unavailable and use the database network tools to enable the use of the IPC protocol.