Oracle Database Configuration for Vontu: The database template examined

Article Id: 159546

Status: Published

Updated On: 11-04-2014 13:42

Legacy Id: TECH218990

Products:

Data Loss Prevention Enforce

Issue/Introduction:

The Vontu installation requires an Oracle database to be set up according to particular settings, sizes, and configurations. Using the Oracle_10g_Database_for_Vontu_v8.dbt during database creation makes sure that these settings are in place.

Questions regarding how different Oracle components are set up often arise, and the .dbt file is often referred to for the answers. Its XML format, however, makes this file cumbersome as a reference.

Resolution:

The Oracle_10g_Database_for_Vontu_v8.dbt is a database creation template used by the Oracle Database Creation Assistant, or DBCA, for the creation of Symantec DLP's database. It provides explicit database parameters needed to configure, install, and maintain the Vontu schema.

The Oracle_10g_Database_for_Vontu_v8.dbt is an XML file. The following is a copy of the .dbt with the XML stripped out and annotations added.

This document serves as guidance with regard to how the Oracle database is configured for use with Symantec DLP/Vontu.

This template is for Vontu 8.x on Oracle 10.2.0.x

======================
Vontu specifically does not use the following Oracle RDBMS applications:
ISEARCH,
OMS,
JSERVER,
SPATIAL,
ODM,
IMEDIA,
XDB_PROTOCOLS,
ORACLE_TEXT,
SAMPLE_SCHEMA,
CWMLITE,
EM_REPOSITORY, -- Enterprise manager installation is offered during the course of the DB installation. At that time, the OEM may be selected for installation and the repository tablespace can be selected. Vontu instructions specify OEM installation.
HTMLDB,
NET_EXTENSIONS

======================
No custom scripts are executed during the course of the installation.

======================
Oracle 10g has hundreds of parameters that control all forms of database variables. The InitParams section of the .dbt lists specific parameters and the values needed for Symantec DLP installation:

pga_aggregate_target  419430400
fast_start_mttr_target  0
sort_area_size   524288
sga_target   1153433600
sga_max_size   1153433600
streams_pool_size  0
shared_pool_size  0
large_pool_size   0
java_pool_size   0
db_cache_size   0
session_max_open_files  20
processes   1000
aq_tm_processes   1
star_transformation_enabled FALSE
control_files   ("{ORACLE_BASE.EN_US}\oradata\{DB_UNIQUE_NAME.EN_US}\CONTROL01.CTL", "{ORACLE_BASE.EN_US}\oradata\{DB_UNIQUE_NAME.EN_US}\CONTROL02.CTL", "{ORACLE_BASE.EN_US}\oradata\{DB_UNIQUE_NAME.EN_US}\CONTROL03.CTL")
timed_statistics  TRUE
compatible   10.2.0.2.0
query_rewrite_enabled  FALSE
disk_asynch_io   FALSE
sessions   1500
background_dump_dest  {ORACLE_BASE.EN_US}\admin\{DB_UNIQUE_NAME.EN_US}\bdump
job_queue_processes  10
db_name
nls_length_semantics  CHAR
user_dump_dest   {ORACLE_BASE.EN_US}\admin\{DB_UNIQUE_NAME.EN_US}\udump
undo_retention   10800
open_cursors   300
db_block_size   8192
undo_tablespace   UNDOTBS1
core_dump_dest   {ORACLE_BASE.EN_US}\admin\{DB_UNIQUE_NAME.EN_US}\cdump
remote_login_passwordfile EXCLUSIVE
undo_management   AUTO
db_file_multiblock_read_count 16
optimizer_index_caching  90
optimizer_index_cost_adj 25

characterSet AL32UTF8
nationalCharacterSet AL16UTF16

archiveLogMode   false

initParamFileName  {ORACLE_BASE.EN_US}\admin\{DB_UNIQUE_NAME.EN_US}\pfile\init.ora

SPFile true
{ORACLE_HOME.EN_US}\database\spfile{SID.EN_US}.ora

======================
ControlfileAttributes

id="Controlfile"

maxDatafiles 100
maxLogfiles 16
maxLogMembers 3
maxLogHistory 1
maxInstances 8
CONTROL01.CTL filepath="{ORACLE_BASE.EN_US}\oradata\{DB_UNIQUE_NAME.EN_US}\"
CONTROL02.CTL filepath="{ORACLE_BASE.EN_US}\oradata\{DB_UNIQUE_NAME.EN_US}\"
CONTROL03.CTL filepath="{ORACLE_BASE.EN_US}\oradata\{DB_UNIQUE_NAME.EN_US}\"

======================
DatafileAttributes

DRSYS
  {ORACLE_BASE.EN_US}\oradata\{DB_UNIQUE_NAME.EN_US}\DRSYS01.DBF
  temporary false
  online  true
  status  0
  size unit="MB" 20
  reuse  true
  autoExtend true
  increment unit="KB" 640
  maxSize unit="MB" 32767

LOB_TABLESPACE
  {ORACLE_BASE.EN_US}\oradata\{DB_UNIQUE_NAME.EN_US}\LOB01.DBF
  temporary false
  online  true
  status  0
  size unit="MB" 1024
  reuse  true
  autoExtend true
  increment unit="MB" 100
  maxSize unit="MB" 32767

  {ORACLE_BASE.EN_US}\oradata\{DB_UNIQUE_NAME.EN_US}\LOB02.DBF
  temporary false
  online  true
  status  0
  size unit="MB" 1024
  reuse  true
  autoExtend true
  increment unit="MB" 100
  maxSize unit="MB" 32767

  {ORACLE_BASE.EN_US}\oradata\{DB_UNIQUE_NAME.EN_US}\LOB03.DBF
  temporary false
  online  true
  status  0
  size unit="MB" 1024
  reuse  true
  autoExtend true
  increment unit="MB" 100
  maxSize unit="MB" 32767

SYSAUX
  {ORACLE_BASE.EN_US}\oradata\{DB_UNIQUE_NAME.EN_US}\SYSAUX01.DBF
  temporary false
  online  true
  status  0
  size unit="MB" 500
  reuse  true
  autoExtend true
  increment unit="KB" 10240
  maxSize unit="MB" 32767

SYSTEM
  {ORACLE_BASE.EN_US}\oradata\{DB_UNIQUE_NAME.EN_US}\SYSTEM01.DBF
  temporary false
  online  true
  status  0
  size unit="MB" 530
  reuse  true
  autoExtend true
  increment unit="KB" 10240
  maxSize unit="MB" 32767

TEMP
  {ORACLE_BASE.EN_US}\oradata\{DB_UNIQUE_NAME.EN_US}\TEMP01.DBF
  temporary true
  online  true
  status  0
  size unit="MB" 300
  reuse  true
  autoExtend true
  increment unit="MB" 128
  maxSize unit="MB" 32767

UNDOTBS1
  {ORACLE_BASE.EN_US}\oradata\{DB_UNIQUE_NAME.EN_US}\UNDOTBS01.DBF
  temporary false
  online  true
  status  0
  size unit="MB" 1024
  reuse  true
  autoExtend true
  increment unit="KB" 5120
  maxSize unit="MB" 32767

USERS
  {ORACLE_BASE.EN_US}\oradata\{DB_UNIQUE_NAME.EN_US}\USERS01.DBF
  temporary false
  online  true
  status  0
  size unit="MB" 1024
  reuse  true
  autoExtend true
  increment unit="MB" 100
  maxSize unit="MB" 32767

======================
TablespaceAttributes

DRSYS
  online  true
  offlineMode 1
  readOnly false
  temporary false
  defaultTemp false
  undo  false
  local  true
  blockSize 8192
  allocation 1
  uniAllocSize unit="KB" -1
  initSize unit="KB" 64
  increment unit="KB" 0
  incrementPercent 0
  minExtends 1
  maxExtends 2147483645
  minExtendsSize unit="KB" 64
  logging  true
  recoverable false
  maxFreeSpace 0
  autoSegmentMgmt true
  bigfile  false
  datafilesList
   {ORACLE_BASE.EN_US}\oradata\{DB_UNIQUE_NAME.EN_US}\DRSYS01.DBF
   id -1

LOB_TABLESPACE
  online  true
  offlineMode 1
  readOnly false
  temporary false
  defaultTemp false
  undo  false
  local  true
  blockSize 8192
  allocation 1
  uniAllocSize unit="KB" -1
  initSize unit="KB" 64
  increment unit="KB" 0
  incrementPercent 0
  minExtends 1
  maxExtends 2147483645
  minExtendsSize unit="KB" 64
  logging  true
  recoverable false
  maxFreeSpace 0
  autoSegmentMgmt true
  bigfile  false
  datafilesList
   {ORACLE_BASE.EN_US}\oradata\{DB_UNIQUE_NAME.EN_US}\LOB01.DBF
   id -1
   {ORACLE_BASE.EN_US}\oradata\{DB_UNIQUE_NAME.EN_US}\LOB02.DBF
   id -1
   {ORACLE_BASE.EN_US}\oradata\{DB_UNIQUE_NAME.EN_US}\LOB03.DBF
   id -1

SYSAUX
  online  true
  offlineMode 1
  readOnly false
  temporary false
  defaultTemp false
  undo  false
  local  true
  blockSize 8192
  allocation 1
  uniAllocSize unit="KB" -1
  initSize unit="KB" 64
  increment unit="KB" 0
  incrementPercent 0
  minExtends 1
  maxExtends 2147483645
  minExtendsSize unit="KB" 64
  logging  true
  recoverable false
  maxFreeSpace 0
  autoSegmentMgmt true
  bigfile  false
  datafilesList
   {ORACLE_BASE.EN_US}\oradata\{DB_UNIQUE_NAME.EN_US}\SYSAUX01.DBF
   id -1

SYSTEM
  online  true
  offlineMode 1
  readOnly false
  temporary false
  defaultTemp false
  undo  false
  local  true
  blockSize 8192
  allocation 1
  uniAllocSize unit="KB" -1
  initSize unit="KB" 64
  increment unit="KB" 0
  incrementPercent 0
  minExtends 1
  maxExtends 2147483645
  minExtendsSize unit="KB" 64
  logging  true
  recoverable false
  maxFreeSpace 0
  autoSegmentMgmt true
  bigfile  false
  datafilesList
   {ORACLE_BASE.EN_US}\oradata\{DB_UNIQUE_NAME.EN_US}\SYSTEM01.DBF
   id -1

TEMP
  online  true
  offlineMode 1
  readOnly false
  temporary true
  defaultTemp true
  undo  false
  local  true
  blockSize 8192
  allocation 2
  uniAllocSize unit="KB" 1024
  initSize unit="KB" 1024
  increment unit="KB" 1024
  incrementPercent 0
  minExtends 1
  maxExtends -1
  minExtendsSize unit="KB" 1024
  logging  false
  recoverable false
  maxFreeSpace 0
  autoSegmentMgmt false
  bigfile  false
  datafilesList
   {ORACLE_BASE.EN_US}\oradata\{DB_UNIQUE_NAME.EN_US}\TEMP01.DBF
   id -1

UNDOTBS1
  online  true
  offlineMode 1
  readOnly false
  temporary true
  defaultTemp true
  undo  false
  blockSize 8192
  allocation 1
  uniAllocSize unit="KB" -1
  initSize unit="KB" 64
  increment unit="KB" 0
  incrementPercent 0
  minExtends  1
  maxExtends  2147483645
  minExtendsSize unit="KB" 64
  logging  true
  recoverable false
  maxFreeSpace 0
  autoSegmentMgmt false
  bigfile  false
  datafilesList
   {ORACLE_BASE.EN_US}\oradata\{DB_UNIQUE_NAME.EN_US}\UNDOTBS01.DBF
   id -1

USERS
  online  true
  offlineMode 1
  readOnly false
  temporary false
  defaultTemp false
  undo  false
  local  true
  blockSize 8192
  allocation 1
  uniAllocSize unit="KB" -1
  initSize unit="KB" 64
  increment unit="KB" 0
  incrementPercent 0
  minExtends 1
  maxExtends 2147483645
  minExtendsSize unit="KB" 64
  logging  true
  recoverable false
  maxFreeSpace 0
  autoSegmentMgmt true
  bigfile  false
  datafilesList
   {ORACLE_BASE.EN_US}\oradata\{DB_UNIQUE_NAME.EN_US}\USERS01.DBF">
   id -1

======================
RedoLogGroupAttributes

id=  "1"
reuse  false
fileSize unit="KB" 102400
Thread  1
  member ordinal="0"
  memberName="REDO01.LOG"
  filepath="{ORACLE_BASE.EN_US}\oradata\{DB_UNIQUE_NAME.EN_US}\"

id=  "2"
reuse  false
fileSize unit="KB" 102400
Thread  1
  member ordinal="0"
  memberName="REDO02.LOG"
  filepath="{ORACLE_BASE.EN_US}\oradata\{DB_UNIQUE_NAME.EN_US}\"

id=  "3"
reuse  false
fileSize unit="KB" 102400
Thread  1
  member ordinal="0"
  memberName="REDO03.LOG"
  filepath="{ORACLE_BASE.EN_US}\oradata\{DB_UNIQUE_NAME.EN_US}\"