在hp-ux 11i上测试通过
oracle版本为817
建好inittest.ora和PWDtest.ora
目录：
/oracle/DATA/
执行下面的脚本
set termout on
set echo on
spool test.log
connect internal
startup pfile=/oracle/product/8.1.7/dbs/inittest.ora nomount
create database
test
logfile
group 1 (
'/oracle/DATA/redotest01a.log',
'/oracle/DATA/redotest01b.log' ) size 10M reuse,
group 2 (
'/oracle/DATA/redotest02a.log',
'/oracle/DATA/redotest02b.log' ) size 10M reuse,
group 3 (
'/oracle/DATA/redotest03a.log',
'/oracle/DATA/redotest03b.log' ) size 10M reuse
maxdatafiles 250
maxinstances 2
maxlogfiles 16
character set ZHS16GBK
national character set ZHS16GBK
datafile
'/oracle/DATA/systest.dbf' size 300M reuse
/
spool off
disconnect
connect internal
spool test_catalog.log
@/oracle/product/8.1.7/rdbms/admin/catalog.sql
spool off
connect internal
spool test.log
create rollback segment r0 tablespace system
storage (
initial
32k
next
32k
minextents
2
maxextents
100
)
/
alter rollback segment r0 online
/
create tablespace rbs
datafile
'/oracle/DATA/rbstest01.dbf' size 150M reuse,
'/oracle/DATA/rbstest02.dbf' size 150M reuse
default storage (
initial
1M
next
1M
pctincrease
0
minextents
9
maxextents
300
)
/
create tablespace temp
datafile
'/oracle/DATA/tmptest.dbf' size 500M reuse
default storage (
initial
128k
next
128k
pctincrease
0 )
temporary
/
create rollback segment r01 tablespace rbs
storage ( optimal 20M )
/
create rollback segment r02 tablespace rbs
storage ( optimal 20M )
/
create rollback segment r03 tablespace rbs
storage ( optimal 20M )
/
create rollback segment r04 tablespace rbs
storage ( optimal 20M )
/
create ??????rollback segment r05 tablespace rbs
storage ( optimal 20M )
/
create rollback segment r06 tablespace rbs
storage ( optimal 20M )
/
create rollback segment r07 tablespace rbs
storage ( optimal 20M )
/
create rollback segment r08 tablespace rbs
storage ( optimal 20M )
/
alter rollback segment r01 online
/
alter rollback segment r02 online
/
alter rollback segment r03 online
/
alter rollback segment r04 online
/
alter rollback segment r05 online
/
alter rollback segment r06 online
/
alter rollback segment r07 online
/
alter rollback segment r08 online
/
alter rollback segment r0
offline
/
alter user system temporary tablespace temp
/
spool off
connect internal
spool test_catproc.log
@/oracle/product/8.1.7/rdbms/admin/catproc.sql
spool off
spool test_catexp.log
@/oracle/product/8.1.7/rdbms/admin/catexp.sql
spool off
