Please ensure $APPLTMP and $APPLPTMP point to the same location and can be written to by both oracle and applmgr user. Submit Gather Schema Statistics for a single schema like AK and see if it completes with the same error. If it does, you need to cross mount a directory between the database server and application server so temporary files can be written and read by both servers.
Concurrent Processing - Troubleshooting Concurrent Request ORA-20100 errors in the request logs (Doc ID 261693.1)
Thanks, As per the Apps Tier context file - the value of $APPLTMP= location in apps tier server. Whereas $APPLPTMP= location is pointing to db server. The issue was in utl_file_dir, in which the directory path's were not defined separately within quotes. After fixing it and bouncing the db tier services resolved it.,
Thanks & Regards
Sorry my mistake. Issue is still there. I am working on it....
I recommend making $APPLTMP and $APPLPTMP the same directory, mounting it to the database server via NFS, and making that directory the first directory in utl_file_dir and retesting. Once done, you should also be able to submit Gather Schema Statistics successfully.