Home » RDBMS Server » Server Administration » Audit file filed
Audit file filed [message #211841] Tue, 02 January 2007 11:14 Go to next message
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
Re: Audit file filed [message #211842 is a reply to message #211841] Tue, 02 January 2007 11:19 Go to previous messageGo to next message
BlackSwan
Messages: 25036
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.
Re: Audit file filed [message #211844 is a reply to message #211842] Tue, 02 January 2007 11:42 Go to previous messageGo to next message
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..
Re: Audit file filed [message #211850 is a reply to message #211841] Tue, 02 January 2007 12:13 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
What output is produced by:
$ df -k

??????????
Re: Audit file filed [message #211859 is a reply to message #211850] Tue, 02 January 2007 13:12 Go to previous messageGo to next message
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
Re: Audit file filed [message #211861 is a reply to message #211841] Tue, 02 January 2007 13:18 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>/dev/cciss/c0d0p2 6047972 5740748 0 100%% /mnt/ora_system
is 100% FULL & Oracle want to write additional data to it.
Re: Audit file failed [message #211862 is a reply to message #211861] Tue, 02 January 2007 13:27 Go to previous message
SRIVASUWIN
Messages: 45
Registered: October 2006
Location: TRICHY
Member


So the solution is I want to freeup the space in /mnt/ora_system to get rid from the issue is it right..?
Previous Topic: SCN
Next Topic: Turn off Archive log mode in oracle 9i
Goto Forum:
  


Current Time: Sun Dec 04 16:37:24 CST 2016

Total time taken to generate the page: 0.09212 seconds