I have a database using 11gR2 (188.8.131.52) I call server 1. Sometime, $ORACLE_GRID/rdbms/audit/ directory is deleted and if its exists, it doesn't audit file.
When I log on asm via sqlplus, I see in this directory have a new file *.aud.
I have crontab for delete old audit file as below:
find /u01/app/oracle/product/11.2.0/grid/rdbms/audit/ -ctime +1 | xargs rm -rf
I checked other database using same oracle version, $ORACLE_GRID/rdbms/audit/ directory in this server has a lot of audit files.
Please tell me why doesn't audit file create in server 1. How to resolve it ?
you have to look at the database parameter AUDIT_TRAIL. It tells whether there is Audit and where it is stored. So there is a difference in this parameter between the databases. You can read more about the parameter in the manual: http://docs.oracle.com/cd/E14072_01/server.112/e10820/initparams017.htm
Herald ten Dam
Look in your Pfile that the parameter about the audit files are set correctly. Also, look the alert_SID.log if then any errors. I did a explanation about this files in my blog http://translate.google.com/translate?hl=en&sl=pt&tl=en&u=http%3A%2F%2Fbrunors.com%2F%3Fp%3D248%26gt . Above all, see the parameters in your database.
Kind regards, Bruno Reis.