Home » RDBMS Server » Server Administration » core dump under $ORACLE_HOME/dbs (11.1.0.7.0)
core dump under $ORACLE_HOME/dbs [message #568082] Tue, 09 October 2012 07:51 Go to next message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

Hi,

I saw big size .core file is generated in $ORACLE_HOME/dbs folder even when no dump dest parameter is set to dbs folder. P;ease suggest how to check what causing this genrarating of these files.

PROD1 /oravl01/oracle/11.1.0.7/dbs > ls
1                                core.11528  core.15973  core.22231  core.26792  core.29496  core.5262             initCCLCLMP.ora
controlfile.binary.PROD1.Fri  core.12504  core.15981  core.2262   core.27129  core.29802  core.5847             initdw.ora
controlfile.binary.PROD1.Mon  core.12520  core.1617   core.23115  core.27196  core.30793  core.6176             init.ora
controlfile.binary.PROD1.Sat  core.1256   core.1626   core.23276  core.27531  core.30877  core.6221             initTESTCRM.ora
controlfile.binary.PROD1.Sun  core.12594  core.16364  core.23681  core.27560  core.30885  core.6535             orapwPROD1
controlfile.binary.PROD1.Thu  core.13010  core.16479  core.24054  core.27686  core.31211  core.6802             orapwTESTCRM
controlfile.binary.PROD1.Tue  core.13012  core.16746  core.2447   core.27777  core.31644  core.6810             pfilePROD1_1.ora
controlfile.binary.PROD1.Wed  core.13067  core.16748  core.24513  core.27847  core.31713  core.6857             pfilePROD1.ora
controlfile.binary.TESTCRM.Fri   core.13247  core.17685  core.24521  core.27917  core.31729  core.6861             snapcf_PROD1.f
controlfile.binary.TESTCRM.Mon   core.1325   core.18562  core.24572  core.27919  core.31836  core.8218             snapcf_copy_PROD1.bak
controlfile.binary.TESTCRM.Thu   core.13305  core.18980  core.24762  core.27926  core.31844  core.8555             snapcf_copy_TESTCRM.bak
core.10244                       core.13496  core.19040  core.2494   core.27929  core.31977  core.8561             snapcf_TESTCRM.f
core.10286                       core.13708  core.19048  core.2510   core.28003  core.31985  core.9639             spfilePROD1.ora
core.10294                       core.13716  core.20576  core.25110  core.28228  core.3871   hc_PROD1.dat
core.10516                       core.14112  core.20844  core.25238  core.28363  core.3873   hc_CCLCLMP.dat
core.10526                       core.14999  core.20846  core.25246  core.28371  core.391    hc_TESTCRM.dat
core.10565                       core.15007  core.2110   core.2526   core.28938  core.3921   initPROD1.ora
core.11150                       core.15325  core.2118   core.26604  core.29077  core.4160   initPROD1.ora.bkp
core.11152                       core.15703  core.21270  core.26784  core.29079  core.4421   initPROD1.ora.old
PROD1 /oravl01/oracle/11.1.0.7/dbs > sqlplus

SQL*Plus: Release 11.1.0.7.0 - Production on Tue Oct 9 08:16:19 2012

Copyright (c) 1982, 2008, Oracle.  All rights reserved.

Enter user-name: / as sysdba

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> show parameter CORE_DUMP_DES

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
core_dump_dest                       string      /oravl01/oracle/11.1.0.7/diag/
                                                 rdbms/cclclmp/PROD1/cdump
SQL> show parameter background_core_dump

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
background_core_dump                 string      partial
SQL> show parameter dump

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
background_core_dump                 string      partial
background_dump_dest                 string      /oravl01/oracle/11.1.0.7/diag/
                                                 rdbms/cclclmp/PROD1/trace
core_dump_dest                       string      /oravl01/oracle/11.1.0.7/diag/
                                                 rdbms/cclclmp/PROD1/cdump
max_dump_file_size                   string      unlimited
shadow_core_dump                     string      partial
user_dump_dest                       string      /oravl01/oracle/11.1.0.7/diag/
                                                 rdbms/cclclmp/PROD1/trace
SQL>
Re: core dump under $ORACLE_HOME/dbs [message #568083 is a reply to message #568082] Tue, 09 October 2012 07:55 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10613
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Looks like there is more than one database using this ORACLE_HOME.
I would check those too.
Re: core dump under $ORACLE_HOME/dbs [message #568084 is a reply to message #568083] Tue, 09 October 2012 07:58 Go to previous messageGo to next message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

Hello Mahesh,

No other database is accessing that home. This is RAC database and this one node 1. PLease suggest further.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
PROD1 /oravl01/oracle/11.1.0.7/dbs > ps -ef | grep pmon
oracle   19991     1  0 Sep06 ?        00:00:00 asm_pmon_+ASM1
oracle   20793     1  0 Sep06 ?        00:07:05 ora_pmon_PROD1
oracle   27488 24076  0 08:56 pts/1    00:00:00 grep -i pmon
PROD1 /oravl01/oracle/11.1.0.7/dbs >
Re: core dump under $ORACLE_HOME/dbs [message #568094 is a reply to message #568084] Tue, 09 October 2012 08:31 Go to previous messageGo to next message
BlackSwan
Messages: 21941
Registered: January 2009
Senior Member
when were the core files made?
what clues exist within alert_PROD1.log & alert_+ASM1.log files

Re: core dump under $ORACLE_HOME/dbs [message #568107 is a reply to message #568094] Tue, 09 October 2012 08:55 Go to previous messageGo to next message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

Hey BlackSwan,

No, no clue in either alert log.
Re: core dump under $ORACLE_HOME/dbs [message #568110 is a reply to message #568107] Tue, 09 October 2012 09:05 Go to previous messageGo to next message
BlackSwan
Messages: 21941
Registered: January 2009
Senior Member
ls -ltr /oravl01/oracle/11.1.0.7/dbs/core*

post results from OS command above
Re: core dump under $ORACLE_HOME/dbs [message #568112 is a reply to message #568110] Tue, 09 October 2012 09:59 Go to previous messageGo to next message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

Hi,

PROD1 /oravl01/oracle/11.1.0.7/dbs > ls -ltr /oravl01/oracle/11.1.0.7/dbs/core*
-rw------- 1 oracle oinstall 22720512 Sep 11 02:00 /oravl01/oracle/11.1.0.7/dbs/core.6176
-rw------- 1 oracle oinstall 21811200 Sep 11 02:19 /oravl01/oracle/11.1.0.7/dbs/core.6861
-rw------- 1 oracle oinstall 21917696 Sep 11 02:19 /oravl01/oracle/11.1.0.7/dbs/core.6857
-rw------- 1 oracle oinstall 22310912 Sep 11 02:20 /oravl01/oracle/11.1.0.7/dbs/core.29802
-rw------- 1 oracle oinstall 21811200 Sep 12 02:00 /oravl01/oracle/11.1.0.7/dbs/core.10244
-rw------- 1 oracle oinstall 21811200 Sep 12 02:21 /oravl01/oracle/11.1.0.7/dbs/core.10526
-rw------- 1 oracle oinstall 21909504 Sep 12 02:21 /oravl01/oracle/11.1.0.7/dbs/core.10516
-rw------- 1 oracle oinstall 22315008 Sep 12 02:21 /oravl01/oracle/11.1.0.7/dbs/core.2447
-rw------- 1 oracle oinstall 22310912 Sep 13 02:00 /oravl01/oracle/11.1.0.7/dbs/core.24054
-rw------- 1 oracle oinstall 21811200 Sep 13 02:22 /oravl01/oracle/11.1.0.7/dbs/core.24521
-rw------- 1 oracle oinstall 21917696 Sep 13 02:22 /oravl01/oracle/11.1.0.7/dbs/core.24513
-rw------- 1 oracle oinstall 22310912 Sep 13 02:22 /oravl01/oracle/11.1.0.7/dbs/core.17685
-rw------- 1 oracle oinstall 21811200 Sep 14 02:00 /oravl01/oracle/11.1.0.7/dbs/core.28938
-rw------- 1 oracle oinstall 21811200 Sep 14 02:20 /oravl01/oracle/11.1.0.7/dbs/core.29079

PROD1 /oravl01/oracle/11.1.0.7/dbs > file core.13010
core.13010: ELF 64-bit LSB core file AMD x86-64, version 1 (SYSV), SVR4-style, from 'oracle'



I have also these are created by ORACLE user and checking forward with doc id: 1812.1.
Re: core dump under $ORACLE_HOME/dbs [message #568117 is a reply to message #568112] Tue, 09 October 2012 10:04 Go to previous message
BlackSwan
Messages: 21941
Registered: January 2009
Senior Member
something starts at 0200 hours that spews these files
Previous Topic: Temporary tablespace not seen on user_tablespaces
Next Topic: Strange deadlock in tracefile
Goto Forum:
  


Current Time: Thu Apr 17 21:00:35 CDT 2014

Total time taken to generate the page: 0.06790 seconds