dba每天都要看告警日志
告警日志命名方式:
alert_.log
默认存放位置都在:
$ORACLE_BASE/ADMIN/SID/bdump
设置存放位置的参数为:
background_dump_dest
SQL> show parameter background_dump_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
background_dump_dest string /oracle/admin/mis/bdump
告警日志出现ora错误的时候,可以用命令oerr 打开,看详细的信息
[oracle@DELL bdump]$ oerr ora 0744507445, 00000, "exception encountered: core dump [%s] [%s] [%s] [%s] [%s] [%s]"
// *Cause: An OS exception occurred which should result in the creation of a
// core file. This is an internal error.
// *Action: Contact your customer support representativ
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22934571/viewspace-1045197/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22934571/viewspace-1045197/