Re: IP auditing for unsuccessful connections

To use auditing you will need to set the init parameter Audit_trail=DB (or file)

Then set auditing on:

Audit session whenever not successful;

The output from failed connections can be seen in dba_audit_session.

You need to be careful regarding the growth of the underlying table SYS.AUD$, which is in the system tablespace by default.

There is a MOS article about moving it to a separate tablespace.

Turn off the auditing using the noaudit command.

Regards

Neil.
sent from my phone

On 28 Apr 2011, at 17:27, Dianna Gibbs <DIANNA.GIBBS_at_childrens.com> wrote:

> We have a new application that is multi-tiered with connections coming from many different windows and websphere servers.
>
>

--
http://www.freelists.org/webpage/oracle-l