Handmade all scripts and instructions
System environment:
1, operating system: Windows 2000 Server, machine memory 128M
2, Database: Oracle 8i R2 (8.1.6) for NT Enterprise Edition
3, installation path: d: / oracle
Building a library step:
1, manually create related directories
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, manually create initialization start-up parameter file: d: /oacle/admin/test/pfile/inittest.ora, content:
3, manually create D: /oracle/ora81/Database/inittest.ora file,
Content: ifile = 'd: /oracle/admin/test/pfile/inittest.ora'
4, use an ORAPWD.EXE command, create D: /oracle/ora81/Database/pwdtest.ora
Command: D: / ORACLE / ORA81 / BIN / ORAPWD File = D: /oracle/ora81/database/pwdtest.ora password = Oracle Entries = 5
5, through the ORADIM.EXE command, generate a new instance management service in the service, start mode is manual
SET ORACLE_SID = TEST
D: / Oracle / ORA81 / BIN / ORADIM -NEW -SID TEST -STARTMODE MANUAL-PFILE "D: /Oracle/admin/test/pfile/inittest.ora"
6, generate various database objects
D: /> SVRMGRL
- Create a database
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: /oacle/oradata/test/redo03.log' size 2048k
MaxLogfiles 32
MaxLogmembers 2
MaxLoghistory 1
DataFile 'D: /oracle/oradata/test/system01.dbf' size 58m Reuse Autoextend On Next 640K
MaxDatafiles 254
MaxInstances 1
Character set zhs16gbk
National Character Set ZHS16GBK;
Control file, log file is generated when executed above
Connect Internal / Oracle
- Modify system table space
ALTER TABLESPACE SYSTEM Default Storage (Initial 64k Next 64K MineXtens 1 maxExtents unlimited Pctincrease 50); Alter TableSpace System Minimum Extent 64K;
- Create a back scroll space
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 Mineltents 8 MaxExtents 4096);
- Create user table space
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 a temporary table space
Create TableSpace Temp DataFile 'D: /oracle/roadata/test/temp01.dbf' size 32m Reuse
AutoExtend on Next 640K
Minimum extent 64k
Default Storage (Initial 64k Next 64k Minelts 1 maxExtents unlimited pctincrease 0) Temporary;
- Create tool table space
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 Mineltnts 1 maxextents 4096 pctincrease 0);
- Create index table space
Create TableSpace Indx DataFile 'D: /oracle/roadata/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 a rollback segment
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);
- Make the rollback group online
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;
- Modify the temporary table space of SYS users to TEMP
Alter User Sys Temporary TableSpace Temp;
- Create a data dictionary table
@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/sqlplus/admin/pupbld.sql
Connect Internal / Oracle
@D: /oracle/ora81/rdbms/admin/catrep.sql
exit
- Generate SQL * PLUS Help System
SQLPlus System / Manager
@D: /oracle/ora81/sqlplus/admin/help/helpbld.sql helpus.sql
Exit
- Modify System User Default Table Space and Temporary Table Space
SVRMGRL
Connect Internal / Oracle
Alter User System Default TableSpace Tools;
Alter User System Temporary TableSpace Temp;
Exit
7, set the Test instance launch service to automatic start-up mode
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