ORA-09817: Write to audit file failed.

[budh]

Hi,

I have an exp running on a schedule daily as a method to backup our database. Recently I started getting this error:

EXP-00008: ORACLE error 9817 encountered
ORA-09817: Write to audit file failed.
EXP-00000: Export terminated unsuccessfully

I have checked permissions to the audit log file and everything is ok. I have also checked disk space and there is tons. Any idea what is causing this problem?

SYSTEM: Windows 2003 Std. Ed. Oracle 10g R2

Thanx
D

[LKBrwn_DBA]

Yes, this is your problem: SYSTEM: WinDoze.

PS: Export is not a good method to backup your database.

Check the value for: AUDIT_FILE_DEST parameter and the value of the instance parameter AUDIT_SYS_OPERATIONS.

Re-check if you have privileges to write on the AUDIT_FILE_DEST path or the path is full.

[budh]

hehehehe... But WinDoze works eh... and yes, I know exp is not a good way to back up my database, but it works for us - for now...

show parameter AUDIT_FILE_DEST:

audit_file_dest string D:\ORACLE\PRODUCT\10.2.0\ADMIN\SPFDB\ADUMP

show parameter AUDIT_SYS_OPERATIONS:

audit_sys_operations boolean TRUE

I have checked permissions and it is correct. Further I am administrator on the server so have complete permissions.

Any other ideas?

[BV1963]

Post your export script please

[budh]

exp '/@SPFDB as sysdba' file=D:\Backup\SPFDB.dmp log=D:\Backup\SPFDB.log full=yes statistics=none

[mdvreddy]

check the file system having enough space to have file size growing.
Cheers...
/MR

[LKBrwn_DBA]

Try this:

exp /@SPFDB file=D:\Backup\SPFDB.dmp log=D:\Backup\SPFDB.log full=yes statistics=none

[budh]

There is enough space on the disk 40.1GB.

If I remove the 'as sysdba' it then askes for a username and password when executing the script.

[BV1963]

put another valid userid and password instead of sysdba. sysdba connections are monitored and traces stored on the disk where you lacking free space

exp system/manager@db .......

[budh]

if I do an exp using a username and password it works just fine. So, yes it obviously has something to do with Audit. Besides permissions and space, what else can I look for. ON the web, I have only found articles regarding permissions and space...