7 x 24 在线支持!
Oracle在数据库启动时产生的错误 ORA-48178 和 ORA-27041
如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!
诗檀软件专业数据库修复团队
服务热线 : 13764045638 QQ号:47079569 邮箱:service@parnassusdata.com
[oracle@ocm_rac01 ~]$ oerr ora 48178 48178, 00000, "error encountered while reading an ADR block file during ADR initialization [%s]" // *Cause: An error was encountered while reading an ADR block file during // the initialization of the ADR subsystem. // *Action: Check the state of the file system. [oracle@ocm_rac01 ~]$ oerr ora 27041 27041, 00000, "unable to open file" // *Cause: open system call returned an error, additional information // indicates which function encountered the error // *Action: check errno
适用于:
Oracle服务器 – 企业版 – 版本: 11.2.0.1 to 11.2.0.1 – Release: 11.2 to 11.2
本文信息适用于任何平台。
症状
在新创建的11.2.0.1数据库的启动时产生以下错误:
ERROR: ORA-48178 encountered when checking if the process is able to
ERROR: create the ADR schema in the specified ADR Base directory [/d01/oratest/TEST/11.2.0/admin]
ERROR: The ORA-48178 error is caused by the ORA-48122 error.
ORA-48122: error with opening the ADR block file [/d01/oratest/TEST/11.2.0/admin/diag/rdbms/test/TEST/metadata/ADR_INTERNAL.mif] [0]
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 2
ERROR: Check if the directory is readable and check if the OS version is supported for ADR.
ERROR: The process will switch back to the pre-ADR method of tracing and logging.
更改
错误在创建新数据库后发生。
原因
该问题的原因在Bug:10086423中被指出。这是由该新数据库的ADR目录结构中的元数据文件(.ASM 和 .MIF文件)上的错误文件权限导致的。
解决方案
该问题在11.2.0.2 patchset和更改版本中解决。
要处理该问题,手动设置权限所涉及的文件,就像在:
$ chmod 760 /d01/oratest/TEST/11.2.0/admin/diag/rdbms/test/TEST/metadata/ADR_INTERNAL.mif