Auditing In Oracle Of Sys and Other Users

- 

- 

-  

SQL> SHOW PARAMETER AUDIT

NAME                 TYPE        VALUE
----------------------------------------------------
audit_file_dest      string      C:\ORACLE\PRODUCT\10.2.0\
                                 ADMIN\DB10G\ADUMP
audit_sys_operations boolean     FALSE
audit_trail          string      NONE
SQL>

Audit is disable by default, but can be enabled by audit_trail 

static parameter which can have following possible values.

Audit_Trail = 'Following_Option'

Data Guard/Broker Configuration Oracle 10g

PRIMARY SITE: (Information)

•                      Machine IP: 192.168.1.10
•                      Database name (db_name): ORCL
•                      Database Unique Name (db_unique_name): primary
•                      TNS Service Name: to_standby (Through this service, the primary machine will be connected to   STANDBY machine)

STANDBY SITE: (Information)

•                      Machine IP: 192.168.1.20
•                      Database name (db_name): ORCL
•                      Database Unique Name (db_unique_name): standby
•                      TNS Service Name: to_primary (Through this service, the standby machine will be connected to PRIMARY machine)