asm oracle文件权限,audit目录权限问题 导致asm无法启动

主机硬盘故障，厂家更换硬盘后，在启动数据库时发现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 ::= [/][@] | /

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 ::= [/][@] | /

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 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