普通创建数据库的一些参数信息模板

Posted on 2012-12-02 19:08  bingfeng  阅读(698)  评论(0编辑  收藏  举报
普通创建数据库的一些参数信息模板
Use this template to create a customized database.

Common Options

OptionSelected

Oracle JVM true
Oracle Data Mining true
Oracle Text true
Oracle XML DB true
Oracle Intermedia true
Oracle OLAP true
Oracle Spatial true
Oracle Ultra Search false
Oracle Label Security false
Sample Schemas false
Enterprise Manager Repository true

初始化参数

audit_file_dest {ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/adump
background_dump_dest {ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/bdump
compatible 10.2.0.2.0
control_files ("{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/control01.ctl", "{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/control02.ctl", "{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/control03.ctl")
core_dump_dest {ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/cdump
db_block_size 8KB
db_file_multiblock_read_count 16
db_recovery_file_dest {ORACLE_BASE}/flash_recovery_area
db_recovery_file_dest_size 2048MB
dispatchers (PROTOCOL=TCP) (SERVICE={SID}XDB)
job_queue_processes 10
open_cursors 300
pga_aggregate_target 24MB
processes 150
remote_login_passwordfile EXCLUSIVE
sga_target 140MB
undo_management AUTO
undo_tablespace UNDOTBS1
user_dump_dest {ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/udump

字符集设置

Database Character Set WE8ISO8859P1
National Character Set AL16UTF16

控制文件

{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/control01.ctl
{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/control02.ctl
{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/control03.ctl

表空间

SYSAUX PERMANENT LOCAL
SYSTEM PERMANENT LOCAL
TEMP TEMPORARY LOCAL
UNDOTBS1 PERMANENT , UNDO LOCAL
USERS PERMANENT LOCAL

数据文件(M)

{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/sysaux01.dbf SYSAUX 120
{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/system01.dbf SYSTEM 300
{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/temp01.dbf TEMP 20
{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/undotbs01.dbf UNDOTBS1 200
{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/users01.dbf USERS 5

Redo日志组(K)

1 51200
2 51200
3 51200

Copyright © 2021 bingfeng
Powered by .NET 6 on Kubernetes