oracle create database 手动创建数据库

(2012-04-17 10:15:08)

 

 

create the sql file: XXX.sql

CREATE DATABASE ratl1252
USER SYS IDENTIFIED BY rati0nal
USER SYSTEM IDENTIFIED BY rati0nal
LOGFILE GROUP 1 ('/Oracle/product/10.2.0/Db_1/oradata/ratl1252/redo01.log') SIZE 100M,
GROUP 2 ('/Oracle/product/10.2.0/Db_1/oradata/ratl1252/redo02.log') SIZE 100M,
GROUP 3 ('/Oracle/product/10.2.0/Db_1/oradata/ratl1252/redo03.log') SIZE 100M
MAXLOGFILES 16
MAXLOGMEMBERS 5
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 2
CHARACTER SET WE8MSWIN1252
DATAFILE '/Oracle/product/10.2.0/Db_1/oradata/ratl1252/system01.dbf' SIZE 2048M REUSE
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/Oracle/product/10.2.0/Db_1/oradata/ratl1252/sysaux01.dbf' SIZE 1024M REUSE
DEFAULT TEMPORARY TABLESPACE Temp
TEMPFILE '/Oracle/product/10.2.0/Db_1/oradata/ratl1252/temp01.dbf'
SIZE 2048M REUSE;

add below settings to init.ora file:
undo_management=AUTO

undo_tablespace=UNDOTBS

export $ORACLE_SID=SID_Name

sqlplus /nolog

conn /as sysdba

startup nomount

@../XXX.sql
安装数据字典
@%oracle_home%\rdbms\admin\catalog.sql
安装oralce系统包
@%oracle_home%\rdbms\admin\catproc.sql
安装product_user_profile表
@%oracle_home%\sqlplus\admin\pupbld.sql