Patch u6678700 driver (upgrade 12.1.1) : failed on XDPQFIX.sql
Patch u6678700 driver (upgrade 12.1.1) : failed on XDPQFIX.sql
Applying u6678700 driver (upgrade from 11.5.10.2 to 12.1.1) and it failed on XDPQFIX.sql with following error:
sqlplus -s APPS_APPLSYS2/***** @/opt/app/applmgr/apps/apps_st/appl/xdp/12.0.0/patch/115/sql/XDPQFIX.sql &un_xdp &pw_xdp &un_xdp
Connected.
DECLARE
*
ERROR at line 1:
ORA-24002: QUEUE_TABLE XDP.XDP_PENDING_ORDER_QTAB does not exist
ORA-06512: at "SYS.DBMS_AQADM", line 1121
ORA-06512: at line 25
I believe it is because the XDP_PENDING_ORDER_QUEUE does not exist as a queue_table. It does exist as a table.
SQL> select owner, object_name, object_type
Applying u6678700 driver (upgrade from 11.5.10.2 to 12.1.1) and it failed on XDPQFIX.sql with following error:
sqlplus -s APPS_APPLSYS2/***** @/opt/app/applmgr/apps/apps_st/appl/xdp/12.0.0/patch/115/sql/XDPQFIX.sql &un_xdp &pw_xdp &un_xdp
Connected.
DECLARE
*
ERROR at line 1:
ORA-24002: QUEUE_TABLE XDP.XDP_PENDING_ORDER_QTAB does not exist
ORA-06512: at "SYS.DBMS_AQADM", line 1121
ORA-06512: at line 25
I believe it is because the XDP_PENDING_ORDER_QUEUE does not exist as a queue_table. It does exist as a table.
SQL> select owner, object_name, object_type
Tagged:
0