?
Solved

AUDIT_FILE_DEST parameter

Posted on 2003-03-18
1
Medium Priority
?
1,536 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
[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
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Suggested Courses

770 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