啟動資料庫出現ORA-9925錯誤

嘗試用非oracle使用者啟動資料庫，碰到這個錯誤。

錯誤詳細資訊為：

enmo@jyoracle:/oracle/admin/enmo>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Dec 16 20:28:09 2011

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

ERROR:
ORA-09925: Unable to create audit trail file
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 9925
ORA-09925: Unable to create audit trail file
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 9925

Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied

Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

其實這個錯誤很明顯，是由於AUDIT TRAIL檔案無法建立所致，導致這個問題多半是由於許可權造成的，檢查後發現果然如此：

enmo@jyoracle:/oracle/admin/enmo>ls
adump bdump cdump udump
enmo@jyoracle:/oracle/admin/enmo>ls -l
total 0
drwxr-xr-x 2 enmo dba 256 Dec 16 20:17 adump
drwxr-xr-x 2 enmo dba 256 Dec 16 20:14 bdump
drwxr-xr-x 2 enmo dba 256 Dec 16 20:14 cdump
drwxr-xr-x 2 enmo dba 256 Dec 16 20:15 udump
enmo@jyoracle:/oracle/admin/enmo>chmod 775 adump
enmo@jyoracle:/oracle/admin/enmo>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Dec 16 20:29:46 2011

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to an idle instance.

由於當前的使用者屬於dba組，並非oracle使用者，因此如果要資料庫可以訪問adump目錄，應該設定改目錄組選項可寫。