ORA-09925: Unable to create audit trail file

[Valarie Lim]

Currently my server is running HP-UX 11.11, with Oracle9i.

Every night we shut down the oracle DB to perform backup. After backup, sometimes when database is coming up, the error "ORA-09925: Unable to create audit trail file" will appear. The database will be mounted but not open. Will need to restart the DB to make sure DB is OK.

My file/directories permission are already set properly.
Is this an oracle9i bug?

Please Help!
Yew Meng
IS this

[Yogeeraj_1]

hi,

this problem may be related to disk access/corruption problem.

This error indicates that you are unable to write to the audit directory. You have checked your audit directory and there is plenty of freespace available. You have even removed the aud$ files from the directory and this does not seem to help. All permissions are also correctly set.

(see attached metalink document)

run fsck against the filesystem, unmount and mount the filesystem.

Hope this helps!

Yogeeraj

[Yogeeraj_1]

hi again.

1. sorry forgot to attach note.

2. It can also be a disk space problem.

Make space available in $ORACLE_HOME/rdbms/audit by removing files that are not needed

or Make sure the directory exists and is readable by oracle

or Change init.ora audit_file_dest to an existing directory.

3. What other errors do youhave in your alert log?

Regards
Yogeeraj

[T G Manikandan]

What is the destination diractory specified for the parameter user_dump_dest in the init.ora file.

Make sure that the directory exist and it has the permissions for oracle user.

Revert

[Valarie Lim]

yogeeraj,

Think my filesystem should be consistent. This error only happens once in while (like two weeks).
fsck was not run.

T G,

as a matter of fact, Oracle9i was upgraded from 8i this year. Therefore there are two oracle user in the system.
oracle8 and oracle9.

The owner for user_dump_dest=/directory

is actually own by oracle8:dba.

permission is set at
drwxrwxr-x.

Is this a concern?

The frustrating part is that it happens intermittenly.

Thanks for the help!

[T G Manikandan]

What is

ORACLE_BASE
ORACLE_HOME

REvert

[T G Manikandan]

ALso this could be of

the inodes.
check your OS /var/adm/syslog/syslog.log file for any messages.

Please revert

[Yogeeraj_1]

hi,

To check the INODES for the device.
use:
df -i

Regards
Yogeeraj

[Valarie Lim]

syslog.log shows nothing.

The ORACLE_HOME=/oracle9

could not get hold of ORACLE_BASE. think it should be /oracle9 also.

attached is the output of inodes for /oracle9 filesystem where the audit trail resides.

By the way, DB auditing is not enabled in the init.ora.
Why is there is audit trail in /oracle9/rdbms/audit?

[T G Manikandan]

the administrative user connections are logged to files created by Oracle and stored in $ORACLE_HOME/rdbms/audit directory.

This does not have to have the audit_trial enabled or auditing enabled.

Because auditing make entries in the tables of the database.
When the database is down and the administrative accouts startup and do anything on the instance it is logged here.

Thanks