EBS ADOP Phase Failing Due to ORA-600 Error
There’s an issue in EBS 12.2 and database 12.1.0.2 versions
related to Materialized Views. While executing ADOP (prepare, apply, finalize
or cutover) phases, the cycle could fail due to an ORA-600 : internal error code,
arguments: [kqllod:no stub for dependency parent] error.
After working with Oracle, they provided information about BUG
27883586 related to MView Refresh or Create while they are editioned.
The solution is to apply patch 27883586 to the database which is
currently available for August 2017 release and then recreate the MViews.
Oracle also released a merge patch on top if this (28820125).
If you need it for a different release, please contact Oracle to
provide it.
Happy patching,
Alfredo
posted by Alfredo Krieg @ 8:00 PM
1 Comments
1 Comments:
great note, today I had a similar issue on cutover adop phase, I was checking on the net and I found this note from a good fried, as an additional comment I have applied the following patch on DB side, this patch is for have more details about the DB objects in conflict
Patch: 19953905
Before Patch application:
Fri Mar 15 13:38:12 2019
Errors in file /u01/ebs/dev/12.1.0/admin/EBSSUPT_piaddevebsdb1/diag/rdbms/ebssupt/EBSSUPT/trace/EBSSUPT_ora_19120.trc (incident=296022):
ORA-00600: internal error code, arguments: [kqllod:no stub for dependency parent], [], [], [], [], [], [], [], [], [], [], []
After patch application
Fri Mar 15 13:54:21 2019
Errors in file /u01/ebs/dev/12.1.0/admin/EBSSUPT_piaddevebsdb1/diag/rdbms/ebssupt/EBSSUPT/trace/EBSSUPT_ora_30970.trc (incident=327856):
ORA-00600: internal error code, arguments: [kqllod:no stub for dependency parent], [XXBLA_DMRT_UTILS_PKG], [], [173], [9], [APPS], [1035232], [1075], [], [], [], []
Incident details in: /u01/ebs/dev/12.1.0/admin/EBSSUPT_piaddevebsdb1/diag/rdbms/ebssupt/EBSSUPT/incident/incdir_327856/EBSSUPT_ora_30970_i327856.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Fri Mar 15 13:54:24 2019
Dumping diagnostic data in directory=[cdmp_20190315135424], requested by (instance=1, osid=30970), summary=[incident=327856].
Fri Mar 15 13:54:24 2019
Errors in file /u01/ebs/dev/12.1.0/admin/EBSSUPT_piaddevebsdb1/diag/rdbms/ebssupt/EBSSUPT/trace/EBSSUPT_ora_30976.trc (incident=327857):
ORA-00600: internal error code, arguments: [kqllod:no stub for dependency parent], [XXBLA_INV_ORG_V], [], [173], [4], [APPS], [1669770], [710], [], [], [], []
Incident details in: /u01/ebs/dev/12.1.0/admin/EBSSUPT_piaddevebsdb1/diag/rdbms/ebssupt/EBSSUPT/incident/incdir_327857/EBSSUPT_ora_30976_i327857.trc
In mi case two objects, one view and one package were the objects in conflict, (XXBLA_DMRT_UTILS_PKG and XXBLA_INV_ORG_V) after that I had to drop, execute cutover and then recreate the objects) now I am checking with Oracle support for check if there is a patch for does not have this kind of errors when the objects are views and packages
Good Job Alfred
Regards
Carlos Romero
Post a Comment
Subscribe to Post Comments [Atom]
<< Home