오라클 DATABASE 수동생성

sqlplus '/as sysdba'
startup nomount

create database <databasename>

controlfile reuse

datafile '/db2_ora_data01/system01.dbf' SIZE 550M AUTOEXTEND ON NEXT 10M MAXSIZE 1024M EXTENT MANAGEMENT LOCAL 

sysaux

datafile '/db2_ora_data01/sysaux01.dbf' SIZE 500M AUTOEXTEND ON NEXT 10M MAXSIZE 1024M 

default temporary tablespace temp

tempfile '/db2_ora_data02/temp01.dbf' SIZE 5000M AUTOEXTEND ON NEXT 100M MAXSIZE 20480M

EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M

undo tablespace UNDOTBS1

datafile '/db2_ora_data01/undotbs01.dbf' SIZE 5000M AUTOEXTEND ON NEXT 100M MAXSIZE 20480M

character set US7ASCII

national character set AL16UTF16

logfile

GROUP 1('/db2_orasystem/redoA_01.log','/db2_ora_data01/redoB_01.log') SIZE 50M,

GROUP 2('/db2_orasystem/redoA_02.log','/db2_ora_data01/redoB_02.log') SIZE 50M,

GROUP 3('/db2_orasystem/redoA_03.log','/db2_ora_data01/redoB_03.log') SIZE 50M,

GROUP 4('/db2_orasystem/redoA_04.log','/db2_ora_data01/redoB_04.log') SIZE 50M,

GROUP 5('/db2_orasystem/redoA_05.log','/db2_ora_data01/redoB_05.log') SIZE 50M,

GROUP 6('/db2_orasystem/redoA_06.log','/db2_ora_data01/redoB_06.log') SIZE 50M,

GROUP 7('/db2_orasystem/redoA_07.log','/db2_ora_data01/redoB_07.log') SIZE 50M,

GROUP 8('/db2_orasystem/redoA_08.log','/db2_ora_data01/redoB_08.log') SIZE 50M

sqlplus '/as sysdba'
/rdbms/admin/catalog.sql 
/rdbms/admin/catproc.sql

/sqlplus/admin/pupbld.sql
/sqlplus/admin/help/hlpbld.sql
/sqlplus/admin/help/helpus.sql