ORA 7445 [nszgclient()+63]' "AFTER DDL ON DATABASE" TRIGGER USING SYS_CONTEXT (Doc ID 2269335.1)

Last updated on JUNE 19, 2017

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

M000 process is reporting an error ORA-7445 every day at the same time.

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x90] [PC:0x3B03DE9, nszgclient()+63] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/peprnce/peprnce1/trace/peprnce1_m000_36084.trc (incident=229251):
ORA-07445: exception encountered: core dump [nszgclient()+63] [SIGSEGV] [ADDR:0x90] [PC:0x3B03DE9] [Address not mapped to object] []
Incident details in: /u01/app/oracle/diag/rdbms/peprnce/peprnce1/incident/incdir_229251/peprnce1_m000_36084_i229251.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Sat Mar 11 02:15:16 2017

Information from the trace file is showing an alter table for AWR dictionary tables.

7FFF24C3C540 65746C61 61742072 20656C62 24485257 [alter table WRH$]
7FFF24C3C550 4C49465F 41545345 20535854 696C7073 [_FILESTATXS spli]
7FFF24C3C560 61702074 74697472 206E6F69 24485257 [t partition WRH$]
7FFF24C3C570 4C49465F 5F545345 30383732 37323935 [_FILEST_27805927]
7FFF24C3C580 315F3339 37363030 20746120 38373228 [93_10067 at (278]
7FFF24C3C590 32393530 2C333937 31313031 69202933 [0592793,10113) i]
7FFF24C3C5A0 206F746E 72617028 69746974 57206E6F [nto (partition W]
7FFF24C3C5B0 5F244852 454C4946 325F5453 35303837 [RH$_FILEST_27805]
7FFF24C3C5C0 39373239 30315F33 20373630 6C626174 [92793_10067 tabl]
7FFF24C3C5D0 61707365 53206563 55415359 70202C58 [espace SYSAUX, p]
7FFF24C3C5E0 69747261 6E6F6974 48525720 49465F24 [artition WRH$_FI]
7FFF24C3C5F0 5453454C 3837325F 32393530 5F333937 [LEST_2780592793_]
7FFF24C3C600 31313031 61742033 73656C62 65636170 [10113 tablespace]
7FFF24C3C610 53595320 29585541 64707520 20657461 [ SYSAUX) update ]
7FFF24C3C620 65646E69 00736578 08F7C887 00000000 [indexes.........]
7FFF24C3C630 00000000 00000000 00000000 00000000 [................]

The error is reproduced when the following own code trigger is executed as part of an alter by background process m000 when AWR dictionary tables are altered internally by the M000 process.

CREATE OR REPLACE TRIGGER TR_LOG_M_TRG
AFTER ALTER ON DATABASE
DECLARE
V_MTH_AUTH VARCHAR2(300); -- SYS_CONTEXT('USERENV','AUTHENTICATION_METHOD')
BEGIN
SELECT SYS_CONTEXT('USERENV', 'AUTHENTICATION_METHOD')
INTO V_MTH_AUTH
FROM DUAL;
END;
/

 

ERROR
-----------------------
ORA 7445 [nszgclient()+63]'

Changes

 No Changes.

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