ORA-09925

今天进入测试服务器

发现很怪异的事情，

敲入SQLPLUS / AS SYSDBA报如下错误：

ORA-09925: Unable to create audit trail file

重启服务器以后，尽然好了！

搜索了下support.oracle.com，

Problem Description
-------------------

You are trying to startup your database and receive the following
error:

    ORA-09925:  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.

This error indicates that you are unable to write to the audit
directory.  You have checked your audit directory and there is plenty
of freespace available.  You have even removed the aud$ files from the
directory and this does not seem to help.  All permissions are also
correctly set.
 

Solution Description
--------------------

Have your UNIX sysadmin run fsck against the filesystem, unmount and
mount the filesystem.


Explanation
-----------

There is an error in the status of the filesystem and it needs to be
corrected so that writes to the audit directory will succeed.

fsck audits and interactively repairs inconsistent file system
conditions.  If the file system is inconsistent the default action
for each correction is to wait for the user to respond yes or no.
If the user does not have write permission fsck defaults to a no action.
Some corrective actions will result in loss of data.  The amount and
severity of data loss may be determined from the diagnostic output.    


References
----------

UNIX online manual,  see man fsck

 

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

转载于:http://blog.itpub.net/8183550/viewspace-666998/