ORA-02042 too many distributed transactions 原因: The distributed transaction table is full because too many distributed transactions are active. 方法: Increase the DISTRIBUTED_TRANSACTIONS parameter in the initialization parameter file, shut down and restart Oracle, or run fewer transactions. If it is certain there are not too many concurrent distributed transactions, this may be an internal error. In this case, contact customer support. Shutting down and restarting the instance could be a work-around.
ORA-02042 too many distributed transactions Cause: The distributed transaction table is full because too many distributed transactions are active. Action: Increase the DISTRIBUTED_TRANSACTIONS parameter in the initialization parameter file, shut down and restart Oracle, or run fewer transactions. If it is certain there are not too many concurrent distributed transactions, this may be an internal error. In this case, contact Oracle Customer Support. Shutting down and restarting the instance could be a workaround
Cause: The distributed transaction table is full because too many distributed transactions are active. Action: Increase the DISTRIBUTED_TRANSACTIONS parameter in the initialization parameter file, shut down and restart Oracle, or run fewer transactions. If it is certain there are not too many concurrent distributed transactions, this may be an internal error. In this case, contact Oracle Customer Support. Shutting down and restarting the instance could be a workaround
init.ora文件
增加
distributed_transactions = 500的数量