Home » RDBMS Server » Server Administration » ERROR: ORA-09925: Unable to create audit trail file Linux-x86_64 Error: (Linux 6)
ERROR: ORA-09925: Unable to create audit trail file Linux-x86_64 Error: [message #609198] Mon, 03 March 2014 21:17 Go to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Hi All,

I would like to share the issue i faced in database server along with resolution .

When i try to login to one of testing database in RAC server, i get following error message.
ERROR:
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 28: No space left on device
Additional information: 9925
ORA-01075: you are currently logged on
Enter user-name:

Then i found audit file location is full.

Workaround :-

Deleted some old files on audit location as below.

"cd /oradbaudit/app/oracle/admin/<ORACLE DATABASE UNIQUE NAME>/adump"

"find . -name "*.aud" \( -mtime + -o -atime +1 \) | xargs rm"

With Regards,
Jack
Re: ERROR: ORA-09925: Unable to create audit trail file Linux-x86_64 Error: [message #609200 is a reply to message #609198] Mon, 03 March 2014 21:40 Go to previous messageGo to next message
BlackSwan
Messages: 22521
Registered: January 2009
Senior Member
BTW, only the newer versions of Oracle DB are certified on Linux 6.
Posting Guidelines clearly state that you are to provide 4 digit Oracle version in EVERY new thread!
Re: ERROR: ORA-09925: Unable to create audit trail file Linux-x86_64 Error: [message #609216 is a reply to message #609200] Tue, 04 March 2014 01:47 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Got it Blackswan.

Oracle version is 11.2.0.3.0
Re: ERROR: ORA-09925: Unable to create audit trail file Linux-x86_64 Error: [message #609263 is a reply to message #609216] Tue, 04 March 2014 23:09 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Hi,

When trying to delete some old files older than 1 day, i see this 'find' command is not working on linux platform.

[oracle@RAC03 adump]$ find . -name "*.aud" \( -mtime + -o -atime +1 \) | xargs rm
find: invalid argument `-o' to `-mtime'
rm: missing operand
Try `rm --help' for more information.

Note:--
Audit files are located in /oradbaudit FS and space usage details is below.

/dev/mapper/datavg-auditfslv
                      51606140  13544832  35439868  28% /oradbaudit
/dev/mapper/datavg-dbtoolslv

Even i am not able to create a new file on /oradbaudit after deleting few files on same location as shown below.

[oracle@RAC03 adump]$ touch test
touch: cannot touch `test': No space left on device
[oracle@RAC03 adump]$
[oracle@RAC03 adump]$ pwd
/oradbaudit/app/oracle/admin/DB1/adump

Request your suggestion on how to proceed further with this.

Regards,
jack
Re: ERROR: ORA-09925: Unable to create audit trail file Linux-x86_64 Error: [message #609266 is a reply to message #609263] Tue, 04 March 2014 23:21 Go to previous messageGo to next message
BlackSwan
Messages: 22521
Registered: January 2009
Senior Member
http://www.unix.com/shell-programming-scripting/150608-find-number-files-older-than-1-day-dir.html
Re: ERROR: ORA-09925: Unable to create audit trail file Linux-x86_64 Error: [message #609271 is a reply to message #609263] Wed, 05 March 2014 00:29 Go to previous messageGo to next message
Michel Cadot
Messages: 58610
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
-mtime + -o


1 missing?


Re: ERROR: ORA-09925: Unable to create audit trail file Linux-x86_64 Error: [message #609318 is a reply to message #609271] Wed, 05 March 2014 08:16 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Quote:
1 missing?


Michel,
Can you be clear what you are trying to tell me ?

Re: ERROR: ORA-09925: Unable to create audit trail file Linux-x86_64 Error: [message #609320 is a reply to message #609318] Wed, 05 March 2014 08:35 Go to previous messageGo to next message
cookiemonster
Messages: 10852
Registered: September 2008
Location: Rainy Manchester
Senior Member
The + in the code Michel is quoting needs to be followed by a number.
Re: ERROR: ORA-09925: Unable to create audit trail file Linux-x86_64 Error: [message #609322 is a reply to message #609320] Wed, 05 March 2014 09:12 Go to previous messageGo to next message
gazzag
Messages: 276
Registered: November 2010
Location: Bristol, UK
Senior Member
find . -name "*.aud" \( -mtime +1 -o -atime +1 \) | xargs rm;

HTH
-g
Re: ERROR: ORA-09925: Unable to create audit trail file Linux-x86_64 Error: [message #609334 is a reply to message #609322] Wed, 05 March 2014 11:49 Go to previous messageGo to next message
Michel Cadot
Messages: 58610
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Good to see you are able to read my and cookiemonster's posts and can then write the command.

Re: ERROR: ORA-09925: Unable to create audit trail file Linux-x86_64 Error: [message #609388 is a reply to message #609334] Thu, 06 March 2014 04:07 Go to previous messageGo to next message
gazzag
Messages: 276
Registered: November 2010
Location: Bristol, UK
Senior Member
I wanted to finish the thread before one of us died.
Re: ERROR: ORA-09925: Unable to create audit trail file Linux-x86_64 Error: [message #609439 is a reply to message #609388] Thu, 06 March 2014 20:09 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Quote:
I wanted to finish the thread before one of us died.


This thread is already closed.Thanks guys for confirming the command.
Re: ERROR: ORA-09925: Unable to create audit trail file Linux-x86_64 Error: [message #609440 is a reply to message #609439] Thu, 06 March 2014 20:23 Go to previous message
BlackSwan
Messages: 22521
Registered: January 2009
Senior Member
>This thread is already closed
when did this occur?
Previous Topic: SGA estimation
Next Topic: pin oracle table rows
Goto Forum:
  


Current Time: Tue Jul 29 10:58:04 CDT 2014

Total time taken to generate the page: 0.11283 seconds