|
|
|
|
|
|
|
|
| Re: disable Oracle 11 audit (.aud) [message #556108 is a reply to message #556097] |
Thu, 31 May 2012 05:48   |
John Watson
Messages: 8988
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
We have a cusomter whose sys.aud$ table had grown to 6G, in the system tablespace, because of the 11g efault audits. They were not aware that the auditing was happening. This will show you the audits:
select privilege from dba_priv_audit_opts;
and disable them with
noaudit .....
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: disable Oracle 11 audit (.aud) [message #556141 is a reply to message #556135] |
Thu, 31 May 2012 08:10 |
 |
Shamall
Messages: 12
Registered: May 2012
|
Junior Member |
|
|
when I start oracle the log file still shows:
Could not open audit file: /dev/null/xe_ora_4457_1.aud
Retry Iteration No: 1 OS Error: 20
Retry Iteration No: 2 OS Error: 20
Retry Iteration No: 3 OS Error: 20
Retry Iteration No: 4 OS Error: 20
Retry Iteration No: 5 OS Error: 20
OS Audit file could not be created; failing after 5 retries
that´s all. I just have to change from /dev/null back to the old path, but how ....
there is no init.ora in admin/XE/dbs
[Updated on: Thu, 31 May 2012 08:11] Report message to a moderator |
|
|
|
|
|
|
|
| Re: disable Oracle 11 audit (.aud) [message #556151 is a reply to message #556144] |
Thu, 31 May 2012 08:45 |
|
Shamall
Messages: 12
Registered: May 2012
|
Junior Member |
|
|
my env is only:
USER=oracle
MAIL=/var/spool/mail/oracle
PWD=/u01/app/oracle
HOME=/u01/app/oracle
LOGNAME=oracle
p.s. user root / ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
while changing the parameter the db was not running. Now I have restored my backup and the db is running again. But I still don´t know which init.ora I a´m using.
[Updated on: Thu, 31 May 2012 08:47] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
