Printable View
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
Yes, this is your problem: SYSTEM: WinDoze.
PS: Export is not a good method to backup your database. :rolleyes:
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.
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?
Post your export script please
exp '/@SPFDB as sysdba' file=D:\Backup\SPFDB.dmp log=D:\Backup\SPFDB.log full=yes statistics=none
check the file system having enough space to have file size growing.
Cheers...
/MR
Try this:
:rolleyes:Code:exp /@SPFDB file=D:\Backup\SPFDB.dmp log=D:\Backup\SPFDB.log full=yes statistics=none
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.
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 .......
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...
Perhaps this is because the issue is just related to permissions and space... but you should keep your mind open to other possibilities like alien abduction -as Gandolf has pointed out in other cases :cool:Quote:
Originally Posted by budh
As I told you, trace file can not be created due to the either lack of space or permissions. It only gets created when you connect as a sysdba. Check your bdump and udump directoties settings and locations.
background_dump_dest
user_dump_dest
hi,
any suggestions?
Did you do what was suggested already?
yes.. everything.. still same problem..
The OS User currently being used to do the exports are in the local administrators group. The user I have logged onto the box with is also a member of domain admins and has been added to the local admin group. There is 40GB of free space on the drive.
No underlying OS errors? (error codes, error msgs). can you check a few trace files?
nope.. nothing.. That's the problem.. I don't know where to look... I have checked all the common places, event viewer, logs etc etc. but nothing...
Can you connect to the database as a sysdba using sqlplus ?
What are the values of these parameters :
background_dump_dest
user_dump_dest
BV1963... you are a Saint!
YESQuote:
Originally Posted by BV1963
D:\ORACLE\PRODUCT\10.2.0\ADMIN\SPFDB\BDUMPQuote:
Originally Posted by BV1963
D:\ORACLE\PRODUCT\10.2.0\ADMIN\SPFDB\UDUMPQuote:
Originally Posted by BV1963
I am out of ideas, ....
Is D:\ORACLE\PRODUCT\10.2.0\ADMIN\SPFDB\ADUMP is writeable?
yes..the user I am using has been given complete admin rights on the box. Me too!! :( Yikes! What do I do? Thanx all for your help though... I wll post solution once I find it (if I find it).
This is not what BV1963 asked.Quote:
Originally Posted by budh
On the other hand, when talking about privs you should be looking at Oracle account privs, not the privs you have.
Quote:
Originally Posted by PAVB
This is excatly right, thanks PAVB! So , can you write to this dir? What if somebody made this directory read only?
BTW, are you logging in with the local account and domain account? Sometimes it creates a lot of confusion specifically if domaiin accout has the same name a local one.
Domain account and the domain account is being used to execute the exp script and yes there it has read/write/execute writes on all necessary folders...
This account has been setup to use Windows Authentication. How does that differ from:
NOTE: this problem only started once I turned Auditing on. The script worked fine, before thatQuote:
On the other hand, when talking about privs you should be looking at Oracle account privs, not the privs you have.
It means that oracle session runs under oracle privs , not under your acct privs,therefore PAVB suggest that you should check if acct which is used for oracle server (service?) has all the right privs.Quote:
Originally Posted by budh