{"id":416,"date":"2013-10-10T15:05:28","date_gmt":"2013-10-11T00:05:28","guid":{"rendered":"\/blog\/?p=416"},"modified":"2023-09-21T09:38:51","modified_gmt":"2023-09-21T00:38:51","slug":"oracle-database-%ec%83%9d%ec%84%b1","status":"publish","type":"post","link":"https:\/\/hasu0707.duckdns.org\/blog\/?p=416","title":{"rendered":"Oracle Database \uc0dd\uc131"},"content":{"rendered":"\n

\ucd9c\ucc98 : http:\/\/ntalbs.tistory.com\/100<\/a><\/span>

\uc0d8\ud50c \uc2a4\ud06c\ub9bd\ud2b8<\/p>

oracle_db_creation_script_sample.tar.gz<\/a><\/p>


\uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0dd\uc131\ud560 \ub54c \ubcf4\ud1b5\uc740 DBCA\ub97c \uc774\uc6a9\ud55c\ub2e4.<\/span>
\n\uadf8\ub7ec\ub098 DBCA\ub9cc \uc0ac\uc6a9\ud574 DB\ub97c \uc0dd\uc131\ud558\ub2e4\ubcf4\uba74, DBCA\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc5c6\ub294 \uc0c1\ud669\uc5d0\ub294 \ub2f9\ud669\ud558\uac8c \ub41c\ub2e4.<\/span><\/p>

\n<\/span>
\n\ub2e4\uc74c\uc740 DBCA\ub97c \uc774\uc6a9\ud560 \uc218 \uc5c6\ub294 \uacbd\uc6b0 \uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0dd\uc131\ud558\ub294 \uc808\ucc28\ub2e4.<\/span>
\n<\/span>
\n<\/span>
  1. SID, ORACLE_HOME \uc124\uc815<\/span>

    <\/span><\/a><\/span><\/div>
    export<\/span><\/code> <\/span>ORACLE_SID=testdbexport ORACLE_HOME=<\/span><\/code>\/path\/to\/oracle\/home<\/span><\/code><\/div><\/div><\/td><\/tr><\/tbody><\/table><\/div><\/div>
    \n<\/span><\/li>
  2. \ucd08\uae30\ud654 \ud30c\ub77c\ubbf8\ud130 \ud30c\uc77c \uc0dd\uc131 (minimal)<\/span>
    \n$ORACLE_HOME\/dbs\uc5d0 init<SID>.ora \ud30c\uc77c\uc744 \ub9cc\ub4e0\ub2e4.<\/span>

    <\/span><\/a><\/span><\/div>
    control_files = (<\/span><\/code>\/path\/to\/control1<\/span><\/code>.ctl,<\/span><\/code>\/path\/to\/control2<\/span><\/code>.ctl,<\/span><\/code>\/path\/to\/control3<\/span><\/code>.ctl)<\/span><\/code><\/div>
    undo_management = AUTO<\/span><\/code><\/div>
    undo_tablespace = UNDOTBS1<\/span><\/code><\/div>
    db_name = <\/span><\/code>test<\/span><\/code><\/div>
    db_block_size = 8192<\/span><\/code><\/div>
    sga_max_size = 1073741824 <\/span><\/code># 1GBsga_target = 1073741824 # 1GB<\/span><\/code><\/div><\/div><\/td><\/tr><\/tbody><\/table><\/div><\/div>
    \n<\/span><\/li>
  3. \ud328\uc2a4\uc6cc\ub4dc \ud30c\uc77c \uc0dd\uc131<\/span>

    <\/span><\/a><\/span><\/div>
    $ORACLE_HOME<\/span><\/code>\/bin\/orapwd<\/span><\/code> <\/span>file<\/span><\/code>=$ORACLE_HOME<\/span><\/code>\/dbs\/pwd<\/span><\/code>{sid}.ora password=oracle entries=5<\/span><\/code><\/div><\/div><\/td><\/tr><\/tbody><\/table><\/div><\/div>
    \n<\/span><\/li>
  4. \uc778\uc2a4\ud134\uc2a4 \uae30\ub3d9<\/span>

    <\/span><\/a><\/span><\/div>
    $ sqlplus <\/span><\/code>'\/as sysdba'<\/span><\/code><\/div><\/div><\/td><\/tr><\/tbody><\/table><\/div><\/div>

    <\/span><\/a><\/span><\/div>
    SQL> startup nomount<\/span><\/code><\/div><\/div><\/td><\/tr><\/tbody><\/table><\/div><\/div>
    \n<\/span><\/li>
  5. CREATE DATABASE \ubb38 \uc2e4\ud589<\/span>
    \n<\/span>

    <\/span><\/a><\/span><\/div>
    create<\/span><\/code> <\/span>database<\/span><\/code> <\/span>test<\/span><\/code><\/div>
    dblogfile <\/span><\/code>group<\/span><\/code> <\/span>1 (<\/span><\/code>'\/path\/to\/redo1.log'<\/span><\/code>) <\/span><\/code>size<\/span><\/code> <\/span>100M,<\/span><\/code><\/div>
    group<\/span><\/code> <\/span>2 (<\/span><\/code>'\/path\/to\/redo2.log'<\/span><\/code>) <\/span><\/code>size<\/span><\/code> <\/span>100M,<\/span><\/code><\/div>
    group<\/span><\/code> <\/span>3 (<\/span><\/code>'\/path\/to\/redo3.log'<\/span><\/code>) <\/span><\/code>size<\/span><\/code> <\/span>100M<\/span><\/code><\/div>
    character<\/span><\/code> <\/span>set<\/span><\/code> <\/span>ko16ksc5601<\/span><\/code><\/div>
    national<\/span><\/code> <\/span>character<\/span><\/code> <\/span>set<\/span><\/code> <\/span>al16utf16<\/span><\/code><\/div>
    datafile <\/span><\/code>'\/path\/to\/system.dbf'<\/span><\/code> <\/span>size<\/span><\/code> <\/span>500M autoextend <\/span><\/code>on<\/span><\/code> <\/span>next<\/span><\/code> <\/span>10M maxsize unlimited extent management <\/span><\/code>local<\/span><\/code><\/div>
    sysaux datafile <\/span><\/code>'\/path\/to\/sysaux.dbf'<\/span><\/code> <\/span>size<\/span><\/code> <\/span>100M autoextend <\/span><\/code>on<\/span><\/code> <\/span>next<\/span><\/code> <\/span>10M maxsize unlimited<\/span><\/code><\/div>
    undo tablespace undotbs1 datafile <\/span><\/code>'\/path\/to\/undotbs1.dbf'<\/span><\/code> <\/span>size<\/span><\/code> <\/span>100M<\/span><\/code><\/div>
    default<\/span><\/code> <\/span>temporary<\/span><\/code> <\/span>tablespace <\/span><\/code>temp<\/span><\/code> <\/span>tempfile <\/span><\/code>'\/path\/to\/temp01.dbf'<\/span><\/code> <\/span>size<\/span><\/code> <\/span>100M;<\/span><\/code><\/div><\/div><\/td><\/tr><\/tbody><\/table><\/div><\/div>
    <\/span>\nCREATE DATABASE \ubb38 Syntax\ub294 \ub2e4\uc74c\uacfc \uac19\ub2e4.<\/span>
    \n<\/span>CREATE DATABASE<\/span> [<\/span><\/span><\/span>database name<\/span><\/span><\/i>]<\/span><\/span>
    \n<\/span>[CONTROLFILE REUSE]<\/span><\/span>
    \n<\/span>[LOGFILE [GROUP <\/span><\/span>integer<\/span><\/span><\/i>] <\/span><\/span>file specification<\/span><\/span><\/i>]<\/span><\/span>
    \n<\/span>[MAXLOGFILES <\/span><\/span>integer<\/span><\/span><\/i>]<\/span><\/span>
    \n<\/span>[MAXLOGMEMBERS <\/span><\/span>integer<\/span><\/span><\/i>]<\/span><\/span>
    \n<\/span>[MAXLOGHISTORY <\/span><\/span>integer<\/span><\/span><\/i>]<\/span><\/span>
    \n<\/span>[MAXDATAFILES <\/span><\/span>integer<\/span><\/span><\/i>]<\/span><\/span>
    \n<\/span>[MAXINSTANCES <\/span><\/span>integer<\/span><\/span><\/i>]<\/span><\/span>
    \n<\/span>[ARCHIVELOG|NOARCHIVELOG]<\/span><\/span>
    \n<\/span>[CHARACTER SET <\/span><\/span>charset<\/span><\/span><\/i>]<\/span><\/span>
    \n<\/span>[NATIONAL CHARACTER SET <\/span><\/span>charset<\/span><\/span><\/i>]<\/span><\/span>
    \n<\/span>[DATAFILE filespec [autoextend]]<\/span><\/span>
    \n<\/span>[DEFAULT TEMPORARY TABLESPACE <\/span><\/span>tablespace filespec<\/span><\/span><\/i>]<\/span><\/span>
    \n<\/span>[UNDO TABLESPACE <\/span><\/span>tablespace <\/span><\/span><\/i>DATAFILE <\/span><\/span>filespec<\/span><\/span><\/i>]<\/span><\/span>
    \n<\/span>[SET TIME_ZONE [<\/span><\/span>time_zone_region<\/span><\/span><\/i>]];<\/span><\/span><\/div>\n<\/span>
    \n<\/span><\/li>
  6. Data Dictionary View \uc0dd\uc131 \uc2a4\ud06c\ub9bd\ud2b8 \uc2e4\ud589<\/span>

    <\/span><\/a><\/span><\/div>
    $ORACLE_HOME<\/span><\/code>\/rdbms\/admin\/CATALOG<\/span><\/code>.sql$ORACLE_HOME<\/span><\/code>\/rdbms\/admin\/CATPROC<\/span><\/code>.sql<\/span><\/code><\/div><\/div><\/td><\/tr><\/tbody><\/table><\/div><\/div><\/li>
  7. SPFILE \uc0dd\uc131<\/span>

    <\/span><\/a><\/span><\/div>
    SQL> <\/span><\/code>create<\/span><\/code> <\/span>spfile <\/span><\/code>from<\/span><\/code> <\/span>pfile;<\/span><\/code><\/div><\/div><\/td><\/tr><\/tbody><\/table><\/div><\/div>
    \n<\/span><\/li>
  8. \ucd94\uac00 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \uc0dd\uc131<\/span><\/li>
  9. sys, system \uacc4\uc815 \uc554\ud638 \ubcc0\uacbd<\/span><\/li><\/ol>\n<\/span><\/div>


    <\/p>\n\n\n

    oracle_db_creation_script_sample.tar.gz<\/a>\ub2e4\uc6b4\ub85c\ub4dc<\/a><\/div>\n\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[10],"tags":[],"class_list":["post-416","post","type-post","status-publish","format-standard","hentry","category-computing_database"],"_links":{"self":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/416","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=416"}],"version-history":[{"count":0,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/416\/revisions"}],"wp:attachment":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=416"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=416"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=416"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}