Index

A  C  D  E  G  H  I  L  M  O  P  R  S  T  U  V 

---

A

add_agent command (AVCA), A

add_collector command (AVMSSQLDB), 3.1.3.1, 3.1.3.1, D

add_collector command (AVORCLDB), 2.2, 3.1.3.1, C

add_source command (AVMSSQLDB), 3.1.2.1, D

add_source command (AVORCLDB), 2.2, 3.1.2.1, C

adding

audit sources to Audit Vault, 2.2

Audit Vault Collection Agent, A

collectors, 3.1.3.1, 3.1.3.1, C, D

AVMSSQLDB collector, 2.3

DBAUD collector, 2.2

OSAUD collector, 2.2, 2.2

REDO collector, 2.2

sources, C, D

Microsoft SQL Server Database, 2.3, 3.1.2.1

Oracle Database, 2.2, 3.1.2.1

alter_collector command (AVMSSQLDB), 3.1.3.2, D

alter_collector command (AVORCLDB), 3.1.3.2, C

alter_source command (AVMSSQLDB), 3.1.2.2, D

alter_source command (AVORCLDB), 3.1.2.2, C

altering

collectors, 3.1.3.2, 3.1.3.2, C, D

DBAUD collector attributes, C

MSSQLDB collector attributes, D

OSAUD collector attributes, C

REDO collector attributes, C

sources, 3.1.2.2, 3.1.2.2, C, D

audit trail

finding information about, F.1

Audit Vault administrator roles

AV_ADMIN, 1.2, 5.4

AV_AGENT, 1.2, 5.4

AV_AUDITOR, 1.2, 5.4

AV_SOURCE, 1.2, 5.4

Audit Vault Collection Agent

adding, A

dropping, 3.1.1.1, A

securing, 5.1, 5.1, A

See collection agent OC4J

starting, 2.4.1, 3.2.3.1, B

state of, 3.2.3.1, B

state of agent OC4J, B

stopping, 3.2.3.1, B

viewing information, 3.2.3.2

Audit Vault Configuration Assistant (AVCA) utility

commands

add_agent command, A

create_credential command, A

deploy_av command, A

drop_agent command, 3.1.1.1, A

generate_csr command, 5.1, A

help command, A

import_cert command, 5.1, A

redeploy command, A

remove_cert command, A

secure_agent command, 5.1, A

secure_av command, 5.1, A

set_warehouse_retention command, 3.1.4.3, A

set_warehouse_schedule command, 3.1.4.3, A

table of, A

Audit Vault Console

starting, 3.2.1

collection agents, 3.2.3.2

collectors, 3.2.4.2

state of, 3.2.1, B

stopping, 3.2.1

collection agents, 3.2.3.2

collectors, 3.2.4.2

viewing

Audit Vault errors, 3.2.6

Collection Agent information, 3.2.3.2

collector information, 3.2.4.2

data warehouse loading history, 3.2.5.2

data warehouse purging history, 3.2.5.2

data warehouse refresh history, 3.2.5.2

Audit Vault Control (AVCTL) utility

commands

-help command, B

load_warehouse command, 3.2.5.1, B

purge_warehouse command, 3.2.5.1, B

refresh_warehouse command, 3.2.5.1, 3.2.5.1, A, B

show_agent_status command, 2.4.1, B

show_av_status command, B

show_collector_status command, 2.4.2, 2.4.3, B

show_oc4j_status command, B

start_agent command, 2.4.1, 3.2.3.1, B

start_av command, 3.2.1, B

start_collector command, 2.4.2, 2.4.3, 3.2.4.1, B

start_oc4j command, 3.2.2, B

stop_agent command, 3.2.3.1, B

stop_av command, 3.2.1, B

stop_collector command, 3.2.4.1, B

stop_oc4j command, 3.2.2, B

table of, B

Audit Vault Microsoft SQL Server Database (AVMSSQLDB) utility

commands, D

add_collector command, 3.1.3.1, 3.1.3.1, D

add_source command, 3.1.2.1, D

alter_collector command, 3.1.3.2, D

alter_source command, 3.1.2.2, D

drop_collector command, 3.1.3.3, D

drop_source command, D

help command, D

setup command, 2.3, D

table of, D

verify command, 2.3, D

Audit Vault Oracle Database (AVORCLDB) utility

commands, C

add_collector command, 2.2, 3.1.3.1, C

add_source command, 2.2, 3.1.2.1, C

alter_collector command, 3.1.3.2, C

alter_source command, 3.1.2.2, C

drop_collector command, 3.1.3.3, C

drop_source command, C

-help command, C

setup command, 2.2, C

table of, C

verify command, 2.2, C

log file, 6.1, 6.2

Audit Vault Server

securing, 5.1, A

auditing

finding information about, F.1

auditing, purging records

audit trail

purge job, creating, 4.4.2.1.1

purging manually, 4.4.2.2

database audit trail

batch size, clearing, 4.4.2.3.2

batch size, setting, 4.4.2.3.1

initializing

cancelling, 4.4.2.1.3

checking if done, 4.4.2.1.2

clean-up operation, 4.4.2.1.1

purge jobs, managing

deleting, 4.4.2.4.4

enabling or disabling, 4.4.2.4.1

time interval for all purge jobs, 4.4.2.4.2

time interval for named purge job, 4.4.2.4.3

tracing debug levels, setting, 4.4.2.5

authentication

securing Audit Vault, 5.1, A

securing Audit Vault Collection Agent, 5.1, A

AV_ADMIN role

of Audit Vault administrator, 1.2, 5.4

AV_AGENT role

of Audit Vault administrator, 1.2, 5.4

AV_AUDITOR role

of Audit Vault administrator, 1.2, 5.4

AV_SOURCE role

of Audit Vault administrator, 1.2, 5.4

avca

create_wallet command, A

AVCA utility

See Audit Vault Configuration Assistant (AVCA) utility

AVCTL utility

See Audit Vault Control (AVCTL) utility

AVMSSQLDB command-line utility, D

AVMSSQLDB syntax, D

AVMSSQLDB utility

See Audit Vault Microsoft (AVMSSQLDB) utility

AVORCLDB command-line utility, C

AVORCLDB syntax, C

AVORCLDB utility

See Audit Vault Oracle Database (AVORCLDB) utility

---

C

checking

Audit Vault Collection Agent status, 3.2.3.1

Audit Vault Console status, 3.2.1

collection agent OC4J status, 3.2.2

collector status, 2.4.2, 2.4.3, 3.2.4.1

CLEAN_AUDIT_TRAIL procedure, G

CLEAR_AUDIT_TRAIL_PROPERTY procedure, G

CLEAR_LAST_ARCHIVE_TIMESTAMP procedure, G

collection agent OC4J

starting, 3.2.2

state of, 3.2.2

stopping, 3.2.2

collector for Oracle Database REDO audit logs

See REDO collector

collectors

adding, 3.1.3.1, 3.1.3.1, C, D

AVMSSQLDB collector, 2.3

DBAUD collector, 2.2

OSAUD collector, 2.2, 2.2

REDO collector, 2.2

altering, 3.1.3.2, 3.1.3.2, C, D

attributes for DBAUD collector, C

attributes for MSSQLDB collector, D

attributes for OSAUD collector, C

attributes for REDO collector, C

checking status, 2.4.2, 2.4.3, 3.2.4.1

dropping, 3.1.3.3, C, D

starting, 2.4.2, 2.4.3, 3.2.4.1, B

state of, 2.4.2, 2.4.2, 2.4.3, 2.4.3, 3.2.4.1, B

stopping, 3.2.4.1, B

commands

log file, 6.1, 6.2

create_credential command (AVCA), A

CREATE_PURGE_JOB procedure, G

create_wallet command, A

creating

credentials, A

credential

creating, A

---

D

data warehouse

schedule for refreshing data, 3.1.4.3, A

setting

data retention period, 3.1.4.3, A

refresh data schedule, 3.1.4.3

viewing history of loading, 3.2.5.2

viewing history of purging, 3.2.5.2

viewing history of refreshing, 3.2.5.2

database audit trail

batch size for records during purging, 4.4.2.3.1

tablespace, moving to one other than SYSTEM, 4.4.1.1

Database Vault administrator roles

DV_ACCTMGR, 1.2, 5.4

DV_OWNER, 1.2, 5.4

DBAUD collector attributes, C

DBMS_AUDIT_MGMT package, G

CLEAN_AUDIT_TRAIL procedure, G

CLEAR_AUDIT_TRAIL_PROPERTY procedure, G

CLEAR_LAST_ARCHIVE_TIMESTAMP procedure, G

CREATE_PURGE_JOB procedure, G

DEINIT_CLEANUP procedure, G

DROP_PURGE_JOB procedure, G

GET_AUDIT_COMMIT_DELAY function, G

INIT_CLEANUP procedure, G

IS_CLEANUP_INITIALIZED function, G

SET_AUDIT_TRAIL_LOCATION procedure, G

SET_AUDIT_TRAIL_PROPERTY procedure, G

SET_DEBUG_LEVEL procedure, G

SET_LAST_ARCHIVE_TIMESTAMP procedure, G

SET_PURGE_JOB_INTERVAL procedure, G

SET_PURGE_JOB_STATUS procedure, G

DEINIT_CLEANUP procedure, G

deploy_av command (AVCA), A

disabling

alert settings globally, 3.1.5

drop_agent command (AVCA), 3.1.1.1, A

drop_collector command (AVMSSQLDB), 3.1.3.3, D

drop_collector command (AVORCLDB), 3.1.3.3, C

DROP_PURGE_JOB procedure, G

drop_source command (AVMSSQLDB), D

drop_source command (AVORCLDB), C

dropping

Audit Vault Collection Agent, 3.1.1.1, A

collectors, 3.1.3.3, C, D

sources, 3.1.2.3, 3.1.2.3, C, D

DV_ACCTMGR role

of Database Vault administrator, 1.2, 5.4

DV_OWNER role

of Database Vault administrator, 1.2, 5.4

---

E

enabling

alert settings globally, 3.1.5

environment variables

LD_LIBRARY_PATH, 2.1, 2.1

LIBPATH, 2.1, 2.1

ORACLE_HOME, 2.1, 2.1

ORACLE_SID, 2.1, 2.1

PATH, 2.1, 2.1

SHLIB_PATH, 2.1, 2.1

error and log files

Audit Vault Collection Agent

{collector-name}_{source-name}_{source-id}.log, 6.2

agent.err, 6.2

agent.out, 6.2

av_client-0.log, 6.2

avca.log, 6.2

avorcldb.log, 6.2

sqlnet.log, 6.2

Audit Vault Server

agent.err, 6.1

agent.out, 6.1

av_client-0.log, 6.1

avca.log, 6.1

collection agent OC4J

AVAgent-access.log, 6.2

failed commands

configToolFailedCommands, 6.2

Oracle Enterprise Manager

logging, 6.1

errors

viewing

in Audit Vault Console, 3.2.6

---

G

generate_csr command (AVCA), 5.1, A

GET_AUDIT_COMMIT_DELAY function, G

granting

required privileges

to source database user, 2.2

to source database user for the DBAUD collector, 2.2

to source database user for the OSAUD collector, 2.2

required privileges to source database user

for the REDO collector, 2.2

granting required privileges

for policy management, 2.2

---

H

-help command (AVCA), A

-help command (AVCTL), B

help command (AVMSSQLDB), D

-help command (AVORCLDB), C

---

I

import_cert command (AVCA), 5.1, A

INIT_CLEANUP procedure, G

initialization parameters

hidden

redo log audit source release 10.1, E.2

redo log audit source release 10.2, E.3, E.4

redo log audit source release 9.2, E.1

redo log

audit source release 10.1, E.2

audit source release 10.2, E.3, E.4

audit source release 9.2, E.1, E.1

init.ora parameters

See initialization parameters

IS_CLEANUP_INITIALIZED function, G

---

L

LD_LIBRARY_PATH environment variable, 2.1, 2.1

LIBPATH environment variable, 2.1, 2.1

load_warehouse command (AVCTL), 3.2.5.1, B

location of

Audit Vault Collection Agent

log and error files, 6.2

Audit Vault failed commands

log file, 6.2

Audit Vault Server

log and error files, 6.1

---

M

management

source audit trails, 4.4

managing collection agents and collectors

starting

collection agents, 3.2.3.2, B

collectors, 3.2.4, 3.2.4.2, B

stopping

collection agents, 3.2.3.2, B

collectors, 3.2.4, 3.2.4.2, B

viewing

collection agent information, 3.2.3.2

collector information, 3.2.4, 3.2.4.2

MSSQLDB collector attributes, D

---

O

operating system audit trail

age, controlling, 4.4.4

size, controlling, 4.4.3

ORACLE_HOME environment variable, 2.1, 2.1

ORACLE_SID environment variable, 2.1, 2.1

OSAUD collector attributes, C

---

P

PATH environment variable, 2.1, 2.1

performance

database audit trail, moving to different tablespace, 4.4.1.1

purge_warehouse command (AVCTL), 3.2.5.1, B

---

R

redeploy command (AVCA), A

REDO collector attributes, C

refresh_warehouse command (AVCTL), 3.2.5.1, 3.2.5.1, A, B

remove_cert command (AVCA), A

---

S

schedule for refreshing warehouse data, 3.1.4.3, A

secure_agent command (AVCA), 5.1, A

secure_av command (AVCA), 5.1, A

securing

Audit Vault Collection Agent, 5.1, A

Audit Vault Server, 5.1, A

securing Audit Vault by mutual authentication, 5.1, A

securing Audit Vault Collection Agent by mutual authentication, 5.1, A

SET_AUDIT_TRAIL_LOCATION procedure, G

SET_AUDIT_TRAIL_PROPERTY procedure, G

SET_DEBUG_LEVEL procedure, G

SET_LAST_ARCHIVE_TIMESTAMP procedure, G

SET_PURGE_JOB_INTERVAL procedure, G

SET_PURGE_JOB_STATUS procedure, G

set_warehouse_retention command (AVCA), 3.1.4.3, A

set_warehouse_schedule command (AVCA), 3.1.4.3, A

setting

refresh warehouse data schedule, 3.1.4.3

schedule for refreshing warehouse data, 3.1.4.3, A

set up source in collection agent home, 2.2, 2.3, C, D

warehouse data retention period, 3.1.4.3, A

setup command (AVMSSQLDB), 2.3, D

setup command (AVORCLDB), 2.2, C

SHLIB_PATH environment variable, 2.1, 2.1

show_agent_status command (AVCTL), 2.4.1, B

show_av_status command (AVCTL), B

show_collector_status command (AVCTL), 2.4.2, 2.4.3, B

show_oc4j_status command (AVCTL), B

source audit trails

cleanup, 4.4

sources

adding, C, D

Microsoft SQL Server Database, 2.3, 3.1.2.1

Oracle Database, 2.2, 3.1.2.1

altering, 3.1.2.2, 3.1.2.2, C, D

dropping, 3.1.2.3, 3.1.2.3, C, D

start_agent command (AVCTL), 2.4.1, 3.2.3.1, B

start_av command (AVCTL), 3.2.1, B

start_collector command (AVCTL), 2.4.2, 2.4.3, 3.2.4.1, B

start_oc4j command (AVCTL), 3.2.2, B

starting

Audit Vault Collection Agent, 2.4.1, 3.2.3.1, B

using Audit Vault Console, 3.2.3.2

Audit Vault Console, 3.2.1

collection agent OC4J, 3.2.2

collectors, 2.4.2, 2.4.3, 3.2.4.1, B

using Audit Vault Console, 3.2.4.2

state of

Audit Vault Collection Agent, 3.2.3.1, B

Audit Vault Console, 3.2.1, B

collection agent OC4J, 3.2.2, B

collectors, 2.4.2, 2.4.2, 2.4.3, 2.4.3, 3.2.4.1, B

stop_agent command (AVCTL), 3.2.3.1, B

stop_av command (AVCTL), 3.2.1, B

stop_collector command (AVCTL), 3.2.4.1, B

stop_oc4j command (AVCTL), 3.2.2, B

stopping

Audit Vault Collection Agent, 3.2.3.1, B

using Audit Vault Console, 3.2.3.2

Audit Vault Console, 3.2.1

collection agent OC4J, 3.2.2

collectors, 3.2.4.1, B

using Audit Vault Console, 3.2.4.2

SYSAUX tablespace

moving database audit trail tables to, 4.4.1.1

---

T

troubleshooting tips, 6.3

Audit Vault Collection Agent, 6.3.2

Audit Vault collector, 6.3.3

Audit Vault Console, 6.3.4

Audit Vault in an Oracle RAC environment, 6.3.5

Audit Vault Server, 6.3.1

---

U

users

Audit Vault source user, 2.2

Oracle source database user, 2.2

---

V

verify command (AVMSSQLDB), 2.3, D

verify command (AVORCLDB), 2.2, C

verifying

source compatibility with collectors, 2.2, C, D

source compatibility with each collector, 2.2

viewing

Audit Vault Collection Agent information, 3.2.3.2

Audit Vault errors

in Audit Vault Console, 3.2.6

data warehouse loading history

Audit Vault Console, 3.2.5.2

data warehouse purging history

Audit Vault Console, 3.2.5.2

data warehouse refresh history

Audit Vault Console, 3.2.5.2

views

audit trail, F.1, F.1