All scripts and instructions for manually creating databases in Oracle

System Environment:
1. Operating System: Windows 2000 Server, 128 MB of machine memory
2. Database: Oracle 8i R2 (8.1.6) for NT Enterprise Edition
3. installation path: D: \ ORACLE

Steps for creating a database:
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 the initialization startup parameter file: D: \ Oracle \ admin \ test \ pfile \ inittest. ora. content:

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

# Log_archive_start = true
# Log_archive_dest_1 = "location = D: \ Oracle \ oradata \ oradb \ archive"
# Log_archive_format = % ORACLE_SID % T % TS % S. ARC

1 2 3 Next Page

[Content navigation]
Page 1st: All scripts and instructions for manual database creation in Oracle	Page 2nd: All scripts and instructions for manual database creation in Oracle
Page 3rd: All scripts and instructions for manual database creation in Oracle