Solved

ora 09945

Posted on 2007-04-03
5
668 Views
Last Modified: 2008-01-09
 ORA-09945
ORA-09945: Unable to initialize the audit trail file

What to do incase of above error
 
 
 
0
Comment
Question by:suhinrasheed
5 Comments
 
LVL 17

Expert Comment

by:NicksonKoh
ID: 18848655
Cause: Oracle was unable to write header information to the file being used as the audit trail.

Action: Check the UNIX error number for a possible operating system error. If there is no error, contact Oracle Customer Support.
0
 
LVL 28

Expert Comment

by:Naveen Kumar
ID: 18848663
ORA-09945 Unable to initialize the audit trail file

Cause: Oracle was unable to write header information to the file being used as the audit trail.

Action: Check the UNIX error number for a possible operating system error. If there is no error, contact Oracle Support Services.


Is there any file read/write permission error in the OS level ? When r u getting this error ? Do you get this when running a insert command or any other command ?

Thanks
0
 

Author Comment

by:suhinrasheed
ID: 18848673
i get this error when i try to log on to sys user
0
 
LVL 7

Expert Comment

by:gattu007
ID: 18850314
You are out of space in your ORACLE_HOME
0
 
LVL 7

Accepted Solution

by:
gattu007 earned 500 total points
ID: 18850335
or

You are out of space in your audit dest  directory
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Oracle regular expression 6 47
Bash Script to Analyze Oracle Schemas 11 85
data lookup in Oracle - need suggestions 55 104
Create table from select - oracle 6 27
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now