Home

 

Changing Oracle configuration parameters

 

For each Oracle database that the queue manager is coordinating, we need to:

Review your maximum sessions

You might need to review your LICENSE_MAX_SESSIONS and PROCESSES settings to take into account the additional connections required by processes belonging to the queue manager. Refer to Database connections for more details.

Set database privileges

The Oracle user name specified in the xa_open string must have privileges to access the DBA_PENDING_TRANSACTIONS view, as described in the Oracle documentation.

The necessary privilege can be given using the following example command:

 grant select on DBA_PENDING_TRANSACTIONS to myuser; 

 

Parent topic:

Oracle configuration

fa13660_

 

Home