IDC资讯中心
手工创建数据库的全部脚本及说明
系统环境：
1、操作系统：windows 2000 server，机器内存128m
2、数据库： oracle 8i r2 (8.1.6) for nt 企业版
3、安装路径：d:\oracle
建库步骤：
1、手工创建相关目录
d:\oracle\admin\test
d:\oracle\admin\test\adhoc
d:\oracle\admin\test\bdump
d:\oracle\admin\test\cdump
d:\oracle\admin\test\create
d:\oracle\admin\test\exp
d:\oracle\admin\test\pfile
d:\oracle\admin\test\udump
d:\oracle\oradata\test
d:\oracle\oradata\test\archive
2、手工创建初始化启动参数文件：d:\oracle\admin\test\pfile\inittest.ora，内容：
3、手工创建d:\oracle\ora81\database\inittest.ora文件，
内容：ifile=d:\oracle\admin\test\pfile\inittest.ora
4、使用orapwd.exe命令，创建d:\oracle\ora81\database\pwdtest.ora
命令：d:\oracle\ora81\bin\orapwd file=d:\oracle\ora81\database\pwdtest.ora password=oracle entries=5
5、通过oradim.exe命令，在服务里生成一个新的实例管理服务，启动方式为手工
set oracle_sid=test
d:\oracle\ora81\bin\oradim -new -sid test -startmode manual -pfile “d:\oracle\admin\test\pfile\inittest.ora”
6、生成各种数据库对象
d:\>svrmgrl
–创建数据库
connect internal/oracle
startup nomount pfile=”d:\oracle\admin\test\pfile\inittest.ora”
create database test
logfile d:\oracle\oradata\test\redo01.log size 2048k,
d:\oracle\oradata\test\redo02.log size 2048k,
d:\oracle\oradata\test\redo03.log size 2048k
maxlogfiles 32
maxlogmembers 2
maxloghistory 1
datafile d:\oracle\oradata\test ystem01.dbf size 58m reuse autoextend on next 640k
maxdatafiles 254
maxinstances 1
character set zhs16gbk
national character set zhs16gbk;
控制文件、日志文件在上面语句执行时生成
connect internal/oracle
–修改系统表空间
alter tablespace system default storage ( initial 64k next 64k minextents 1 maxextents unlimited pctincrease 50);
alter tablespace system minimum extent 64k;
–创建回滚表空间
create tablespace rbs datafile d:\oracle\oradata\test\rbs01.dbf size 256m reuse
autoextend on next 5120k
minimum extent 512k
default storage ( initial 512k next 512k minextents 8 maxextents 4096);
–创建用户表空间
create tablespace users datafile d:\oracle\oradata\test\users01.dbf size 128m reuse
autoextend on next 1280k
minimum extent 128k
default storage ( initial 128k next 128k minextents 1 maxextents 4096 pctincrease 0);
–创建临时表空间
create tablespace temp datafile d:\oracle\oradata\test\temp01.dbf size 32m reuse
autoextend on next 640k
minimum extent 64k
default storage ( initial 64k next 64k minextents 1 maxextents unlimited pctincrease 0) temporary;
–创建工具表空间
create tablespace tools datafile d:\oracle\oradata\test\tools01.dbf size 64m reuse
autoextend on next 320k
minimum extent 32k
default storage ( initial 32k next 32k minextents 1 maxextents 4096 pctincrease 0);
–创建索引表空间
create tablespace indx datafile d:\oracle\oradata\test\indx01.dbf size 32m reuse
autoextend on next 1280k
minimum extent 128k
default storage ( initial 128k next 128k minextents 1 maxextents 4096 pctincrease 0);
–创建回滚段
create public rollback segment rbs0 tablespace rbs storage ( optimal 4096k );
create public rollback segment rbs1 tablespace rbs storage ( optimal 4096k );
create public rollback segment rbs2 tablespace rbs storage ( optimal 4096k );
create public rollback segment rbs3 tablespace rbs storage ( optimal 4096k );
create public rollback segment rbs4 tablespace rbs storage ( optimal 4096k );
create public rollback segment rbs5 tablespace rbs storage ( optimal 4096k );
create public rollback segment rbs6 tablespace rbs storage ( optimal 4096k );
create public rollback segment rbs7 tablespace rbs storage ( optimal 4096k );
create public rollback segment rbs8 tablespace rbs storage ( optimal 4096k );
create public rollback segment rbs9 tablespace rbs storage ( optimal 4096k );
create public rollback segment rbs10 tablespace rbs storage ( optimal 4096k );
create public rollback segment rbs11 tablespace rbs storage ( optimal 4096k );
create public rollback segment rbs12 tablespace rbs storage ( optimal 4096k );
create public rollback segment rbs13 tablespace rbs storage ( optimal 4096k );
create public rollback segment rbs14 tablespace rbs storage ( optimal 4096k );
create public rollback segment rbs15 tablespace rbs storage ( optimal 4096k );
create public rollback segment rbs16 tablespace rbs storage ( optimal 4096k );
create public rollback segment rbs17 tablespace rbs storage ( optimal 4096k );
create public rollback segment rbs18 tablespace rbs storage ( optimal 4096k );
create public rollback segment rbs19 tablespace rbs storage ( optimal 4096k );
create public rollback segment rbs20 tablespace rbs storage ( optimal 4096k );
create public rollback segment rbs21 tablespace rbs storage ( optimal 4096k );
create public rollback segment rbs22 tablespace rbs storage ( optimal 4096k );
create public rollback segment rbs23 tablespace rbs storage ( optimal 4096k );
create public rollback segment rbs24 tablespace rbs storage ( optimal 4096k );
–使回滚段在线
alter rollback segment “rbs0” online;
alter rollback segment “rbs1” online;
alter rollback segment “rbs2” online;
alter rollback segment “rbs3” online;
alter rollback segment “rbs4” online;
alter rollback segment “rbs5” online;
alter rollback segment “rbs6” online;
alter rollback segment “rbs7” online;
alter rollback segment “rbs8” online;
alter rollback segment “rbs9” online;
alter rollback segment “rbs10” online;
alter rollback segment “rbs11” online;
alter rollback segment “rbs12” online;
alter rollback segment “rbs13” online;
alter rollback segment “rbs14” online;
alter rollback segment “rbs15” online;
alter rollback segment “rbs16” online;
alter rollback segment “rbs17” online;
alter rollback segment “rbs18” online;
alter rollback segment “rbs19” online;
alter rollback segment “rbs20” online;
alter rollback segment “rbs21” online;
alter rollback segment “rbs22” online;
alter rollback segment “rbs23” online;
alter rollback segment “rbs24” online;
–修改sys用户的临时表空间为temp
alter user sys temporary tablespace temp;
–创建数据字典表
@d:\oracle\ora81\rdbms\admin\catalog.sql;
@d:\oracle\ora81\rdbms\admin\catexp7.sql
@d:\oracle\ora81\rdbms\admin\catproc.sql
@d:\oracle\ora81\rdbms\admin\caths.sql
connect system/manager
@d:\oracle\ora81 qlplus\admin\pupbld.sql
connect internal/oracle
@d:\oracle\ora81\rdbms\admin\catrep.sql
exit
–生成sql*plus帮助系统
sqlplus system/manager
@d:\oracle\ora81 qlplus\admin\help\helpbld.sql helpus.sql
exit
–修改system用户默认表空间和临时表空间
svrmgrl
connect internal/oracle
alter user system default tablespace tools;
alter user system temporary tablespace temp;
exit
7、将test实例启动服务设置成自动启动方式
d:\oracle\ora81\bin\oradim -edit -sid test -startmode auto
—————-init.ora 内容————————–
db_name = “test”
instance_name = test
service_names = test
db_files = 1024
control_files = (“d:\oracle\oradata\test\control01.ctl”, “d:\oracle\oradata\test\control02.ctl”, “d:\oracle\oradata\test\control03.ctl”)
open_cursors = 200
max_enabled_roles = 30
db_file_multiblock_read_count = 8
db_block_buffers = 4096
shared_pool_size = 52428800
large_pool_size = 78643200
java_pool_size = 20971520
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
processes = 115
parallel_max_servers = 5
log_buffer = 32768
max_dump_file_size = 10240
global_names = true
oracle_trace_collection_name = “”
background_dump_dest = d:\oracle\admin\test\bdump
user_dump_dest = d:\oracle\admin\test\udump
db_block_size = 16384
remote_login_passwordfile = exclusive
os_authent_prefix = “”
job_queue_processes = 4
job_queue_interval = 60
open_links = 4
distributed_transactions = 10
mts_dispatchers = “(protocol=tcp)(pre=oracle.aurora.server.sgiopserver)”
mts_dispatchers = “(protocol=tcp)”
compatible = 8.1.0
sort_area_size = 65536
sort_area_retained_size = 65536
