1.确定oracle的ORACLE_SID名称;

2.确定数据库使用的字符集;

3.设置参数文件parameter initsid.ora;

4.根据参数文件中创建所需要的文件夹;

5.创建口令文件 orapwd file=orapwsid password=oracle entries=10 force=y

5.设置create database command 脚本;

CREATE DATABASE "shirley"

MAXINSTANCES 1

MAXLOGHISTORY 1

MAXLOGFILES 5

MAXLOGMEMBERS 5

MAXDATAFILES 100

DATAFILE '/usr/local/src/oradata/shirley/system01.dbf' size 100m reuse autoextend on next 1m maxsize unlimited extent management local

sysaux datafile '/usr/local/src/oradata/shirley/sysaux01.dbf' size 100m reuse autoextend on next 1m maxsize unlimited

default temporary tablespace TEMP tempfile '/usr/local/src/oradata/shirley/temp01.dbf' size 20m reuse autoextend on next 640k maxsize unlimited

undo tablespace UNDOTBS1 datafile '/usr/local/src/oradata/shirley/undotbs01.dbf' size 20m reuse autoextend on next 5M maxsize unlimited

logfile GROUP 1 ('/usr/local/src/oradata/shirley/redo1.dbf') size 10m,

GROUP 2 ('/usr/local/src/oradata/shirley/redo2.dbf') size 10m,

GROUP 3 ('/usr/local/src/oradata/shirley/redo3.dbf') size 10m

6.设置表空间及索引空间;

7.运行data dictionary等sql语句

7.1 @$ORACLE_HOME/rdbms/admin/catalog.sql;

7.2 @$ORACLE_HOME/rdbms/admin/catproc.sql;

7.3 @$ORACLE_HOME/sqlplus/admin/pupbld.sql;

[@more@]

ITPub博客

手动创建数据库步骤