OraFAQ Forum: Security » How to set Destination file for AUDIT_TRAIL=OS

Home » RDBMS Server » Security » How to set Destination file for AUDIT_TRAIL=OS

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to set Destination file for AUDIT_TRAIL=OS [message #278634]

Mon, 05 November 2007 03:50

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 ?

Report message to a moderator

Re: How to set Destination file for AUDIT_TRAIL=OS [message #278635 is a reply to message #278634]

Mon, 05 November 2007 04:04

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

Report message to a moderator

Re: How to set Destination file for AUDIT_TRAIL=OS [message #278638 is a reply to message #278634]

Mon, 05 November 2007 04:14

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

Report message to a moderator

Re: How to set Destination file for AUDIT_TRAIL=OS [message #278641 is a reply to message #278638]

Mon, 05 November 2007 04:22

Michel Cadot
Messages: 68712
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: How to set Destination file for AUDIT_TRAIL=OS [message #278650 is a reply to message #278634]

Mon, 05 November 2007 05:06

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

Report message to a moderator

Re: How to set Destination file for AUDIT_TRAIL=OS [message #278652 is a reply to message #278634]

Mon, 05 November 2007 05:08

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Quote:

scope=spfile

Report message to a moderator

Re: How to set Destination file for AUDIT_TRAIL=OS [message #278654 is a reply to message #278634]

Mon, 05 November 2007 05:13

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

Report message to a moderator

Re: How to set Destination file for AUDIT_TRAIL=OS [message #278657 is a reply to message #278654]

Mon, 05 November 2007 05:20

Michel Cadot
Messages: 68712
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Copy and paste what you did.
For sure you did it wrong.

Regards
Michel

Report message to a moderator

Re: How to set Destination file for AUDIT_TRAIL=OS [message #278670 is a reply to message #278657]

Mon, 05 November 2007 06:19

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

Report message to a moderator

Re: How to set Destination file for AUDIT_TRAIL=OS [message #278673 is a reply to message #278670]

Mon, 05 November 2007 06:27

Michel Cadot
Messages: 68712
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: How to set Destination file for AUDIT_TRAIL=OS [message #278686 is a reply to message #278634]

Mon, 05 November 2007 07:04

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

Michel Cadot
Messages: 68712
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: How to set Destination file for AUDIT_TRAIL=OS [message #278924 is a reply to message #278634]

Tue, 06 November 2007 05:36

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

Report message to a moderator

Re: How to set Destination file for AUDIT_TRAIL=OS [message #278945 is a reply to message #278924]

Tue, 06 November 2007 07:15

Michel Cadot
Messages: 68712
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

select * from v$version;
show parameter comptabible

Regards
Michel

Report message to a moderator

Re: How to set Destination file for AUDIT_TRAIL=OS [message #278965 is a reply to message #278634]

Tue, 06 November 2007 08:12

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

Report message to a moderator

Re: How to set Destination file for AUDIT_TRAIL=OS [message #278998 is a reply to message #278965]

Tue, 06 November 2007 09:39

Michel Cadot
Messages: 68712
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Sorry "compatible" not "comptabible"

Regards
Michel

Report message to a moderator

Re: How to set Destination file for AUDIT_TRAIL=OS [message #279103 is a reply to message #278634]

Tue, 06 November 2007 22:58

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

Michel Cadot
Messages: 68712
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: How to set Destination file for AUDIT_TRAIL=OS [message #279154 is a reply to message #278634]

Wed, 07 November 2007 02:42

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

Report message to a moderator

Re: How to set Destination file for AUDIT_TRAIL=OS [message #279158 is a reply to message #279154]

Wed, 07 November 2007 02:53

Michel Cadot
Messages: 68712
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Metalink note 1063941.6: cannot specify audit_file_dest on Windows platform

Regards
Michel

Report message to a moderator

Previous Topic:	SYS has insufficient priviledges
Next Topic:	Oracle 11g DBMS_SQL Security

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 13 03:22:15 CST 2024