2012. 7. 9. 18:07

1. 새로운 init file을 만들고 수정한다.

   $ cp init.ora $ORACLE_HOME/dbs/initSID.ora

2. Instance를 startup 한다.

   $ svrmgrl
   SVRMGR> STARTUP NOMOUT PFILE=initSID.ora

   ORACLE instance started.

3. DATABASE를 생성한다.

   CREATE DATABASE SID
     MAXLOGFILES 5
     MAXLOGMEMBERS 5
     MAXDATAFIlES 100
     MAXLOGHISTORY 100
   LOGFILE
     GROUP 1 ('/DISK3/log1a.rdo','/DISK4/log1b.rdo') SIZE 1 M,
     GROUP 2('/DISK3/log2a.rdo','/DISK4/log2b.rdo') SIZE 1 M
   DATAFILE
     '/DISK1/system01.dbf' size 50M autoextend on
   CHARACTER SET US7ASCII ;

* database를 create 하는 file ---> sql.bsq

Posted by 몰라욧