创建相关目录cd $ORACLE_BASEmkdir -p admin/SID_NAME/adumpmkdir -p oradata/SID_NAME
创建口令文件cd $ORACLE_HOME/dbsorapwd file=orapwSID_NAME password=oracle entries=30
复用及修改参数文件cat init.ora|grep -v ^$|grep -v ^#>initSID_NAME.oravi initSID_NAME.ora修改相应配置信息，最终效果如下：======================================================================db_name='SID_NAME'memory_target=2048mprocesses=1500audit_file_dest='$ORACLE_BASE/admin/SID_NAME/adump'audit_trail='db'db_block_size=8192db_domain=''db_recovery_file_dest='$ORACLE_BASE/fast_recovery_area'db_recovery_file_dest_size=5Gdiagnostic_dest='$ORACLE_BASE'dispatchers='(PROTOCOL=TCP)(SERVICE=ORCLXDB)'open_cursors=500remote_login_passwordfile='EXCLUSIVE'undo_tablespace='UNDOTBS1'control_files=($ORACLE_BASE/oradata/SID_NAME/control01.ctl,$ORACLE_BASE/oradata/SID_NAME/control02.ctl)compatible='11.2.0'======================================================================
创建建库脚本（格式敏感，清除多余空格）vi createmydb.sql CREATE DATABASE SID_NAME USER SYS IDENTIFIED BY oracle USER SYSTEM IDENTIFIED BY oracle LOGFILE GROUP 1 ('/oradata/SID_NAME/redo01.log') SIZE 100M, GROUP 2 ('/oradata/SID_NAME/redo02.log') SIZE 100M, GROUP 3 ('/oradata/SID_NAME/redo03.log') SIZE 100M MAXLOGFILES 50 MAXLOGMEMBERS 5 MAXLOGHISTORY 1 MAXDATAFILES 100 MAXINSTANCES 1 CHARACTER SET ZHS16GBK NATIONAL CHARACTER SET AL16UTF16 DATAFILE '/oradata/SID_NAME/system01.dbf' SIZE 2G autoextend on EXTENT MANAGEMENT LOCAL SYSAUX DATAFILE '/oradata/SID_NAME/sysaux01.dbf' SIZE 2G autoextend on DEFAULT TEMPORARY TABLESPACE tempts1 TEMPFILE '/oradata/SID_NAME/temp01.dbf' SIZE 2G autoextend on UNDO TABLESPACE undotbs1 DATAFILE '/oradata/SID_NAME/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
创建SPFILE，启动数据库，执行建库脚本export ORACLE_SID=SID_NAMEsqlplus / as sysdbacreate spfile from pfilestartup nomount@$pwd/createmydb.sql
执行必选预置脚本@?/rdbms/admin/catalog.sql@?/rdbms/admin/catproc.sql conn system/oracle@?/sqlplus/admin/pupbld.sql
建库完成
