手动创建数据库方法

步骤四：启动新创建的实例，创建数据库步骤五：创建数据字典  这两个步骤用一个脚本实现

在创建数据库之前要以新的参数文件启动数据库实例，即nomount数据库，因没有控制文件还不能mount或open
c:/>sqlplus "/as sysdba"
sql>startup nomount              
oracle 例程已经启动。

total system global area  118255568 bytes
fixed size                   282576 bytes
variable size              83886080 bytes
database buffers           33554432 bytes
redo buffers                 532480 bytes
若数据库参数文件不在f:/oracle/ora90/database下，或参数文件名称没有按initsid.ora取名，则启动实例时要加参数pfile指出参数文件路

径，例sql>startup pfile=路径/参数文件名 nomount
运行脚本文件名为createdb.sql   其中文件最后是加载一些程序包以创建数据字典
sql>@存放路径/createdb.sql
createdb.sql文件内容为：

create database sjpdb02
logfile
      group 1 ('f:/oracle/oradata/sjpdb02/redo01a.log',
               'f:/oracle/oradata/sjpdb02/redo01b.log')  size 5m,
      group 2 ('f:/oracle/oradata/sjpdb02/redo02a.log',
               'f:/oracle/oradata/sjpdb02/redo02b.log')  size 5m,
      group 3 ('f:/oracle/oradata/sjpdb02/redo03a.log',
               'f:/oracle/oradata/sjpdb02/redo03b.log')  size 5m
maxlogfiles 32
maxlogmembers 3
maxloghistory 1
datafile 'f:/oracle/oradata/sjpdb02/system01.dbf' size 100m
autoextend on next 512k maxsize unlimited
maxdatafiles 254
maxinstances 1
character set zhs16gbk
national character set utf8;

alter tablespace system default storage
(initial 64k minextents 1
maxextents unlimited pctincrease 50);
alter tablespace system minimum extent 64k;

create undo tablespace undotbs
datafile 'f:/oracle/oradata/sjpdb02/undotbs01.dbf' size 50m
autoextend on next 512k
extent management local;
create temporary tablespace temp
tempfile 'f:/oracle/oradata/sjpdb02/temp01.dbf' size 32m
autoextend on next 512k
extent management local;

create tablespace tools
datafile 'f:/oracle/oradata/sjpdb02/tools01.dbf' size 32m
autoextend on next 512k
extent management dictionary
minimum extent 32k
default storage(initial 32k next 32k minextents 1
maxextents 4096 pctincrease 0);

create  tablespace indx
datafile 'f:/oracle/oradata/sjpdb02/indx01.dbf' size 32m
autoextend on next 512k
minimum extent 128k
default storage(initial 128k next 128k minextents 1
maxextents 4096 pctincrease 0);

create  tablespace users
datafile 'f:/oracle/oradata/sjpdb02/users01.dbf' size 20m
autoextend on next 512k
extent management dictionary
minimum extent 128k
default storage(initial 128k next 128k minextents 1
maxextents 4096 pctincrease 0);

@f:/oracle/ora90/rdbms/admin/catalog.sql
@f:/oracle/ora90/rdbms/admin/catproc.sql
@f:/oracle/ora90/rdbms/admin/catexp7.sql
@f:/oracle/ora90/rdbms/admin/catrep.sql
@f:/oracle/ora90/rdbms/admin/caths.sql
connect system/manager
@f:/oracle/ora90/sqlplus/admin/pupbld.sql

步骤六：网络配置即配置监听器(lisener.ora)和网络连接解析配置（tnsnames.ora）

可以使用net manager来配置