Home » RDBMS Server » Security » How to set Destination file for AUDIT_TRAIL=OS
How to set Destination file for AUDIT_TRAIL=OS [message #278634] Mon, 05 November 2007 03:50 Go to next message
sbmk_design
Messages: 88
Registered: April 2007
Location: CHENNAI
Member
Hi
OS = Window 2003 server
ORACLE= EE-10.1.0.2.0

I set AUDIT_TRAIL=DB it works well, I could see
all audit information in DBA_AUDIT_TRAIL table

Now I wanted to store all audit information
in os file.I set these two parameters

1)AUDIT_TRAIL=OS
2)AUDIT_SYS_OPERATIONS=TRUE

3)Restarted the server.

4)There is no any folder/file like AUDIT
in my Oracle_home\rdbms\--- (or)
Oracle_base\product\10.1.0\admin\orcl\---


5)There is no any such parameter like
AUDIT_FILE_DEST

6)How to set audit file Destination path ?
Re: How to set Destination file for AUDIT_TRAIL=OS [message #278635 is a reply to message #278634] Mon, 05 November 2007 04:04 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

As a DBA ,Paste the output of ,
Quote:


show parameter audit_file_dest

Re: How to set Destination file for AUDIT_TRAIL=OS [message #278638 is a reply to message #278634] Mon, 05 November 2007 04:14 Go to previous messageGo to next message
sbmk_design
Messages: 88
Registered: April 2007
Location: CHENNAI
Member
Mr Arju
I gave the following syntax,getting error
SQL>Alter system set audit_trial_dest='c:\ora';

Error:ORA-02065 illegal option for ALTER SYSTEM.

BY
sbmk
Re: How to set Destination file for AUDIT_TRAIL=OS [message #278641 is a reply to message #278638] Mon, 05 November 2007 04:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is audit_trial_dest?
Arju talked about audit_file_dest.
Do you see the difference?

In addition, this is a static parameter you have to specify scope=spfile or modify it in init.ora and restart.

Regards
Michel
Re: How to set Destination file for AUDIT_TRAIL=OS [message #278650 is a reply to message #278634] Mon, 05 November 2007 05:06 Go to previous messageGo to next message
sbmk_design
Messages: 88
Registered: April 2007
Location: CHENNAI
Member
sorry Mr Michel
That is typing mistake, actually I gave audit_file_dest=
I am getting the same error.Moreover once again I checked my
server init parameters there is no such parameter like
AUDIT_FILE_DEST

by
sbmk
Re: How to set Destination file for AUDIT_TRAIL=OS [message #278652 is a reply to message #278634] Mon, 05 November 2007 05:08 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:

scope=spfile
Re: How to set Destination file for AUDIT_TRAIL=OS [message #278654 is a reply to message #278634] Mon, 05 November 2007 05:13 Go to previous messageGo to next message
sbmk_design
Messages: 88
Registered: April 2007
Location: CHENNAI
Member
Mr Arju
yes I added scope=spfile also I am getting the same
Error:ORA-02065 illegal option for ALTER SYSTEM.

by
sbmk
Re: How to set Destination file for AUDIT_TRAIL=OS [message #278657 is a reply to message #278654] Mon, 05 November 2007 05:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Copy and paste what you did.
For sure you did it wrong.

Regards
Michel
Re: How to set Destination file for AUDIT_TRAIL=OS [message #278670 is a reply to message #278657] Mon, 05 November 2007 06:19 Go to previous messageGo to next message
sbmk_design
Messages: 88
Registered: April 2007
Location: CHENNAI
Member
Mr.Michel
This is syntax I used

SQL> alter system set audit_trail=os scope=spfile;
System altered.

SQL> alter system set audit_sys_operations=true scope=spfile;
System altered.

-- server restarted---------------

SQL> alter system set audit_file_dest='e:\traceout' ;
alter system set audit_file_dest='e:\traceout'
*
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM


SQL> alter system set audit_file_dest=e:\traceout ;
alter system set audit_file_dest=e:\traceout
*
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM

by
sbmk
Re: How to set Destination file for AUDIT_TRAIL=OS [message #278673 is a reply to message #278670] Mon, 05 November 2007 06:27 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What part of "scope=spfile" don't you understand?
Curious you are able to do it for audit_trail or audit_sys_operations but not for audit_file_dest.
You know you can do it in 3 statements not only 2.

Regards
Michel
Re: How to set Destination file for AUDIT_TRAIL=OS [message #278686 is a reply to message #278634] Mon, 05 November 2007 07:04 Go to previous messageGo to next message
sbmk_design
Messages: 88
Registered: April 2007
Location: CHENNAI
Member
Mr Michel

I tried with audit_file_dest=e:\traceout scope=spfile;
still I am the same error

--- folder within single quote----

SQL> ALTER SYSTEM SET AUDIT_FILE_DEST='E:\TRACEOUT' SCOPE=SPFILE;
ALTER SYSTEM SET AUDIT_FILE_DEST='E:\TRACEOUT' SCOPE=SPFILE
*
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM

--- folder without single quote----

SQL> ALTER SYSTEM SET AUDIT_FILE_DEST=E:\TRACEOUT SCOPE=SPFILE;
ALTER SYSTEM SET AUDIT_FILE_DEST=E:\TRACEOUT SCOPE=SPFILE
*
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM

am i missing any other related parameter to set?

by
sbmk

[Updated on: Mon, 05 November 2007 07:05]

Report message to a moderator

Re: How to set Destination file for AUDIT_TRAIL=OS [message #278707 is a reply to message #278686] Mon, 05 November 2007 07:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL> ALTER SYSTEM SET AUDIT_FILE_DEST='C:\ORACLE\ADMIN\MIKA\ADUMP' SCOPE=SPFILE;

System altered.

I just copy and paste your statement changing the directory to an existing one and this works.
Check your ' are correct ones.
As you don't format we can't see it.

Regards
Michel
Re: How to set Destination file for AUDIT_TRAIL=OS [message #278924 is a reply to message #278634] Tue, 06 November 2007 05:36 Go to previous messageGo to next message
sbmk_design
Messages: 88
Registered: April 2007
Location: CHENNAI
Member
Hi
Still I couldn't fix AUDIT_FILE_DEST. I checked folder. It exist and all privileges(read write) granted.
In my init parameter file there is no such parameter called
AUDIT_FILE_DEST .see.. then how can I fix this parameter..
any other way ?

SQL> select * from v$parameter order by name;
NUM NAME TYPE VALUE
---------- ----------------------------- -----------
658 O7_DICTIONARY_ACCESSIBILITY 1 FALSE
208 active_instance_count 3
1043 aq_tm_processes 3 0
448 archive_lag_target 3 0
1123 asm_diskgroups 2
1119 asm_diskstring 2
1124 asm_power_limit 3 1
664 audit_sys_operations 1 TRUE
771 audit_trail 2 OS
748 background_core_dump 2 partial

SQL> ALTER SYSTEM SET AUDIT_FILE_DEST='E:\Oracle\product\10.1.0\admin\orcl\adump' SCOPE=SPFILE;

ALTER SYSTEM SET AUDIT_FILE_DEST='E:\Oracle\product\10.1.0\admin\orcl\adump' SCOPE=SPFILE
*
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM

by
sbmk
Re: How to set Destination file for AUDIT_TRAIL=OS [message #278945 is a reply to message #278924] Tue, 06 November 2007 07:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
select * from v$version;
show parameter comptabible

Regards
Michel
Re: How to set Destination file for AUDIT_TRAIL=OS [message #278965 is a reply to message #278634] Tue, 06 November 2007 08:12 Go to previous messageGo to next message
sbmk_design
Messages: 88
Registered: April 2007
Location: CHENNAI
Member
Mr Michel


SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod
PL/SQL Release 10.1.0.2.0 - Production
CORE 10.1.0.2.0 Production
TNS for 32-bit Windows: Version 10.1.0.2.0 - Production
NLSRTL Version 10.1.0.2.0 - Production

SQL> show parameter comptabible;
SQL> --- nothing is displayed here ---
SQL>

by
sbmk
Re: How to set Destination file for AUDIT_TRAIL=OS [message #278998 is a reply to message #278965] Tue, 06 November 2007 09:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Sorry "compatible" not "comptabible"

Regards
Michel
Re: How to set Destination file for AUDIT_TRAIL=OS [message #279103 is a reply to message #278634] Tue, 06 November 2007 22:58 Go to previous messageGo to next message
sbmk_design
Messages: 88
Registered: April 2007
Location: CHENNAI
Member
Ok Mr.Michel
SQL> show parameter compatible;(already I have given this)

NAME TYPE VALUE
------------------------------------ ----------- ------------
compatible string 10.1.0.2.0

by
sbmk

[Updated on: Tue, 06 November 2007 23:01]

Report message to a moderator

Re: How to set Destination file for AUDIT_TRAIL=OS [message #279133 is a reply to message #279103] Wed, 07 November 2007 01:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

already I have given this

No, you didn't have, you gave version.
And even if it the case, answer my questions.

Try:
ALTER SYSTEM SET AUDIT_FILE_DEST='E:\Oracle\product\10.1.0\admin\orcl\adump' deferred SCOPE=xxx;
with xxx is in (BOTH,MEMORY,SPFILE) that is try the 3 syntaxes.


Regards
Michel
Re: How to set Destination file for AUDIT_TRAIL=OS [message #279154 is a reply to message #278634] Wed, 07 November 2007 02:42 Go to previous messageGo to next message
sbmk_design
Messages: 88
Registered: April 2007
Location: CHENNAI
Member
Mr Michel
I tried with all 3 possibility, shows error

SQL> alter system set audit_trail=os scope=spfile;
System altered.

SQL> alter system set audit_sys_operations=true scope=spfile;
System altered.

SQL> alter system set audit_file_dest='E:\Oracle\product\10.1.0\admin\orcl\adump' deferred SCOPE=SPFILE;
alter system set audit_file_dest='E:\Oracle\product\10.1.0\admin\orcl\adump' deferred SCOPE=SPFILE
*
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM


SQL> alter system set audit_file_dest='E:\Oracle\product\10.1.0\admin\orcl\adump' deferred SCOPE=BOTH;
alter system set audit_file_dest='E:\Oracle\product\10.1.0\admin\orcl\adump' deferred SCOPE=BOTH
*
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM


SQL> alter system set audit_file_dest='E:\Oracle\product\10.1.0\admin\orcl\adump' deferred SCOPE=MEMORY;
alter system set audit_file_dest='E:\Oracle\product\10.1.0\admin\orcl\adump' deferred SCOPE=MEMORY
*
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM

by
sbmk
Re: How to set Destination file for AUDIT_TRAIL=OS [message #279158 is a reply to message #279154] Wed, 07 November 2007 02:53 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Metalink note 1063941.6: cannot specify audit_file_dest on Windows platform

Regards
Michel
Previous Topic: SYS has insufficient priviledges
Next Topic: Oracle 11g DBMS_SQL Security
Goto Forum:
  


Current Time: Thu Mar 28 10:22:31 CDT 2024