We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

ORACLE ERROR ORA-09817 and ORA-09945

markchih
markchih asked
on
Medium Priority
14,260 Views
Last Modified: 2012-06-27
Hi, I am having a problem:

ORA-09817: Write to audit file failed.
Linux Error: 28: No space left on device
ORA-09945: Unable to initialize the audit trail file
Linux Error: 28: No space left on device

It's apparent that the filesystem is full.  df shows that there is no space left.
what I would like to know is how to move the tablespace to another filesystem temporarily to clean up the filesystem
because I couldn't connect / as sysdba anymore

Thanks
Comment
Watch Question

Which Oracle version are you using?

In 9i,try connecting as sys:

sqlplus /nolog
connect sys/change_on_install@<sid> as sysdba


where change_on_install is the default password..
markchih, you have to move other files that are not Oracle files to a new location to release the space to solve the problem. Or you can delete/move the old archived log files if possible.

For your information Oracle always generate an audit (.aud) file when you connect INTERNAL, regardless of whether auditing has been turned on in the database and this is a security feature and expected behavior. So if the systemfile is full you will get trouble when trying to connect

Hope this helps
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Commented:
Your audit file destination is full.

"show parameter aud" will tell you where audit_file_dest is.

Using your operating sysdtem commands, delete most (or all) of your.aud files.
Or you can compress them into a zip or tar file.
Alternately add space if you don't want to do either of the above.

The first message (from catchmeifuwant) gives you instructions that should let you login to the database if your problem had been a full archive log destination.  Try logging in as a non-sysdba user as that won't require a .aud file.

HTH
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.