Sun Storage 53x0/52x0 NAS Appliance : ORA-07445 ssexhd() due to OS resource access issues

Asset ID:	1-72-2158036.1
Update Date:	2018-05-10
Keywords:

Solution Type Problem Resolution Sure

Solution 2158036.1 : Sun Storage 53x0/52x0 NAS Appliance : ORA-07445 ssexhd() due to OS resource access issues

Applies to:

Sun Storage 5210 NAS Appliance - Version All Versions and later
Sun Storage 5310 NAS Appliance - Version All Versions and later
Sun Storage 5320 NAS Appliance - Version All Versions and later
Sun Storage 5320 NAS Gateway - Version All Versions and later
Sun Storage 5320 NAS Cluster - Version All Versions and later
Information in this document applies to any platform.

Symptoms

DB alert errors (Sun Jul 03 11:27:47) (NFS errors noticed at the same time):

Sun Jul 03 11:27:47 HKT 2016
Errors in file /u01/app/oracle/admin/tnss/bdump/tnss_dbw0_5160.trc:
ORA-07445: exception encountered: core dump [ssexhd()+532] [SIGSEGV] [Address not mapped to object] [0x000000004] [] []
Sun Jul 03 11:27:48 HKT 2016
Errors in file /u01/app/oracle/admin/tnss/bdump/tnss_ckpt_5164.trc:
ORA-07445: exception encountered: core dump [ssexhd()+532] [SIGSEGV] [Address not mapped to object] [0x000000004] [] []
Sun Jul 03 11:27:57 HKT 2016
Errors in file /u01/app/oracle/admin/tnss/bdump/tnss_pmon_5152.trc:
ORA-00469: CKPT process terminated with error
Sun Jul 03 11:27:57 HKT 2016
PMON: terminating instance due to error 469
Instance terminated by PMON, pid = 5152
Mon Jul 04 10:36:32 HKT 2016
Starting ORACLE instance (normal)

OS error message (Sun Jul 03 11:27:47):

Jul 3 11:27:48 tnssu5 nfs: [ID 257235 kern.info] NOTICE: [NFS4][Server: 192.168.xx.xxx][Mntpt: /zone/tnssu5-root/root/dbdata]Couldn't reclaim lock for pid 5160 for file ./tnss/undotbs102.dbf (rnode_pt 0x300b0e93400) on (server 192.168.44.xxx): error 10033
Jul 3 11:27:48 tnssu5 nfs: [ID 269213 kern.info] NOTICE: [NFS4][Server: 192.168.xx.xxx][Mntpt: /zone/tnssu5-root/root/dbdata]Process 5160 lost its locks on file ./tnss/undotbs102.dbf (rnode_pt: 300b0e93400) due to NFS recovery error (NFS4ERR_NO_GRACE) on server 192.168.44.xxx.
Jul 3 11:27:48 tnssu5 nfs: [ID 257235 kern.info] NOTICE: [NFS4][Server: 192.168.xx.xxx][Mntpt: /zone/tnssu5-root/root/dbdata]Couldn't reclaim lock for pid 5164 for file ./tnss/control02.ctl (rnode_pt 0x300753c7bd0) on (server 192.168.44.xxx): error 10033
Jul 3 11:27:48 tnssu5 nfs: [ID 269213 kern.info] NOTICE: [NFS4][Server: 192.168.xx.xxx][Mntpt: /zone/tnssu5-root/root/dbdata]Process 5164 lost its locks on file ./tnss/control02.ctl (rnode_pt: 300753c7bd0) due to NFS recovery error (NFS4ERR_NO_GRACE) on server 192.168.44.xxx.
Jul 3 11:27:48 tnssu5 nfs: [ID 257235 kern.info] NOTICE: [NFS4][Server: 192.168.xx.xxx][Mntpt: /zone/tnssu5-root/root/dbdata]Couldn't reclaim lock for pid 5160 for file ./tnss/system01.dbf (rnode_pt 0x3009ad956b0) on (server 192.168.44.xxx): error 10033
Jul 3 11:27:48 tnssu5 nfs: [ID 269213 kern.info] NOTICE: [NFS4][Server: 192.168.xx.xxx][Mntpt: /zone/tnssu5-root/root/dbdata]Process 5160 lost its locks on file ./tnss/system01.dbf (rnode_pt: 3009ad956b0) due to NFS recovery error (NFS4ERR_NO_GRACE) on server 192.168.44.xxx.

Changes

NONE

Cause

NFS mount point access errors or OS resource access errors.

ssexhd function handles Unix-specific EXception HanDler, in this case exception encountered in ssexhd due to oracle unable to access system datafiles

Solution

Please verify OS message logs and involve (client) OS admin to resolve OS related issues.

Check for relevancy - 10-May-2018

Attachments

This solution has no attachment