今天發現一現象

在$ORACLE_HOME/dbs下發現很多core文件，為什麼這些文件會產生在這個目錄下呢？按道理應該在core_dump_dest='/u01/app/oracle/admin/sfcsys/cdump'.

結合alert log總結發現：

1.當ORA-07445時，core文件會走常規路徑在core_dump_dest下;

2.當ORA-00600時，core文件則會產生在$ORACLE_HOME/dbs.

ORA-00600: internal error code, arguments: [504], [0x200126F4], [16], [2], [compile environment latch], [0], [0], [0x0]
ORA-00600: 內部錯誤代碼, 引數: [526], [0x9F73FCA8], [4], [enqueue hash chains], [1], [0x20004FC4], [0], []
ORA-00600: internal error code, arguments: [504], [0x9DCC8644], [16], [0], [In memory undo latch], [3], [2], [0x0]

隨它樂意呵.

//

The information in this document applies to:
Oracle Server - Enterprise Edition - Version: 8.1.7.4
This problem can occur on any platform.

Errors
ORA-7445 "exception encountered: core dump [%s] [%s]"

Symptoms
- Oracle is dumping CORE in $ORACLE_HOME/dbs directory rather than CORE_DUMP_DEST
- The default directory filesystem usage peaked at 100%.
Cause
If the CORE_DUMP_DEST is not used, the default will be the ORACLE_HOME/dbs
directory.

The common causes are:
- CORE_DUMP_DEST not set.
- Invalid directory specified (includes case sensitive naming convention).
- Insufficient privileges on the specified directory.
- Insufficient space in the directory.

If you have already checked and ruled out these causes then the remaining
reason is (from Note:39793.1 "PARAMETER:CORE_DUMP_DEST"):
" In some cases this parameter may not have been read when a core file
is produced. In this case the core dump is typically written to the
default location ($ORACLE_HOME/dbs). "

In certain cases when if the the SGA is not mapped, there is no way we can find
out where core_dump_dest is and dumps are created in ORACLE_HOME/dbs directory.
- This cannot be avoided.

This is usually the case when there is a memory related issue that is flagged
before the error moves to the point in the code stack where the CORE_DUMP_DEST
is read.

In terms of the use of the CORE_DUMP_DEST vs ORACLE_HOME/dbs, this is
considered an 'expected behavior'
Fix
CORE_DUMP_DEST should point to the directory where core dumps from the Oracle server will be placed. A core dump is a memory image of the Oracle shadow process produced when an unexpected , unrecoverable or invalid condition occurs.

Note that Oracle should always try to write a trace file before producing a core dump. Always check and locations for trace files first.

In some cases this parameter may not have been read when a core file is produced. In this case the core dump is typically written to the default location ($ORACLE_HOME/dbs).

CORE_DUMP_DEST should have WRITE permission for the Oracle user.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7836221/viewspace-608178/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7836221/viewspace-608178/