Oracle Error ORA-55713: GLOBAL_TXN_PROCESSES cannot be set to 0 at runtime

Oracle 55 Views 0 Min Read

Oracle Error Message

ORA-55713: GLOBAL_TXN_PROCESSES cannot be set to 0 at runtime

Reason for the Error

An attempt was made to set initialization parameter GLOBAL_TXN_PROCESSES to 0 at runtime.

Solution

Set the initialization parameter GLOBAL_TXN_PROCESSES to 0 before starting RAC instance to disable GTX background processes. Note that XA transactions are not supported on RAC database when GTX background processes are disabled.

Tags: