ORA-09925 ,ORA-27086

ORA-09925: Unable to create audit trail file

SQL> !oerr ora 9925
09925, 00000,  "Unable to create audit trail file"
// *Cause:  ORACLE was not able to create the file being used to hold
//          audit trail records.
// *Action: Check the UNIX error number for a possible operating system error.
//          If there is no error, contact ORACLE customer support.

SQL> show parameter audit_file_dest

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest                      string      /opt/oracle/admin/test/adump

没有admin/test/adump目录，新建该目录，问题解决

 

ORA-27086: unable to lock file - already in use
jk2f8DW-Z:HT0Linux-x86_64 Error: 11: Resource temporarily unavailable

SQL> !oerr ora 27086
27086, 00000, "unable to lock file - already in use"
// *Cause:  the file is locked by another process, indicating that it is
//          currently in use by a database instance.
// *Action: determine which database instance legitimately owns this file.

 

网上查了下说这个跟挂载存储有关，但是该服务器没有挂载存储，所以重启了下服务器，问题解决。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22779291/viewspace-695540/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22779291/viewspace-695540/