Re: access with ORA-09817

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Tue, 29 Mar 2005 16:30:18 +0200
Message-ID: <4249667c$0$28059$ba620e4c@news.skynet.be>

"Jeroen van Sluisdam" <jeroen.van.sluisdam_at_vrijuit.nl> wrote in message news:cb391de7.0503290621.c04300f_at_posting.google.com...
> So my filesystem is full
> Access is denied, only way is cleaning up the filesystem ?
> Any other tips and trics ?
>
> Tnx.
>
> Jeroen
>
> Oracle 9.2.0.4 HP-UX 11.11
>
> $ sqlplus "/ as sysdba"
>
> SQL*Plus: Release 9.2.0.4.0 - Production on Tue Mar 29 16:14:39 2005
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
> ERROR:
> ORA-09817: Write to audit file failed.
> HP-UX Error: 28: No space left on device
> ORA-09945: Unable to initialize the audit trail file
> HP-UX Error: 28: No space left on device
>
>
> Enter user-name:
> ERROR:
> ORA-01017: invalid username/password; logon denied

Yes : schedule a shell script which will alert you when filesystems are running full. This way you can take pro-active actions.

Matthias Received on Tue Mar 29 2005 - 08:30:18 CST