oracle 创建数据库 create database,oracle create database 手动创建数据库

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