What are the Oracle Initialization (INIT.ORA) parameters required for VigilEnt Password Manager for (NETIQKB30522)

goal
What are the Oracle Initialization (INIT.ORA) parameters required for VigilEnt Password Manager for Oracle?

fact
VigilEnt Password Manager for Oracle 5.0

fact
VigilEnt Password Manager for Oracle 6.x

fact
VigilEnt Security Agent for Oracle 1.x

fix

The Oracle initialization (INIT.ORA) parameters required for VigilEnt Password Manager are:

• audit_trail=DB or TRUE
• job_queue_processes=4
• job_queue_interval=60

The Oracle privilege for "Create Session" needs to be audited. Issuing the SQL statement "audit connect" at a SQLplus prompt will activate this feature.

These SQL statements can help check if these items have been setup.

• Select name, value from v$parameter where name like 'audit%'
  
• Select name, value from v$parameter where name like '%job%'
  
• Select name, value from v$parameter where name = 'compatible'
  
• Select user_name, audit_option from sys.dba_stmt_audit_opts where audit_option like 'CREATE%'
  

Formerly known as NETIQKB30522