My Oracle Support Banner

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 later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.