Oracleֹݿ   (4728) 
ݿ⣺Oracle 8i R2 (8.1.6) 
װ·/data/ora816 
ݿʵweb 
ݿȫƣweb.edi.com 

1ֹĿ¼ 
/data/ora816/admin/web 
/data/ora816/admin/web/adhoc 
/data/ora816/admin/web/bdump 
/data/ora816/admin/web/cdump 
/data/ora816/admin/web/create 
/data/ora816/admin/web/exp 
/data/ora816/admin/web/pfile 
/data/ora816/admin/web/udump 

/data/ora816/oradata/web 
/data/ora816/oradata/web/archive 

2ֹʼļ/data/ora816/admin/web/pfile/initweb.ora 
$ORACLE_HOME/dbsĿ¼Ƿгʼļsidweb,ڴĿ¼Ӧһinitweb.oraļûУԽinit.oraļƳinitweb.oraļcp init.ora initweb.ora.sidweb,ڴĿ¼Ӧһinitweb.oraļûУԽinit.oraļƳinitweb.oraļcp init.ora initweb.ora. 
ln -s /data/ora816/admin/web/initweb.ora /data/ora816/dbs/initweb.ora 

:initweb.oraݣ 

3ʹorapwde/data/ora816/dbs/orapwweb 
orapwd file=/data/ora816/dbs/orapwweb password=ORACLE entries=5 

4黷ǷãORACLE_HOME,ORACLE_SID鷽echo $ORACLE_HOME,echo $ORACLE_SIDûãᷢһУʱͨrootȨ޵¼޸/etc/profileļĩβϣORACLE_HOME=װORACLEʱ·/data/ora816 ORACLE_SID=װʱsid,orcl,ļweb 
export ORACLE_HOME ORACLE_SID 
ͬʱӦ޸PATHԱʹùsvrmgrl,sqlplusȡbinĿ¼뵽PATHС 

5ֱǷļ$ORACLE_HOME/rdbms/admin/catdbsyn.sql$ORACLE_HOME/rdbms/admin/catproc.sql$ORACLE_HOME/sqlplus/admin/pupbld.sqlڣ°װoracleϵͳ 

6׼űcreate_db.sql 

rem űʼ 
connect internal 
startup nomount pfile="$ORACLE_HOME/admin/web/pfile/initweb.ora" 
set echo on 
spool makedb.log 
create database web 
datafile '$ORACLE_HOME/oradata/web/web_syst_01.dbf' size 500M reuse 
logfile 
'$ORACLE_HOME/oradata/web/web_redo_01.dbf' size 10M reuse, 
'$ORACLE_HOME/oradata/web/web_redo_02.dbf' size 10M reuse, 
'$ORACLE_HOME/oradata/web/web_redo_03.dbf' size 10M reuse 
MAXLOGFILES 32 
MAXLOGMEMBERS 2 
MAXLOGHISTORY 1 
MAXDATAFILES 254 
MAXINSTANCES 1 
CHARACTER SET ZHS16GBK 
NATIONAL CHARACTER SET ZHS16GBK; 

connect INTERNAL/oracle 
rem --޸ϵͳռ 
ALTER TABLESPACE SYSTEM DEFAULT STORAGE ( INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 50); 
ALTER TABLESPACE SYSTEM MINIMUM EXTENT 64K; 
connect INTERNAL/oracle 

rem --޸ϵͳռ 
ALTER TABLESPACE SYSTEM DEFAULT STORAGE ( INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 50); 
ALTER TABLESPACE SYSTEM MINIMUM EXTENT 64K; 

rem --عռ 
CREATE TABLESPACE RBS DATAFILE '/data/ora816/oradata/web/rbs01.dbf' SIZE 256M REUSE 
AUTOEXTEND ON NEXT 5120K 
MINIMUM EXTENT 512K 
DEFAULT STORAGE ( INITIAL 512K NEXT 512K MINEXTENTS 8 MAXEXTENTS 4096); 

rem --ûռ 
CREATE TABLESPACE USERS DATAFILE '/data/ora816/oradata/web/users01.dbf' SIZE 128M REUSE 
AUTOEXTEND ON NEXT 1280K 
MINIMUM EXTENT 128K 
DEFAULT STORAGE ( INITIAL 128K NEXT 128K MINEXTENTS 1 MAXEXTENTS 4096 PCTINCREASE 0); 

rem --ʱռ 
CREATE TABLESPACE TEMP DATAFILE '/data/ora816/oradata/web/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; 

rem --߱ռ 
CREATE TABLESPACE TOOLS DATAFILE '/data/ora816/oradata/web/tools01.dbf' SIZE 64M REUSE 
AUTOEXTEND ON NEXT 320K 
MINIMUM EXTENT 32K 
DEFAULT STORAGE ( INITIAL 32K NEXT 32K MINEXTENTS 1 MAXEXTENTS 4096 PCTINCREASE 0); 

rem --ռ 
CREATE TABLESPACE INDX DATAFILE '/data/ora816/oradata/web/indx01.dbf' SIZE 32M REUSE 
AUTOEXTEND ON NEXT 1280K 
MINIMUM EXTENT 128K 
DEFAULT STORAGE ( INITIAL 128K NEXT 128K MINEXTENTS 1 MAXEXTENTS 4096 PCTINCREASE 0); 

rem --ع 
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 ); 

rem --ʹع 
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; 

rem --޸sysûʱռΪTEMP 
alter user sys temporary tablespace TEMP; 

rem --ֵ 
connect system/manager 
@$ORACLE_HOME/rdbms/admin/catdbsyn.sql 

connect internal 
@/data/ora816/rdbms/admin/catalog.sql; 
@/data/ora816/rdbms/admin/catexp7.sql 
@/data/ora816/rdbms/admin/catproc.sql 
@/data/ora816/rdbms/admin/caths.sql 

connect system/manager 
@/data/ora816/sqlplus/admin/pupbld.sql 

connect internal/oracle 
@/data/ora816/rdbms/admin/catrep.sql 

rem --޸systemûĬϱռʱռ 
alter user system default tablespace SYSTEM; 
alter user system temporary tablespace TEMP; 

spool off 
rem ű 


7ִнű 
ԽִнűˣתĿ¼$ORACLE_HOME/dbsȥҽcreate_db.sqlҲŵĿ¼У濪ʼˣ 

svrmgrlس 
SVRMGR>connect internal 
connected. 
SVRMGR>startupس 
SVRMGR>@create_db.sqlس(ok,ͿԿĻڲϵʱ̣ҪСʱʱҪһ) 
ִ֮Ҫ˳ȥ 
SVRMGR>exit 
ûдĻݿѾˡ 

8SQL*Plusϵͳ 
sqlplus SYSTEM/manager 
@/data/ora816/sqlplus/admin/help/helpbld.sql helpus.sql 

9˵ 

1)create database web 
datafile '$ORACLE_HOME/oradata/web/web_syst_01.dbf' size 500M reuse 
logfile 
'$ORACLE_HOME/oradata/web/web_redo_01.dbf' size 10M reuse, 
'$ORACLE_HOME/oradata/web/web_redo_02.dbf' size 10M reuse, 
'$ORACLE_HOME/oradata/web/web_redo_03.dbf' size 10M reuse 

ע⿴һɵļ֣web_syst_01.dbfweb_redo_01.dbfweb_redo_02.dbfweb_redo_03.dbfע⽫sidӦĲ֣ҵҵsidweb 

⻹ɱռʱļļ 
create tablespace rollback 
datafile '$ORACLE_HOME/dbs/web_roll_01.dbf' size 8M reuse; 

create tablespace temp 
datafile '$ORACLE_HOME/dbs/web_temp_01.dbf' size 5M reuse 
temporary; 

create tablespace users 
datafile '$ORACLE_HOME/dbs/web_user_01.dbf' size 10M reuse; 

ҲҪĳӦ 

2)connect system/manager 
@$ORACLE_HOME/rdbms/admin/catdbsyn.sql 
connect internal 
@$ORACLE_HOME/rdbms/admin/catproc.sql 
connect system/manager 
@$ORACLE_HOME/sqlplus/admin/pupbld.sql 

еconnect system/manager Ǽsystem˺ŵmanager(ϵͳĬϵ)ͨalter user system identified by ޸룬뻻ȷ¼ 

3)initweb.oraļݣ 
db_name = "web" 
instance_name = web 
service_names = web.edi.com 
db_files = 1024 
control_files = ("/data/ora816/oradata/web/control01.ctl", "/data/ora816/oradata/web/control02.ctl", "/d 
ata/ora816/oradata/web/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 = /data/ora816/admin/web/bdump 
user_dump_dest = /data/ora816/admin/web/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 

# log_archive_start = true 
# log_archive_dest_1 = "location=/data/ora816/oradata/oradb/archive" 
# log_archive_format = %%ORACLE_SID%%T%TS%S.ARC
Some additions: 

7. after connect as internal, you should run your creat_db.sql. (delete that part: startup). 

9- 3). In the initweb.ora, you should add rollback_segments = ( RBS0, RBS1, RBS2 ...) in order for them to be online next time the database is started. Otherwise, you have to bring them online again (you have 24 RBS!). 

db_block_size is a important parameter, you should includ it here. 

Normally, you don't need to change defaul tablespace for sys and system, they are SYSTEM by default if you create one. If you do want to change them, you should do so before you run those catXX.sql.
 
