Handmade all scripts and instructions

zhaozj2021-02-11  162

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

转载请注明原文地址:https://www.9cbs.com/read-5670.html

New Post(0)