OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Audit file filed

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Audit file filed [message #211841]

Tue, 02 January 2007 11:14

SRIVASUWIN
Messages: 45
Registered: October 2006
Location: TRICHY

Member

Hello sir,

When i am trying to connect sys user, i got the following error

SQL*Plus: Release 9.2.0.4.0 - Production on Tue Jan 2 11:27:39 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

ERROR:
ORA-09817: Write to audit file failed.
Linux Error: 28: No space left on device
ORA-01075: you are currently logged on

OS--->LINUX

plz help me to get rid from issue.

Thank u sir

Report message to a moderator

Re: Audit file filed [message #211842 is a reply to message #211841]

Tue, 02 January 2007 11:19

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

What part of "Linux Error: 28: No space left on device" do you NOT understand?
The volume where AUDIT writes its output is FULL.

Report message to a moderator

Re: Audit file filed [message #211844 is a reply to message #211842]

Tue, 02 January 2007 11:42

SRIVASUWIN
Messages: 45
Registered: October 2006
Location: TRICHY

Member

hello sir,

thank u for reply

Now i have checked the
$ORA_HOME/rdbms/audit and deleted the old files ,but still the error presist.

Plz help me what can i do..

Report message to a moderator

Re: Audit file filed [message #211850 is a reply to message #211841]

Tue, 02 January 2007 12:13

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

What output is produced by:
$ df -k

??????????

Report message to a moderator

Re: Audit file filed [message #211859 is a reply to message #211850]

Tue, 02 January 2007 13:12

SRIVASUWIN
Messages: 45
Registered: October 2006
Location: TRICHY

Member

thanks for your reply sir.

Disconnected from Oracle9i Release 9.2.0.4.0 - Production
JServer Release 9.2.0.4.0 - Production
[oracle@ML3508x73 oracle]$ df -k
Disconnected from Oracle9i Release 9.2.0.4.0 - Production
JServer Release 9.2.0.4.0 - Production
[oracle@ML3508x73 oracle]$ df -k
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/cciss/c0d0p5 62346620 56146548 3032976 95% /
/dev/cciss/c0d0p1 98747 25718 67930 28% /boot
/dev/cciss/c0d1p1 70560640 7686700 59289664 12%% /mnt/ora_data
/dev/cciss/c0d2p1 70560640 2169636 64806728 4%% /mnt/ora_index
/dev/cciss/c0d3p1 70560640 224672 66751692 1%% /mnt/ora_redo
/dev/cciss/c0d0p2 6047972 5740748 0 100%% /mnt/ora_system
none 1030824 0 1030824 0% /dev/shm

Report message to a moderator