My Oracle Support Banner

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

Last updated on FEBRUARY 12, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 12.1.0.2 [Release 11.2 to 12.1]
Information in this document applies to any platform.

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

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.