Friday, November 7, 2008

Audit Vault

# Install the Audit Vault Server
# This installs Oracle 10.2.0.3, plus database, plus Database Vault, plus Audit Vault

./runInstaller

File not found: %fineName% - IGNORE

# EM http://server:1158/em
# DV http://server:1158/dva
# AV http://server:5700/av

############################################

# Add the agent configuration on the server
avca add_agent -agentname avagent -agenthost server.domain
# creates user/password on the server for the agent to connect to.

# Install the Audit Vault Agent

./runInstaller

# Failed :- Oracle Audit Vault Configuration Assistant

Check what failed in configToolFailedCommands

# manually run the configuration on the agent ORACLE_HOME

avca -s initialize_agent -agentname avagent -agentusr user/password -agentport 7016 -av server:port:DB -rmiport 3121 -jmsport 3300

avctl show_agent_status -agentname avagent

############################################
# Create a DBAUD collector

# On the source database create the collector user

cd $ORACLE_HOME/av/scripts/streams/source
sqlplus dvmanager/password
create user srcuser1 identified by password;
@zarsspriv.sql srcuser setup
connect srcuser/password
SELECT * FROM SESSION_PRIVS;
SELECT * FROM SESSION_ROLES;

# on the source agent verify the source database permissions

avorcldb verify -src server:port:service -colltype ALL

ERROR: parameter GLOBAL_NAMES = false is not set to required value true

# on the AV server add the Oracle Database Source

avorcldb add_source -src server:port:service -desc 'av' -agentname avagent

# on the AV server add the DBAUD collector

avorcldb add_collector -srcname AV.CMC.LOCAL -agentname avagent -colltype DBAUD

# On the agent setup the source

avorcldb setup -verbose -srcname AV.CMC.LOCAL

###########################################

# Check the server
avctl show_av_status

# Stop AV
avctl stop_av

# Start the agent
# From the agent
avctl start_oc4j

# From the server
avctl start_agent -agentname avagent