4.1.2 Setting the database environment (Setting Oracle)
This section describes the settings that must be specified on the database side if you are using Oracle JDBC Thin Driver. For more information, see the Oracle documentation.
-
Granting the permissions necessary to perform transaction recovery
The following permissions must be granted to users who connect to Oracle Database for such users to be able to use global transactions:
-
SELECT permission of SYS.DBA_PENDING_TRANSACTIONS
-
FORCE ANY TRANSACTION permission
-
Permission to EXECUTE the SYS.DBMS_SYSTEM
For details on how to give permission, see Oracle manual.
-
-
Setting access permission for dynamic performance view
User connecting to Oracle must have permission to access the dynamic performance view. Set the permission to access the dynamic performance view for the users connecting to Oracle with one of the following methods:
-
Run GRANT SELECT_CATALOG_ROLE TO User name;
-
Run GRANT SELECT ON V_$INSTANCE TO User name; ,GRANT SELECT ON V_$PROCESS TO User name; and GRANT SELECT ON V_$SESSION TO User name;
-
-
Setting Timeout
Set in the DISTRIBUTED_LOCK_TIMEOUT parameter of the Oracle Server definition.
Note that other than the DISTRIBUTED_LOCK_TIMEOUT parameter, settings of the SesTmm parameter of XAOpenString affect the timeout; however, this parameter cannot be tuned.
For details, see the following subsections or manuals:
-
8.6.6 Setting the database timeout in the uCosminexus Application Server System Design Guide
-
8.6.8 Tuning parameters for setting the timeout in the uCosminexus Application Server System Design Guide
-
Oracle manual
-