Oracle Database Configuration for Symantec DLP: The database template examined
Article ID: 159546
Updated On: 01-04-2022
Products
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}\"
Feedback
