ORA-7445 [qctcopn] or various ORA-600 during complex view merging (Doc ID 2441435.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

Whenever customer performs a specific SQL, ct faced an error ORA-7445 [qctcopn].

Call stack:

skdstdst <- ksedst1 <- ksedst <- dbkedDefDump <- ksedmp
<- ssexhd <- sighandler <- qctcopn <- qctcpqb <- qctcpqbl
<- qctcpqb <- qctcpqbl <- xtydrv <- kkqcttcalo <- kkqctdrvIT
<- apadrv <- opitca <- kksFullTypeCheck <- rpiswu2 <- kksLoadChild
<- kxsGetRuntimeLock <- kksfbc <- kkspsc0 <- kksParseCursor <- opiosq0
<- kpooprx <- kpoal8 <- opiodr <- ttcpip <- opitsk
<- opiino <- opiodr <- opidrv <- sou2o <- opimai_real
<- ssthrdmain <- main <- libc_start_main <- start

Changes

If you see ORA-7445[qctcopn] or ORA-600 on certain query and it is resolved
after disabling complex view merging, you may have encountered this bug 23312077.

Here are the scenario for reproduction as follows:
.
1. Setup for testcase
=====================
.
$ sqlplus '/as sysdba'
SQL> setup.sql
.
$ tar xvf deleteme.tar
$ cd deleteme
$ export NLS_LANG=American_America.UTF8
$ imp system/<PASSWORD> fromuser=AAAA touser=AAAA file=AAAA.dmp
$ imp system/<PASSWORD> fromuser=BBBB touser=BBBB file=BBBB.dmp
$ imp system/<PASSWORD> fromuser=CCCC touser=CCCC file=CCCC.dmp
.
.
2. reproduces the issue ORA-07445 [qctcopn()+49]
================================================
.
$ sqlplus <USER>/<PASSWORD>
SQL> @test.sql

Please find attached.

  - setup.sql
  - deleteme.tar

Cause

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