Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cant start dbase as No space left on device due to $USERS.dbf

Status
Not open for further replies.

marrow

Technical User
Jul 20, 2001
425
US
Orace9.2
SQL> connect /as sysdba
ERROR:
ORA-09817: Write to audit file failed.
SVR4 Error: 28: No space left on device
ORA-09945: Unable to initialize the audit trail file
SVR4 Error: 28: No space left on device

On test system USERS.dbf has taken 12Gb of space and filled file-system to 100%. Should I simply delete offending USERS so our other database can startup, or... advice welcome
 
I released some space and was able to shutdown & restart databases OK. So I now need to address $users01.dbf and reduce size from 12GB to a normal size as space is still at almost 100%
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top