1.手动建库大致步骤

1. 设置环境变量.bash_profile
2. 创建目录结构
3. 创建参数文件(位置:$ORACLE_HOME/dbs)
4. 生成密码文件
5. 执行建库脚本
6. 创建数据字典
7. 其他设置

2.DBCA 脚本创建

2.1设置系统环境变量

ORACLE_HOME=/app/oracle/11g/11.2.4.2;export ORACLE_HOMEORACLE_BASE=/app/oracle/11g;export ORACLE_BASEORACLE_SID=dw; export ORACLE_SIDPATH=/usr/sbin:$PATH; export $PATHPATH=$ORACLE_HOME/bin:$PATH; export $PATHLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATHCLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

2.2创建相应的目录

cd $ORACLE_BASEcd adminmkdir $ORACLE_SIDcd $ORACLE_SIDmkdir adump bdump cdump dpdump pfile udumpps:确认相应的目录echo  $ORACLE_SIDecho  $ORACLE_BASEecho  $ORACLE_HOME

2.3修改pfile参数

具体情况而定修改相应的参数如：audit_file_dest，background_dump_dest，control_files，core_dump_dest，log_archive_dest_1，user_dump_dest等

2.4生成密码文件

cd $ORACLE_HOME/dbsorapwd file=orapw$ORACLE_SID password=&pwd entries=8

2.5 连接到数据库，启动到nomount状态

sqlplus / as sysdba  startup nomount

2.6执行建库脚本 

ASM 磁盘组Cat create_db.sqlCREATE DATABASE dw        USER SYS IDENTIFIED BY oracle        USER SYSTEM IDENTIFIED BY oracle        LOGFILE GROUP 1  '+DATA_DG' size 300m,                 GROUP 2  '+DATA_DG' size 300m,                GROUP 3  '+DATA_DG' size 300m      MAXLOGFILES 32      MAXLOGMEMBERS 3      MAXLOGHISTORY 1      MAXDATAFILES 300     CHARACTER SET AL32UTF8      NATIONAL CHARACTER SET AL16UTF16      EXTENT MANAGEMENT LOCAL 		DATAFILE '+DATA_DG' SIZE 800M REUSE      SYSAUX DATAFILE '+DATA_DG' SIZE 800M REUSE      DEFAULT TABLESPACE users         DATAFILE '+DATA_DG'         SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED      DEFAULT TEMPORARY TABLESPACE temp         TEMPFILE '+data_dg'         SIZE 5120M REUSE      UNDO TABLESPACE UNDOTBS1         DATAFILE '+DATA_DG'         SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;  文件系统CREATE DATABASE dw        USER SYS IDENTIFIED BY oracle        USER SYSTEM IDENTIFIED BY oracle        LOGFILE GROUP 1  ('/u01/app/oracle/oradata/dw/redo01a.log','/u01/app/oracle/oradata/dw/redo01b.log') SIZE 512M),       GROUP 2 ('/u01/app/oracle/oradata/dw/redo02a.log','/u01/app/oracle/oradata/dw/redo02b.log') SIZE 512M),      GROUP 3  ('/u01/app/oracle/oradata/dw/redo01a.log','/u01/app/oracle/oradata/dw/redo01b.log') SIZE 512M),       MAXLOGFILES 32      MAXLOGMEMBERS 3      MAXLOGHISTORY 1      MAXDATAFILES 300     CHARACTER SET AL32UTF8      NATIONAL CHARACTER SET AL16UTF16      EXTENT MANAGEMENT LOCAL 		DATAFILE '/u01/app/oracle/oradata/dw/system01.dbf' SIZE 800M REUSE      SYSAUX DATAFILE '/u01/app/oracle/oradata/dw/sysaux01.dbf' SIZE 800M REUSE      DEFAULT TABLESPACE users         DATAFILE '/u01/app/oracle/oradata/dw/user01.dbf         SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED      DEFAULT TEMPORARY TABLESPACE temp         TEMPFILE '/u01/app/oracle/oradata/dw/temp01.dbf'         SIZE 5120M REUSE      UNDO TABLESPACE UNDOTBS1         DATAFILE '+DATA_DG'         SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;Ps:   相应的路径与属性根据相应的需求进行修改

2.6执行创建数据字典脚本

@?/rdbms/admin/catalog.sql  @?/rdbms/admin/catproc.sql  @?/sqlplus/admin/pupbld.sql #需使用system用户执行

3.DBCA静默建库

vmhost:oracle > dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName dw -sid dw -sysPassword oracle -systemPassword oralce -storageType ASM -diskGroupName data_dg -nationalCharacterSet "AL16UTF16" -characterSet "AL32UTF8" -nodeinfo cnlf081000 -sampleSchema false -asmSysPassword oracle -variablesFile /app /oracle/11g/11.2.4.2/dbs/initdw.ora -recoveryAreaDestination +fra_dg   -databaseType  DATA_WAREHOUSINGCopying database files1% complete3% complete9% complete15% complete21% complete27% complete30% completeCreating and starting Oracle instance32% complete36% complete40% complete44% complete45% complete48% complete50% completeCreating cluster database views52% complete70% completeCompleting Database Creation73% complete76% complete85% complete94% complete100% completeLook at the log file "/app/oracle/11g/cfgtoollogs/dbca/dw/dw.log" for further details.vmhost:oracle>