| Enable audit_trail on 2 node RAC ENV on Oracle10g [message #532553] |
Wed, 23 November 2011 08:09  |
 |
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
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
