Manually create an Oracle database

System Environment:
1. Operating System: Windows 2000 Pro
2. Database: Oracle9I Release 9.2.0.3.0
3. installation path: D: \ ORACLE

Steps for creating a database:
1. manually create related directories
D: \ Oracle \ admin \ ora92
D: \ Oracle \ admin \ ora92 \ adhoc
D: \ Oracle \ admin \ ora92 \ bdump
D: \ Oracle \ admin \ ora92 \ cdump
D: \ Oracle \ admin \ ora92 \ create
D: \ Oracle \ admin \ ora92 \ exp
D: \ Oracle \ admin \ ora92 \ pfile
D: \ Oracle \ admin \ ora92 \ udump

D: \ Oracle \ oradata \ ora92
D: \ Oracle \ oradata \ ora92 \ archive

------------------------------------
These steps are relatively simple and will soon be completed. I think it is helpful to manually create a database to understand the structure.

2. manually create the initialization startup parameter file: D: \ Oracle \ admin \ ora92 \ pfile \ initora92.ora. content:
--------------------------------------------------------------------------
###################################
# Copyright (c) 1991,200 1, 2002 by Oracle Corporation
###################################
# MTS
Dispatchers = "(PROTOCOL = TCP) (SERVICE = ora9iXDB )"
# Optimizer
Hash_join_enabled = TRUE
Query_rewrite_enabled = FALSE
Star_transformation_enabled = FALSE
# Job Queues
Job_queue_processes = 10
# Instance Identification
Instance_name = ora9i
# Miscellaneous
Aq_tm_processes = 1
Compatible = 9.2.0.0.0
# Security and Auditing
Remote_login_passwordfile = EXCLUSIVE
# Sort, Hash Joins, Bitmap Indexes
Pga_aggregate_target = 25165824
Sort_area_size = 524288
# Database Identification
Db_domain = ""
Db_name = ora92
# File Configuration
Control_files = ("D: \ oracle \ oradata \ ora92 \ control01.ctl ",
"D: \ oracle \ oradata \ ora92 \ control02.ctl ",
"D: \ oracle \ oradata \ ora92 \ control03.ctl ")
# Pools
Java _ pool_size = 33554432
Large_pool_size = 8388608
Shared_pool_size = 50331648
# Cursors and Library Cache
Open_cursors = 300
# System Managed Undo and Rollback Segments
Undo_management = AUTO
Undo_retention = 600
Undo_tablespace = UNDOTBS1
# Diagnostics and Statistics
Background_dump_dest = D: \ oracle \ admin \ ora92 \ bdump
Core_dump_dest = D: \ oracle \ admin \ ora92 \ cdump
Timed_statistics = TRUE
User_dump_dest = D: \ oracle \ admin \ ora92 \ udump
# Processes and Sessions
Processes = 150
# Redo Log and Recovery
Fast _start_mttr_target = 300
# Cache and I/O
DB _ block_size = 4096
DB _ cache_size = 25165824
Db_file_multiblock_read_count = 16
--------------------------------------------------------------------------

3. manually create the D: \ Oracle \ Ora92 \ DATABASE \ initora92.ora file,

Content: IFILE = 'd: \ Oracle \ admin \ ora92 \ pfile \ initora92.ora'

4. Use the orapwd.exe command to create D: \ Oracle \ Ora92 \ DATABASE \ PWDora92.ora

Command: D: \ Oracle \ Ora92 \ bin \ orapwd file = D: \ Oracle \ Ora92 \ DATABASE \ PWDora92.ora

Password = lovehoney entries = 5

5. Use the oradim.exe command to generate a new instance Management Service in the service.
Add HKEY_LOCAL_MACHINE \ SOFTWARE \ ORACLE \ HOME0 to the Registry to add the string value "ORACLE_SID" = "ora92 "(

Important, otherwise ORA-12560 error occurs)
You can also set ORACLE_SID = ora92
D: \ Oracle \ Ora92 \ bin \ oradim-new-sid ora92-startmode manual-pfile

"D: \ Oracle \ admin \ ora92 \ pfile \ initora92.ora"

6. generate various database objects
D: \> Oracle \ Ora92 \ bin \ sqlplus/nolog

Conn SYS/lovehoney as SYSDBA

-- Create a database
Startup nomount pfile = "D: \ Oracle \ admin \ ora92 \ pfile \ initora92.ora"

Create database ora92
LOGFILE 'd: \ Oracle \ oradata \ ora92 \ redo01.log' SIZE 2048 K,
'D: \ Oracle \ oradata \ ora92 \ redo02.log 'size 2048 K,
'D: \ Oracle \ oradata \ ora92 \ redo03.log 'size 2048 K
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXLOGHISTORY 1
DATAFILE 'd: \ Oracle \ oradata \ ora92 \ system01.dbf' SIZE 58 m reuse autoextend on next 640 K
MAXDATAFILES 254
MAXINSTANCES 1
Character set ZHS16GBK
National character set ZHS16GBK;

Control Files and log files are generated when the preceding statements are executed.

This article from the CSDN blog, reproduced please indicate the source: http://blog.csdn.net/zjwy82/archive/2005/06/13/393566.aspx