mth_pre_upgrade.sql Failed While Applying EBS Patch 9239090

This error may occur when you try to re-apply the patch 9239090 (EBS 12.1.3), because the mth_pre_upgrade.sql tries to create a table named “MTH.MTH_RESOURCES_D_TEMP” without checking if it exists. All you need is to drop that table and restart the worker. Connect your database as sys/system, and issue the command:

Then run adctrl, enter 2 (Tell worker to restart a failed job), and then enter the number of the failed worked. ADPatch will continue to apply the patch.

Please share
  •  
  •  
  •  
  •  
  •  
  •  
  •  

Gokhan Atil is a database administrator who has hands-on experience with both RDBMS and noSQL databases, and strong background on software development. He is certified as Oracle Certified Professional (OCP) and is awarded as Oracle ACE (in 2011) and Oracle ACE Director (in 2016) for his continuous contributions to the Oracle users community.

Leave Comment

Your email address will not be published. Required fields are marked *