How To Resolve Ora-09817
When I try to connect oracle database under Linux,it throws errors like this:
ORA-09817: Write to audit file failed No space left on device How to Shutdown and Start Oracle Real Application Clusters Database - These 10 Easy Steps What is Exadata? ORA-28007: The Password Cannot Be Reused SQL alter user system identified by mufti@143; alter user system identified by mufti@143. ERROR at line 1: ORA-28007: the password cannot be reused Check user profile: SQL select USERNAME, PROFILE, ACCOUNTSTATUS from dbausers where username = 'SYSTEM'; USERNAME PROFILE ACCOUNTSTATUS.
df command shows there's no space left and the filesystem is full.I want to know the size of each tablespace and how to release the free tablespace.Thanks!
1 Answer
Svr4 Error: 28: No Space Left On Device
First see which partition is full:
Oracle needs to write to the audit file whenever someone logs on.Free some space and add a monitor on the mountpoint to alert you before it runs out of space.
I recommend NAGIOS for free monitoring of Linux (and a lot more).
sth
Not the answer you're looking for? Browse other questions tagged oracle10g or ask your own question.
How To Resolve Ora-09817 In Hindi
When I try to connect oracle database under Linux,it throws errors like this:
df command shows there's no space left and the filesystem is full.I want to know the size of each tablespace and how to release the free tablespace.Thanks!
1 Answer
First see which partition is full:
Oracle needs to write to the audit file whenever someone logs on.Free some space and add a monitor on the mountpoint to alert you before it runs out of space.
I recommend NAGIOS for free monitoring of Linux (and a lot more).
sth