| Monu |
Posted: Feb 07, 2008 04:02:12 PM |
Total Post: 26
Joined: Jan, 2008
|
I'm getting following errors: -
SQL> conn / as sysdba
ERROR:
ORA-09817: Write to audit file failed.
Linux Error: 28: No space left on device
ORA-01075: you are currently logged on
reason is I set audit_sys_operations=true;
and now SYS.AUD$ TABLE IS FULL. AND NO SPACE LEFT ON MOUNTED DISK, I CAN'T TRUNCATE SYS.AUD$ TABLE WITHOUT LOGIN BY SYS AND SYS.AUD$ TABLE IS IN SYSTEM TABLESPACE. TELL ME WHAT TO DO.
other parameters relating to auditing are: -
audit_trail=db
audit_file_dest=?/rdbms/audit |
|
|
 Murtuja |
| Posted: Feb 07, 2008 10:58:02 PM |  |
|
Total Post: 857
Joined: Jan, 2006
|
Have you checked disk space using "df -h".If it's full then you have to make some space free.
|
|
|
|
|
| Murtuja |
| Posted: Feb 07, 2008 10:59:56 PM | |
|
Total Post: 857
Joined: Jan, 2006
|
Hi,
You can delete files from udump,bdump directories and also from ?/network/log.
|
|
|
|
|
| Monu |
| Posted: Feb 08, 2008 11:23:43 AM | |
|
Total Post: 26
Joined: Jan, 2008
|
Yes, I released some of the space from the disk and it's working properly. DOn't you think it is better to specify a file on o/s level rather than using database, for auditing sysdba. ie by setting audit_sys_operations=true;
Need Advice.
Is there any documentation on auditing please let me that as I need to implement auditing in our organisation.
Thanks.....
|
|
|
|
|
| Mohammed Taj |
| Posted: Feb 09, 2008 12:18:09 AM | |
|
Total Post: 746
Joined: Jul, 2007
|
http://download.oracle.com/docs/cd/B19306_01/network.102/b14266/auditing.htm#DBSEG125
http://dbataj.blogspot.com/search/label/Audit%20Database
|
|
|
|
|
| Gitesh |
| Posted: Mar 11, 2008 07:41:29 AM | |
|
Total Post: 322
Joined: May, 2005
|
Hi,
audit_file_dest
audit_sys_operations
Kindly check audit_file_dest's location. Default is the @ORACLE_HOME/rdbms/audit. Change same location otherwise your ORACLE_HOME will be full.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
