创建oracle脚本范例,Oracle脚本创建数据库

Oracle的脚本手动创建数据库

第一步：

建立实例参数文件，确定实例名称

参数文件名：init+SID.ora

如我的是

initlzy03文件夹里面的内容，lzy03是创建的实例名，黄色的是安装的路径，每个人的安装都不一样，要逐个路径去对应一遍

# Cache and I/O

db_block_size=8192(8kM)

# Cursors and Library Cache

open_cursors=300

# Database Identification

instance_name=lzy03

db_domain=http://doc.docsou.com

db_name=lzy03

# File Configuration

control_files=("D:\app\heejeong\oradata\lzy03\control01.ctl",

"D:\app\heejeong\flash_recovery_area\lzy03\control02.ctl")

db_recovery_file_dest=D:\app\heejeong\flash_recovery_area

db_recovery_file_dest_size=5218762752

# Miscellaneous

compatible=11.2.0.0.0

diagnostic_dest=D:\app\heejeong\oradata

memory_target=635437056

# NLS

nls_language="SIMPLIFIED CHINESE"

nls_territory="CHINA"

# Processes and Sessions

processes=150

# Security and Auditing

audit_file_dest=D:\app\heejeong\admin\lzy03\adump

audit_trail=db

remote_login_passwordfile=EXCLUSIVE

# System Managed Undo and Rollback Segments

undo_management=AUTO

undo_tablespace=UNDOTBS1