ORA-09925: Unable to create audit trail file & SVR4 Error: 49: Disc quota exceeded

##########################
#  Error
##########################

ORA-09925: Unable to create audit trail file

##########################
#  Full Error 
##########################

ORA-09925: Unable to create audit trail file
SVR4 Error: 49: Disc quota exceeded
Additional information: 9925
ORA-01075: you are currently logged on

##########################
#  Error Occurred
##########################

When i tried to login to the database as SYS user.

Command Executed

sqlplus / as sysdba

##########################
## Cause
##########################

There may be many reasons for this ORA-09925 Error. Possibly because of,

1. FRA Become Full
2. Number of Files Quota Exceeded 
3. ORACLE_HOME is 100% full

##########################

## Solution
##########################

• FRA Become Full

Some times this happens when FRA becomes 100%, check the usage of FRA and clear it. Run below query to check FRA usage.

Select * from v$flash_recovery_area_usage;

If Archive logs occupied FRA, then run a backup of archivelogs with delete input option.

• Number of Files Quota Exceeded 

SVR4 Error: 49: Disc quota exceeded

The above error accompanied ORA-09925 Error, so there is a possibility that the disk quota might have exceeded. Run the below command to check quota for the User.


mydb @server01:/opt/oracle/admin/mydb/bdump

quota -v

Disk quotas for oracle (uid 1001):

Filesystem     usage  quota  limit    timeleft  files  quota  limit    timeleft

/home/username

               898688 819200 1024000                380     -1     -1

From the above output we can see that usage(898688) is which is higher than the quota(819200). So reduce the number of files created. Some times Audit files generation will be high with a bunch of files. So clearing the audit files will help to overcome this error.

There are chances that some times the quota might have not exceeded.

In the below output, usage is very less still Disk quota Exceeded Error.

mydb @server01:/opt/oracle/admin/mydb/bdump

quota -v

Disk quotas for oracle (uid 1001):

Filesystem     usage  quota  limit    timeleft  files  quota  limit    timeleft

/home/username

               89688 819200 1024000                380     -1     -1

• ORACLE_HOME is 100% full

In the above case problem is ORACLE_HOME has 100% FULL. 

Run df -h and Clear the Files.

Some times Space will be not be cleared after removing files also. This is because the deleted FILES are being used by ORALCE or Other Process. Use lsof command to check the List of Open Files.

If the files are used by database, then bouncing the database will release the space used.