Issues with AUDIT_FILE_DEST parameter

[Ainsley]

Hello guys,
I am getting error during create spfile from pfile. I am running with Windows 2000 Server and Oracle 9i Enterprise. When I execute this command,it throws some error like :

ERROR at line 1:
ORA-01078: failure in processing system parameters
LRM-00101: unknown parameter name 'audit_file_dest'

Please share some suggestion with me to solve this problem. Your help will be appreciated.

[Reegan]

Issues with AUDIT_FILE_DEST parameter

The parameter shows the character of Database Instance.So the parameters plays a very important role in database functioning.When you change some parameter in PFILE related AUDITING and wants to reflect same contents in SPFILE also.

You are getting some error as mentioned above.You need to change or remove the AUDIT_FILE_DEST parameter from the pfile and then start your database normally.

[opaper]

AUDIT_FILE_DEST parameter :

This parameter specifies and locate the directory where the audit trail is written.The audit_trail parameter defines the format of audit records.You can define the AUDIT_FILE_DEST parameter manually and In case of default behavior,It stores the audit record in ORACLE_BASE/admin/DB_UNIQUE_NAME/adump.

The parameter is specified in the parameter file as follows :

AUDIT_FILE_DEST = 'directory......'

Where "directory......" locate the ORACLE_BASE/admin/DB_UNIQUE_NAME/adump as default and manually you can put any path as you want.

[MindSpace]

The AUDIT_TRAIL initialization parameter :

The AUDIT_TRAIL initialization parameter decide the format of the audit records of database or database user.It has some values that is being passed with the parameter.

The three values are being used :os,xml or extended.You can use one of these three values at a time.

AUDIT_TRAIL=XML

Now the audit records will be generated in the XML format and stored into the specified directory.

[Modifier]

AUDIT_SYS_OPERATIONS parameter :

The AUDIT_SYS_OPERATIONS parameter defines the behavior of AUDITING issued by SYS user.The Database administrator can enable and disable whenever he/she required.

It perform the functionality of auditing on Boolean values which is issued with the AUDIT_SYS_OPERATIONS parameter.The default behavior of this parameter is FALSE.