手动创建数据库的步骤和例子

来源：互联网发布：石油行情分析软件编辑：程序博客网时间：2024/06/12 00:06

--第一步
sqlplus /nolog
conn / as sysdba
shutdown immediate
startup nomount

--第二步
mkdir E:/orcl/database/admin/adump
mkdir E:/orcl/database/admin/bdump
mkdir E:/orcl/database/admin/cdump
mkdir E:/orcl/database/admin/dpdump
mkdir E:/orcl/database/admin/udump
mkdir E:/orcl/database/admin/pfile
mkdir E:/orcl/database/oradata/orcl
mkdir E:/orcl/database/db_1

--第三步
Create init1.ora according to init.ora,then
put the fie init1.ora into 'E:/orcl/database/'

--第四步
set ORACLE_SID=test

--第五步
orapwd file=E:/orcl/database/db_1/PWDorcl.ora password=zak force=y
oradim -NEW -SID test -STARTMODE auto -SRVCSTART system -PFILE 'E:/orcl/database/init1.ora'

--最后
sqlplus /nolog
conn / as sysdba
startup nomount pfile=E:/orcl/database/init1.ora

--例子
CREATE DATABASE test
MAXDATAFILES 100
MAXINSTANCES 8
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
LOGFILE GROUP 1 ('E:/orcl/database/oradata/mydatabase/redo01.log') SIZE 51200K,
GROUP 2 ('E:/orcl/database/oradata/mydatabase/redo02.log') SIZE 51200K,
GROUP 3 ('E:/orcl/database/oradata/mydatabase/redo03.log') SIZE 51200K
DATAFILE 'E:/orcl/database/oradata/mydatabase/system01.dbf' SIZE 300M REUSE
SYSAUX DATAFILE 'E:/orcl/database/oradata/mydatabase/sysaux01.dbf' SIZE 120M REUSE
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'E:/orcl/database/oradata/mydatabase/temp01.dbf' SIZE 20M REUSE
UNDO TABLESPACE "UNDOTBS1" DATAFILE 'E:/orcl/database/oradata/mydatabase/undotbs01.dbf' SIZE 200M REUSE