圖二十五：選擇建立資料庫需之範本檔。
建議第一次安裝之讀者選擇【General Purpose】選項。
表一、二、三、四、五則整理出【General Purpose】選項中各參數之系統預設值，,
供各位讀者參考。
表一：一般性參數之預設值
Option Name Selected
Example Schemas true
Oracle Intermedia true
Oracle JVM true
Oracle Label Security false
Oracle OLAP Services true
Oracle Spatial true
Oracle Ultra Search true
表二：起始參數(Initialization parameter)之預設值
Name Value
background_dump_dest {ORACLE_BASE}/admin/{DB_NAME}/bdump
compatible 9.0.0
control_files ("{ORACLE_BASE}/oradata/{DB_NAME}/control01.ctl", "{ORACLE_BASE}/oradata/{DB_NAME}/control02.ctl", "{ORACLE_BASE}/oradata/{DB_NAME}/control03.ctl")
core_dump_dest {ORACLE_BASE}/admin/{DB_NAME}/cdump
db_block_size 8192
db_cache_size 67108864
db_name
dispatchers (PROTOCOL=TCP)(SER=MODOSE), (PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer), (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
fast_start_mttr_target 300
java_pool_size 117440512
Large_pool_size 1048576
Open_cursors 300
processes 150
remote_login_passwordfile EXCLUSIVE
resource_manager_plan SYSTEM_PLAN
shared_pool_size 117440512
sort_area_size 524288
Timed_statistics TRUE
Undo_management AUTO
Undo_tablespace UNDOTBS
user_dump_dest {ORACLE_BASE}/admin/{DB_NAME}/udump
表三：資料庫檔案相關之參數預設值
Name Tablespace Size(M)
{ORACLE_BASE}/oradata/{DB_NAME}/cwmlite01.dbf CWMLITE 20
{ORACLE_BASE}/oradata/{DB_NAME}/drsys01.dbf DRSYS 20
{ORACLE_BASE}/oradata/{DB_NAME}/example01.dbf EXAMPLE 160
{ORACLE_BASE}/oradata/{DB_NAME}/indx01.dbf INDX 25
{ORACLE_BASE}/oradata/{DB_NAME}/system01.dbf SYSTEM 325
{ORACLE_BASE}/oradata/{DB_NAME}/tools01.dbf TOOLS 10
{ORACLE_BASE}/oradata/{DB_NAME}/undotbs01.dbf UNDOTBS 260
{ORACLE_BASE}/oradata/{DB_NAME}/users01.dbf USERS 25
{ORACLE_BASE}/oradata/{DB_NAME}/temp01.dbf TEMP 40
表四：控制檔之參數預設值
Control file
{ORACLE_BASE}/oradata/{DB_NAME}/control01.ctl
{ORACLE_BASE}/oradata/{DB_NAME}/control02.ctl
{ORACLE_BASE}/oradata/{DB_NAME}/control03.ctl
表五：重置交易紀錄檔群組之參數預設值
Group Size(K)
1 102400
2 102400
3 102400
如果您已經熟悉如何設定各資料庫參數，不想使用以上三種範本建立資料庫的話。可利用第四個選項【New database】自行設定所有Oracle資料庫參數。但如果您對於這方面不是很有經驗的話，建議您盡量不要使用該選項建立資料庫！
表六、七、八、九、十、十一則整理出【New Database】選項中各參數之系統預設值，供各位讀者作為設定時之參考：
表六：一般性參數之預設值
Option Name Selected
Example Schemas true
Oracle Intermedia true
Oracle JVM true
Oracle Label Security false
Oracle Spatial true
Oracle Ultra Search true
表七：起始參數(Initialization parameter)之預設值
Name Value
background_dump_dest {ORACLE_BASE}/admin/{DB_NAME}/bdump
compatible 9.0.0
control_files ("{ORACLE_BASE}/oradata/{DB_NAME}/control01.ctl", "{ORACLE_BASE}/oradata/{DB_NAME}/control02.ctl", "{ORACLE_BASE}/oradata/{DB_NAME}/control03.ctl")
core_dump_dest {ORACLE_BASE}/admin/{DB_NAME}/cdump
db_block_size 8KB
db_cache_size 50MB
dispatchers "(PROTOCOL=TCP)(SER=MODOSE)", "(PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer)", "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"
fast_start_mttr_target 300
java_pool_size 50MB
large_pool_size 1MB
open_cursors 300
processes 150
remote_login_passwordfile EXCLUSIVE
resource_manager_plan SYSTEM_PLAN
shared_pool_size 50MB
sort_area_size 524288
timed_statistics TRUE
undo_management AUTO
undo_tablespace UNDOTBS
user_dump_dest {ORACLE_BASE}/admin/{DB_NAME}/udump
表八：控制檔之參數預設值
Control file
{ORACLE_BASE}/oradata/{DB_NAME}/control01.ctl
{ORACLE_BASE}/oradata/{DB_NAME}/control02.ctl
{ORA
