Oracle Database Configuration for Symantec DLP: The database template examined

book

Article ID: 159546

calendar_today

Updated On:

Products

Data Loss Prevention Enforce

Issue/Introduction

The Symantec DLP installation requires an Oracle database to be set up according to particular settings, sizes, and configurations.  Using the Oracle_x.x.0.0_Template_xxx.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_x.x.0.0_Template_xxx.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 Symantec DLP schema. 

The .dbt file is an XML file. 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.

This template is for Symantec DLP 15.8 on Oracle 19.3.0.0

======================================================================================================================================
Symantec DLP specifically does not use the following Oracle RDBMS applications:

 ISEARCH,
 OMS,
 JSERVER,
 SPATIAL,
 ODM,
 IMEDIA,
 XDB_PROTOCOLS,
 ORACLE_TEXT,
 SAMPLE_SCHEMA,
 CWMLITE,
 NET_EXTENSIONS
 APEX
 DV

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. DLP instructions specify OEM installation.
 HTMLDB,
 NET_EXTENSIONS

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

======================================================================================================================================
Oracle 19c 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:

fast_start_mttr_target value=0
memory_target value=3072 unit=MB
memory_max_size value=3072 unit=MB
pga_aggregate_target value=0
pga_aggregate_limit value=0
session_max_open_files value=20
processes value=1000
star_transformation_enabled value=FALSE
control_files value=("{ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\CONTROL01.CTL", "{ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\CONTROL02.CTL", quot;{ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\CONTROL03.CTL")
timed_statistics value=TRUE
compatible value=19.3.0.0.0
query_rewrite_enabled value=FALSE
disk_asynch_io value=FALSE
sessions value=1500
job_queue_processes value=10
db_name value=
undo_retention value=10800
open_cursors value=1000
db_block_size value=8192
undo_tablespace value=UNDOTBS1
remote_login_passwordfile value=EXCLUSIVE
undo_management value=AUTO

<characterSet>AL32UTF8</characterSet>
<nationalCharacterSet>AL16UTF16</nationalCharacterSet>
<archiveLogMode>false</archiveLogMode>
<initParamFileName>{ORACLE_BASE}\admin\{DB_UNIQUE_NAME}\pfile\init.ora</initParamFileName>
<SPfile useSPFile="true">{ORACLE_HOME}\database\spfile{SID}.ora</SPfile>


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

 id="Controlfile"

 maxDatafiles 100
 maxLogfiles 16
 maxLogMembers 3
 maxLogHistory 1
 maxInstances 8

 CONTROL01.CTL filepath={ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\
 CONTROL02.CTL filepath={ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\
 CONTROL03.CTL filepath={ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\

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

 DRSYS
  {ORACLE_BASE.EN_US}\oradata\{DB_UNIQUE_NAME}\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}\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}\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}\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}\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}\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}\TEMP01.DBF
  temporary true
  online  true
  status  0
  size unit="MB" 32767
  reuse  true
  autoExtend true
  increment unit="MB" 128
  maxSize unit="MB" 32767

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

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

  {ORACLE_BASE.EN_US}\oradata\{DB_UNIQUE_NAME}\USERS02.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}\USERS03.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}\oradata\{DB_UNIQUE_NAME}\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}\oradata\{DB_UNIQUE_NAME}\LOB01.DBF
   id -1
   {ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\LOB02.DBF
   id -1
   {ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\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}\oradata\{DB_UNIQUE_NAME}\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}\oradata\{DB_UNIQUE_NAME}\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}\oradata\{DB_UNIQUE_NAME}\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}\oradata\{DB_UNIQUE_NAME}\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}\oradata\{DB_UNIQUE_NAME}\USERS01.DBF">
   id -1
   {ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\USERS02.DBF">
   id -1
   {ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\USERS03.DBF">
   id -1

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

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

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

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