Siebel Installation Guide for UNIX: Servers, Mobile Web Clients, Tools > Configuring the RDBMS > Configuring Oracle for Siebel Applications >

Guidelines for Creating Oracle Database Objects

To help you automate creation of the Siebel Database schema, Siebel Systems provides sample scripts (CrBlankOracleSiebelDEMO.sql and CrBlankOracleSiebelDEMOPostCrDB.sql), located in the $SIEBEL_ROOT/dbsrvr/Oracle directory. Use these scripts as a reference to create scripts based on your deployment's requirements for creating database objects for the Siebel schema.

Before using these scripts, make sure you read the file CrBlankOracleSiebelDEMOReadMe.txt. See also Overview of Database Configuration.

Use a small, nonproduction environment for testing purposes.

After you install the Siebel Database Server files on the Siebel Server machine, as described in Installing the Siebel Database Server and Configuring the Siebel Database you may modify the database table and index creation scripts to specify the table space names you created for Siebel tables and indexes. For more information, see Guidelines for Overriding Oracle Default Table Spaces for Database Objects.

These settings should be used only as guidelines for your initial configuration. Your final settings will vary based on the server hardware configuration, the number of users, and the type of workload.

Additional information on Oracle configuration is available from Oracle, the hardware vendor, and other sources of documentation. Also refer to Oracle documentation for additional information concerning tuning options for Oracle.