Login  Register

Online Patch Enabling Patch Is Failing on ADZDPREP.sql

classic Classic list List threaded Threaded
2 messages Options Options
Embed post
Permalink
Reply | Threaded
Open this post in threaded view
| More
Print post
Permalink

Online Patch Enabling Patch Is Failing on ADZDPREP.sql

Mansoor8810
1 post
DOC> ***************************************************
DOC> Move XML SCHEMA to a Non-Editioned E-biz user (APPS_NE)
DOC>
DOC>#
begin
*
ERROR at line 1:
ORA-20001: ORA-01453: SET TRANSACTION must be first statement of transaction
ORA-06512: at "APPS.AD_ZD", line 29
ORA-06512: at "APPS.AD_ZD_PREP", line 423
ORA-06512: at line 3
Restarted: file ADZDPREP.sql on worker 1 for product ad username APPLSYS.
FAILED: file ADZDPREP.sql on worker 1 for product ad username APPLSYS.

ATTENTION: All workers either have failed or are waiting:

       FAILED: file ADZDPREP.sql on worker  1.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.


We are upgrading with database version is 11.2.0.4.

There are no errors in compiling the pacakge.

SQL> alter package AD_ZD_PREP compile body;

Package body altered.

The actual error is happening while moving XML shchema in

ADZDPREP.sql script.

Move XML SCHEMA to a Non-Editioned E-biz user (APPS_NE)

begin
ad_zd.log('adzdprep', 'STATEMENT','Move XML SCHEMA: begin');
ad_zd_prep.move_xml_schemas;
ad_zd.log('adzdprep', 'STATEMENT','end');
end;
/
yes I verified MOS Doc ID 1630377.1.The XDB_MIGRATESCHEMA package is valid in our environment.
So that document is not helpful.

SQL> select object_name,object_type,status from dba_objects where object_name ='XDB_MIGRATESCHEMA';

OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE         STATUS
------------------- -------
XDB_MIGRATESCHEMA
PACKAGE             VALID

XDB_MIGRATESCHEMA
PACKAGE BODY        VALID
Reply | Threaded
Open this post in threaded view
| More
Print post
Permalink

Re: Online Patch Enabling Patch Is Failing on ADZDPREP.sql

ErmanArslansOracleBlog
Administrator
5727 posts
I didn't share that MOS note to be followed line by line. It is a guidance.
There you see that there is a code misalignment.. And in your case, you too have a misalignment in code level.  Here is why -> ORA-01453: SET TRANSACTION must be first statement of transaction..

So review your before-actions. Any missing patches or patching actions before this online patching enablement patch?

As that MOS note suggest run ETCC and see if there is anything extra is missing..