如果自己搞不定可以找诗檀软件专业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