Oracle Audit Vault Installation – Step by Step

Phạm Bảo Nguyên's Blog

Oracle Audit Vault Installatio n

(Step by Step)

1. Audit Vault Server install:

$cd /source/avserver

$./runInstaller

2. Tạo user cho Audit vault server

$ sqlplus avmanager/manager-123

SQL> create user agentav identified by xxxx;

3. Add agent name vào Audit vault server

$ avca add_agent -agentname  agent_fcrac1 -agenthost  fcrac1 -agentusr agentav

AVCA started

Adding agent…

Agent added successfully.

4. Cài đặt Audit vault agent:

$cd  /source/avagent/hpux_ia64

$./runInstaller

5. Cấu hình Audit vault agent:

On Source Database (On Client):

$sqlplus / as sysdba

SQL> CREATE USER audituser IDENTIFIED BY xxxxx;

SQL> exit

$cd $AVAGENT_HOME/av/scripts/streams/source

$sqlplus / as sysdba

SQL>@zarsspriv.sql audituser SETUP

Granting privileges to AUDITUSER … Done.

SQL>@zarsspriv.sql audituser REDO_COLL

Granting privileges to AUDITUSER … Done.

SQL>exit

ON Audit Vault Server:

$ avorcldb add_source -src fcrac1-vip:1521:naprod -srcname fcrac1  -agentname  agent_fcrac1

$avorcldb add_collector -srcname fcrac1  -agentname agent_fcrac1 -colltype OSAUD -orclhome /u01/app/db

$avorcldb add_collector -srcname fcrac1  -agentname agent_fcrac1 -colltype DBAUD

On Source Database (On…

View original post 197 more words

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s