Manually create an Oracle database in Windows

System Environment:
1. Operating System: Windows 2003 Server
2. Database: Oracle9i Release 9.0.1.1.1
3. installation path: D:/Oracle database creation steps: 1. manually create related directories
D:/Oracle/admin/orarman
D:/Oracle/admin/orarman/Arch
D:/Oracle/admin/orarman/bdump
D:/Oracle/admin/orarman/create
D:/Oracle/admin/orarman/pfile
D:/Oracle/admin/orarman/udump

D:/Oracle/oradata/orarman
D:/Oracle/oradata/orarman/archive if it is too troublesome, you can copy the % ORACLE_HOME %/ora90/admin/sample directory to % ORACLE_HOME %/admin for modification. 2. manually create the initialization startup parameter file: D:/Oracle/admin/orarman/pfile/init. ora. You can copy an existing parameter file and modify it as follows: db_name = orarmaninstance_name = orarman
Db_domain = ""
Service_names = orarmancontrol_files = ("D:/Oracle/oradata/orarman/control01.ctl", "d:/Oracle/oradata/orarman/control02.ctl ",
"D:/Oracle/oradata/orarman/control03.ctl ")
DB _ block_size = 4096
Background_dump_dest = D:/Oracle/admin/orarman/bdump
Core_dump_dest = D:/Oracle/admin/orarman/cdump
User_dump_dest = D:/Oracle/admin/orarman/udump 3. manually create the D:/Oracle/orarman/database/initorarman. ora file,
Content: ifile = 'd:/Oracle/admin/orarman/pfile/init. ora '4、use the orapwd.exe command to create D:/Oracle/ora90/database/pwdorarman. ora

Command: D:/Oracle/ora90/bin/orapwd file = D:/Oracle/ora90/database/pwdorarman. ora Password = admin entries = 5 5. Use the oradim.exe command to generate a new instance Management Service in the service. The startup mode is manual.
Add HKEY_LOCAL_MACHINE/software/Oracle/home0 to the Registry to add the string value oracle_sid = orarman (this is important, otherwise a ORA-12560 error occurs)
You can also set oracle_sid = oraorarman
D:/Oracle/ora90/bin/oradim-New-Sid orarman-startmode manual-pfile "D:/Oracle/admin/orarman/pfile/init. ora "6. generate various database objects
D:/> Oracle/ora90/bin/sqlplus/nologconn sys/change_on_install as sysdba -- create a database
Startup nomount pfile = "D:/Oracle/admin/orarman/pfile/init. ora"

-- Create spfile
Create spfile from pfilecreate database orarman
Logfile
Group 1 ('d:/Oracle/oradata/orarman/redo01a. log ',
'D:/Oracle/oradata/orarman/redo01b. log') size 5 m,
Group 2 ('d:/Oracle/oradata/orarman/redo02a. log ',
'D:/Oracle/oradata/orarman/redo02b. Log ') size 5 m,
Group 3 ('d:/Oracle/oradata/orarman/redo03a. log ',
'D:/Oracle/oradata/orarman/redo03b. log') size 5 m
Maxlogfiles 32
Maxlogmembers 2
Maxloghistory 1
Maxdatafiles 254
Maxinstances 1
Datafile 'd:/Oracle/oradata/orarman/system01.dbf' size 100 m reuse autoextend on next 10 m maxsize Unlimited
Undo tablespace undotbs datafile 'd:/Oracle/oradata/orarman/undotbs01.dbf' size 200 m reuse autoextend on next 10 m maxsize Unlimited
Default temporary tablespace temp
Tempfile 'd:/Oracle/oradata/orarman/temp01.dbf' size 40 m Reuse
Autoextend on next 1280 K maxsize Unlimited
Character Set zhs16gbk
National Character Set al16utf16; 7. create other tablespaces
(1) create a user tablespace
Create tablespace users
Datafile 'd:/Oracle/oradata/orarman/users01.dbf' size 25 m Reuse
Autoextend on next 1280 K maxsize unlimited (2) create a tool tablespace
Create tablespace tools
Datafile 'd:/Oracle/oradata/orarman/tools01.dbf' size 10 m Reuse
Autoextend on next 1280 K maxsize unlimited (3), create index tablespace
Create tablespace indx
Datafile 'd:/Oracle/oradata/orarman/indx01.dbf' size 25 m Reuse
Autoextend on next 1280 K maxsize unlimited8. The data dictionary file is: @ $ ORACLE_HOME/rdbms/admin/catalog. SQL @ $ ORACLE_HOME/rdbms/admin/catproc. SQL @ $ ORACLE_HOME/rdbms/admin/catexp. sql9. Set the instance startup service to automatic
D:/Oracle/ora90/bin/oradim-edit-Sid orarman-startmode auto