创建相关目录

cd $ORACLE_BASE

mkdir -p admin/SID_NAME/adump

mkdir -p oradata/SID_NAME

创建口令文件

cd $ORACLE_HOME/dbs

orapwd file=orapwSID_NAME password=oracle entries=30

复用及修改参数文件

cat init.ora|grep -v ^$|grep -v ^#>initSID_NAME.ora

vi initSID_NAME.ora修改相应配置信息，最终效果如下：

======================================================================

db_name='SID_NAME'

memory_target=2048m

processes=1500

audit_file_dest='$ORACLE_BASE/admin/SID_NAME/adump'

audit_trail='db'

db_block_size=8192

db_domain=''

db_recovery_file_dest='$ORACLE_BASE/fast_recovery_area'

db_recovery_file_dest_size=5G

diagnostic_dest='$ORACLE_BASE'

dispatchers='(PROTOCOL=TCP)(SERVICE=ORCLXDB)'

open_cursors=500

remote_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_NAME

sqlplus / as sysdba

create spfile from pfile

startup nomount

@$pwd/createmydb.sql

执行必选预置脚本

@?/rdbms/admin/catalog.sql

@?/rdbms/admin/catproc.sql

conn system/oracle

@?/sqlplus/admin/pupbld.sql

建库完成