手工創(chuàng)建數(shù)據(jù)庫(kù)的全部腳本及說明

2024-07-21 02:09:15

字體：大中小

供稿：網(wǎng)友

手工創(chuàng)建數(shù)據(jù)庫(kù)的全部腳本及說明

系統(tǒng)環(huán)境：
1、操作系統(tǒng)：windows 2000 server，機(jī)器內(nèi)存128m
2、數(shù)據(jù)庫(kù)：　oracle 8i r2 (8.1.6) for nt 企業(yè)版
3、安裝路徑：d:/oracle

建庫(kù)步驟：
1、手工創(chuàng)建相關(guān)目錄
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、手工創(chuàng)建初始化啟動(dòng)參數(shù)文件：d:/oracle/admin/test/pfile/inittest.ora，內(nèi)容：

3、手工創(chuàng)建d:/oracle/ora81/database/inittest.ora文件，

   內(nèi)容：ifile='d:/oracle/admin/test/pfile/inittest.ora'

4、使用orapwd.exe命令，創(chuàng)建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命令，在服務(wù)里生成一個(gè)新的實(shí)例管理服務(wù)，啟動(dòng)方式為手工
   set oracle_sid=test
   d:/oracle/ora81/bin/oradim -new -sid test -startmode manual -pfile "d:/oracle/admin/test/pfile/inittest.ora"

6、生成各種數(shù)據(jù)庫(kù)對(duì)象
d:/>svrmgrl

--創(chuàng)建數(shù)據(jù)庫(kù)
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;

控制文件、日志文件在上面語(yǔ)句執(zhí)行時(shí)生成

connect internal/oracle
--修改系統(tǒng)表空間
alter tablespace system default storage ( initial 64k next 64k minextents 1 maxextents unlimited pctincrease 50);
alter tablespace system minimum extent 64k;

--創(chuàng)建回滾表空間
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);

--創(chuàng)建用戶表空間
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);

--創(chuàng)建臨時(shí)表空間
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;

--創(chuàng)建工具表空間
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);

--創(chuàng)建索引表空間
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);

--創(chuàng)建回滾段
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用戶的臨時(shí)表空間為temp
alter user sys temporary tablespace temp;

--創(chuàng)建數(shù)據(jù)字典表
@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幫助系統(tǒng)
sqlplus system/manager
@d:/oracle/ora81 qlplus/admin/help/helpbld.sql helpus.sql
exit

--修改system用戶默認(rèn)表空間和臨時(shí)表空間
svrmgrl
connect internal/oracle
alter user system default tablespace tools;
alter user system temporary tablespace temp;
exit

7、將test實(shí)例啟動(dòng)服務(wù)設(shè)置成自動(dòng)啟動(dòng)方式
d:/oracle/ora81/bin/oradim -edit -sid test -startmode auto

----------------init.ora 內(nèi)容--------------------------

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

上一篇：數(shù)據(jù)庫(kù)綜合開發(fā)實(shí)踐

下一篇：如何查看什么時(shí)間有哪些數(shù)據(jù)庫(kù)對(duì)象結(jié)構(gòu)被修改過