Oracle Management Database Considerations › Oracle Database Installation, Configuration, and Deployment › Processes Parameter

Processes Parameter

The default value for this parameter is 150 which is acceptable for the majority of MDB deployments.

Character Sets

Choose from one of the following options:

• Choose Default if you only need the MDB to support the language currently used by the operating system.
• Choose Unicode (AL32UTF8) if your MDB needs to support multiple languages.

Connection Mode

When setting up connections, the Oracle MDB Dedicated Server Mode is recommended so there is a dedicated server process for each user process. Dedicated Server Mode is used when the number of total clients is small, or with persistent long-running requests to the database.

Redo Log Files

A database has a minimum of two redo log groups. A typical configuration has three redo log groups. Multiplexing of the redo log files is highly recommended.

MDB Database Users

When the MDB is created, a user named MDBADMIN is created. MDBADMIN is the user that owns the MDB database.

An Oracle user with SYSDBA privileges is required to create the MDB. This user's password should be specified when creating the MDB. If no user is specified when the MDB is created, the SYS user will be used and its password will be required. However, use of the SYS and SYSTEM accounts should be avoided when creating or making changes to the MDB schema.

The Oracle user you use to run the MDB installation must have the following database administrator privileges:

• The dba role (connect sys as sysdba; grant dba to installation_user;)
• The sysdba role (connect sys as sysdba; grant sysdba to installation_user;)
• The privilege to grant the mdbadmin user various privileges to the system tables and views (connect sys as sysdba; grant all privileges on "sys". TABLE_NAME" to installation_user with grant option;)
• The values to be assumed by TABLE_NAME are:

  COL$, DBA_CONSTRAINTS, DBA_CONS_COLUMNS, DBA_INDEXES, DBA_IND_COLUMNS, DBA_OBJECTS, DBA_OBJECT_TABLES, DBA_REGISTRY, DBA_TABLES, DBA_TABLESPACES, DBA_TAB_COLUMNS, DBA_TAB_PRIVS, DBA_VIEWS, DBMS_REGISTRY, EXPDEPACT$, EXPDEPOBJ$, EXPPKGACT$, EXPPKGOBJ$, KOPM$, OBJ$, TS$, USER$