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 this post Share on Facebook0Share on Google+0Share on LinkedIn0Share on Reddit0Tweet about this on Twitter

Gokhan Atil is a database administrator who has hands-on experience with both RDBMS and noSQL databases (Oracle, PostgreSQL, Microsoft SQL Server, Sybase IQ, MySQL, Cassandra, MongoDB and ElasticSearch), 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 *