ORA-02047: cannot join the distributed transaction

Current Database details:

- Oracle Database 10g EE 10.2.0.5.0  

- Linux x86_64

Error:

ORA-02047: cannot join the distributed transaction in progress.

WARNING:Could not increase the asynch I/O limit to 480 for SQL direct I/O

Cause:

The user was facing issue with his one of the job which was failed due to below error message.
The problem was due to aio-max-size in #cd /proc/sys/fs/aio-max-size on linux server was not set, the default is 128

Solution:

To ensure ASYNC I/O can be performed by Oracle Database, you need to verify or set the following parameters in the Database:

SQL> alter system set disk_asynch_io=true scope=spfile;         

SQL> alter system set filesystemio_options=setall scope=spfile;  

Need to  shutdown and startup the database and check if the warning reappears.

Current:

NAME                     TYPE        VALUE

------------------------ ----------- -------

disk_asynch_io           boolean     FALSE

filesystemio_options     string      NONE

New:

NAME                     TYPE        VALUE

------------------------ ----------- -------

disk_asynch_io           boolean     TRUE

filesystemio_options     string      SETALL

Thanks for reading this post ! Please comment if you like this post ! Click on FOLLOW to get next blog updates !