Home » Server Options » RAC & Failsafe » Enable audit_trail on 2 node RAC ENV on Oracle10g (Oracle10g, Linux)
Enable audit_trail on 2 node RAC ENV on Oracle10g [message #532553] Wed, 23 November 2011 08:09 Go to next message
gauravsrivastava
Messages: 22
Registered: November 2011
Location: india
Junior Member
Hi All,

I have a production database with 2 node Physical RAC ENV on two saparate machines , and we are going to enable audit trail parameter to DB values to capture all failed loggin attempts on a database.

we have done this on our testing ENV but dont know the procedure to deploy this steps on 2 node RAC ENV .

I have done the below steps on our standalone testing ENV

1. Log in as SYS and connect with the SYSDBA privilege.
o User Name: SYS
o Password: Enter your password.
o Connect As: SYSDBA
2. To enable audit on DB use below command
SQL>alter system set audit_trail=DB scope=SPFILE;

3. Then restart the database.
4. After successful startup use the below command to capture log
SQL> audit create session whenever not successful;


Request you to please provide me the steps to enable audit_trail to capture failed login attempts on two node RAC ENV.

Thanks in Advance.

Gaurav
Re: Enable audit_trail on 2 node RAC ENV on Oracle10g [message #532563 is a reply to message #532553] Wed, 23 November 2011 08:37 Go to previous messageGo to next message
Michel Cadot
Messages: 67369
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In the same way and restart both instances.

Regards
Michel
Re: Enable audit_trail on 2 node RAC ENV on Oracle10g [message #532564 is a reply to message #532563] Wed, 23 November 2011 08:41 Go to previous messageGo to next message
gauravsrivastava
Messages: 22
Registered: November 2011
Location: india
Junior Member
also the command "audit create session whenever not successful" need to be run ob both instance ;

Re: Enable audit_trail on 2 node RAC ENV on Oracle10g [message #532565 is a reply to message #532564] Wed, 23 November 2011 08:44 Go to previous messageGo to next message
Michel Cadot
Messages: 67369
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, I don't know if it is useful but it is harmless.

Regards
Michel
Re: Enable audit_trail on 2 node RAC ENV on Oracle10g [message #532568 is a reply to message #532565] Wed, 23 November 2011 09:05 Go to previous message
gauravsrivastava
Messages: 22
Registered: November 2011
Location: india
Junior Member
Thanks Michel
Previous Topic: RAC installation error on vmware
Next Topic: RMAN backup on RAC cluster
Goto Forum:
  


Current Time: Thu Sep 24 10:48:11 CDT 2020