My Oracle Support Banner

Dropping a User Cascade from the EM Console Fails with ORA-7445 [_memcpy()+976] (Doc ID 1121949.1)

Last updated on FEBRUARY 03, 2022

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.Symptoms

Dropping a user cascade from the Enterprise Manager console fails with the following error:

ORA-07445: exception encountered: core dump [_memcpy()+976] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []

The call stack contains the following functions:

<- memcpy <- qmtCopySharedStr <- qmtLoadSharedData <- qmtbInit
<- qmtInit <- qm_init_sga_pass1 <- qm_init_uga_helper <- rpiswu2 <- qm_run_as_ksys

Once a drop user cascade fails, any attempts to run utlrp.sql after that will hang.
Although the drop user cascade fails, all of the user's objects are removed. 

Attempting to drop a user without cascade just hangs.

The following error may also be encountered:

ORA-00600: internal error code, arguments: [qmtInit1], [], [], [], [], [], [], []

The LD_LIBRARY_PATH is set correctly on the database server:

ORACLE_HOME =        /oracle/product/10.2.0
LD_LIBRARY_PATH = /oracle/product/10.2.0/lib


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

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