Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

AUDIT_FILE_DEST parameter

Posted on 2003-03-18
1
Medium Priority
?
1,547 Views
Last Modified: 2007-12-19
We are using Oracle9i Release 9.2.0.1.0 - Production Standard. We tried to set the parameter audit file destination in the pfile but when starting up the database it didn't recognize the parameter. We dropped it and went forward. Auditing is working and it is dumping to the default destination.

Can somebody give me a reason that Oracle didn't recognize this?  It's in the documentation..!?!
0
Comment
Question by:DonFreeman
1 Comment
 
LVL 3

Accepted Solution

by:
bkowalski earned 200 total points
ID: 8160790
If this is on NT or 2000, then this is likely your problem:

Problem Description: When configuring Auditing on an NT and you add the parameter AUDIT_FILE_DEST then you bounce the database for the parameter to take effect you get:  LRM-00101: UNKNOWN PARAMETER NAME 'AUDIT_FILE_DEST' ORA-01078: FAILURE IN PROCESSING SYSTEM PARAMETERS    

Problem Explanation: On Windows NT the auditing information is sent to the NT Event Viewer not a file This parameter is not supported for Windows NT since all auditing information is sent to the Windows NT Event Viewer and not a file.  
0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

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

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses
Course of the Month13 days, 11 hours left to enroll

580 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