oracle创建数据库可以采取dbca，也可采取手动脚本创建；版本：oracle10.2.1，手动脚本创建数据库的方法总结如下：
注意：相关目录必须先创建，将相关的目录改为自己的目录即可；
step 1: decide on your instance identifier (sid)
step 2: establish the database administrator authentication method
step 3: create the initialization parameter file and admin directory
db_block_size=8192
db_file_multiblock_read_count=16
open_cursors=300
db_domain=
db_name=orcl
background_dump_dest=/u01/app/oracle/admin/orcl/bdump
core_dump_dest=/u01/app/oracle/admin/orcl/cdump
user_dump_dest=/u01/app/oracle/admin/orcl/udump
control_files=(/u01/app/oracle/oradata/orcl/control01.ctl,
/u01/app/oracle/oradata/orcl/control02.ctl,
/u01/app/oracle/oradata/orcl/control03.ctl)
db_recovery_file_dest=/u01/app/oracle/flash_recovery_area
db_recovery_file_dest_size=2147483648
compatible=10.2.0.1.0
processes=150
sga_target=283115520
audit_file_dest=/u01/app/oracle/admin/orcl/adump
remote_login_passwordfile=exclusive
pga_aggregate_target=94371840
undo_management=auto
undo_tablespace=undotbs1
step 4: start the instance
startup nomount
step 5: issue the create database statement
create database orcl
maxinstances 8
maxloghistory 1
maxlogfiles 16
maxlogmembers 3
maxdatafiles 100
datafile '/u01/app/oracle/oradata/orcl/system01.dbf' size 300m
extent management local
sysaux datafile '/u01/app/oracle/oradata/orcl/sysaux01.dbf' size 120m
smallfile default temporary tablespace temp tempfile '/u01/app/oracle/oradata/orcl/temp01.dbf' size 20m
smallfile undo tablespace undotbs1 datafile '/u01/app/oracle/oradata/orcl/undotbs01.dbf' size 200m
character set we8iso8859p1
national character set al16utf16
logfile group 1 ('/u01/app/oracle/oradata/orcl/redo01.log') size 51200k,
group 2 ('/u01/app/oracle/oradata/orcl/redo02.log') size 51200k,
group 3 ('/u01/app/oracle/oradata/orcl/redo03.log') size 51200k
user sys identified by oracle user system identified by oracle;
step 6: run scripts to build data dictionary views
connect sys/password as sysdba
@$oracle_home/rdbms/admin/catalog.sql
@$oracle_home/rdbms/admin/catproc.sql
，