audit目录权限问题 导致asm无法启动
时间：2010-08-06 来源：olivenan
主机硬盘故障，厂家更换硬盘后，在启动数据库时发现ASM和instance无法启动
1、查看状态
oracle@CHNFSCC1[billdb1]:/home/oracle$ crs_stat
NAME=ora.billdb.billdb1.inst
TYPE=application
TARGET=ONLINE
STATE=OFFLINE
NAME=ora.billdb.billdb2.inst
TYPE=application
TARGET=ONLINE
STATE=ONLINE on chnfscc2
NAME=ora.billdb.db
TYPE=application
TARGET=ONLINE
STATE=ONLINE on chnfscc2
NAME=ora.chnfscc1.ASM1.asm
TYPE=application
TARGET=ONLINE
STATE=UNKNOWN on chnfscc1
NAME=ora.chnfscc1.LISTENER_CHNFSCC1.lsnr
TYPE=application
TARGET=ONLINE
STATE=ONLINE on chnfscc1
NAME=ora.chnfscc1.gsd
TYPE=application
TARGET=ONLINE
STATE=ONLINE on chnfscc1
NAME=ora.chnfscc1.ons
TYPE=application
TARGET=ONLINE
STATE=ONLINE on chnfscc1
NAME=ora.chnfscc1.vip
TYPE=application
TARGET=ONLINE
STATE=ONLINE on chnfscc1
NAME=ora.chnfscc2.ASM2.asm
TYPE=application
TARGET=ONLINE
STATE=ONLINE on chnfscc2
NAME=ora.chnfscc2.LISTENER_CHNFSCC2.lsnr
TYPE=application
TARGET=ONLINE
STATE=ONLINE on chnfscc2
NAME=ora.chnfscc2.gsd
TYPE=application
TARGET=ONLINE
STATE=ONLINE on chnfscc2
NAME=ora.chnfscc2.ons
TYPE=application
TARGET=ONLINE
STATE=ONLINE on chnfscc2
NAME=ora.chnfscc2.vip
TYPE=application
TARGET=ONLINE
STATE=ONLINE on chnfscc2
2、检查crs没有发现异常
oracle@CHNFSCC1[billdb1]:/home/oracle$ crsctl check crs
CSS appears healthy
CRS appears healthy
EVM appears healthy
oracle@CHNFSCC1[billdb1]:/home/oracle$
3、用crs_start和srvctl均无法启动asm实例 oracle@CHNFSCC1[billdb1]:/home/oracle$ crs_start ora.billdb.billdb1.inst CRS-1028: Dependency analysis failed because of: 'Resource in UNKNOWN state: ora.chnfscc1.ASM1.asm' CRS-0223: Resource 'ora.billdb.billdb1.inst' has placement error. oracle@CHNFSCC1[billdb1]:/home/oracle$ srvctl start asm -n CHNFSCC1 PRKS-1009 : Failed to start ASM instance "+ASM1" on node "CHNFSCC1", [PRKS-1009 : Failed to start ASM instance "+ASM1" on node "CHNFSCC1", [CRS-1028: Dependency analysis failed because of: CRS-0223: Resource 'ora.chnfscc1.ASM1.asm' has placement error.]] [PRKS-1009 : Failed to start ASM instance "+ASM1" on node "CHNFSCC1", [CRS-1028: Dependency analysis failed because of: CRS-0223: Resource 'ora.chnfscc1.ASM1.asm' has placement error.]] 4、关闭asm实例 oracle@CHNFSCC1[billdb1]:/home/oracle$ crs_stop ora.chnfscc1.ASM1.asm Attempting to stop `ora.chnfscc1.ASM1.asm` on member `chnfscc1` `ora.chnfscc1.ASM1.asm` on member `chnfscc1` has experienced an unrecoverable failure. Human intervention required to resume its availability. CRS-0216: Could not stop resource 'ora.chnfscc1.ASM1.asm'. 关闭失败，用参数-f强制关闭 oracle@CHNFSCC1[billdb1]:/home/oracle$ crs_stop -f ora.chnfscc1.ASM1.asm Attempting to stop `ora.chnfscc1.ASM1.asm` on member `chnfscc1` Stop of `ora.chnfscc1.ASM1.asm` on member `chnfscc1` succeeded. Target set to OFFLINE for `ora.billdb.billdb1.inst` oracle@CHNFSCC1[billdb1]:/home/oracle$ 5、再次尝试启动asm，有错误出现 oracle@CHNFSCC1[billdb1]:/home/oracle$ srvctl start asm -n CHNFSCC1 PRKS-1009 : Failed to start ASM instance "+ASM1" on node "CHNFSCC1", [PRKS-1009 : Failed to start ASM instance "+ASM1" on node "CHNFSCC1", [chnfscc1:ora.chnfscc1.ASM1.asm: chnfscc1:ora.chnfscc1.ASM1.asm:SQL*Plus: Release 10.2.0.3.0 - Production on Tue Aug 3 16:21:04 2010 chnfscc1:ora.chnfscc1.ASM1.asm: chnfscc1:ora.chnfscc1.ASM1.asm:Copyright (c) 1982, 2006, Oracle. All Rights Reserved. chnfscc1:ora.chnfscc1.ASM1.asm: chnfscc1:ora.chnfscc1.ASM1.asm:Enter user-name: ERROR: chnfscc1:ora.chnfscc1.ASM1.asm:ORA-09925: Unable to create audit trail file chnfscc1:ora.chnfscc1.ASM1.asm:HPUX-ia64 Error: 6: No such device or address chnfscc1:ora.chnfscc1.ASM1.asm:Additional information: 9925 chnfscc1:ora.chnfscc1.ASM1.asm:ORA-09925: Unable to create audit trail file chnfscc1:ora.chnfscc1.ASM1.asm:HPUX-ia64 Error: 6: No such device or address chnfscc1:ora.chnfscc1.ASM1.asm:Additional information: 9925 chnfscc1:ora.chnfscc1.ASM1.asm: chnfscc1:ora.chnfscc1.ASM1.asm: chnfscc1:ora.chnfscc1.ASM1.asm:Enter user-name: SP2-0306: Invalid option. chnfscc1:ora.chnfscc1.ASM1.asm:Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}] chnfscc1:ora.chnfscc1.ASM1.asm:where <logon> ::= <username>[/<password>][@<connect_identifier>] | / chnfscc1:ora.chnfscc1.ASM1.asm:Enter user-name: Enter password: chnfscc1:ora.chnfscc1.ASM1.asm:ERROR: chnfscc1:ora.chnfscc1.ASM1.asm:ORA-01005: null password given; logon denied chnfscc1:ora.chnfscc1.ASM1.asm: chnfscc1:ora.chnfscc1.ASM1.asm: chnfscc1:ora.chnfscc1.ASM1.asm:SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus chnfscc1:ora.chnfscc1.ASM1.asm: CRS-0215: Could not start resource 'ora.chnfscc1.ASM1.asm'.]] [PRKS-1009 : Failed to start ASM instance "+ASM1" on node "CHNFSCC1", [chnfscc1:ora.chnfscc1.ASM1.asm: chnfscc1:ora.chnfscc1.ASM1.asm:SQL*Plus: Release 10.2.0.3.0 - Production on Tue Aug 3 16:21:04 2010 chnfscc1:ora.chnfscc1.ASM1.asm: chnfscc1:ora.chnfscc1.ASM1.asm:Copyright (c) 1982, 2006, Oracle. All Rights Reserved. chnfscc1:ora.chnfscc1.ASM1.asm: chnfscc1:ora.chnfscc1.ASM1.asm:Enter user-name: ERROR: chnfscc1:ora.chnfscc1.ASM1.asm:ORA-09925: Unable to create audit trail file chnfscc1:ora.chnfscc1.ASM1.asm:HPUX-ia64 Error: 6: No such device or address chnfscc1:ora.chnfscc1.ASM1.asm:Additional information: 9925 chnfscc1:ora.chnfscc1.ASM1.asm:ORA-09925: Unable to create audit trail file chnfscc1:ora.chnfscc1.ASM1.asm:HPUX-ia64 Error: 6: No such device or address chnfscc1:ora.chnfscc1.ASM1.asm:Additional information: 9925 chnfscc1:ora.chnfscc1.ASM1.asm: chnfscc1:ora.chnfscc1.ASM1.asm: chnfscc1:ora.chnfscc1.ASM1.asm:Enter user-name: SP2-0306: Invalid option. chnfscc1:ora.chnfscc1.ASM1.asm:Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}] chnfscc1:ora.chnfscc1.ASM1.asm:where <logon> ::= <username>[/<password>][@<connect_identifier>] | / chnfscc1:ora.chnfscc1.ASM1.asm:Enter user-name: Enter password: chnfscc1:ora.chnfscc1.ASM1.asm:ERROR: chnfscc1:ora.chnfscc1.ASM1.asm:ORA-01005: null password given; logon denied chnfscc1:ora.chnfscc1.ASM1.asm: chnfscc1:ora.chnfscc1.ASM1.asm: chnfscc1:ora.chnfscc1.ASM1.asm:SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus chnfscc1:ora.chnfscc1.ASM1.asm: CRS-0215: Could not start resource 'ora.chnfscc1.ASM1.asm'.]] oracle@CHNFSCC1[billdb1]:/home/oracle$
6、解决方法，ORA-09925错误是由于$ORACLE_HOME/rdbms/audit目录无法写入导致，修正权限即可 Diagnosis: On UNIX: 1) Ensure the directory $ORACLE_HOME/rdbms/audit or the directory specified by the init.ora <parameter:AUDIT_FILE_DEST> exists, is writable by the oracle software owner and that the disk is not full. 2) Check $ORACLE_HOME/bin/oracle has permission of 6755. If not, then correct the permissions by executing this from the $ORACLE_HOME/bin directory: chmod 6755 oracle
3、用crs_start和srvctl均无法启动asm实例 oracle@CHNFSCC1[billdb1]:/home/oracle$ crs_start ora.billdb.billdb1.inst CRS-1028: Dependency analysis failed because of: 'Resource in UNKNOWN state: ora.chnfscc1.ASM1.asm' CRS-0223: Resource 'ora.billdb.billdb1.inst' has placement error. oracle@CHNFSCC1[billdb1]:/home/oracle$ srvctl start asm -n CHNFSCC1 PRKS-1009 : Failed to start ASM instance "+ASM1" on node "CHNFSCC1", [PRKS-1009 : Failed to start ASM instance "+ASM1" on node "CHNFSCC1", [CRS-1028: Dependency analysis failed because of: CRS-0223: Resource 'ora.chnfscc1.ASM1.asm' has placement error.]] [PRKS-1009 : Failed to start ASM instance "+ASM1" on node "CHNFSCC1", [CRS-1028: Dependency analysis failed because of: CRS-0223: Resource 'ora.chnfscc1.ASM1.asm' has placement error.]] 4、关闭asm实例 oracle@CHNFSCC1[billdb1]:/home/oracle$ crs_stop ora.chnfscc1.ASM1.asm Attempting to stop `ora.chnfscc1.ASM1.asm` on member `chnfscc1` `ora.chnfscc1.ASM1.asm` on member `chnfscc1` has experienced an unrecoverable failure. Human intervention required to resume its availability. CRS-0216: Could not stop resource 'ora.chnfscc1.ASM1.asm'. 关闭失败，用参数-f强制关闭 oracle@CHNFSCC1[billdb1]:/home/oracle$ crs_stop -f ora.chnfscc1.ASM1.asm Attempting to stop `ora.chnfscc1.ASM1.asm` on member `chnfscc1` Stop of `ora.chnfscc1.ASM1.asm` on member `chnfscc1` succeeded. Target set to OFFLINE for `ora.billdb.billdb1.inst` oracle@CHNFSCC1[billdb1]:/home/oracle$ 5、再次尝试启动asm，有错误出现 oracle@CHNFSCC1[billdb1]:/home/oracle$ srvctl start asm -n CHNFSCC1 PRKS-1009 : Failed to start ASM instance "+ASM1" on node "CHNFSCC1", [PRKS-1009 : Failed to start ASM instance "+ASM1" on node "CHNFSCC1", [chnfscc1:ora.chnfscc1.ASM1.asm: chnfscc1:ora.chnfscc1.ASM1.asm:SQL*Plus: Release 10.2.0.3.0 - Production on Tue Aug 3 16:21:04 2010 chnfscc1:ora.chnfscc1.ASM1.asm: chnfscc1:ora.chnfscc1.ASM1.asm:Copyright (c) 1982, 2006, Oracle. All Rights Reserved. chnfscc1:ora.chnfscc1.ASM1.asm: chnfscc1:ora.chnfscc1.ASM1.asm:Enter user-name: ERROR: chnfscc1:ora.chnfscc1.ASM1.asm:ORA-09925: Unable to create audit trail file chnfscc1:ora.chnfscc1.ASM1.asm:HPUX-ia64 Error: 6: No such device or address chnfscc1:ora.chnfscc1.ASM1.asm:Additional information: 9925 chnfscc1:ora.chnfscc1.ASM1.asm:ORA-09925: Unable to create audit trail file chnfscc1:ora.chnfscc1.ASM1.asm:HPUX-ia64 Error: 6: No such device or address chnfscc1:ora.chnfscc1.ASM1.asm:Additional information: 9925 chnfscc1:ora.chnfscc1.ASM1.asm: chnfscc1:ora.chnfscc1.ASM1.asm: chnfscc1:ora.chnfscc1.ASM1.asm:Enter user-name: SP2-0306: Invalid option. chnfscc1:ora.chnfscc1.ASM1.asm:Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}] chnfscc1:ora.chnfscc1.ASM1.asm:where <logon> ::= <username>[/<password>][@<connect_identifier>] | / chnfscc1:ora.chnfscc1.ASM1.asm:Enter user-name: Enter password: chnfscc1:ora.chnfscc1.ASM1.asm:ERROR: chnfscc1:ora.chnfscc1.ASM1.asm:ORA-01005: null password given; logon denied chnfscc1:ora.chnfscc1.ASM1.asm: chnfscc1:ora.chnfscc1.ASM1.asm: chnfscc1:ora.chnfscc1.ASM1.asm:SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus chnfscc1:ora.chnfscc1.ASM1.asm: CRS-0215: Could not start resource 'ora.chnfscc1.ASM1.asm'.]] [PRKS-1009 : Failed to start ASM instance "+ASM1" on node "CHNFSCC1", [chnfscc1:ora.chnfscc1.ASM1.asm: chnfscc1:ora.chnfscc1.ASM1.asm:SQL*Plus: Release 10.2.0.3.0 - Production on Tue Aug 3 16:21:04 2010 chnfscc1:ora.chnfscc1.ASM1.asm: chnfscc1:ora.chnfscc1.ASM1.asm:Copyright (c) 1982, 2006, Oracle. All Rights Reserved. chnfscc1:ora.chnfscc1.ASM1.asm: chnfscc1:ora.chnfscc1.ASM1.asm:Enter user-name: ERROR: chnfscc1:ora.chnfscc1.ASM1.asm:ORA-09925: Unable to create audit trail file chnfscc1:ora.chnfscc1.ASM1.asm:HPUX-ia64 Error: 6: No such device or address chnfscc1:ora.chnfscc1.ASM1.asm:Additional information: 9925 chnfscc1:ora.chnfscc1.ASM1.asm:ORA-09925: Unable to create audit trail file chnfscc1:ora.chnfscc1.ASM1.asm:HPUX-ia64 Error: 6: No such device or address chnfscc1:ora.chnfscc1.ASM1.asm:Additional information: 9925 chnfscc1:ora.chnfscc1.ASM1.asm: chnfscc1:ora.chnfscc1.ASM1.asm: chnfscc1:ora.chnfscc1.ASM1.asm:Enter user-name: SP2-0306: Invalid option. chnfscc1:ora.chnfscc1.ASM1.asm:Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}] chnfscc1:ora.chnfscc1.ASM1.asm:where <logon> ::= <username>[/<password>][@<connect_identifier>] | / chnfscc1:ora.chnfscc1.ASM1.asm:Enter user-name: Enter password: chnfscc1:ora.chnfscc1.ASM1.asm:ERROR: chnfscc1:ora.chnfscc1.ASM1.asm:ORA-01005: null password given; logon denied chnfscc1:ora.chnfscc1.ASM1.asm: chnfscc1:ora.chnfscc1.ASM1.asm: chnfscc1:ora.chnfscc1.ASM1.asm:SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus chnfscc1:ora.chnfscc1.ASM1.asm: CRS-0215: Could not start resource 'ora.chnfscc1.ASM1.asm'.]] oracle@CHNFSCC1[billdb1]:/home/oracle$
6、解决方法，ORA-09925错误是由于$ORACLE_HOME/rdbms/audit目录无法写入导致，修正权限即可 Diagnosis: On UNIX: 1) Ensure the directory $ORACLE_HOME/rdbms/audit or the directory specified by the init.ora <parameter:AUDIT_FILE_DEST> exists, is writable by the oracle software owner and that the disk is not full. 2) Check $ORACLE_HOME/bin/oracle has permission of 6755. If not, then correct the permissions by executing this from the $ORACLE_HOME/bin directory: chmod 6755 oracle
相关阅读 更多 +
