OraFAQ Forum: Server Administration » ERROR: ORA-09925: Unable to create audit trail file Linux-x86

Home » RDBMS Server » Server Administration » ERROR: ORA-09925: Unable to create audit trail file Linux-x86_64 Error: (Linux 6)

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

ERROR: ORA-09925: Unable to create audit trail file Linux-x86_64 Error: [message #609198]

Mon, 03 March 2014 21:17

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

Report message to a moderator

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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!

Report message to a moderator

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

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Got it Blackswan.

Oracle version is 11.2.0.3.0

Report message to a moderator

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

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

Report message to a moderator