Generating init.ora File

 The Generating init.ora File option generates an init.ora file based on your inputs for the Number of Users, Dedicated Server, Database Type,
Parallel Query Option (PQO), and so on. You can generate the init.ora file without creating the database. This option is useful when you are
migrating or upgrading your database, and you want to use the init.ora parameters added in the CES Database Server 9.1.9.

If you are migrating or upgrading your database to Oracle, you might need to compare your current init.ora parameter values with the generated
values and choose the optimal values suitable for your system.

This task explains how to generate the init.ora file:

  1. From the navigation pad, select Administration > Generate Init.ora.

    The Database Setup Information window appears.

    This table describes the fields displayed in the Database Setup Information window:

    Field

    Description

    Number of CPUs

    Enter the number of CPUs in this field.

    Physical RAM

    Enter the RAM size, and select MB or GB.

    Concurrent Users

    Select the concurrent users. The available options are:

    • Department

    • Company

    • Enterprise

    • Me

    Enter the number of users.

    Database Block Size

    Select the database block size. The available options are: 4K, 8K, 16K, and 32K.

    Server Type

    Select the server type. The available options are:

    • Dedicated Server (DS)

    • Shared Server (SS)

    Parallel Query Option

    Select the Parallel Query option. The available options are: YES, and NO.

  2. Specify the values, and then click Next.

    The Redo Log File size window appears.

  3. The recommended values displayed here are based on the values entered in the previous window. Specify the values for the Redo Log File Size. The init.ora file generated is based on this value.

  4. Click Next to proceed.

    The recommended init.ora parameters appears.

  5. Click Finish.

    You are prompted for the name of the file in which the init.ora parameter values are to be stored.

  6. Type the name, and then click OK to save the values.