Index

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

A

add_agent command (AVCA utility), 7.1
add_collector command
IBM DB2 databases, 12.2
Oracle databases, 9.2
SQL Server databases, 10.2
Sybase ASE databases, 11.2
add_source command
IBM DB2 databases, 12.3
Oracle databases, 9.3
SQL Server databases, 10.3
Sybase ASE databases, 11.3
adding
Audit Vault collection agents, 7.1
collectors for IBM DB2 databases, 12.2
collectors for Oracle databases, 9.2
collectors for SQL Server databases, 10.2
collectors for Sybase ASE databases, 11.2
administrators
general steps for using Oracle Audit Vault, 1.2
main tasks, 1.1
managing security, 5
agents
See Audit Vault collection agents
alert processing
about, 3.2.5
managing, 3.2.5
setting time zones, 7.21
alert settings
disabling globally, 3.2.5, 3.2.5
email notifications for, 3.6.1
enabling globally, 3.2.5, 3.2.5
error messages, B.1.5
trouble ticket notifications for, 3.7.1
alerts, A.3.6.4
functions not working, A.3.6.4
not firing, A.3.6.4
alter_collector command
IBM DB2 databases, 12.4
Oracle databases, 9.4
SQL Server databases, 10.4
Sybase ASE databases, 11.4
alter_smtp command (AVCA utility), 7.3
alter_source command
IBM DB2 databases, 12.5
Oracle databases, 9.5
SQL Server databases, 10.5
Sybase ASE databases, 11.5
altering
DB2DB collector attributes, 12.4
DBAUD collector attributes, 9.4
MSSQLDB collector attributes, 10.4
OSAUD collector attributes, 9.4
REDO collector attributes REDO collector
altering, 9.4
source database collector attributes, 3.3
SYBDB collector attributes, 11.4
archive log disk space
monitoring in Audit Vault Server, 4.3
attributes
collectors
about, 3.3.1
altering Audit Vault Console, 3.3.2
altering from command line, 3.3.3
source databases
about, 3.5.1
altering from command line, 3.5.3
altering in Audit Vault Console, 3.5.2
audit data
loading to Audit Vault, 3.4.3.1
loading to warehouse, 8.2
purging from warehouse, 8.3
setting a retention period, 7.22
audit events
error codes, B.1.2
viewing categories, 3.2.6
audit trail cleanup
Audit Vault repository, 4.11
IBM DB2 audit files, 2.6.6.1
new features, Preface
Oracle source databases, 4.10.1
SQL Server audit files, 2.4.7
Audit Vault administrator roles
AV_ADMIN
about, 1.5
roles and privileges granted, 5.5
AV_AGENT
about, 1.5
roles and privileges granted, 5.5
AV_AUDITOR
about, 1.5
roles and privileges granted, 5.5
See also Oracle Database Vault, administrator roles
Audit Vault agents
monitoring from Cloud Control, 6.7.1
Audit Vault collection agents
about, 1.3.4.1
adding, 7.1
audit data collection when agent is stopped, 1.3.4.1
audit record collection when agents are down, 2.10
checking status of pre-Release 10.2.3.2 collection agent, 8.15.1
checking status of Release 10.2.3.2 agents, 8.4
configuring connectivity for Oracle RAC nodes, 4.8
configuring for Oracle RAC nodes, 4.7
debugging advice, A.3.3.2
dropping, 7.9
errors log file
Audit Vault collection agent, A.2
Audit Vault Server, A.1
finding names of existing agents, 2.9.1
locations
for DB2DB collector, 1.6.5
for DBAUD collector, 1.6.2
for MSSQLDB collector, 1.6.3
for OSAUD collector, 1.6.2
for REDO collector, 1.6.2
for SYBDB collector, 1.6.4
log file
Audit Vault collection agent, A.2
Audit Vault Server, A.1
port numbers, 4.9.2
port numbers used by, 1.3.4.3
port numbers, changing, 4.9
ratio to collectors, 1.3.4.1
redeploying av.ear or AVAgent.ear file, 7.15
remote agents, affect on SYSDBA and SYSOPER audit data, 1.3.4.1
running commands in Windows environment, 2.2.4
starting, 8.9
status blank on Windows Services Panel, A.3.3.1
stopping, 8.15.3
troubleshooting tips, A.3.3.1
UNIX environment variable settings, 2.2.3
using on Windows, 2.2.5
wallet credentials not successful, A.3.3.4
Audit Vault collectors
about, 1.3.4.1
adding for DB2, 12.2
adding for Oracle database, 9.2
adding for SQL Server, 10.2
adding to Sybase ASE, 11.2
adding, general steps, 2.1
attributes
about, 3.3.1
altering in Audit Vault Console, 3.3.2
altering in shell, 3.3.3
DB2DB collector, 12.4
DBAUD collector, 9.4, 9.4
MSSQLDB collector, 10.4
OSAUD collector, 9.4, 9.4
REDO collector, 9.4
SYBDB collector, 11.4
checking status of, 2.9.2, 8.6
collector not starting, 8.11
DB2DB collector
location of agent, 1.6.5
DBAUD
moving to different agent, 9.4
DBAUD collector
location of agent, 1.6.2
dropping
from IBM DB2, 12.6
from Oracle databases, 9.6
from SQL Server databases, 10.6
from Sybase ASE databases, 11.6
host computer failure, A.3.4.8
monitoring from Cloud Control, 6.8.1
moving collector to a different agent
DBAUD, 9.4
example for DBAUD, 9.4
example for SQL Server, 10.4
example for Sybase ASE, 11.4
SQL Server collector, 10.4
Sybase collector, 11.4
MSSQLDB collector
location of agent, 1.6.3
new features, Preface
OSAUD collector
location of agent, 1.6.2
ratio to collection agents, 1.3.4.1
REDO collector
location of agent, 1.6.2
starting, 8.11
status of startup or shutdown jobs, 6.8.3
stopping, 8.14
SYBDB
moving to different agent, 10.4, 11.4
SYBDB collector
location of agent, 1.6.4
timestamps for purge process, 4.10.2
troubleshooting tips, A.3.4.3
Audit Vault Configuration Assistant (AVCA) utility
commands
add_agent command, 7.1
alter_smtp command, 7.3
create_credential command, 7.4
create_wallet command, 7.5
deploy_av command, 7.6
disable_remedy command, 7.7
disable_smtp command, 7.8
drop_agent command, 7.9
enable_remedy command, 7.10
enable_smtp command, 7.11
generate_csr command, 7.12
-help command, 7.13
import_cert command, 7.14
redeploy command, 7.15
register_remedy command, 7.16
register_smtp command, 7.17
remove_cert command, 7.18
secure_remedy command, 7.19
secure_smtp command, 7.20
set_server_tz command, 7.21
set_warehouse_retention command, 7.22
set_warehouse_schedule command (deprecated), Preface
show_remedy_config command, 7.23
show_server_tz command, 7.24
show_smtp_config command, 7.25
table of, 7
test_remedy command, 7.26
test_smtp command, 7.27
log file
Audit Vault collection agent, A.2
Audit Vault Server, A.1
new features, Preface
Audit Vault Console
checking status, 3.2.2
checking status of, 8.5
debugging advice, A.3.5.2
deploying in an Oracle RAC environment, 4.6
logging in, 3.2.3
starting, 3.2.3
stopping, 3.2.4, 3.2.4
troubleshooting tips, A.3.5.1
viewing
Audit Vault errors, 3.2.7
Web browser hanging, A.3.5.1
Audit Vault Control (AVCTL) utility
commands
-help command, 8.1
load_warehouse command, 8.2
purge_warehouse command, 8.3
refresh_warehouse command (deprecated), Preface
show_agent_status command, 8.4
show_av_status command, 8.5
show_collector_status command, 2.9.2, 8.6
show_oc4j_status command, 8.15.1
show_remedy_status command, 8.7
show_smtp_status command, 8.8
start_agent command, 8.9, 8.9
start_av command, 8.10
start_collector command, 8.11
start_oc4j command, 8.15.2
stop_agent command, 8.12, 8.12
stop_av command, 3.2.4, 8.13
stop_collector command, 8.14
stop_oc4j command, 8.15.3, 8.15.3
table of, 8
log file
Audit Vault collection agent, A.2
Audit Vault Server, A.1
new features, Preface
Audit Vault data warehouse
about, 3.4.1
audit data not appearing in, A.3.6.3
error messages, B.1.7
loading data
about, 3.4.3.1
from command line, 3.4.3.3
using Audit Vault Console, 3.4.3.2
new features, Preface
purging data
about, 3.4.4.1
from command line, 3.4.4.3
using Audit Vault Console, 3.4.4.2
setting a retention period
about, 3.4.2.1
example, 3.4.2.1
setting with Audit Vault Console, 3.4.2.2
setting with avca set_warehouse_retention command, 3.4.2.3
setting data retention period, 7.22
Audit Vault IBM DB2 (AVDB2DB) utility
commands
add_collector command, 12.2
add_source command, 12.3
alter_collector command, 12.4
alter_source command, 12.5
drop_collector command, 12.6
drop_source command, 12.7
-help command, 12.8
table of, 12
verify command, 12.9
log file
Audit Vault collection agent, A.2
syntax, 12.1
See also IBM DB2 databases
Audit Vault Microsoft SQL Server Database (AVMSSQLDB) utility
commands
add_collector command, 10.2
add_source command, 10.3
alter_collector command, 10.4
alter_source command, 10.5
drop_collector command, 10.6
drop_source command, 10.7
-help command, 10.8
setup command, 10.9
table of, 10
verify command, 10.10
log file
Audit Vault collection agent, A.2
Audit Vault Server, A.1
new features, Preface
syntax, 10.1
Audit Vault Microsoft SQL Server Database (AVMSSQLDB) utility
See also Microsoft SQL Server databases
Audit Vault Oracle Database (AVORCLDB) utility
commands
add_collector command, 9.2
add_source command, 9.3
alter_collector command, 9.4
alter_source command, 9.5
drop_collector command, 9.6
drop_source command, 9.7
-help command, 9.8
setup command, 9.9
table of, 9
verify command, 9.10
log file, A.2
Audit Vault collection agent, A.2
Audit Vault Server, A.1
new features, Preface
syntax, 9.1
See also Oracle databases
Audit Vault policies
internal service for, 1.3.2.2
location in Audit Vault Server, 1.3.2.2
log file, A.1
Oracle databases, 9.3
Oracle RAC, 4.8
script for policy management (zarsspriv.sql), 2.3.1
where created from, 1.3.2.2
Audit Vault Server
about, 1.3.2.1
administrative tasks
archive log disk space, 4.3
backup and recovery operations, 4.5
changing user passwords, 5.4.1
configuring collection agent connectivity for RAC, 4.8
configuring collection agent to listen to RAC nodes, 4.7
flash recovery area, 4.4
SYSAUX tablespace usage, 4.2
alert settings, managing, 3.2.5
audit event categories, viewing, 3.2.6
Audit Vault Console status, checking, 3.2.2
checking errors, 3.2.7
components, 1.3.2.2
error codes
alert errors, B.1.5
attribute definition errors, B.1.4
collector errors, B.1.3
data warehouse errors, B.1.7
event errors, B.1.2
generic errors, B.1.1
policy errors, B.1.8
service-side audit service errors, B.1.6
finding version of, 6.3
listener name, 1.3.2.2
performance tuning, A.3.2.1
port numbers used by, 1.3.2.3
port numbers, changing, 4.9
running commands in Windows environment, 2.2.4
starting console, 8.10
troubleshooting tips, A.3.2.1
UNIX environment variable settings, 2.2.2
Audit Vault Sybase ASE Database (AVSYBDB) utility
commands
add_collector command, 11.2
add_source command, 11.3
alter_collector command, 11.4
alter_source command, 11.5
drop_collector command, 11.6
drop_source command, 11.7
-help command, 11.8
setup command, 11.9
table of, 11
verify command, 11.10
log file
Audit Vault collection agent, A.2
Audit Vault Server, A.1
syntax, 11.1
See also Sybase ASE databases
AV_ADMIN role
about, 1.5
changing user password, 5.4.2
roles and privileges granted, 5.5
AV_AGENT role
about, 1.5
changing user password, 5.4.4
roles and privileges granted, 5.5
AV_AUDITOR role
about, 1.5
changing user password, 5.4.6
roles and privileges granted, 5.5
AVCA_SMTPUSR environment variable, 7.3
AVDB2DB command-line utility
See Audit Vault IBM DB2 (AVDB2DB) utility commands commands
AVMSSQLDB command-line utility
See Audit Vault Microsoft SQL Server Database (AVMSSQLDB) utility commands
AVORCLDB command-line utility, 9.1
See Audit Vault Oracle Database (AVORCLDB) utility commands
AVREPORTUSER account
changing password of, 5.4.3
AVSYBDB command-line utility
See Audit Vault Sybase ASE Database (AVSYBDB) utility commands(AVMSSQLDB) utility commands

B

back-up and recovery for Audit Vault Server, 4.5
BMC Remedy Action Request (AR) System Server
See trouble tickets

C

certificates
See Oracle wallets
collection agents
See Audit Vault collection agents
collectors
See Audit Vault collectors
commands
log file, A.2
compressed syslog files, 1.3.4.2
coraenv UNIX script, 2.2.2
create_credential command (AVCA utility), 7.4
create_wallet command, 7.5

D

data warehouse
See Audit Vault data warehouse
DB2 collector attributes, 12.4
DB2DB collector
about, 1.3.4.2
audit trail settings for, 1.6.5
detailed information about audit trails, 1.6.5
See also IBM DB2 databases
db2jcc.jar file, 2.6.1
DBAUD collector
about, 1.3.4.2
attributes, 9.4
audit trail settings for, 1.6.2
detailed information about audit trails, 1.6.2
DBAUD collector attributes, 9.4
DBSNMP account
how Oracle Audit Vault handles, 5.5
deploy_av command (AVCA utility), 7.6
deprecated Oracle Audit Vault utility commands, Preface
disable_remedy command (AVCA utility), 7.7
disable_smtp command (AVCA utility), 7.8
drop_agent command (AVCA utility), 7.9
drop_collector command
IBM DB2 databases, 12.6
Oracle databases, 9.6
SQL Server databases, 10.6
Sybase ASE databases, 11.6
drop_source command
IBM DB2 databases, 12.7
Oracle databases, 9.7
SQL Server databases, 10.7
Sybase ASE databases, 11.7
dropping
Audit Vault collection agents, 7.9
collectors from IBM DB2 databases, 12.6
collectors from Oracle Database, 9.6
collectors from SQL Server, 10.6
collectors from Sybase ASE, 11.6
DV_ACCTMGR role
about, 1.5
DV_ACCTMGR roles and privileges granted
about, 5.5
DV_OWNER role
about, 1.5
roles and privileges granted, 5.5

E

email notifications
about, 3.6.1
altering SMTP configuration, 7.3
configuring, 3.6
configuring for secure server, 7.20
configuring users for, 3.6.2
disabling SMTP configuration, 7.8
enabling SMTP configuration, 7.11
finding SMTP configuration, 7.25
finding SMTP status, 8.8
log file
Audit Vault Server, A.1
registering for, 7.3
registering SMTP service, 7.17
testing configuration, 7.27
unregistering SMTP service, 7.17
enable_remedy command (AVCA utility), 7.10
enable_smtp command (AVCA utility), 7.11
Enterprise Manager Information Reports
Audit Vault reports, 6.12
environment variables
AVCA_SMTPUSR, 7.3
LANG, 2.2.2
LD_LIBRARY_PATH, 2.2.2
LIBPATH, 2.2.2
ORACLE_HOME, 2.2.2
ORACLE_SID, 2.2.2
PATH, 2.2.2
SHLIB_PATH, 2.2.2
error and log files
Audit Vault collection agent
agent.err, A.2
agent.out, A.2
av_client-0.log, A.2
avca.log, A.2
avorcldb.log, A.2
sqlnet.log, A.2
Audit Vault collection agent log files, A.2
Audit Vault Server
agent.out, A.1
av_client-0.log, A.1
avca.log, A.1
log file location, A.1
debugging advice for Audit Vault collection agents, A.3.3.2
debugging Audit Vault Console, A.3.5.2
error messages, B
failed commands
configToolFailedCommands, A.2
OC4J
AVAgent-access.log, A.2
operational errors, 3.2.7
Oracle Enterprise Manager
logging, A.1
sqlnet.log, A.2
See also troubleshooting
errors and log files
incidents displayed in Cloud Control, 6.11
examples
See also reference chapters for utilities

F

failover recovery for collectors, 9.4, 10.4, 11.4
example for DBAUD, 9.4
example for SQL Server, 10.4
example for Sybase ASE, 11.4
flash recovery area
monitoring in Audit Vault Server, 4.4

G

generate_csr command (AVCA utility), 7.12
granting required privileges
for policy management, 2.3.1
to source database user
for the REDO collector, 2.3.1
to source database user for the DBAUD collector, 2.3.1
to source database user for the OSAUD collector, 2.3.1

H

-help command
AVCA utility, 7.13
AVCTL utility, 8.1
AVDB2DB utility, 12.8
AVMSSQLDB utility, 10.8
AVORCLDB utility, 9.8
AVSYBDB utility, 11.8
HTTPS communication, 5.6

I

IBM DB2 databases
adding collector to Oracle Audit Vault, 2.6.5
compatibility with collector, 2.6.3
converting binary audit file to ASCII text file, 2.6.6.1
creating user account, 2.6.2
IBM Data Server Driver for JDBC and SQLJ, 2.6.1
jar file missing, A.3.4.6
modifying collector attributes, 3.3
modifying source attributes, 3.5
planning configuration, 1.6.5
registering with Oracle Audit Vault, 2.6
removing from Oracle Audit Vault, 3.8
source database errors, B.1.2
unable to connect to source database, A.3.4.7
verifying compatibility with collector, 12.9
See also Audit Vault IBM DB2 (AVDB2DB) utility
import_cert command (AVCA), 7.14
initialization parameters
hidden
redo log audit source release 10.1, 13.6
redo log audit source release 10.2, 13.4, 13.5
redo log audit source release 9.2, 13.7
redo log
audit source release 10.1, 13.6
audit source release 10.2, 13.4, 13.5
audit source release 11.2, 13.3
audit source release 9.2, 13.7
init.ora parameters
See initialization parameters

L

LANG environment variable, 2.2.2
languages supported, 2.2.2
LD_LIBRARY_PATH environment variable, 2.2.2
LIBPATH environment variable, 2.2.2
load_warehouse command (AVCTL utility), 8.2
log file locations and descriptions
Audit Vault collection agent, A.2
Audit Vault failed commands, A.2
Audit Vault Server, A.1
logging into Audit Vault pages in Oracle Enterprise Manager Cloud Control, 6.2

M

managing collection agents and collectors
starting
collection agents, pre-Release 10.2.3.2, 8.15.2
collection agents, Release 10.2.3.2, 8.9, 8.9
collectors, 8.11
stopping
collection agents, Release 10.2.3.2, 8.12
collectors, 8.14
Microsoft SQL Server databases
checking collector status, 2.9.2
collection agent credentials, adding, 2.4.6
collector, adding to Oracle Audit Vault, 2.4.5
compatibility with collector, 2.4.3
creating user account, 2.4.2
downloading SQL Server JDBC Driver, 2.4.1
jar file missing, A.3.4.6
modifying collector attributes, 3.3
modifying source attributes, 3.5
planning configuration, 1.6.3
registering with Oracle Audit Vault, 2.4
removing from Oracle Audit Vault, 3.8
setting up in collection agent home, 10.9
source database errors, B.1.2
trace files, preventing from being deleted by accident, 2.4.7
unable to connect to source database, A.3.4.7
verifying compatibility with collector, 10.10
See also Audit Vault Microsoft SQL Server Database (AVMSSQLDB) utility
Microsoft Windows
running commands in, 2.2.4
monitoring
agents in Cloud Control, 6.7.1
alert incidents in Cloud Control, 6.11
auditor notifications in Cloud Control, 6.10
collectors in Cloud Control, 6.8.1
general Oracle Audit Vault activities in Cloud Control, 6.3
source databases in Cloud Control, 6.9
MSSQLDB collector
about, 1.3.4.2
attributes, 10.4
audit trail settings for, 1.6.3
detailed information about audit trails, 1.6.3
See also Microsoft SQL Server databases
My Oracle Support, Preface

N

new features in this release, Preface
not able to be created, A.3.6.4

O

OC4J agent
about, 1.3.2.2
checking status for, 8.15.1
checking status for Release 10.2.3.2, 8.4
collection agent components, 1.3.4.2
failing to start, A.3.3.3
how it fits in general process flow, 1.3.5
log file locations, A.2
requirements for IBM DB2, 2.6.1
requirements for SQL Server, 2.4.1
requirements for Sybase ASE, 2.5.1
starting, 8.15.2
stopping, 8.15.3
using in Microsoft Windows, 2.2.4
when starting Audit Vault Console, 3.2.3
Oracle Audit Vault
administrative tasks for high volume systems, 4
components, 1.3
configuring source databases, 2
how administrators use, 1.1
how components work together, 1.3.5, 1.3.5
how it is secured, 5
languages supported, 2.2.2
maintenance tasks, 3
new features in this release, Preface
roles, 5.2
tools, 1.4
topology of configuration, 6.4
user accounts creating during installation, 5.2
using with Enterprise Manager Cloud Control, 6.1
See also entries beginning with Audit Vault
Oracle Audit Vault clients
error messages, B.2
Oracle Audit Vault Server
adding to Enterprise Manager group, 6.13.3
removing from Enterprise Manager, 6.13.4
Oracle Container for Java
See OC4J agent
Oracle Database Vault
how it implements security, 5.5
included in Audit Vault Server, 1.3.3
Oracle Database Vault administrator roles
DV_ACCTMGR
about, 1.5
DV_ACCTMGR role
roles and privileges granted, 5.5
DV_OWNER
about, 1.5
roles and privileges granted, 5.5
Oracle databases
adding collectors to Oracle Audit Vault, 2.3.4
checking collector status, 2.9.2
collection agent credentials, adding, 2.3.5
collectors not working, A.3.4.3
compatibility with collectors, 2.3.2
creating user account, 2.3.1
log file for policy creation (policy-0.log), A.1
modifying collector attributes, 3.3
modifying source attributes, 3.5
planning configuration, 1.6.2
registering with Oracle Audit Vault, 2.3
removing from Oracle Audit Vault, 3.8
setting up in collection agent home, 9.9
source database errors, B.1.2
unable to connect to source database, A.3.4.7
verifying compatibility with collectors, 9.10
See also Audit Vault Oracle Database (AVORCLDB) utility
Oracle Enterprise Manager Cloud Control
about using with Audit Vault, 6.1
access to Audit Vault
adding or removing administrative users, 6.13.1.2
changing administrative owner, 6.13.1.1
adding Audit Vault Server to group, 6.13.3
Audit Vault reports, 6.12
download information for plug-in, 6.1
logging into Audit Vault pages, 6.2
managing Audit Vault Server, 6.13
monitoring agents, 6.7.1
monitoring alert incidents, 6.11
monitoring collectors, 6.8.1
monitoring general Oracle Audit Vault activities, 6.3
monitoring source auditor activities, 6.10
monitoring source databases, 6.9
removing Audit Vault Server from, 6.13.4
shutting down Audit Vault Server console, 6.13.2
starting Audit Vault Server console, 6.13.2
status of collector startups and shutdowns, 6.8.3
thresholds for warning and critical alerts, 6.6
topology of Audit Vault configuration, 6.4
Oracle Enterprise Manager Database Control console, 5.3
Oracle MetaLink
See My Oracle Support
Oracle Real Application Clusters
avca add_agent command failing on node, A.3.7.1
configuring collection agent connectivity for, 4.8
configuring collection agents for, 4.7
creating collectors for, 2.3.4
creating source database user account, 2.3.1
deploying av.ear file to nodes, 7.6
troubleshooting tips, A.3.7.1
where to run AVCA commands, 7
where to run AVCTL commands, 8
Oracle Streams
supplemental logging for REDO collectors, 13.2
Oracle wallets
creating, 7.5
creating credentials, 7.4
credentials not successful, A.3.3.4
generating certificate requests, 7.12
how Oracle Audit Vault uses, 5.3
importing certificate requests, 7.14
locations, 5.3
removing certificates, 7.18
ORACLE_HOME environment variable, 2.2.2
ORACLE_SID environment variable, 2.2.2
oraenv UNIX script, 2.2.2
OSAUD collector
about, 1.3.4.2
attributes, 9.4
audit trail settings for, 1.6.2
detailed information about audit trails, 1.6.2
operating system .aud files, 1.3.4.2
syslog files, 1.3.4.2
syslog files, compressed, 1.3.4.2
Windows Event Log, 1.3.4.2
XML files, 1.3.4.2
OSAUD collector attributes, 9.4

P

passwords
guidelines for changing, 5.4.1
PATH environment variable, 2.2.2
performance tuning
Audit Vault Server, A.3.2.1
policies
See Audit Vault policies
port numbers
Audit Vault collection agent
changing, 4.9
finding, 1.3.4.3
Audit Vault collection agents, 4.9.2
Audit Vault Console, 4.9.1.2
Audit Vault Console port, 4.9.1.2
Audit Vault PL/SQL Gateway, 4.9.1.3
Audit Vault Server
changing, 4.9
finding, 1.3.2.3
Oracle Enterprise Manager Database Control
changing port number, 4.9.1.2
purge_warehouse command (AVCTL utility), 8.3
purging audit trail
IBM DB2 audit files, 2.6.6.1
new features, Preface
Oracle Audit Vault repository audit trail, 4.11
Oracle source databases, 4.10.1
source database in Audit Vault environment, 4.10.2
SQL Server audit files, 2.4.7

R

redeploy command (AVCA utility), 7.15
REDO collector
about, 1.3.4.2
attributes, 9.4
audit trail settings for, 1.6.2
configuration report and health check script, A.3.4.10
detailed information about audit trails, 1.6.2
recommended init.ora settings, 13.1
supplemental Oracle Streams logging, 13.2
refresh_warehouse command (AVCTL utility) (deprecated), Preface
register_remedy command (AVCA utility), 7.16
register_smtp command (AVCA utility), 7.17
Remedy trouble ticket service
registering with Oracle Audit Vault, 7.16
Remedy trouble tickets
See trouble tickets
remedy.properties.tmpl descriptor properties file, 3.7.2, 3.7.2
remove_cert command (AVCA utility), 7.18
removing
source databases from Audit Vault, 3.8
reports
cannot be viewed, A.3.6.1
checking time zone used for, 7.24
data not showing, A.3.6.2
Enterprise Manager Information Reports, 6.12
log file, A.1
log file created during PDF generation, A.1
new features, Preface
setting time zones, 7.21
roles used with Oracle audit Vault, 5.2

S

scheduling audit collections
See Audit Vault data warehouse
Secure Sockets Layer (SSL)
SMTP configuration, 7.20
secure_remedy command (AVCA utility), 7.19
secure_smtp command (AVCA utility), 7.20
securing
Oracle Audit Vault accounts, 5.2
server.xml file, 5.3
set_server_tz command (AVCA utility), 7.21
set_warehouse_retention command (AVCA utility), 7.22
set_warehouse_schedule command (AVCA utility) (deprecated), Preface
setup command
Oracle databases, 9.9
SQL Server databases, 10.9
Sybase databases, 11.9
SHLIB_PATH environment variable, 2.2.2
show_agent_status command (AVCTL utility), 8.4
show_av_status command (AVCTL utility), 8.5
show_collector_status command (AVCTL utility), 2.9.2, 8.6
show_oc4j_status command (AVCTL), 8.15.1
show_remedy_config command (AVCA utility), 7.23
show_remedy_status command (AVCTL utility), 8.7
show_server_tz command (AVCA utility), 7.24
show_smtp_config command (AVCA utility), 7.25
show_smtp_config command (AVCTL utility), 8.8
SMTP servers
See Audit Vault email notification service
source databases
about, 1.3.1
altering collector attributes, 3.3
altering source database attributes, 3.5
changing source user password, 5.4.5
general steps for adding to Oracle Audit Vault, 2.1
log file created for Oracle database policies, A.1
monitoring from Cloud Control, 6.9
removing from Audit Vault
about, 3.8.1
from command line, 3.8.3
using Audit Vault Console, 3.8.2
supported database products, 1.3.1
UNIX environment variable settings, 2.2.1
See also IBM DB2 databases, Microsoft SQL Server databases, Oracle databases, and Sybase ASE databases
SQL*Net
log file, A.2
start_agent command (AVCTL utility), 8.9, 8.9
start_av command (AVCTL utility), 8.10
start_collector command (AVCTL utility), 8.11
start_oc4j command (AVCTL utility), 8.15.2
starting
Audit Vault collection agent, Release 10.2.3.2, 8.9
Audit Vault Console, 3.2.3
collectors, 8.11
state of
Audit Vault collection agents, pre-Release 10.2.3.2, 8.15.1
Audit Vault collection agents, Release 10.2.3.2, 8.4
Audit Vault Console, 3.2.2, 8.5
collectors, 8.6
stop_agent command (AVCTL utility), 8.12, 8.12
stop_av command (AVCTL utility), 3.2.4, 8.13
stop_collector command (AVCTL utility), 8.14
stop_oc4j command (AVCTL utility), 8.15.3, 8.15.3
stopping
Audit Vault collection agents, for pre-Release 10.2.3.2, 8.15.3
Audit Vault Console, 3.2.4
collectors, 8.14
Sybase ASE databases
adding collector to Oracle Audit Vault, 2.5.5
collector status, checking, 2.9.2, 2.9.2
compatibility with collector, 2.5.3
creating user account, 2.5.2
jar file missing, A.3.4.6
jConnect for JDBC driver, 2.5.1
modifying collector attributes, 3.3
modifying source attributes, 3.5
planning configuration, 1.6.4
registering with Oracle Audit Vault, 2.5
removing from Oracle Audit Vault, 3.8
setting up in collection agent home, 11.9
source database errors, B.1.2
unable to connect to source database, A.3.4.7
verifying compatibility with collector, 11.10
See also Audit Vault Sybase ASE Database (AVSYBDB) utility
SYBDB collector
about, 1.3.4.2
attributes, 11.4
audit trail settings for, 1.6.4
detailed information about audit trails, 1.6.4
See also Sybase ASE databases
SYS account
how Oracle Audit Vault handles, 5.5
SYSAUX tablespace
monitoring in Audit Vault Server, 4.2
SYSDBA privilege
how Oracle Audit Vault handles, 5.5
remote collection agent, effect on, 1.3.4.1
syslog files, 1.3.4.2
SYSMAN account
how Oracle Audit Vault handles, 5.5
SYSOPER privilege
how Oracle Audit Vault handles, 5.5
remote collection agent, effect on, 1.3.4.1
SYSTEM account
how Oracle Audit Vault handles, 5.5

T

test_remedy command (AVCA utility), 7.26
test_smtp command (AVCA utility), 7.27
thresholds for warning and critical alerts, 6.6
time zones, setting for reports and alerts, 7.21
tnsnames.ora file
updated by avorcldb setup command, 9.9
topology of Audit Vault configuration, 6.4
trace files
Microsoft SQL Server, preventing from being deleted, 2.4.7
Transport Layer Security (TLS)
SMTP configuration, 7.20
trouble tickets
about, 3.7.1
configuring, 3.7
disabling configuration, 7.7
disabling security configuration, 7.19
enabling configuration, 7.10
enabling security configuration, 7.19
log file
Audit Vault Server, A.1
removing from Oracle Audit Vault, 7.16
status checking, 7.23
testing connection to Oracle Audit Vault, 7.26
updating with deployment descriptor properties file, 7.2
troubleshooting
alerts not firing, A.3.6.4
Audit Vault collector, A.3.4.3
Audit Vault Console, A.3.5.1
Audit Vault Console, disabled in an Oracle RAC node, 4.6
Audit Vault data warehouse, audit data not appearing in, A.3.6.3
Audit Vault in an Oracle RAC environment, A.3.7.1
Audit Vault reports
data not showing, A.3.6.2
reports cannot be viewed, A.3.6.1
Audit Vault Server, A.3.2.1
collector host computer failure, A.3.4.8
collector not starting, 8.11
data not showing in reports, A.3.6.2
error messages, B
failover recovery for collectors, 9.4, 10.4, 11.4
example for DBAUD, 9.4
example for SQL Server, 10.4
example for Sybase ASE, 11.4
finding detailed information about an error, A.3.1
finding Oracle Database trace files, A.3.1
monitoring
agents in Cloud Control, 6.7.1
alert incidents in Cloud Control, 6.11
audit notifications in Cloud Control, 6.10
collectors in Cloud Control, 6.8.1
general activities in Cloud Control, 6.3
source databases in Cloud Control, 6.9
new alerts not able to be created, A.3.6.4
SQL Server trace files being deleted by accident, 2.4.7
viewing operational errors, 3.2.7
See also errors and log files

U

UNIX environment variable settings, 2.2.5
users
default Oracle Audit Vault user accounts, 5.2
UTC time zone
status checking, 7.24

V

verify command
IBM DB2 databases, 12.9
Oracle databases, 9.10
SQL Server databases, 10.10
Sybase ASE databases, 11.10
verifying source database compatibility
with DB2 collector, 12.9
with Oracle Database collectors, 9.10
with SQL Server collector, 10.10
with Sybase ASE collector, 11.10
viewing
Audit Vault errors, 3.2.7

W

wallets
See Oracle wallets
Windows
See Microsoft Windows