@H_502_0@创建密码文件
@H_502_0@cd $ORACLE_HOME/dbs
@H_502_0@orapwd file=orapwogg02 password=oracle entries=5
@H_502_0@
@H_502_0@mkdir -p $ORACLE_BASE/flash_recovery_area
@H_502_0@mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/adump
@H_502_0@mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/dpdump
@H_502_0@mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/pfile
@H_502_0@mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/scripts
@H_502_0@
@H_502_0@cd $ORACLE_HOME
@H_502_0@cd dbs
@H_502_0@
@H_502_0@cat init.ora|grep -v ^$|grep -v ^# > initicsdb.ora
@H_502_0@
@H_502_0@vim 编辑icsdb.sh 文件
@H_502_0@
@H_502_0@db_name='icsdb' #此处设置为SID
@H_502_0@memory_target=450M #SGA 大小
@H_502_0@processes = 150 #连接数
@H_502_0@audit_file_dest='/oracle/admin/icsdb/adump'
@H_502_0@audit_trail ='db'
@H_502_0@db_block_size=8192 #块大小
@H_502_0@db_domain=''
@H_502_0@db_recovery_file_dest='/oracle/flash_recovery_area' #指定快速恢复区路径
@H_502_0@db_recovery_file_dest_size=2G
@H_502_0@diagnostic_dest='/oracle' #oracle 软件安装目录
@H_502_0@dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
@H_502_0@open_cursors=300
@H_502_0@remote_login_passwordfile='EXCLUSIVE'
@H_502_0@undo_tablespace='UNDOTBS' #指定control 文件路径
@H_502_0@control_files = (/ora_data/icsdb/control01.ctl,/ora_data/icsdb/control02.ctl)
@H_502_0@compatible ='11.2.0'
@H_502_0@
@H_502_0@
@H_502_0@启动实例到nomount状态
@H_502_0@sqlplus / as sysdba
@H_502_0@sql> startup nomount pfile='$ORACLE_HOME/dbs/initicsdb.ora'
@H_502_0@sql> create spfile from pfile;
@H_502_0@
@H_502_0@
@H_502_0@运行如下脚本：
@H_502_0@CREATE DATABASE icsdb
@H_502_0@ USER SYS IDENTIFIED BY sys_password
@H_502_0@ USER SYSTEM IDENTIFIED BY system_password
@H_502_0@ LOGFILE GROUP 1 ('/ora_data/icsdb/redo01a.log','/ora_data/icsdb/redo01b.log') SIZE 100M BLOCKSIZE 512,
@H_502_0@ GROUP 2 ('/ora_data/icsdb/redo02a.log','/ora_data/icsdb/redo02b.log') SIZE 100M BLOCKSIZE 512,
@H_502_0@ GROUP 3 ('/ora_data/icsdb/redo03a.log','/ora_data/icsdb/redo03b.log') SIZE 100M BLOCKSIZE 512
@H_502_0@ MAXLOGFILES 5
@H_502_0@ MAXLOGMEMBERS 5
@H_502_0@ MAXLOGHISTORY 1
@H_502_0@ MAXDATAFILES 100
@H_502_0@ CHARACTER SET US7ASCII
@H_502_0@ NATIONAL CHARACTER SET AL16UTF16
@H_502_0@ EXTENT MANAGEMENT LOCAL
@H_502_0@ DATAFILE '/ora_data/icsdb/system01.dbf' SIZE 325M REUSE
@H_502_0@ SYSAUX DATAFILE '/ora_data/icsdb/sysaux01.dbf' SIZE 325M REUSE
@H_502_0@ DEFAULT TABLESPACE users
@H_502_0@ DATAFILE '/ora_data/icsdb/users01.dbf'
@H_502_0@ SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
@H_502_0@ DEFAULT TEMPORARY TABLESPACE tempts1
@H_502_0@ TEMPFILE '/ora_data/icsdb/temp01.dbf'
@H_502_0@ SIZE 50M REUSE
@H_502_0@ UNDO TABLESPACE undotbs
@H_502_0@ DATAFILE '/ora_data/icsdb/undotbs01.dbf'
@H_502_0@ SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
@H_502_0@
@H_502_0@
@H_502_0@#create oracle dictionary information
@H_502_0@@?/rdbms/admin/catalog.sql
@H_502_0@@?/rdbms/admin/catproc.sql
@H_502_0@conn / as system
@H_502_0@@?/sqlplus/admin/pupbld.sql
@H_502_0@The database was created successfully
