Configuring an Oracle instance

An Oracle database requires certain parameter settings and other configurations.

Before you begin

  • You must have the Oracle database installed. Ensure that you have installed the correct versions and patches. See Software Product Compatibility Reports for supported version information.
  • Ensure that the user responsible for creating and modifying the Oracle database has a specified quota (extent) assigned in the table space, even if the user was assigned an unlimited table space. Otherwise, the installer might display the error ORA-09150: no privileges on tablespace name.

Procedure

  1. Run the create instance procedure. Use AL32UTF8 as the character set.
  2. Configure the INIT<INSTANCE_NAME>.ORA file.
    The following parameter settings are required:
    Parameter Parameter Definition Value
    OPEN_CURSORS Number of open cursors Greater than or equal to 2000
    SHARED_POOL_SIZE Shared pool size Greater than or equal to 90000000
    LARGE_POOL_SIZE Large pool size Greater than or equal to 614400
    JAVA_POOL_SIZE Java pool size Greater than or equal to 20971520
    PROCESSES Number of processes Greater than or equal to 500

    Must be greater than the number of connections that are required by Sterling B2B Integrator (sum of transactional or local and NoTrans pools in jdbc.properties), and operational management tools.
    LOG_BUFFER Log buffer Greater than or equal to 163840
    DB_BLOCK_SIZE Database block size Greater than or equal to 8192
      Maximum extends Unlimited
      Character set AL32UTF8
    NLS_LENGTH_SEMANTICS NLS Length semantics CHAR

    When you change the multi-byte character set to CHAR, Oracle reserves space equivalent to "n" characters, which is more than "n" bytes.
    SGA_MAX_SIZE SGA maximum size 1 GB to n GB, depending on the amount of physical memory on your database server. If the server is running only this database, up to 80% of physical memory.
    SGA_TARGET SGA components total size 1 GB to n GB, depending on the amount of physical memory on your database server. If the server is running only this database, up to 80% of physical memory.
    PGA_AGGREGATE_TARGET PGA target aggregate memory 1 GB to n GB, depending on the amount of physical memory on your database server. If the server is running only this database, up to 80% of physical memory.
    cursor_sharing Cursor sharing exact
    timed_statistics Timed Statistics true
    optimizer_mode Optimizer mode All_rows
    Note: After you complete the installation of Sterling B2B Integrator with Oracle, you can improve the performance of the database with the settings listed in the Oracle Database Configuration and Monitoring.
  3. Identify or create a table space for user tables and indexes.
  4. Create a user.
    Unless stated for a task, the user does not require database administrator (DBA) privileges.
  5. Grant permissions to the user.
    The following permissions are required for the administrative user for creating and modifying the Oracle database:
    • GRANT "CONNECT" TO SI_USER
    • ALTER USER SI_USER DEFAULT ROLE "CONNECT"
    • GRANT CREATE SEQUENCE TO SI_USER
    • GRANT CREATE TABLE TO SI_USER
    • GRANT CREATE TRIGGER TO SI_USER
    • GRANT SELECT ON CTXSYS.CTX_USER_INDEXES TO SI_USER
    • GRANT SELECT ON SYS.DBA_DATA_FILES TO SI_USER
    • GRANT SELECT ON SYS.DBA_FREE_SPACE TO SI_USER
    • GRANT SELECT ON SYS.DBA_USERS TO SI_USER
    • GRANT SELECT ON SYS.V_$PARAMETER TO SI_USER
    • GRANT SELECT ANY DICTIONARY TO SI_USER
    • GRANT ALTER SESSION TO SI_USER
    • GRANT CREATE SESSION TO SI_USER
    • GRANT CREATE VIEW TO SI_USER.
  6. If you are using Oracle AQ, grant the AQ_ADMINISTRATOR_ROLE permission.