一直想手动创建一下数据库，以便了解oracle建库的过程，今天终于尝试了一把，下面是经过：

建库语句如下：

CREATE DATABASE MANUALDB
LOGFILE GROUP 1 ('D:oracleproduct10.2.0oradatamanualdbredo01.log') SIZE 100M,
GROUP 2 ('D:oracleproduct10.2.0oradatamanualdbredo02.log') SIZE 100M,
GROUP 3 ('D:oracleproduct10.2.0oradatamanualdbredo03.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
DATAFILE 'D:oracleproduct10.2.0oradatamanualdbsystem01.dbf' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE 'D:oracleproduct10.2.0oradatamanualdbsysaux01.dbf' SIZE 325M REUSE
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE 'D:oracleproduct10.2.0oradatamanualdbtemp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE UNDOTBS1
DATAFILE 'D:oracleproduct10.2.0oradatamanualdbundotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

参数文件：

aq_tm_processes=0
audit_file_dest=D:ORACLEPRODUCT10.2.0ADMINMANUALDBADUMP
background_dump_dest=D:ORACLEPRODUCT10.2.0ADMINMANUALDBBDUMP
compatible=10.2.0.1.0
control_files=D:ORACLEPRODUCT10.2.0ORADATAMANUALDBCONTROL01.CTL, D:ORACLEPRODUCT10.2.0ORADATAMANUALDBCONTROL02.CTL, D:ORACLEPRODUCT10.2.0ORADATAMANUALDBCONTROL03.CTL
core_dump_dest=D:ORACLEPRODUCT10.2.0ADMINMANUALDBCDUMP
db_block_size=8192
db_file_multiblock_read_count=16
db_name=MANUALDB
dispatchers="(PROTOCOL=TCP) (SERVICE=MANUALDBXDB)"
global_names=TRUE
job_queue_processes=10
nls_length_semantics=BYTE
open_cursors=300
pga_aggregate_target=95420416
processes=150
remote_login_passwordfile=EXCLUSIVE
resource_manager_plan=""
sga_target=289406976
streams_pool_size=50331648
undo_management=AUTO
undo_retention=900
undo_tablespace=UNDOTBS1
user_dump_dest=D:ORACLEPRODUCT10.2.0ADMINMANUALDBUDUMP
service_names=MANUALDB
session_max_open_files=20
instance_name=MANUALDB

差不多有这两个就可以开始建了，当然相应的目录得事先建好。

db创建好后，得执行这两个脚本。

CONNECT SYS/password AS SYSDBA
@/u01/oracle/rdbms/admin/catalog.sql
@/u01/oracle/rdbms/admin/catproc.sql
EXIT

这样就可以了。

具体可以参考oracle联机文档

Oracle® Database Administrator's Guide
10g Release 2 (10.2)Part Number B14231-02

[@more@]