Getting ORA-600 error while running Generate Asset Trace program

When running the concurrent program ” Generate Asset Trace” report and the initial request for this fails, subsequent spawns of “FATRACE – SLA Sub request” continuously initiate and start to loop and it throw “ORA-00600: internal error code, arguments: [kqludp2]” continually. There is no session found in backend for this program.

Cause:

It’s a bug in database version 10 & 11 G, to overcome this Oracle provide DB patch 19393542 (OPATCH) to fix this. In order the overcome the issue temporary we need to follow the below workaround solution.

Solution:

  • Bring down Concurrent manager
  • Run the command in SYSDBA user in all the DB nodes;

EXECUTE IMMEDIATE ‘alter system flush shared_pool’;

  • Start the Concurrent manager

 

 

Recent Posts