Solved

ora 09945

Posted on 2007-04-03
5
686 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

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

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Suggested Courses

631 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