DB 수동설치

- $ORACLE_HOME/dbs/inittestdb.ora

control_files = ('$ORACLE_BASE/oradata/testdb/control01.ctl',
                 '$ORACLE_BASE/oradata/testdb/control02.ctl')
db_name = testdb
db_block_size = 8192
pga_aggregate_target=96468992
processes = 150
open_cursors=300
undo_management = AUTO
undo_tablespace = UNDOTBS01
compatible = 10.2.0
sga_target = 289406976
background_dump_dest=$ORACLE_HOME/admin/testdb/bdump
core_dump_dest=$ORACLE_HOME/admin/testdb/cdump
user_dump_dest=$ORACLE_HOME/admin/testdb/udump

mkdir $ORACLE_BASE/oradata
mkdir $ORACLE_BASE/oradata/testdb
mkdir $ORACLE_HOME/admin
mkdir $ORACLE_HOME/admin/bdump
mkdir $ORACLE_HOME/admin/cdump
mkdir $ORACLE_HOME/admin/udump

- testdb.sql

CREATE DATABASE testdb
USER SYS IDENTIFIED BY oracle
USER SYSTEM IDENTIFIED BY oracle
LOGFILE GROUP 1 ('$ORACLE_BASE/oradata/testdb/redo01.log') SIZE 100M REUSE,
        GROUP 2 ('$ORACLE_BASE/oradata/testdb/redo02.log') SIZE 100M REUSE,
        GROUP 3 ('$ORACLE_BASE/oradata/testdb/redo03.log') SIZE 100M REUSE
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET KO16KSC5601
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '$ORACLE_BASE/oradata/testdb/system01.dbf' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '$ORACLE_BASE/oradata/testdb/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE tbs_1 DATAFILE '$ORACLE_BASE/oradata/testdb/tbs01.dbf' SIZE 50M REUSE
DEFAULT TEMPORARY TABLESPACE temp
TEMPFILE '$ORACLE_BASE/oradata/testdb/temp01.dbf' SIZE 20M REUSE
UNDO TABLESPACE UNDOTBS01
DATAFILE '$ORACLE_BASE/oradata/testdb/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;