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

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

 

Posted on 2012-12-02 19:08 bingfeng 阅读(54) 评论(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

分类: Oracle

标签: oracle, 手动创建数据库