Oracle Restart : Core dump on Oracle home directory by root OS user (Doc ID 2093533.1)

Last updated on DECEMBER 31, 2015

Applies to:

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

Symptoms

++ Oracle Restart environment with a new setup

++ Core dumps created by root in the oracle home directory for the database
and they are big files around 80GB etc.

++ core dumps being generted in ORACLE_HOME/dbs

drwxr----- 2 oracle asmadmin 2 Aug 28 09:22 core_17617
drwxr----- 2 oracle asmadmin 3 Sep 11 07:05 core_11835
drwxr----- 2 oracle asmadmin 2 Sep 11 09:21 core_1926
drwxr----- 2 oracle asmadmin 2 Sep 11 09:22 core_1628

++ Below core file was generated when the database was up and running and no maintenance activity was done .

drwxr-x--- 2 oracle asmadmin 3 Sep 15 09:50 core_17246

 

Truss on sqlplus as below ,

truss -fe -o sqlplus.truss sqlplus "/ as sysdba"

2300: stat("/app/oracle/diag/rdbms/xxxxx/XXXXX", 0xFFFFFFFF7FFFEA80) Err#13
EACCES [file_dac_search]
...
2300: stat("/app/oracle/diag", 0xFFFFFFFF7FFFDF80) = 0
2300: stat("/app/oracle/diag/rdbms", 0xFFFFFFFF7FFFDF80) Err#13 EACCES
[file_dac_search]
2300: mkdir("/app/oracle/diag/rdbms", 0775) Err#13 EACCES [file_dac_search]
.

So the process tries to access ./diag/rdbms but can't, assumes that it doesn't exist, tries to create it but can't.

 

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