patch issue

[Roshan]

Hi Erman,

I am currently configuring Oracle Mobile Foundations Doc ID 1642431.1.

I have some issues on application of patch for SOA Gateway.

Installing Oracle E-Business Suite Integrated SOA Gateway, Release 12.1.3 (Doc ID 556540.1)

I have performed the prerequisites from Patch 17884289.

After running adpatch, I am getting error from logfile
adwork001.log

Please advise.

Thanks,

Roshan

[ErmanArslansOracleBlog]

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)

[Roshan]

Hi,

thanks. I am still getting same error

adwork001.rar


Start time for statement below is: Fri Dec 01 2017 15:09:55

GRANT select on DBA_SOURCE to em_oam_monitor_role


Start time for statement below is: Fri Dec 01 2017 15:09:55

GRANT select on DBA_TEMP_FILES to em_oam_monitor_role


Start time for statement below is: Fri Dec 01 2017 15:09:55

GRANT select on DBA_USERS to em_oam_monitor_role


Start time for statement below is: Fri Dec 01 2017 15:09:55

GRANT select on DBA_USERS_WITH_DEFPWD to em_oam_monitor_role

AD Worker error:
The following ORACLE error:

ORA-01031: insufficient privileges


occurred while executing the SQL statement:

GRANT select on DBA_USERS_WITH_DEFPWD to em_oam_monitor_role

Error occurred in file

/appl/PMTG/apps/apps_st/appl/ad/12.0.0/patch/115/sql/ademusr.sql

with arguments '&systempwd &un_fnd &pw_fnd &un_apps &pw_apps'.


Time when worker failed: Fri Dec 01 2017 15:09:55

Regards,

Roshan

[Roshan]

Hi,

I have checked

ORA-01031 occurs while Granting SELECT on DBA_USERS_WITH_DEFPWD to em_oam_monitor_role For Patch 20395533 (Doc ID 2093641.1)

Please find below output

SQL> conn / as sysdba
Connected.
SQL>  GRANT select on APPS.FND_FORM_SESSIONS_V to PUBLIC with grant opt

Grant succeeded.

SQL> commit;

Commit complete.

SQL> conn system/qz877wr3x2bqwu9j
Connected.
SQL>  GRANT select on APPS.FND_FORM_SESSIONS_V to em_oam_monitor_role;
 GRANT select on APPS.FND_FORM_SESSIONS_V to em_oam_monitor_role
                      *
ERROR at line 1:
ORA-01720: grant option does not exist for 'APPLSYS.FND_USER'



Regards,

Roshan

[ErmanArslansOracleBlog]

Did you retry this after running adgrants.sql properly?

[Roshan]

Yes, still got same error.

I tried the workaround in the document and it is good now. Patch applied successfully

Regards,

Roshan

[ErmanArslansOracleBlog]

Okay good..
So you granted the missing grant manually then..

[Roshan]

Yes