B.5 Manual Oracle Instance Creation (Optional)

Novell recommends using the Sentinel installer to create the Oracle instance during the Sentinel database components installation. Sentinel 6.1 supports both dedicated server and shared server connection with Oracle. However, performance is better in a dedicated server connection when compared to a shared server connection. This procedure is applicable if it is a corporate policy that the DBA create the Oracle instance. The tablespaces must be named exactly as specified.

  1. Log in as an Oracle user.

  2. Use the Oracle Database Assistant GUI to create the following:

    The database initialization parameter values might vary depending on your system configuration and requirements. Consult your DBA.

    Oracle 11g Parameters

    Value

    memory_max_target

    700MB

    memory_target

    650MB

    open_cursors

    500

    cursor_sharing

    SIMILAR

    optimizer_index_caching

    50

    optimizer_index_cost_adj

    55

    nls_length_semantics

    CHAR

    job_queue_processes

    10

    Oracle 10g Parameters

    Value

    db_cache_size

    1 GB

    java_pool_size

    33,554,432

    large_pool_size

    8,388,608

    shared_pool_size

    100 MB

    pga_aggregate_target

    150,994,944

    sort_area_size

    109,051,904

    open_cursors

    500

    cursor_sharing

    SIMILAR

    optimizer_index_caching

    50

    optimizer_index_cost_adj

    55

    nls_length_semantics

    CHAR

    job_queue_processes

    10

  3. Create Sentinel tablespaces.

    For more information, see Section C.1.2, Creating the Sentinel Tablespaces.

  4. Run the createEsecdba.sh script found in the sentinel\dbsetup\bin directory on the Sentinel Installation CD.

    This script creates the user esecdba, which is required to add the database objects through the Sentinel installer.

  5. Back up the database.

For more information on installing the Sentinel database on Oracle database, see Section 3.6, Custom Installation.