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.
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}\"