Wednesday, October 14, 2015

FAILED: file mth_pre_upgrade.sql on worker 15 for product mth username MTH. R12.1.3 Upgrade

ROR No:2 ( This error will occur, if we are running the patch for the second time)

FAILED: file mth_pre_upgrade.sql on worker 15 for product mth username MTH.
sqlplus -s MTH/***** @/u01/app/oracle/EBS/apps/apps_st/appl/mth/12.0.0/patch/115/sql/mth_pre_upgrade.sql
Connected.
DECLARE
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
ORA-06512: at line 59

Time when worker failed: Mon Apr 09 2012 00:28:06
"adwork002.log" 234201L, 8356714C         
Cause : As we have already started this patch. It created the table MTH_RESOURCES_D_TEMP. Hence we have to rename this as MTH_RESOURCES_D_TEMP_OLD.


SQL> conn mth/mth
Connected.
SQL> rename MTH_RESOURCES_D_TEMP to MTH_RESOURCES_D_TEMP_OLD;

Table renamed.

SQL> exit
1) Then, restart the worker using adctrl utility.

1 comment:

  1. This comment has been removed by a blog administrator.

    ReplyDelete