| 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 ?
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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
|
|
|
|
|
|
| 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 #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
|
|
|
|
|
|
| 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
|
|
|
|
|
|
|
|
|
|
| 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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
