手工创建数据库的全部脚本及说明

2024-07-21 02:09:15

字体：大中小

来源：转载

供稿：网友

手工创建数据库的全部脚本及说明

系统环境：
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

上一篇：数据库综合开发实践

下一篇：如何查看什么时间有哪些数据库对象结构被修改过