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 3. Installation Path: D: / Oracle
Baseline step: 1, manually created the related catalog D: / Oracle / Admin / Testd: / Oracle / Admin / Test / Adhocd: / Oracle / Admin / Test / Bdumpd: / Oracle / Admin / Test / CDumpd: / Oracle / Admin / Admin / Admin / TEST / CREATED: / ORACLE / Admin / Test / Expd: / Oracle / Admin / Test / Pfiled: / Oracle / Admin / Test / UDUMP
D: / Oracle / ORADATA / TESTD: / 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 the way to 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
- Creating a database Connect Internal / ORACLESTARTUP NOMOUNT PFILE = "D: /oracle/admin/test/pfile/inittest.ora" Create Database Testlogfile 'D: /oracle/oradata/test/redo01.log' size 2048k, 'd: /Oracle/oradata/test/redo02.log 'SIZE 2048K,' D: /Oracle/oradata/test/redo03.log 'SIZE 2048KMAXLOGFILES 32MAXLOGMEMBERS 2MAXLOGHISTORY 1DATAFILE' D: /Oracle/oradata/test/system01.dbf 'SIZE 58M REUSE Autoextend On Next 640kmaxdatafiles 254maxinstances 1Character Set ZHS16GBKNATIONAL Character Set ZHS16GBK;
Control file, log file is generated when executed above
connect INTERNAL / oracle-- modifying system table space ALTER TABLESPACE SYSTEM DEFAULT STORAGE (INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 50); ALTER TABLESPACE SYSTEM MINIMUM EXTENT 64K; - Create rollback table 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 temporary table space 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;
- creation tool tablespace 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);
- creating an index table space 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 rollback segments 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 (Optim AL 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); - the rollback segment 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 RO Llback 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 Tempalter User Sys Temporary TableSpace Temp;
- Create a data dictionary table @d: /oracle/ora81/rdbms/admin/catalog.sql; @d:/oacle/ora81/rdbms/admin/catexp7.sql@d: / oracle / ora81 / rdbms / admin / catproc . SQL @ D: /oracle/ora81/rdbms/admin/caths.sql
Connect System / Manager @ d: /oacle/ora81/sqlplus/admin/pumbld.sql
CONNECT INTERNAL / ORACLE @ D: /oracle/ora81/rdbms/admin/catrep.sqlexit - Generate SQL * Plus Help System SQLPlus System / Manager @ d: /oracle/ora81/sqlplus/admin/Help/helpbld.sql Helpus. SQLEXIT
- Modify System User Default Table Space and Temporary Table Space SVRMGRLCONNECT INTERNAL / ORACLALTER 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 e-mail: oceanaut@163.com
