Linux Oracle ¼³Ä¡¿Í È°¿ë(¥°)

À̼öÁØ (dislevel@newhuman.org)

 

     

¼­  ·Ð

    ÀÎÅÍ³Ý ¼­¹ö·Î¼­ÀÇ ¸¹Àº °¡´É¼ºÀ» º¸¿©ÁÖ°í ÀÖ´Â Linux´Â »ç½Ç»ó ¹Ì¹¦ÇÑ ¹®Á¦°¡ ÀÖ¾ú´Ù. Apache´Â À¥¼­¹ö·Î¼­ÀÇ ´õÇÒ ³ªÀ§ ¾ø´Â Á¤»óÀÇ °íÁö¿¡ ÀÖ¾ú°í, Samba´Â ¸¹Àº ÀÛ¾÷µéÀ» MS WINDOWS·ÎºÎÅÍ Çعæ½ÃÄÑ ÁÖ¾úÀ¸¸ç X WINDOW´Â MSÀÇ ±×°Í°ú ¸øÁö ¾ÊÀº ¸¹Àº À©µµ¿ì ¸Å´ÏÀúµé·Î Ä¡ÀåµÇ¾ú´Ù. ¹®Á¦´Â Á»´õ ½Å·Ú¼º ÀÖ´Â ¼­ºñ½ºµéÀ̾ú°í ±×°ÍÀº ´ëü·Î D/B ½Ã½ºÅÛ°úÀÇ ¹ÐÁ¢ÇÑ °ü°è¸¦ °¡Áø´Ù. ¹°·Ð Linux¿¡¼­µµ ¾ÆÁÖ ÈǸ¢ÇÑ(±×°Íµµ °ø°³ÀÇ) D/B µéÀÌ Á¸ÀçÇϴµ¥ MiniSQLÀ̳ª PostgresqlµîÀÌ ±×°ÍÀÌ°í MySQL°°Àº Á¶±Ý Ưº°ÇÑ(¹Ý °ø°³/¹Ý »ó¿ë) °Íµéµµ ÀÖ´Ù. ÇÏÁö¸¸, À̰͵éÀÌ ¾Æ¹«¸® ÈǸ¢ÇÏ´Ù°í Çصµ »ç¿ëÀÚÀÇ ÀÔÀå¿¡¼­´Â ´©±¸Çϳª Ã¥ÀÓÁ®ÁÖÁöµµ, ±â¼úÁö¿ø ÇØÁÖÁöµµ ¾Ê´Â ÀÌ·¯ÇÑ D/B ½Ã½ºÅ۵鿡 ÀÚ½ÅÀÇ ±ÍÁßÇÑ, ȤÀº »ó¾÷ÀûÀÎ ¸ñÀûÀÇ ÀڷḦ ´ã¾ÆµÎ°í ¸¾ ÆíÇØ ÇÏ´Â ÀÌ´Â º°·Î ¾øÀ» °ÍÀÌ´Ù. ±×·¯³ª Áö±ÝÀº ¿©·¯ ¿ì¿© °îÀý ³¡¿¡ Linux´Â Oracle À» À§½ÃÇÑ ´ëÇü D/B½Ã½ºÅÛ ¾÷üµé·ÎºÎÅÍ Áö¿øÀ» ¹Þ°Ô µÇ¾ú´Ù. ´ëÇü »ó¿ë D/B½Ã½ºÅÛ ¾÷üµéÀÇ Áö¿ø°ú ¿£ÅÍÇÁ¶óÀÌÁî±Þ ¼º´ÉÀ» °®Ãá Ä¿³Î 2.2ÀÇ ¹ßÇ¥·Î ÀÎÅÍ³Ý ¼­¹ö ½ÃÀåÀ» ³Ñ¾î ÀÌÁ¦´Â ±¹³»¿¡¼­µµ ¿£ÅÍÇÁ¶óÀÌÁî Ç÷§ÆûÀ¸·Î Linux °¡ °­·ÂÇÏ°Ô µîÀåÇÏ°í ÀÖ´Ù.

 

¸ñ  Àû

    ÀÌ ±ÛÀÇ ¸ñÀûÀº °£´ÜÇÏ´Ù. ¿©·¯ D/Bº¥´õµéÀÇ Á¦Ç°Áß¿¡¼­ À¯µ¶ Çѱ¹¿¡¼­ ÃÊ°­¼¼¸¦ º¸ÀÌ°í ÀÖ´Â Oracle (server for Linux 8.0.5)¸¦ Linux»ó¿¡¼­ ¼³Ä¡ÇÏ´Â ¹æ¹ý°ú ¿î¿ë ¹æ¹ý, ±×¸®°í °£´ÜÇÑ pro-c »ç¿ë¹ý, ±×¸®°í ÇÑÂü ÁÖ°¡¸¦ ¿Ã¸®°í ÀÖ´Â php3¿ÍÀÇ ¿¬µ¿À» ¾à 3ȸºÐ¿¡ °ÉÃÄ »ìÆ캻´Ù. Test¿¡ »ç¿ëµÈ Oracle server´Â Á¤Ç°ÀÌ ¾Æ´Ï°í Oracle Home Page¿¡ °¡¸é ½±°Ô ±¸ÇÒ ¼ö ÀÖ´Â °³¹ßÀÚ ¹öÀüÀÓÀ» ¾Ë·ÁµÐ´Ù.

    ¡Ý ½Ã½ºÅÛ ¿ä±¸»çÇ×

    ¸Þ¸ð¸® : È°¿ëÀÇ ¸ñÀûÀÌ ¾Æ´Ò °æ¿ì 32¸Þ°¡µµ °¡´É

    ½º¿Ò¿µ¿ª : ÀϹÝÀûÀ¸·Î RAMÀÇ 3¹è Å©±âÀÇ ½º¿Ò¿µ¿ªÀÌ ±ÇÀå. 1GBÀÌ»óÀÇ RAMÀ» °¡Áø
                   ½Ã½ºÅÛ¿¡¼­´Â 2¹è Å©±âÀÇ ½º¿Ò¿µ¿ªÀÌ ±ÇÀåµÈ´Ù.

    µð½ºÅ© : ÃÖ¼ÒÇÑ 4°³(At least four devices) : Oracle ¼ÒÇÁÆ®¿þ¾î ¼³Ä¡¸¦ À§ÇØ Çϳª, ³ª¸ÓÁö
                ¼¼°³´Â OFAȣȯ µ¥ÀÌÅͺ£À̽º¸¦ »ý¼ºÇϱâ À§ÇØ »ç¿ëµÈ´Ù.
                - È°¿ëÀÇ ¸ñÀûÀÌ ¾Æ´Ò °æ¿ì ÇÑ °³ÀÇ µð½ºÅ©¶óµµ »ó°ü¾ø´Ù.
                - È°¿ëÀÇ ¸ñÀûÀ̶ó¸é ÃÖ¼Ò 2°³ÀÇ ¹°¸®Àû µð½ºÅ© Ãßõ (¸®´ª½º, ¿À¶óŬ )
                - ´Ù¿î·Îµå ¹ÞÀº ÆÄÀÏ°ú ¾ÐÃàÀ» Ç®°í ¼³Ä¡ÇÒ ¿ë·®À¸·Î ÃÖ¼Ò 1±â°¡ ÀÌ»óÀÌ ÇÊ¿äÇÏ´Ù.

    Operating System : Linux 2.0.34
    - ¿À¶óŬÀÇ ¸®´ª½º ÆÀÀº ½ÇÁ¦ 2.0.33 ÀÌ»óÀ̶ó°í ÇÑ´Ù.
    - ÇÊÀÚ´Â Âü°í·Î ±¹³»¿¡¼­ À¯¸íÇÑ ¾ËÂ¥ ¸®´ª½º 5.2¸¦ »ç¿ëÇÏ¿´À¸¸ç Ä¿³ÎÀº 2.0.36À»
       »ç¿ëÇÏ¿´´Ù.

    System Libraries : GNU C Library, version 2.0.7
    - ¹®¼­»ó¿¡¼­´Â 2.0.7ÀÌ»óÀ» ¿ä±¸ÇÏ°í ÀÖÀ¸³ª ¿À¶óŬÀÇ ¸®´ª½º °³¹ß ÆÀÀ¸·ÎºÎÅÍÀÇ ¼³¸íÀ¸·Î´Â
       ½ÇÁ¦ 2.0.6ÀÌ»óÀÌ¸é µÈ´Ù°í ÇÑ´Ù.
       GLIBC 2.1.x ¿ëÀ¸·Î´Â ÆÐÄ¡ ÆÄÀÏÀÌ µû·Î ³ª¿Í ÀÖ´Ù. ¾ÆÁ÷ Å×½ºÆ®´Â Çغ¸Áö ¸øÇß´Ù.

    Window Manager : ¾î¶² X À©µµ¿ì ½Ã½ºÅÛµµ °¡´É
    -¼Ö¶ó¸®½º¿¡¼­´Â X-window »ó¿¡¼­ °ü¸®ÇÒ ¼ö ÀÖ´Â svrmgrm ÀÌ ÀÖÁö¸¸ Linux¿¡¼­´Â ÇöÀç
      Ä¿¸Çµå ¶óÀÎ ¸ðµå¿¡¼­¸¸ ÀÛµ¿ÇÏ´Âsvrmgrl ¸¸ÀÌ Á¸ÀçÇÑ´Ù.

 

°¡. root ·Î ÇÏ¿©¾ß ÇÒÀÏ

    1. ´Ù¿î·Îµå http://technet.oracle.com¿¡¼­ ¿À¶óŬ ¸®´ª½º¸¦ ´Ù¿î ¹Þ´Â´Ù.

    2. /usr/src ¿¡ ´Ù¿î·Îµå ¹ÞÀº 805ship.tgz ÆÄÀÏÀ» ¿Å±ä ÈÄ /usr/src/ora¿¡¼­ ¾ÐÃàÀ» Ǭ´Ù.
       /usr/src/ora »ó¿¡ ´ÙÀ½°ú °°Àº ÆÄÀÏ°ú µð·ºÅ丮°¡ »ý¼ºµÇ¾úÀ» °ÍÀÌ´Ù.

        # ls
        DST.LST          network/           plsql/
        nlsrtl/              precomp/          RELDESC.TXT
        ocommon/       rdbms/             bin/
        oemagent/       slax/                oracore/
        sqlplus/           jdbc/                orainst/
        svrmgr/           lib/                   ord/
        unix.prd          otrace/              unixdoc/

    3. Create Mount Points
        ÀÌÁ¦ ¿À¶óŬÀ» ¼³Ä¡ÇÒ À§Ä¡¸¦ Á¤ÇÏ´Â ´Ü°èÀÌ´Ù. ¿©±â¼­´Â /home/oracle¿¡ ¿À¶óŬÀ» ¼³Ä¡
        ÇÏ´Â °ÍÀ¸·Î °¡Á¤ÇÏ°Ú´Ù. ÀÌ À§Ä¡¿¡ ¿À¶óŬÀ» ¼³Ä¡ÇÒ ÇÏµå µð½ºÅ© ÆÄƼ¼ÇÀ» ¸¶¿îÆ® ½ÃÄѾß
        ÇÑ´Ù.
    - ´ëºÎºÐÀÇ »ç¿ëÀÚ°¡ ÇϳªÀÇ ÆÄƼ¼Ç¿¡ ¸®´ª½º¸¦ ¼³Ä¡ÇÒ °ÍÀÌ´Ù. ±×·¸Áö¸¸ ¸¸ÀÏ µÎ°³ ÀÌ»óÀÇ
       Çϵåµð½ºÅ© ÆÄƼ¼ÇÀ» ÀÌ¿ëÇÒ °ÍÀ̶ó¸é /etc/fstabÀÇ ³»¿ëÀ» ÀûÇÕÇÏ°Ô °íÃÄ¾ß ÇÑ´Ù.
       °¢ ÆÄƼ¼ÇÀÇ ³»¿ëÀ» ´ÙÀ½¿¡ ¼³¸íÇϵµ·Ï ÇÏ°Ú´Ù.

    4. DBA group »ý¼º
       /etc/group ÆÄÀÏ¿¡ dba¶ó´Â ±×·ìÀ» »ý¼ºÇÑ´Ù.

       # groupadd dba
       È¤Àº Á÷Á¢ vi edit·Î /etc/groupÀ» ÆíÁýÇÒ ¼öµµ ÀÖ´Ù.

    5. ¸®´ª½º Ä¿³Î ¼³Á¤
        ¿À¶óŬ8 ¼­¹öÀÇ SGA ±¸Á¶¸¦ ¼ö¿ëÇϱâ À§ÇØ ¸®´ª½º Ä¿³ÎÀÇ Interprocess Communication
        (IPC) ÆĶó¸ÞÅ͵éÀ» ¼³Á¤ÇØ¾ß ÇÑ´Ù. ½Ã½ºÅÛÀÌ SGA¸¦ ¼ö¿ëÇϱ⿡ ÃæºÐÇÑ shared ¸Þ¸ð¸®¸¦
        °¡ÁöÁö ¾Ê¾Ò´Ù¸é µ¥ÀÌÅͺ£À̽º¸¦ ½ÇÇàÇÒ ¼ö ¾øÀ» °ÍÀÌ´Ù.

    ´ÙÀ½¿¡ »óÀÀÇÏ´Â Ä¿³Î ÆĶó¸ÞÅ͸¦ ¼³Á¤ÇÑ´Ù.

    maximum size of a shared memory segment(SHMMAX)
    maximum number of shared memory segments in the system(SHMMNI)
    maximum number of shared memory segments a user process can attatch(SHMSEG)
    maximum amount of shared memory that can be allocated system-wide(SHMMNS)
    SHMMAX*SHMSEG¿¡ ÀÇÇØ Çã¿ëµÇ´Â Àüü shred ¸Þ¸ð¸® Å©±â°¡ °áÁ¤µÈ´Ù.

    ¤¡) SHMMAX = 4294967295 : ´ÜÀÏ °øÀ¯ ¸Þ¸ð¸® ¼¼±×¸ÕÆ®ÀÇ ÃÖ´ëÅ©±â(¹ÙÀÌÆ®´ÜÀ§)
    ¤¤) SHMMIN = 1 : ´ÜÀÏ °øÀ¯¸Þ¸ð¸® ¼¼±×¸ÕÆ®ÀÇ ÃÖ¼ÒÅ©±â(¹ÙÀÌÆ®)
    ¤§) SHMIMNI = 100 : °øÀ¯¸Þ¸ð¸® Áö½ÃÀÚ(identifiers)ÀÇ °¹¼ö
    ¤©) SHMSEG = 10 : °¢ ÇÁ·Î¼¼½º¿¡ ºÎ¿©µÉ ¼ö ÀÖ´Â °øÀ¯¸Þ¸ð¸® ¼¼±×¸ÕµåÀÇ ÃÖ´ë °¹¼ö
    ¤±) SEMMNS = 200 : ½Ã½ºÅÛ ³»ÀÇ ¼¼¸¶Æ÷¾î °¹¼ö
    ¤²) SEMMNI = 70 : ¼¼¸¶Æ÷¾î Áö½ÃÀÚ(identifiers)ÀÇ °¹¼ö. SEMMNIÀº  µ¿½Ã¿¡ »ý¼ºµÉ ¼ö ÀÖ´Â
                               ¼¼¸¶Æ÷¾î °¹¼ö¸¦ °áÁ¤ÇÑ´Ù.
    ¤µ) SEMMSL = PROCESSES ÃʱâÈ­ ÆĶó¸ÞÅÍÀÇ °ª°ú °°°Å³ª Å©µµ·Ï, ÇϳªÀÇ ¼¼¸¶Æ÷¾î ¾È¿¡
                                            Á¸ÀçÇÒ ¼ö ÀÖ´Â ¼¼¸¶Æ÷¾îµéÀÇ ÃÖ´ë °¹¼ö.
                                            ¿À¶óŬ ÇÁ·Î¼¼½ºµéÀÇ ÃÖ´ë °¹¼ö¿Í °°¾Æ¾ß ÇÑ´Ù.

    ¼Ö¶ó¸®½ºÀÇ °æ¿ì¿¡´Â ´ÙÀ½ÀÇ °ªµéÀ» /etc/system ÆÄÀÏ¿¡¼­ ¼³Á¤ÇØ ÁÖ¾î¾ß ÇÏÁö¸¸, ¼³Á¤À» ÇÏÁö ¾Ê¾Æ ¹®Á¦°¡ ¹ß»ýÇÑÀûÀº ¾ø¾ú´Ù. ±âº» Ä¿³Î »óÅ·Π³õ°í ÀνºÅçÇÏ¿©µµ ¹«¹æÇÏ´Ù. (·¹µåÇòÀÇ µðÆúÆ® Ä¿³ÎÀÌµç ´Ù½Ã ÄÄÆÄÀÏÇÑ Ä¿³ÎÀ̵ç)

    6. ¿À¶óŬ °ü¸®ÀÚ °èÁ¤ »ý¼º
        adduser ȤÀº useradd ·Î dba±×·ì¿¡ ¼ÓÇÏ´Â À¯Àú oracleÀ» »ý¼ºÇÑ´Ù.

      ¤¡) adduser ¸í·ÉÀ¸·Î oracle user¸¦ »ý¼ºÇÑ´Ù.
           # adduser oracle
      ¤¤) vi /etc/passwd ¸í·ÉÀ» »ç¿ëÇÏ¿© oracle user ÀÇ ¼³Á¤ °ªÀ» À§¿¡¼­
          ¼³¸íÇÑ °Í´ë·Î ¹Ù²Û´Ù. - dba gid¿Í °°¾Æ¾ß ÇÑ´Ù.

    7. oratab ÆÄÀÏ »ý¼º
       ¿À¶óŬ ÀνºÅϽº¿¡ ´ëÇÑ Á¤º¸´Â oracle ¼ÒÀ¯ÀÇ oratab ÆÄÀÏ¿¡ ÀúÀåµÈ´Ù.
       ÇÏÁö¸¸ ÀÌ ½ºÅ©¸³Æ®¸¦ root·Î ½ÇÇàÇؼ­ /etc µð·ºÅ丮¿¡ oratab ÆÄÀÏÀÌ »ý¼ºµÇµµ·Ï ÇÑ´Ù.

       ½ÇÁ¦ ÀνºÅç°úÁ¤¿¡¼­ oratab.shÀ» ½ÇÇàÇϸé ORACLE_OWNERȯ°æº¯¼ö°¡ ¼³Á¤µÇ¾î ÀÖ´ÂÁö
       ¹¯°í ÀÖ´Ù. µû¶ó¼­ ORACLE_OWNERÀ» ´ÙÀ½°ú °°ÀÌ ¼³Á¤ÇÑ´Ù.

      #export ORACLE_OWNER=oracle

 

³ª. oracle user ·Î ÇÒ ÀÏ

    1. ~/.bash_profileÀÇ ¼öÁ¤
       ( shÀ» »ç¿ëÇÒ °æ¿ì .profileÀ» ¼öÁ¤ÇÑ´Ù. redhat ¸®´ª½º¸¦ ±âÁØÀ¸·Î ¼³¸íÇÑ´Ù.)
       oracle·Î Á¢¼ÓÇÏ¿© ´ÙÀ½°ú °°ÀÌ .profileÀ» ¸¸µç´Ù. RedHat¿¡¼­´Â .bash profile ÀÌ´Ù.

      export
      ORACLE_HOME=/home/oracle/app/oracle/product/8.0.5
      export
      LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/jdbc/lib
      export ORACLE_SID=linux
      export ORACLE_TERM=386
      export
      ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
      export PATH=$PATH:$ORACLE_HOME/bin
      export TMPDIR=/tmp
      export
      CLASSPATH=$ORACLE_HOME/jdbc/lib/classes111.zip
      umask 022
      (À§¿¡¼­ export ´ÙÀ½ÀÇ ÁÙÀ» export µÚ¿¡ ³ª¿Í¾ß ÇÑ´Ù.)

    À§ÀÇ °æ¿ì´Â ¡°root ÀÛ¾÷ 4¡±ÀÇ ¡°Create Mount Points¡±¿¡¼­ À̾߱âÇÑ ¿À¶óŬÀ» ¼³Ä¡ÇÒ °æ·Î·Î /home/oracleÀÎ °æ¿ìÀÌ´Ù.

°¢ ¼³Á¤¿¡ ´ëÇÑ ¼³¸í

    ORACLE_HOME :
    ¿À¶óŬÀ» /home/oracle¿¡ ¼³Ä¡Çϱâ·Î ÇÏ¿´À¸¹Ç·Î /home/oracle/app/oracle/product/8.0.5·Î ÁöÁ¤µÈ´Ù.

    LD_LIBRARY_PATH :
    ¿À¶óŬÀÇ µ¿Àû/Á¤Àû  ¶óÀ̺귯¸®ÀÇ °æ·Î¸¦ ³ªÅ¸³»´Â ȯ°æº¯¼ö·Î Pro*C³ª PHPµîÀ» »ç¿ëÇÒ ¶§ Áß¿äÇÏ°Ô Àû¿ëµÈ´Ù.

    ORACLE_SID :
    ¿À¶óŬ ÀνºÅϽºÀÇ À̸§ÀÌ´Ù. ¿µ¹®ÀÚ·Î 3-4±ÛÀÚ·Î Á¤ÇØÁØ´Ù. ÇÊÀÚ´Â ÀνºÅÏÆ®ÀÇ À̸§À» linux ¶ó°í Áö¾ú´Ù.

    ±× ¿ÜÀÇ È¯°æº¯¼ö´Â ¿¹Á¦¿¡ ³ª¿Í ÀÖ´Â µ¥·Î ÇÏ¸é µÈ´Ù.

    Áö¿ª¾ð¾î¼³Á¤ ȯ°æº¯¼ö NLS_LANGÀº ¸ðµç ÀνºÅçÀÌ ³¡³ª°í ¼³¸íÇϵµ·Ï ÇÏ°Ú´Ù.

ȯ°æº¯¼ö °»½Å

    À§¿Í °°ÀÌ .profile³»¿ëÀ» º¯°æÇÏ¿´´Ù¸é

      # . .bash_profile ȤÀº
      # source .bash_profile ÇÏ¿© ȯ°æº¯¼ö ³»¿ëÀ» ¾÷µ¥ÀÌÆ®ÇÑ´Ù. ¶Ç´Â oracle°èÁ¤À¸·Î ´Ù½Ã ·Î±×ÀÎÇÑ´Ù.

 

´Ù. ½ÇÁ¦ÀûÀÎ Oracle ÀÇ ¼³Ä¡

    1. ÀνºÅç·¯ ½ÇÇà

      ¤¡) oracle·Î ·Î±×ÀÎ ÇÑ´Ù. - Àý´ë root·Î ÀνºÅç·Î¸¦ ½ÇÇàÇÏ¸é ¾ÈµÈ´Ù.
      ¤¤) oracle ¼³Ä¡ µð·ºÅ丮·Î À̵¿
           # cd /usr/src/ora/orainst
      ¤§) orainst¸¦ ½ÇÇàÇÑ´Ù.
           # ./orainst ¸¦ ½ÇÇàÇÑ´Ù.

    È­¸é¿¡¼­ [TAB]Å°, È­»ìǥŰ, ½ºÆäÀ̽º ¹Ù¸¦ ÀÌ¿ëÇÏ¿© Ç׸ñÀ» ¼±ÅÃÇÒ ¼ö ÀÖ´Ù.

    2. °ËÀº ¹è°æÀÇ ¼³Ä¡È­¸éÀÌ ³ª¿À¸é Custom InstallÀ» ¼±ÅÃÇÑ´Ù.

    3. óÀ½ ¼³Ä¡ÇÏ´Â °ÍÀ̹ǷÎ, (o) Install, Upgrade, or De-Install SoftwareÀ» ¼±ÅÃÇÑ´Ù.

    4. »õ·Ó°Ô ÀνºÅç ÇÒ °ÍÀ̹ǷΠ Install New Product - Create DB ObjectsÀ» ¼±ÅÃÇÑ´Ù.

    5. Mount Point¸¦ ¼³Á¤ÇÑ´Ù. root user·Î ÇÒ ÀÏ 5. ¹ø¿¡¼­ ¼³Á¤ÇÑ °Íó·³ mount point¸¦
        /home/oracle·Î ¼³Á¤ÇÑ´Ù.

    6. .bash_profile¿¡¼­ ¼³Á¤ÇÑ °Íó·³ $ORACLE_HOME µð·ºÅ丮¸¦ ¼³Á¤ÇÑ´Ù.

    7. ORACLE_BASE ¿Í ORACLE_HOMEÀ» ¼³Á¤ÇÑ´Ù.

    8. log ÆÄÀÏÀÌ ³²À» À§Ä¡¸¦ ¼³Á¤ÇÑ´Ù.

    9. Install from CD-ROMÀ» ¼±ÅÃÇÏ¿©¾ß ÇÑ´Ù.

    10. ORACLE_SID¸¦ .bash_profile¿¡¼­ ¼³Á¤ÇÑ °Í°ú °°ÀÌ linux·Î ¼±ÅÃÇÑ´Ù.

    11. NLS ÀÇ ¼³Á¤ - ¿©±â¿¡¼­´Â ÀÏ´Ü ALL language¸¦ ¼±ÅÃÇÑ´Ù.

    12. install ÀÌ ³¡ÀÌ ³­ ÈÄ root.shÀ» ½ÇÇàÇ϶ó´Â ¸Þ½ÃÁö°¡ Ãâ·ÂµÈ´Ù. ¹Ýµå½Ã install ÈÄ¿¡´Â
         root.shÀ» ½ÇÇàÇÏ¿©¾ß ÇÑ´Ù.

    13. Software Asset Manager¿¡¼­ ¼³Ä¡ÇÑ ºÎºÐÀ» ¼±ÅÃÇÑ´Ù.¿©±â¿¡¼­´Â ¸ðµç ºÎºÐÀ» ¼³Ä¡
         ÇÑ´Ù°í °¡Á¤À» ÇÑ´Ù.

    14. 13)¿¡¼­Ã³·³ InstallÀ» ¼±ÅÃÇÑ ÈÄ ¸î °¡Áö »çÇ׿¡ ´ëÇÏ¿© OK¸¦ ÇÑ ÈÄ OSOPER group (dba)
          ¸¦ ¼³Á¤ÇÑ´Ù.

    15. »ý¼ºÇÒ DB Object¸¦ ¼±ÅÃÇÑ´Ù. - Filesystem-Based DatabaseÀ» ¼±ÅÃÇÑ´Ù.

    16. Database Mount Points¸¦ Á¤ÇÑ´Ù. ¼³Ä¡µµÁß¿¡ 3°³ÀÇ mount points¸¦ ±âÀÔÇ϶ó°í Çϴµ¥
         ¹°¸®ÀûÀ¸·Î ºÐ¸®µÈ Çϵ尡 3°³ Á¸ÀçÇÏ¸é °¡Àå ÁÁÁö¸¸ ½ÇÁ¦ PC¿¡¼­´Â Èûµç ÀÏÀÌ´Ù.
         ÀÌ·¸°Ô 3°÷À¸·Î µ¥ÀÌÅ͸¦ ºÐ¸®ÇÏ´Â ÀÌÀ¯´Â µ¥ÀÌÅͺ£À̽º°¡ ÇÏµå µð½ºÅ©·ÎÀÇ Àбâ/¾²±â¸¦
         ÇÏ´Â °úÁ¤¿¡¼­ °æÇÕÀ» ÁÙÀÌ°í ¿¡·¯ ¹× ¹®Á¦ÀÇ ¹ß»ý½Ã ÀÚ¿¬½º·± º¹±¸¸¦ À§ÇÑ °ÍÀÌ´Ù.
         ÇÏÁö¸¸ ¿À¶óŬ ÇÁ·Î±×·¥°ú µ¿ÀÏÇÑ Çϵåµð½º¿¡ ¹Û¿¡ ÀνºÅç ÇÒ °ø°£ÀÌ ¾ø´Ù¸é ¿©±â¿¡ ¸ðµÎ
         µ¿ÀÏÇÑ °æ·Î¸¦ Àû¾îÁÖ¸é µÈ´Ù.

         ÇÊÀÚµµ ¿À¶óŬÀ» ¼³Ä¡ÇÒ ¶§  /home/oracle¿¡ ¿À¶óŬ ÇÁ·Î±×·¥À» ¼³Ä¡ÇÏ°í µ¥ÀÌÅÍ ÆÄÀÏÀ»
         À§ÇÑ 3°³ÀÇ ¸¶¿îÆ® Æ÷ÀÎÆ®µµ /home/oracle·Î ¼³Á¤ÇÏ¿´´Ù.

    17. Character Set ¼³Á¤ - ÇѱÛÀ» ¾²±â À§Çؼ­KO16KSC5601·Î ¼³Á¤ÇÑ´Ù.

    18. National Character Set ¼³Á¤

    19. System password ÀÇ ¼³Á¤ (º¸Åë manager¶ó°í password¸¦ ÀÔ·ÂÇÑ´Ù. )

    20. sys password ÀÇ ¼³Á¤ ( manager·Î password¸¦ ¼³Á¤. )

    21. dba password ÀÇ ¼³Á¤ ( no¶ó°í ¼³Á¤ÇÑ´Ù. )

    22. TNS Listener Password ÀÇ ¼³Á¤

    23. Configure MTS and start SQL*Net listener ¼³Á¤Àº no·Î ÇÑ´Ù.

    24. Control files ÀÇ À§Ä¡ È®ÀÎ.

    25. ±âº»ÀûÀÎ µ¥ÀÌÅͺ£À̽º °ü·Ã ÆÄÀÏÀÇ À§Ä¡¿Í ¿ë·®ÀÇ È®ÀÎ

    26.  JDBC ¼ÂÀÇ ¼±Åà (default·Î ¼±ÅÃÀ»ÇÑ´Ù.)

    27. CTX Temporary TablespaceÀ» ¼±ÅÃÇÑ´Ù.

    28. CTX demo tableÀ» ¼³Ä¡ÇÒ °ÍÀ» ¼±ÅÃÇÑ ÈÄ¿¡, Oracle Document¸¦ ¼³Ä¡ÇÒ °Í¿¡ ´ëÇÏ¿©
         ¼ÂÆÃÇÑ´Ù. µð·ºÅ丮¸¦ ¼³Á¤ÇÑ ÈÄ pdf, html, both ¾î¶² Çü½ÄÀ¸·Î ¼³Ä¡ÇÒ °ÍÀÎÁö ¹¯´Âµ¥
         ±×¶§¿¡´Â ÀÚ½ÅÀÌ ¿øÇÏ´Â Ç׸ñ Áß¿¡¼­ ÇÑ°¡Áö¸¦ ¼±ÅÃÇÏ¸é µÈ´Ù.

    29. ÀÌÁ¦ ÀνºÅçÀÌ ½ÃÀ۵DZ⠽ÃÀÛÇÏ°í ±×·¡ÇÁ°¡ ¿Ã¶ó°¡±â ½ÃÀÛÇÑ´Ù. ÇÏ¿°¾øÀÌ ±â´Ù¸®ÀÚ -_-;

    30. ¼³Ä¡¿Ï·á È­¸é.

    31. ¼³Ä¡ °ËÁõ
         ¼³Ä¡°¡ ¸ðµÎ ³¡³µ´Ù¸é $ORACLE_HOME/orainst µð·ºÅ丮¿¡ »ý¼ºµÈ root.shÀ» root °èÁ¤
         À¸·Î ½ÇÇà ½ÃŲ´Ù.

       ¤¡) root·Î ·Î±×ÀÎÇÑ´Ù.
       ¤¤) cd $ORACLE_HOME/orainst
       ¤§) ./root.sh

      # ./root.sh
      - /etc/oratab ¾Æ·¡¿¡ ´ÙÀ½°ú °°Àº ³»¿ëÀÌ Ãß°¡µÇ¾ú´Ù.

      *:/home/oracle//app/oracle/product/8.0.5:N
      linux:/home/oracle/app/oracle/product/8.0.5:N

 

¶ó. Oracle Database ÀÇ ±¸µ¿

    1. oracle user·Î login.

    2. svrmgrlÀ» ½ÇÇà½ÃŲ ÈÄ database¸¦ °¡µ¿ÇÑ´Ù.

      $ svrmgrl   - svrmgrl ÀÇ ½ÇÇà

      SVRMGR> connect internal - internal Á¢¼Ó
      Connected.
      Oracle Server Manager Release 3.0.5.0.0 - Production

      (c) Copyright 1997, Oracle Corporation. All Rights  
           Reserved.

      Oracle8 Release 8.0.5.0.0 - Production
      PL/SQL Release 8.0.5.1.0 - Production

      SVRMGR> connect internal - internal Á¢¼Ó
      Connected.

      SVRMGR> startup;
      ORACLE instance started.
      Total System Global Area    4754704 bytes
      Fixed Size                         48400 bytes
      Variable Size                     4222976 bytes
      Database Buffers               409600 bytes
      Redo Buffers                     73728 bytes
      Database mounted.
      Database opened.

      SVRMGR> exit - svrmgrl ÀÇ Á¾·á
      Server Manager complete.

    3. lsnrctl ¸í·ÉÀ» ÀÌ¿ëÇÏ¿© Oracle listenerÀ» °¡µ¿½ÃŲ´Ù.
        - lsnrctl start : Oracle listener ÀÇ °¡µ¿
        - lsnrctl stop  : Oracle listener ÀÇ ¸ØÃã
       $ lsnrctl start

    LSNRCTL for Linux: Version 8.0.5.0.0 - Production on 26-APR-99 21:56:51
    (c) Copyright 1997 Oracle Corporation.  All rights reserved.

    Starting /home/oracle/app/oracle/product/8.0.5/bin/tnslsnr: please wait...

    TNSLSNR for Linux: Version 8.0.5.0.0 - Production
    System paramete rfile is
    /home/oracle/app/oracle/product/8.0.5/network/admin/
    listener.ora
    Log messages written to
    /home/oracle/app/oracle/product/8.0.5/network/log/
    listener.log
    Listening on:
    (ADDRESS=(PROTOCOL=ipc)(DEV=6)(KEY=linux))
    Listening on:
    (ADDRESS=(PROTOCOL=ipc)(DEV=10)(KEY=PNPKEY))
    Listening on:
    (ADDRESS=(PROTOCOL=tcp)(DEV=11)(HOST=192.168.1.1)(PORT=1521))

    Connecting to
    (ADDRESS=(PROTOCOL=IPC)(KEY=linux))
    STATUS of the LISTENER
    ------------------------
    Alias                       LISTENER
    Version                   TNSLSNR for Linux: Version 8.0.5.0.0 - Production
    Start Date                26-APR-99 21:56:56
    Uptime                    0 days 0 hr. 0 min. 1 sec
    Trace Level              off
    Security                   OFF
    SNMP                      OFF
    Listener Parameter File   
    /home/oracle/app/oracle/product/8.0.5/network/admin/
    listener.ora
    Listener Log File         
    /home/oracle/app/oracle/product/8.0.5/network/log/
    listener.log
    Services Summary...
    extproc               has 1 service handler(s)
    linux         has 1 service handler(s)
    The command completed successfully

    - ¿À¶óŬ ¸®½º³Ê°¡ Á¦´ë·Î ½ÇÇàÀÌ µÇÁö ¾ÊÀ» °æ¿ì listener.ora, tnsnames.oraÀ» ¾Ë¸Â°Ô
       ÆíÁýÇÑ´Ù.
     (/home/oracle/app/oracle/product/8.0.5/network/admin À§Ä¡ÇÏ¿© ÀÖ´Ù.)

    ´ÙÀ½Àº tcp/ip ÇÁ·ÎÅäÄÝÀ» ±âÁØÀ¸·Î ÇÏ¿©¼­ listener.ora¸¦ ¾Ë¸Â°Ô ÆíÁýÇÑ °ÍÀÌ´Ù.

    #
    # Installation Generated Net8 Configuration
    # Version Date: Jun-17-97
    # Filename: Listener.ora
    #
    LISTENER =
    (ADDRESS_LIST =
    (ADDRESS= (PROTOCOL= IPC)(KEY= linux))
    (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY))
    (ADDRESS= (PROTOCOL= TCP)(Host= 192.168.1.1)
    (Port= 1521))
    - database °¡ ¼³Ä¡µÇ¾î ÀÖ´Â ip¸¦ Àû¾îÁØ´Ù.
    )
    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME= 192.168.1.1.)
    - database °¡ ¼³Ä¡µÇ¾î ÀÖ´Â ip¸¦ Àû¾îÁØ´Ù.
    (ORACLE_HOME=
    /home/oracle/app/oracle/product/8.0.5)
    (SID_NAME = linux)
    - linux sid , ¼³Ä¡µµÁß Àû¾îÁØ sid¸¦ Àû¾îÁØ´Ù.
    )
    (SID_DESC =
    (SID_NAME = extproc)
    (ORACLE_HOME =
    /home/oracle/app/oracle/product/8.0.5)


    (PROGRAM = extproc)
    )
    )
    STARTUP_WAIT_TIME_LISTENER = 0
    CONNECT_TIMEOUT_LISTENER = 10
    TRACE_LEVEL_LISTENER = OFF

    #
    # Installation Generated Net8 Configuration
    # Version Date: Oct-27-97
    # Filename: Tnsnames.ora
    #  
    extproc_connection_data =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = linux))
    (CONNECT_DATA = (SID = extproc))
    )
    linux =
    - oracle alias
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL= TCP)(Host= 192.168.1.1)
    (Port= 1521))
    - database °¡ ¼³Ä¡µÇ¾îÀÖ´Â database ÀÇ ip
      (CONNECT_DATA = (SID = linux))
    - oracle sid
    )

    linux_BEQ =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = BEQ)(PROGRAM =
    /home/oracle/app/oracle/product/8.0.5)
    (argv0 = oraclelinux)
    (args = ¡®(DESCRIPTION =
    (LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))¡¯)
    (envs =
    ¡®ORACLE_HOME=/home/oracle/app/oracle/product/8.0.5,ORACLE_SID=linux¡¯)
    )
    )

    4. ÀÌÁ¦ ´Ù½Ã lsnrctl start ¸í·ÉÀ¸·Î ½ÇÇàÇÏ¿© Oracle listenerÀ» ½ÇÇàÇÑ´Ù.
        ÀÌÁ¦ sqlplusÀ» ½ÇÇàÇÏ¿© Á¢¼ÓÀÌ µÇ³ª È®ÀÎÀ» ÇÏÀÚ. test ¿ëÀ¸·Î id : scott password : tiger
        °¡ Á¦°øµÊÀ» ¾Ë ¼ö ÀÖ´Ù. ÀÌ¹Ì ¼³Ä¡ Áß¿¡ system°ú sysÀÇ password´Â Á÷Á¢ ÀÔ·ÂÇÏ¿´À¸¹Ç
        ·Î, system ȤÀº sys·Î Á¢¼ÓÀÌ °¡´ÉÇÑÁö È®ÀÎÇÒ ¼ö ÀÖ´Ù.

    5. sqlplus·Î Á¢¼ÓÀÌ È®ÀεǾúÀ¸¸é ÀÌÁ¦ listenerÀ» Á¾·áÇÑ ÈÄ database¸¦ Á¾·á½ÃÄÑ º¸ÀÚ.

    - listener ÀÇ Á¾·á
    $ lsnrctl stop

    LSNRCTL for Linux: Version 8.0.5.0.0 - Production on 26-APR-99 22:18:35

    (c) Copyright 1997 Oracle Corporation.  All rights reserved.

    Connecting to
    (ADDRESS=(PROTOCOL=IPC)(KEY=linux))
    The command completed successfully

    - oracle database ÀÇ shutdown
    $ svrmgrl
    Oracle Server Manager Release 3.0.5.0.0 - Production

    (c) Copyright 1997, Oracle Corporation.  All Rights Reserved.

    Oracle8 Release 8.0.5.0.0 - Production
    PL/SQL Release 8.0.5.0.0 - Production

    SVRMGR> connect internal
    Connected.
    SVRMGR> shutdown
    Database closed.
    Database dismounted.
    ORACLE instance shut down.
    SVRMGR> exit
    Server Manager complete.

    $

 

¸¶. Oracle Database ÀÇ »ç¿ëÀÚ µî·Ï

    system/manager¶ó´Â Oracle »ç¿ëÀÚ °èÁ¤Àº UNIX½Ã½ºÅÛ¿¡¼­ÀÇ root¸¦ »ç¿ëÇÏ´Â °Í°ú À¯»çÇϱ⠶§¹®¿¡ ¿ì¸®´Â ¹®Á¦¸¦ ¹ß»ý½ÃÅ°´Â °ÍÀ» ÃÖ¼ÒÈ­Çϱâ À§ÇØ µÇµµ·Ï ÀûÀº ±ÇÇÑÀ» °®´Â »ç¿ëÀÚ¸¦ »ý¼ºÇÒ ÇÊ¿ä°¡ ÀÖ´Ù.

    SQL*PLUS¿¡ ¿¬°áÇÏ°í »ç¿ëÀÚ¸¦ »ý¼ºÇÑ´Ù.

    $ sqlplus system/manager

    SQL*Plus: Release 8.0.5.1.0 - Production

    Copyright (c) Oracle Corporation 1997.  All rights reserved.

    Connected to:
    Oracle8 Server Release 8.0.5.0.0 - Production Release
    PL/SQL Release 8.0.5.0.0 - Production

    SQL> create user <user> identified by <psw>
    2  default tablespace users
    3  temporary tablespace temp;

    User created.
    SQL> grant connect, resource to <user>

    Grant succeeded.

    SQL> exit

    Disconnected from Oracle8 Server Release 8.0.5.0.0 -
    Production Release
    PL/SQL Release 8.0.5.0.0 - Production

    ½Ã½ºÅÛ¿¡ »õ·Î¿î »ç¿ëÀÚ°èÁ¤À» »ý¼ºÇÏ¿´±â ¶§¹®¿¡ »õ·Î¿î °èÁ¤À» °¡Áö°í ½Ã½ºÅÛ¿¡ ·Î±×ÀÎ ÇÒ¼ö ÀÖ´Ù. Oracle µ¥ÀÌÅͺ£À̽º¿¡ ·Î±×ÀÎ Çϱâ À§Çؼ­´Â ´ÙÀ½°ú °°´Ù.

    $ sqlplus <user>/<password>

    ÀÌ ºÎºÐÀÌ ¿¡·¯ ¸Þ½ÃÁö ¾øÀÌ ¼öÇàµÈ´Ù¸é, ¼º°øÀûÀ¸·Î Oracle µ¥ÀÌÅͺ£À̽º¸¦ ¼³Ä¡ÇÑ °ÍÀÌ´Ù.

 

¹Ù. Oracle µ¥ÀÌÅÍ º£À̽ºÀÇ ÀÚµ¿ ½ÇÇà

    Oracle µ¥ÀÌÅͺ£À̽ºÀÇ ÀÚµ¿ ½ÃÀÛ°ú ÁßÁö´Â Oracle¿¡¼­ Á¦°øÇÏ´Â ÆÄÀÏÀÎ dbstart¿Í dbstop¸¦ ÀÌ¿ëÇÏ¿© ¼³Á¤ÇÒ ¼ö ÀÖ´Ù. ÀÌ·¯ÇÑ ÆÄÀϵéÀº etc/oratab ÆÄÀÏÀÇ Á¸Àç¿©ºÎ¿¡ ÀÇÁ¸ÇÑ´Ù.

    /etc/oratab ÆÄÀÏÀÇ Çü½ÄÀº ´ÙÀ½°ú °°´Ù.

    SID:ORACLE_HOME:AUTO

¼³Á¤  ¿¹

    #
    # This file is used by ORACLE utilities.  It is created by root.sh
    # and updated by the Oracle8 and SQL*Net install procedures.
    #
    # A colon, ¡®:¡¯, is used as the field terminator.  A new line terminates
    # the entry.  Lines beginning with a pound sign, ¡®#¡¯, are comments.
    #
    # Entries are of the form:
    # $ORACLE_SID:$ORACLE_HOME:<N|Y>:
    #
    # The first and second fields are the system identifier and home
    # directory of the database respectively.  The third field indicates
    # to the dbstart utility that the database should, ¡°Y¡±, or should not,
    # ¡°N¡±, be brought up at system boot time.
    #
    # Multiple entries with the same $ORACLE_SID are not allowed.
    #
    #
    linux:/oracle8/app/oracle/product/8.0.5:Y

    init.d & rc.d

    ¸®´ª½º ½Ã½ºÅÛÀÇ ½ÃÀÛ°úÁ¤À̳ª Á¾·á°úÁ¤À» º¯ÇüÇÏ¿© µ¥ÀÌŸº£À̽º¸¦ ½ÃÀÛ½ÃÅ°°í Á¾·á ½Ãų ¼ö ÀÖ´Ù. ÀÌ°ÍÀº ¸Å¿ì ½±Áö¸¸, ¾î¶°ÇÑ Linux(slackware, debian, redhat, etc)½Ã½ºÅÛÀ» »ç¿ëÇÏ´À³Ä¿¡ µû¶ó  º¯°æµÉ ¼ö ÀÖ´Ù´Â °ÍÀ» ÇÊÀÚ´Â ÁöÀûÇÑ´Ù. ÀÌ ¹®¼­¿¡¼­´Â Redhat Linux 5.2 ¿¡¼­ µ¿ÀÛÇÏ´Â ¿¹¸¦ º¸¿©ÁÙ °ÍÀÌ´Ù. ÀÚ½ÅÀÇ Linux ½Ã½ºÅÛ¿¡ µû¶ó ¼öÁ¤Çϱâ À§Çؼ­´Â ÀÚ½ÅÀÇ Linux ½Ã½ºÅÛ ¹®¼­ ÀڷḦ Âü°íÇÑ´Ù. ¿ì¼±, ¿ì¸®´Â /etc/rc.d/init.d µð·ºÅ丮¿¡ ÀÖ´Â dbshut¿Í dbstart¸¦ ½ÇÇàÇÒ ½ºÅ©¸³Æ®¸¦ »ý¼ºÇÒ ÇÊ¿ä°¡ ÀÖ´Ù.

    #!/bin/sh
    #
    # /etc/rc.d/init.d/oracle
    # Description: Starts and stops the Oracle database and listeners
    # See how we were called.

    case ¡°$1¡± in
    start)
     echo -n ¡°Starting Oracle Databases: ¡°
     echo ¡°----------------------------------------¡± >> /var/log/oracle
     date +¡±! %T %a %D : Starting Oracle Databases as part of system up.¡±  >> /var/log/oracle
     echo ¡°--------------------------------------------¡± >> /var/log/oracle
     su - oracle -c dbstart >> /var/log/oracle
     echo ¡°Done.¡±
     echo -n ¡°Starting Oracle Listeners: ¡°
     su - oracle -c ¡°lsnrctl start¡± >> /var/log/oracle
     echo ¡°Done.¡±
     echo ¡°¡±
     echo ¡°--------------------------------------------¡± >> /var/log/oracle
     date +¡±! %T %a %D : Finished.¡± >> /var/log/oracle
     echo ¡°--------------------------------------------¡± >> /var/log/oracle
     touch /var/lock/subsys/oracle
     ;;
    stop)
     echo -n ¡°Shutting Down Oracle Listeners: ¡°
     echo ¡°-----------

    ---------------------------------¡± >> /var/log/oracle
     date +¡±! %T %a %D : ShutDown Oracle Databases as part of system down.¡± >> /var/log/oracle
     echo ¡°--------------------------------------------¡± >> /var/log/oracle
     echo ¡°Done.¡±
     rm -f /var/lock/subsys/oracle
     echo -n ¡°Shutting Down Oracle Databases: ¡°
     su - oracle -c dbshut >> /var/log/oracle
     echo ¡°Done.¡±
     echo ¡°¡±
     echo ¡°--------------------------------------------¡± >> /var/log/oracle
     date +¡±! %T %a %D : Finished.¡± >> /var/log/oracle
     echo ¡°-------------------------------------------¡± >> /var/log/oracle
     ;;

    restart)
     echo -n ¡°Restarting Oracle Databases: ¡°
     echo ¡°-------------------------------------------¡± >> /var/log/oracle
     date +¡±! %T %a %D : Restarting Oracle Databases as part of system up.¡± >> /var/log/oracle
     echo ¡°-------------------------------------------¡± >> /var/log/oracle
     su - oracle -c dbstop >> /var/log/oracle
     su - oracle -c dbstart >> /var/log/oracle
     echo ¡°Done.¡±
     echo -n ¡°Restarting Oracle Listeners: ¡°
     su - oracle -c ¡°lsnrctl stop¡± >> /var/log/oracle
     su - oracle -c ¡°lsnrctl start¡± >> /var/log/oracle
     echo ¡°Done.¡±
     echo ¡°¡±
     echo ¡°--------------------------------------------¡± >> /var/log/oracle
     date +¡±! %T %a %D : Finished.¡± >> /var/log/oracle
     echo ¡°-------------------------------------------¡± >> /var/log/oracle
     touch /var/lock/subsys/oracle
     ;;

    *)

    echo ¡°Usage: oracle {start|stop|restart}¡±
    exit 1
    esac

    ÀÌ ÆÄÀÏÀÌ ½ÇÁ¦ÀûÀ¸·Î Á¤È®È÷ ´ç½ÅÀÇ ½Ã½ºÅÛ¿¡¼­  µ¥ÀÌÅͺ£À̽º¸¦ ÁßÁöÇÏ°í ½ÇÇà½ÃÅ°´ÂÁö¸¦ È®ÀÎÇØ¾ß ÇÑ´Ù. ¿¡·¯¸Þ¼¼Áö¸¦ À§ÇÑ /var/log/oracleÀÎ log ÆÄÀÏÀ» È®ÀÎÇ϶ó.
    ´ÙÀ½ ¸í·ÉµéÀº ½ÇÇà¼öÁØ 2,3,4¿¡ ÇØ´çÇÏ´Â µ¥ÀÌÅ׺£À̽º¸¦ ½ÇÇà½Ã´Â °ÍÀ» È®ÀÎ ½ÃÄÑÁÙ °ÍÀÌ´Ù.

    $ ln -s ../init.d/oracle /etc/rc.d/rc2.d/S99oracle
    $ ln -s ../init.d/oracle /etc/rc.d/rc3.d/S99oracle
    $ ln -s ../init.d/oracle /etc/rc.d/rc4.d/S99oracle

    ½Ã½ºÅÛÀ» Àç ºÎÆÃÇϰųª, Àç ½ÇÇà ½Ãų ¶§¿¡ µ¥ÀÌÅͺ£À̽º¸¦ ÁßÁö½ÃÅ°±â À§Çؼ­ ¿ì¸®´Â ´ÙÀ½°ú °°Àº ¿¬°á(link)ÀÌ ÇÊ¿äÇÑ´Ù.

    $ ln -s ../init.d/oracle /etc/rc.d/rc0.d/K01oracle          # Halting
    $ ln -s ../init.d/oracle /etc/rc.d/rc6.d/K01oracle          # Rebooting

 

¸¶Ä¡´Â ±Û

    ÀÌ»óÀ¸·Î °£·«ÇÏ°Ô³ª¸¶ Linux »ó¿¡¼­ÀÇ Oracle µ¥ÀÌÅͺ£À̽º ¼³Ä¡¿Í ±¸µ¿¹ý¿¡ ´ëÇؼ­ ¾Ë¾Æº¸¾Ò´Ù.
    ±×¸²°ú ÇÔ²² Á» ´õ ¸íÈ®ÇÑ ¼³Ä¡¹ýÀ» ¼Ò°³ÇØ ÁÙ ¼öµµ ÀÖ¾úÁö¸¸, ÀÌÁ¦ °£´ÜÇÑ ¼³Ä¡¹ý Á¤µµ´Â ±âŸ Ã¥À̳ª ¿À¶óŬ»ç ¼¼¹Ì³ª¿¡ °¡¸é ½±°Ô ±¸ÇÒ ¼ö ÀÖÀ¸¹Ç·Î ±âº» ¼³Ä¡¹ý¿¡ »ç¿ëÀÚ µî·Ï, ÀÚµ¿ ½ÃÀÛ/Á¾·á¸¦ Ãß°¡ÇØ Ã¹ ±ÛÀ» ¸¶Ä£´Ù. ´ÙÀ½¿¡´Â °£´ÜÇÑ sqlplus »ç¿ë¹ý, Oracle SQL, pro-c ¿¡´ëÇؼ­ ¾Ë¾Æº¸°í ¸¶Áö¸·À¸·Î PHP3¿Í ¿¬µ¿ÇÏ´Â °ÍÀ¸·Î ÀÌ ±ÛÀ» ¸¶Ä¥±î ÇÑ´Ù.




¡ã top

homeÀ¸·Î...