오라클 DB

db 생성 (툴사용)

http://genes1s.egloos.com/v/2827068

 

오라클 DBCA(Database Configuration Assistant)로 데이터베이스 생성 방법

http://m.blog.naver.com/reinstate10/220166999026

 

db 생성 (수동)

http://mypledge.tistory.com/7

http://blog.daum.net/feelsogreat/45

 

윈도우에서 오라클db 생성 (good)

http://fdsblog.tistory.com/entry/ORADIM-%EC%82%AC%EC%9A%A9%EB%B0%A9%EB%B2%95Windows%EC%97%90%EC%84%9C-DATABASE-%EC%83%9D%EC%84%B1-%EB%B0%A9%EB%B2%95

 

3. DB생성
예시.

CREATE DATABASE db1

DATAFILE '/home/oracle/db1/system01.dbf' size 500M reuse autoextend on

sysaux DATAFILE '/home/oracle/db1/sysaux01.dbf' size 300M reuse autoextend on

UNDO TABLESPACE undo1

'/home/oracle/db1/undo1.dbf' size 200M reuse autoextend on maxsize 2G

DEFAULT TEMPORARY TABLESPACE temp

'/home/oracle/db1/temp01.dbf' size 100M reuse autoextend on maxsize 2G

CHARACTER SET KO16MSWIN949

NATIONAL CHARACTER SET AL16UTF16;
 

(옵션

logfile
group 1('/home/oracle/db1/fra/redo01.log') size 50M reuse,
group 2('/home/oracle/db1/fra/redo02.log') size 50M reuse, 
group 3('/home/oracle/db1/fra/redo03.log') size 50M reuse
)
을 추가하셔도 됩니다. 여기서는 db_recovery_file_dest를 파라미터에 지정했기때문에 굳이 안써도 알아서 만들어줍니다.

** 주의사항
첫번째 DATAFILE은 system datafile이므로 system이라고 이름을 적어주면 안됩니다.
(적으면 에러발생) 

 

$ vi listener.ora

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = PLSExtProc)

      (ORACLE_HOME = /home/oracle/product/10g)

      (PROGRAM = extproc)

    )

  )

 

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = server15)(PORT = 1521))

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

    )

  )

 

 

$ vi tnsnames.ora

DB1 =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.15)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = db1)

    )

  )