oracle install for silent, database creation

**********************************************************************
oracle silent install
**********************************************************************

**********************************************************************
setting
**********************************************************************
cd $ORACLE_HOME/dbs
cp init.ora initMYDB.ora
vi initMYDB.ora

< initMYDB.ora >
control_file = (path/oradata/MYDB//data1/control01.ctl,
                        path/oradata/MYDB//data1/control02.ctl)
db_name=MYDB
shared_pool_size=64M
undo_management=AUTO
undo_tablespace=UNDOTBS1
remote_login_passwordfile=exclusive
#db_cache_size=32M



cd $ORACLE_HOME/dbs
orapwd(orapw?) file=orapwMYDB password=oracle

**********************************************************************
database manual create
**********************************************************************
export ORACLE_SID=MYDB
export NLS_LANG="American_America.KO16KSC5601"
sqlplus / as sysdba


startup nomount

create database Ora10g
controlfile reuse
datafile '/safedb1/oracle/oradata/Ora10g/data5/system01.dbf' size 300m reuse
autoextend on next 10m maxsize 1024m extent management local
sysaux
datafile '/safedb1/oracle/oradata/Ora10g/data5/sysaux01.dbf' size 120m reuse
autoextend on next 10m maxsize 1024m
default temporary tablespace temp
tempfile '/safedb1/oracle/oradata/Ora10g/data5/temp01.dbf' size 50m reuse
undo tablespace undotbs1
datafile '/safedb1/oracle/oradata/Ora10g/data5/undotbs01.dbf' size 200m reuse
autoextend on next 10m maxsize 1024m
character set KO16KSC5601
national character set AL16UTF16
logfile
group 1 ('/safedb1/oracle/oradata/Ora10g/data3/redolog01.log') size 10m reuse,
group 2 ('/safedb1/oracle/oradata/Ora10g/data3/redolog02.log') size 10m reuse
user sys identified by initech
user system identified by initeh;


실패 시
shutdown abort
(data1, data2 등의 생성된 파일들 삭제 후)
startup nomount
다시 생성 시도


**********************************************************************
카탈로그 DB 생성 및 오라클 프로시저 생성
**********************************************************************
cd $ORACLE_HOME/rdbms/admin
sqlplus / as sysdba
@catalog.sql
@catproc.sql

**********************************************************************
기타 뷰 생성
**********************************************************************
@catblock.sql
quit
cd $ORACLE_HOME/sqlplus/admin
sqlplus / as sysdba
@pupbld.sql => listener.ora, tnsnames.ora 수정 후 listener 재기동. 그 후 system으로 접근 후 설치
!cd ./help
@hlpbld.sql helpus.sql

**********************************************************************
DB 정보 확인
**********************************************************************
select property_name, property_value from database_properties;