Selecting from a View Across a DBLINK = ORA-7445[qcsfsqacn()+654]

(Doc ID 2316904.1)

Last updated on JULY 13, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Selecting from a view across a dblink fails with the following error:

ORA-07445: Exception aufgetreten: CORE Dump [qcsfsqacn()+654] [SIGSEGV] [ADDR:0x10] [PC:0x403968E] [Address not mapped to object] []

 

The Call Stack Trace in the associated incident trace file shows:

qcsfsqacn <- qcsfaucn <- qcstda <- qcspsec <- qcspqbDescendents
 <- qcspqb <- kkmdrv <- opiSem <- opiprs <- kksParseChildCursor
  <- rpiswu2 <- kksLoadChild <- kxsGetRuntimeLock <- kksfbc <- kkspsc0
    <- kksParseCursor <- opiosq0 <- kpooprx <- kpoal8 <- opiodr

 

Changes

This problem occurs after having upgraded the remote database to 12.2.0.1.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms