ETL Job Fails With ORA-00166 After Patching
(Doc ID 3025230.1)
Last updated on MAY 29, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.22.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
On : 19.22.0.0.0 version, Exa-Internals Errors (ORA-600 & ORA-7445)
ETL Job fails with ORA-00166 after patching
After patching an Exadata machine with RU 19.22.0.0.0 from 19.19.0.0.0. However, after patch was applied Data Loading jobs now fail/terminate with remote/local nesting level is too deep error. The job runs for about an hour loading some tables before failing, even after a manual re-run. There's no current workaround.
The data load (ETL) job creates dynamic sql (merge commands) to insert/update existing table over a dblink (remote DB), then runs each sql (one per table).
DBaaS Exadata
Oracle Lunix: 8.9
Need help to determine what has changed with the latest patch set. As these jobs have always worked through previous patching cycles. Could this be parallelism related?
ERROR
-----------------------
ORA-00166, ORA-00603, ORA-03114
----- Incident Context Dump -----
Address: 0x7feecbfefe40
Incident ID: 345677
Problem Key: ORA 603
Error: ORA-603 [] [] [] [] [] [] [] [] [] [] [] []
[00]: dbgexProcessError [diag_dde]
[01]: dbgePostErrorKGE [diag_dde]
[02]: dbkePostKGE_kgsf [rdbms_dde]
[03]: kgeade []
[04]: kgefecl []
[05]: ksupop [ksu]<-- Signaling
[06]: ktslagsp_main [Space]
[07]: kdliAllocCache [LOB_INODE]
[08]: kdliAllocBlocks [LOB_INODE]
[09]: kdliAllocChunks [LOB_INODE]
[10]: kdliWriteInit [LOB_INODE]
[11]: kdliWriteV [LOB_INODE]
[12]: kdli_fwritev [LOB_INODE]
[13]: kdlxNXWrite [LOB_KDLX]
[14]: kdlx_write [LOB_KDLX]
[15]: kdlxdup_write1 [LOB_KDLXDUP]
[16]: kdlw_write [LOB_KDLW]
[17]: kdld_write [Data]
[18]: kdla_write [LOB_KDLA]
[19]: kdlf_write [Data]
[20]: koklccb [LOB_API]
[21]: kpulbcr [PROGINT]
[22]: ttcdrv []
[23]: nioqwa []
[24]: upirtrc []
[25]: kpurcsc [PROGINT]
[26]: kpulrcsc [PROGINT]
[27]: kpulfrdarr [PROGINT]
[28]: kpulfrd [PROGINT]
[29]: OCILobRead2 []
[30]: koklicrl [LOB_Default]
[31]: koklcre [LOB_API]
[32]: kokleva [LOB_API]
[33]: evaopn2 []
[34]: qesltcEvalOutofLineCols [SQL_Execution]
[35]: qesltcBeforeRowProcessing [SQL_Execution]
[36]: qerltcNoKdtBufferedInsRowCBK [SQL_Execution]
[37]: qerusRop [SQL_Execution]
[38]: qerstRowP [Time_Limit]
[39]: qerstRowP [Time_Limit]
[40]: qervwRowProcedure [SQL_Execution]
[41]: qerstRowP [Time_Limit]
[42]: qerflRop [SQL_Execution]
[43]: qerstRowP [Time_Limit]
[44]: qerpxFetch [Parallel_Execution]
[45]: qerstFetch [Time_Limit]
[46]: qerflFetchOutside [SQL_Execution]
[47]: qerstFetch [Time_Limit]
[48]: qervwFetch [SQL_Execution]
[49]: qerstFetch [Time_Limit]
Changes
Upgrade to RU 19.22.0.0.0 from 19.19.0.0.0
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |