Datapump Export Fails With ORA-07445 [nszgclient()] (Doc ID 1401443.1)

Last updated on NOVEMBER 04, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.
Checked for relevance on 03-SEP-2013

Symptoms

Datapump exports and imports may fail with ORA-07445 [nszgclient()]

/ade/b/641487818/oracle/log/diag/rdbms/a11202/a11202/trace/a11202_dm01_20416.trc
ORA-07445: exception encountered: core dump [nszgclient()+32] [SIGSEGV] [ADDR:0x4C] [PC:0xB0A3190] [Address not mapped to object] []


The typical call stack looks like this:

 

----- Current SQL Statement for this session (sql_id=8gtq2yhbhgga0) -----
INSERT INTO SYS.USER_LOGON_T SELECT SYS_CONTEXT('USERENV', 'AUTHENTICATION_METHOD') FROM DUAL
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x26d33118 2 anonymous block
nszgclient <- kziaguenv <- kzctxEUsrEnv <- kzctxAppCtxValGet <- evactx
<- evaopn2 <- qesltcFastRowOperandsEvaluate <- qerltcLoadStateMachine
<- PGOSF802_qerltcInsertSelectRop <- qerfiFetch <- rwsfcd <- qerltcFetch
<- insexe <- opiexe <- opipls <- opiodr


 

This problem is encountered only when a LOGON TRIGGER is using the SYS_CONTEXT('USERENV','AUTHENTICATION_METHOD') call. If the logon trigger is using any other context variable with SYS_CONTEXT the error is not encountered. Equally if the trigger is dropped or disabled there is no error while running the export.

 

To reproduce the issue one can use the following steps:  

SQL> DROP TABLE SYS.USER_LOGON_T;

Table dropped.

SQL> CREATE TABLE SYS.USER_LOGON_T
2 (
3 AUTHENTICATION_METHOD VARCHAR2(255 CHAR)
4 );

Table created.

SQL>
SQL> CREATE OR REPLACE TRIGGER AFTER_LOGON_TRG
2 AFTER LOGON
3 ON DATABASE
4 begin
5 INSERT INTO SYS.USER_LOGON_T (authentication_method)
6 select sys_context('USERENV', 'AUTHENTICATION_METHOD') from dual;
7 END;
8 /

Trigger created.
SQL> create or replace directory dumps_dir as 'D:\DUMP';

Directory created.

SQL> grant read,write on directory dumps_dir to pons;

Grant succeeded.

SQL> host expdp scott directory=dumps_dir dumpfile=test.dmp logfile=test.log
schemas=scott

Export: Release 11.2.0.2.0 - Production on Thu Dec 29 12:26:54 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Password:

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining and Real Application Testing options
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_SCHEMA_01 for user PONS
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1569
ORA-39062: error creating master process DM00
ORA-31649: Master process DM00 violated startup protocol.

 

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