Re: patch issue

Posted by ErmanArslansOracleBlog on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/patch-issue-tp4594p4596.html

You have multiple ORA- errors , but the following one is crucial.

ALTER INDEX FA.FA_MASS_ADDITIONS_N1 STORAGE (FREELISTS 4)

AD Worker error:
The following ORACLE error:

ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

I guess there is a transaction left there.

This is 12.1 . So patches are not online.
Stop apps services.
Restart db.
enable maintanence mode and retry.

Update me with the outcome.


you have also ->

Applying XDF file : /app/PMTG/apps/apps_st/appl/pji/12.0.0/patch/115/xdf/pji_pa_xbs_denorm_t.xdf
================================================================================


Table Name is PJI_PA_XBS_DENORM_T
Table exists in the target database
Checking for differences
Number of columns for the table in the xml file is 20
The table definition in the XDF is the same as the one in DB.

Executing grants on PJI_PA_XBS_DENORM_T to APPS
GRANT ALL ON PJI.PJI_PA_XBS_DENORM_T TO APPS WITH GRANT OPTION
Synonyms match.


Performing AOL meta data updates
Error during upload of Fnd_Columns
ORA-01722: invalid number
ORA-06512: at "APPS.FND_XDFDICTIONARY_PKG", line 214
ORA-06512: at "APPS.FND_XDFDICTIONARY_PKG", line 1832
ORA-01403: no data found
ORA-06512: at line 1

---->

See this -> Patch 12312729 Fails To Apply Due To ORA-01722: Invalid Number (Doc ID 1356468.1)