· KLDP.org · KLDP.net · KLDP Wiki · KLDP BBS ·
Linuxdoc Sgml/Oracle-HOWTO

You are not allowed to 'LikePages'


Oracle Database HOWTO

Oracle Database HOWTO

Paul Haigh, paul@nailed.demon.co.uk (¹ø¿ª:Á¶È«·¡ chorr@uriel.net) v1.1, 20 June 1998
¸®´ª½º ½Ã½ºÅÛ¿¡¼­ ¿À¶óŬ µ¥ÀÌÅͺ£À̽º ¼­¹ö ¼³Ä¡/¼³Á¤ °¡À̵å

1. °³¿ä

1.1 ¹®¼­¹öÀü

           v0.1 - 21 Feb 1998 - Paul Haigh - ¿À¸®Áö³¯ ¹®¼­ ¹öÁ¯.
           v0.2 - 01 Mar 1998 - Paul Haigh - ¹®¼­±³Á¤.
           v1.0 - 10 Mar 1998 - Paul Haigh - LDP µî·Ï.
           v1.1 - 20 Jun 1998 - Paul Haigh - ¹®Á¦Á¡ÇØ°á ºÎºÐÃß°¡.

1.2 ÀúÀÛ±Ç

¸®´ª½º HOWTO ¹®¼­µéÀÇ ÀúÀÛ±ÇÀº °¢ ¹®¼­ÀÇ ÀúÀڵ鿡°Ô ÀÖ´Ù. ¸®´ª½º HOWTO´Â ÀÌ ÀúÀÛ±ÇÀÌ À¯ÁöµÇ´Â ÇÑ ¸ðµç ¹°¸®Àû ¸Åü³ª ÀüÀÚ ¸Åü¸¦ ÅëÇØ ¹®¼­ Àüü ȤÀº ºÎºÐÀ¸·Î¼­ Àç»ý»ê ¹× ¹èÆ÷µÉ ¼ö ÀÖ´Ù. »ó¾÷ÀûÀÎ Àç¹èÆ÷µµ Çã¿ëµÇ¸ç Àå·ÁµÈ´Ù. ÇÏÁö¸¸ ÀÌ·± °æ¿ì¿¡´Â ÀúÀÚ¿¡°Ô ¾Ë·ÁÁֱ⠹ٶõ´Ù. ¸ðµç ¹ø¿ªÀ̳ª ÆÄ»ýÀûÀÎ ÀÛ¾÷µé, ¸®´ª½º HOWTO ¹®¼­µéÀ» °áÇÕÇÏ´Â ÀÛ¾÷µéÀº ÀÌ ÀúÀÛ±Ç ¾È³»¿¡ µû¶ó¾ß ÇÑ´Ù. ÀÌ´Â ¿©·¯ºÐÀÌ HOWTO¸¦ ÀÌ¿ëÇÑ ÀÛ¾÷À» ÇÏ°í ³ª¼­ ±× ¹èÆ÷¿¡ ºÎ°¡ÀûÀÎ Á¦ÇÑÁ¶°ÇÀ» ´Þ¾Æ¼­´Â ¾ÈµÈ´Ù´Â ¶æÀÌ´Ù. ¾î¶² °æ¿ì¿¡´Â ÀÌ ±ÔÄ¢¿¡ ´ëÇÑ ¿¹¿Üµµ Çã¿ëµÉ ¼ö ÀÖÀ¸¹Ç·Î, ¾Æ·¡ ÁÖ¼Ò¸¦ ÅëÇؼ­ ¸®´ª½º HOWTO Á¶Á¤ÀÚ¿Í Á¢ÃËÇϱ⠹ٶõ´Ù. °£´ÜÈ÷ ¸»Çؼ­ ¿ì¸®´Â ÀÌ Á¤º¸¸¦ °¡´ÉÇÑ ÇÑ ¸¹Àº °æ·Î¸¦ ÅëÇؼ­ º¸±ÞÇϱ⸦ ¹Ù¶õ´Ù. ÇÏÁö¸¸ ¿ì¸®´Â HOWTO ¹®¼­¿¡ ´ëÇÑ ÀúÀÛ±ÇÀÌ À¯ÁöµÇ±â¸¦ ¹Ù¶ó¸ç, HOWTO¸¦ Àç¹èÆ÷ÇÏ´Â ¸ðµç °èȹÀ» Å뺸¹Þ±â¸¦ ¹Ù¶õ´Ù.

1.3 Ã¥ÀÓ¿¡ ´ëÇÑ Æ÷±â

ÇÊÀÚ´Â µÉ¼ö ÀÖ´Â ÇÑ ¿Ã¹Ù¸¥ Á¤º¸¸¦ Á¦°øÇϱâ À§ÇÏ¿© ³ë·ÂÇÏ¿´Áö¸¸, ºÎÁ·ÇÑ Á¤º¸ÀÇ °á°ú·Î¼­ ÀϾ´Â ÀÏ¿¡ ´ëÇؼ­´Â Ã¥ÀÓÀ» Áú ¼ö ¾ø´Ù. ÇÊÀÚ´Â HOWTO ¹®¼­ÀÇ Á¤º¸¿¡ ´ëÇؼ­ º¸ÁõÇÒ ¼ö¾øÀ¸¸ç, HOWTO¹®¼­ÀÇ Á¤º¸¸¦ °¡Áö°í ¼öÇàÇÏ´Â ÀÏ·ÃÀÇ ÀÛ¾÷¿¡ ´ëÇؼ­µµ Ã¥ÀÓÁú ¼ö ¾ø´Ù.

1.4 HowToÀÇ ¸ñÀû

ÀÌ Howto¹®¼­¿¡¼­´Â ¸®´ª½º ¸Ó½Å¿¡¼­ µ¿ÀÛÇÏ´Â ¿À¶óŬµ¥À̺£À̽ºÀÇ ±âº»ÀûÀμ³Ä¡¿Í ±âº»ÀûÀÎ °ü¸®ºÎºÐÀ» ´Ù·ê °ÍÀÌ´Ù. Ưº°È÷ ¿À¶óŬ¼­¹ö/SQL*Net ¼³Ä¡¹× SQL*Net Ŭ¶óÀ̾ðÆ® ¼³Á¤ºÎºÐÀ» ´Ù·é´Ù. ÀÌ ¹®¼­´Â ¿À¶óŬ º£À̽ºÀÇ ¼¼ºÎ°ü¸® ¶Ç´Â »ç¿ë¿¡ ´ëÇÑ ±íÀÌÀÖ´Â ºÎºÐÀ» ´Ù·çÁö ¾ÊÀ¸¸ç, ÀÌ¿Í °°Àº ³»¿ëÀ» ã À¸·Á°í ÇÑ´Ù¸é O'Reilly¶Ç´Â ´Ù¸¥ ÃâÆǻ翡¼­ ³ª¿Â Ã¥µéÀ» »ìÆ캸±â ¹Ù¶õ´Ù. À̹®¼­¿¡¼­´Â Unix¿¡¼­ µ¿ÀÛÇÏ´Â ¿À¶óŬÇÁ·Î±×·¥ÀÇ °³¹ß¿¡ ´ëÇؼ­µµ ¾ð±ÞÇÏÁö ¾Ê´Â´Ù. À̺κп¡ ´ëÇØ ÇÊ¿äÇÏ´Ù¸é SCO·Î ºÎÅÍ SCO°³¹ß½Ã½ºÅÛ (OpenServer 5.X)¸¦ ±¸ÀÔÇÒ °ÍÀ» ±ÇÀåÇÑ´Ù. SCO °³¹ß½Ã½ºÅÛÀº www.sco.com¿¡¼­ $19¶ó´Â Àú·ÅÇÑ °¡°ÝÀ¸·Î ±¸ÀÔÇÒ ¼ö ÀÖ´Ù. HOWTO ¹®¼­¸¦ µû¶óÇϱâ À§ÇØ ÇÊ¿äÇÑ ¸î°¡Áö Ç׸ñ¿¡ ´ëÇØ ¾ð±ÞÇÑ´Ù. ?Oracle Server CD for SCO OpenServer (version 7.3.3.0.0)

ÀÌ°ÍÀº ÇÕ¹ýÀûÀÎ º¹»çº»À̾î¾ßÇÑ´Ù. ±â¾ïÇÒ °ÍÀº ¿À¶óŬÀº ¿µ¸®¸¦ Ãß±¸ÇϱâÀ§ÇÑ È¸»çÀ̸ç ÀÌ Á¦Ç°¿¡ ´ëÇÑ Ã¥ÀÓÀÖ´Ù. ¸¸¾à SQL ±â¹ÝÀÇ ´Ù¸¥ µ¥ÀÌÅͺ£À̽º¸¦ »ç¿ëÇϱ⠿øÇÑ´Ù¸é PostgresSQL¶Ç´Â ±×¿Í À¯»çÇÑ µ¥ÀÌÅͺ£À̽º¸¦ »ç¿ëÇÏ¸é µÈ´Ù. Oracle Web Site·ÎºÎÅÍ 60ÀÏ Æò°¡ÆÇÀ» ÅëÇØ ¼³Ä¡ ÇØ º¼¼öµµ ÀÖ´Ù. ÇÊÀÚ °³ÀÎÀûÀ¸·Î ÀÌ·± ¹æ¹ýÀ¸·Î ¼³Ä¡Çغ¸Áø ¾Ê¾ÒÀ¸¸ç ÀÌ°ÍÀº ¿ÏÀüÈ÷ °ËÁõµÈ ¹æ¹ýÀº ¾Æ´Ï´Ù.

Linux Server À̰͸¶Àú ¼³Ä¡µÇ¾îÀÖÁö ¾Ê´Ù¸é ¹®¼­¸¦ ÀÐÁöµµ ¾Ê¾ÒÀ»°ÍÀÌ´Ù. Kernel 2.0.30+ ´Ù¸¥ Kernel¿¡ ´ëÇؼ­´Â º¸ÀåÇÒ ¼ö°¡ ¾ø´Ù. iBCS iBCS°¡ ¼³Ä¡µÇ¾îÇÏ´Â °ÍÀº ¸Å¿ìÁß¿äÇÑ ºÎºÐÀÌ°í °¡´ÉÇÑÇÑ °¡ÀåÃÖ±ÙÀÇ ¹öÀüÀ» »ç¿ëÇÒ °ÍÀ» ÃßõÇÑ´Ù. (ÇÊÀÚ´Â ·¹µåÇÞÀÇ iBCS-2.0-10.i386.rpmÀ» »ç¿ëÇÏ°í ÀÖ´Ù.) ´ë¿ë·®µð½ºÅ© 600¸Þ°¡¹ÙÀÌÆ®ÀÌ»óÀÌ Àû´çÇÑ µð½ºÅ© ¿ë·®ÀÏ °ÍÀÌ´Ù. ÀÌ ¿ë·®À» ¸ðµÎ¸¦ »ç¿ëÇÒ ÇÊ¿ä°¡ ¾ø´Ù°í »ý°¢ÇÑ´Ù¸é ´õ ÀûÀº ¾çÀ» »ç¿ëÇصµ °¡´ÉÇÏ´Ù. ÇÏÁö¸¸ °³ÀÎÀûÀ¸·Î ÃßõÇÏ°í ½ÍÁö´Â ¾Ê´Ù. 32Mb + Ram RamÀ» ¸¹ÀÌ »ç¿ëÇÑ´Ù°í ´À³¢°ÚÁö¸¸ ¿À¶óŬ µ¥ÀÌŸº£À̽º´Â º¹ÀâÇÑ Á¾·ùÀÇ ¼ÒÇÁÆ®¿þ¾î¶ó´Â °ÍÀ» ±â¾ïÇؾßÇÑ´Ù. ±×·¸´Ù°í Çؼ­ ¿À¶óŬÀ̳ª ÇÊÀÚ°¡ ´õ Àû Àº ·¥¿¡¼­ ¿À¶óŬ µ¥ÀÌŸº£À̽º ÀÛµ¿À» ÇÏÁö¾Ê´Â´Ù´Â °ÍÀº ¾Æ´Ï´Ù. ´ÜÁö, ÃßõÇÒ ¸¸ÇÑ ·¥ÀÇ ¿ë·®ÀÌ 32¸Þ°¡ ¹ÙÀÌÆ®¶ó´Â°ÍÀÌ´Ù.

1.5 ¾ÕÀ¸·ÎÀÇ °³¼±»çÇ×

ÀÌ HOWTO ¹®¼­¿¡¼­´Â ¿À¶óŬ µ¥ÀÌŸº£À̽º ¼­¹ö ÀÚü¿¡ ´ëÇؼ­´Â ´Ù·çÁö ¾Ê´Â´Ù. ±×·¯³ª, ½Ã°£ÀÌ Çã¶ôµÈ´Ù¸é ´ÙÀ½ HOWTO ¹öÀü¿¡¼­ ¾Æ·¡ÀÇ Ç׸ñµéÀ» Æ÷ÇÔ½Ãų°ÍÀÌ´Ù.

  • Oracle ¶óÀ̺귯¸®¸¦ »ç¿ëÇÑ Oracle Pro* ÇÁ·Î±×·¥ÀÇ °³¹ß
  • ´Ù¸¥ ¿À¶óŬ¼­¹ö¹öÀü ¼³Ä¡
  • ¿À¶óŬ À¥¼­¹öÀÇ ¼³Ä¡
  • Oracle Kernel Relink

2. ¿À¶óŬ ¼ÒÇÁÆ®¿þ¾î ¼³Ä¡

2.1 ¼­¹öÁغñ»çÇ×

¿À¶óŬ»ç¿ëÀÚ µî·Ï

¿À¶óŬµ¥ÀÌÅͺ£À̽º¸¦ »ç¿ëÇϱâ À§Çؼ­´Â ¿À¶óŬµ¥ÀÌÅͺ£À̽º¸¦ À¯Áö/°ü¸® ÇÒ¼ö ÀÖ´Â »ç¿ëÀÚ°¡ ÀÖ¾î¾ß¸¸ÇÑ´Ù. ¿ì¸®°¡ ¿À¶óŬĿ³Î(ÃßÈÄ¿¡ ÀÚ¼¼ÇÑ ¼³¸í)¸¦Àç¼³Á¤ÇÏ·Á´Â Àǵµ´Â ¾ø±â ¶§¹®¿¡ ¿ì¸®´Â »ç¿ëÀÚÀ̸§°ú ±×·ìÀ̸§À» À§ÇÑ ¿À¶óŬ¿¡¼­ Á¦°øÇÏ´Â ¼³Á¤À» ¹Þ¾Æµé¿©¾ßÇÑ´Ù. ÀÌ ºÎºÐÀº »ç¿ëÀÚ ORACLE°ú ±×·ì DBA·Î ÁöÁ¤µÇ¾î ÀÖ´Ù.

  1. Root·Î½á ·Î±×ÀÎ
  2. oracle À¯Àú¿Í dba ±×·ì »ý¼º
            $ groupadd dba
            $ useradd oracle
    

  3. À¯Àú oracleÀ» À§ÇÑ home µð·ºÅ丮 »ý¼º
           $ mkdir /home/oracle
           $ mkdir /home/oracle/7.3.3.0.0 (Version of Oracle)
           $ chown -R oracle.dba /home/oracle
    

2.2 CDROMÀ¸·Î ¼³Ä¡

¾Æ½±°Ôµµ SCO°è¿­ÀÇ µð½ºÅ©¿¡¼­ÀÇ Oracle Installer´Â Á¦´ë·Î µ¿ÀÛÇÏÁö ¾ÊÀ» °ÍÀÌ´Ù. Core DumpºÎÅÍ ½Ã½ºÅÛ Á¤Áö±îÁö ´Ù¾çÇÑ ¹®Á¦¸¦ °æÇèÇÏ¿´´Ù. °á°úÀûÀ¸ ·Î ¿ì¸®´Â CDROM¿¡¼­ ÆÄÀϵéÀ» º¹»çÇÏ¿© ¾ÐÃàÀ» Ç® ÇÊ¿ä°¡ ÀÖ´Ù. (CDROMÀÌ ½Ã½ºÅÛ¿¡ ¸¶¿îÆ®µÇ¾ú´ÂÁö È®ÀÎ)

  1. Oracle·Î ·Î±×ÀÎ
  2. /home/oracle/7.3.3.0.0µð·ºÅ丮·Î À̵¿
  3. CDROM¿¡¼­ ¼³Ä¡ÆÄÀÏÀ» º¹»ç
            $ cp -a /mnt/cdrom/* .
    

  4. CDROM¿¡ ÀÖ´Â Oracle°ü·ÃÆÄÀÏÀÇ ¾ÐÃàÀ» Ç®±â
            $ find . -name *_ -exec ~/7.3.3.0.0/orainst/oiuncomp {} \;
    

2.3 ¼³Ä¡ÀÛ¾÷

Root¸¦ À§ÇÑ ÀÛ¾÷

OracleÀ» »ç¿ëÇÒ °¢ »ç¿ëÀÚ¸¦ À§ÇÑ /etc/profile³ª .profile¿¡ ´ÙÀ½ÁÙÀ» Ãß°¡ÇÑ´Ù.


       # Oracle Specific
       ORACLE_HOME=/home/oracle/7.3.3.0.0
       ORACLE_SID=orcl
       ORACLE_TERM=vt100
       export ORACLE_HOME ORACLE_SID ORACLE_TERM
      # Alter path for Oracle
       PATH="$PATH:$ORACLE_HOME/bin"

¿ì¸®´Â ¶ÇÇÑ ¼ÒÀ¯±ÇÇÑÀÚ¸¦ ¹Ù²Ü ÇÊ¿ä°¡ ÀÖ°í OracleÀÇ ±ÇÇÑÀ» Æí¸®ÇÏ°Ô »ç¿ëÇÒ ¼ö ÀÖµµ·Ï Ãß°¡ÇÑ´Ù.
       $ chown root.root $ORACLE_HOME/bin/osh
       $ chmod u+s $ORACLE_HOME/bin/osh

  

OracleÀ» À§ÇÑ ÀÛ¾÷

Á¤È®ÇÑ µ¿ÀÛÀ» È®ÀÎÇϱâ À§ÇÑ Oracle°ü·Ã ÆÄÀÏÀÇ ±ÇÇÑÀ» º¯°æÇÑ´Ù.


       $ chmod +x $ORACLE_HOME/bin/*
       $ chmod u+s $ORACLE_HOME/bin/oracle

Oracle°ü·Ã ÅøµéÀº $ORACLE_HOME/tool_name/mesg µð·ºÅ丮¿¡ ÀÖ´Â ¸Þ½ÃÁöµéÀ» ¿ä±¸ÇÑ´Ù. ±×·¡¼­ msg_shipµð·ºÅ丮¿¡¼­ msegµð·ºÅ丮·Î msb°ü·ÃÆÄÀϵéÀ» ¿Å±ä´Ù.


        $ mv $ORACLE_HOME/plsql/mesg/mesg_ship/*
        $ORACLE_HOME/plsql/mesg/.
        $ mv $ORACLE_HOME/rdbms/mesg/mesg_ship/*
        $ORACLE_HOME/rdbms/mesg/.
        $ mv $ORACLE_HOME/svrmgr/mesg/mesg_ship/*
        $ORACLE_HOME/svrmgr/mesg/.

¸¸¾à ´ÙÀ½ µð·ºÅ丮°¡ Á¸ÀçÇÏÁö ¾ÊÀ¸¸é »ý¼ºÇÑ´Ù.


       $ mkdir $ORACLE_HOME/rdbms/log
       $ mkdir $ORACLE_HOME/rdbms/audit
       $ mkdir $ORACLE_HOME/network/log

´ç½ÅÀÌ »èÁ¦ÇÒ ¼ö ÀÖ´Â ºÎºÐµé

´ÙÀ½ µð·ºÅ丮´Â ¾ÈÀüÇÏ°Ô »èÁ¦µÉ¼ö ÀÖ´Â °ÍµéÀÌ´Ù.

        $ORACLE_HOME/guicommon2/
        $ORACLE_HOME/ctx/
        $ORACLE_HOME/md/
        $ORACLE_HOME/mlx/
        $ORACLE_HOME/precomp/
        $ORACLE_HOME/slax/

3. µ¥ÀÌÅͺ£À̽º »ý¼º

Oracle¼­¹ö¸¦ ¼³Ä¡ÇÑ Áö±ÝºÎÅÍ ¼³Ä¡¸¦ ½ÃÇèÇÒ µ¥ÀÌÅͺ£À̽º¸¦ ¼³Ä¡ÇÒ ÇÊ¿ä°¡ ÀÖ´Ù. ¸¸¾à Oracle 7.2.x³ª ÀÌÀü ¹öÀüÀ» »ç¿ëÇÑ´Ù¸é, ¾Æ·¡ºÎºÐ¿¡ ÀÖ´Â ¹®Á¦ÇØ°áÁöħÀ» Àбâ¹Ù¶õ´Ù.

3.1 ¼³Ä¡°ü·Ã ÆÄÀÏ ¼³Ä¡

$ORACLE_HOME/dbs/init.ora¸¦ $ORACLE_HOME/dbs/initorcl.ora·Î º¹»çÇÑ´Ù.


        $ cd $ORACLE_HOME/dbs
        $ cp init.ora initorcl.ora

´ÙÀ½ÁÙÀ» »ý¼ºÇÑ ÆÄÀÏ¿¡ Ãß°¡ÇÑ´Ù.
        db_name = orcl
        COMPATIBLE=7.3.3.0.0

3.2 µ¥ÀÌÅͺ£À̽º ¼³Ä¡ ½ºÅ©¸³Æ®¸¦ »ý¼º

$ORACLE_HOME/dbsµð·ºÅ丮¿¡ makedb.sqlÀÇ À̸§À¸·Î ÆÄÀÏÀ» »ý¼ºÇÑ´Ù.


        connect internal
        startup nomount
        set echo on
        spool makedb.log
        create database orcl
               maxinstances 1
               maxlogfiles  8
               datafile '$ORACLE_HOME/dbs/orcl_syst_01.dbf' size 40M reuse
               logfile
                       '$ORACLE_HOME/dbs/orcl_redo_01.dbf' size 1M reuse,
                       '$ORACLE_HOME/dbs/orcl_redo_02.dbf' size 1M reuse,
                       '$ORACLE_HOME/dbs/orcl_redo_03.dbf' size 1M reuse;
       @$ORACLE_HOME/rdbms/admin/catalog.sql
       create tablespace rollback
               datafile '$ORACLE_HOME/dbs/orcl_roll_01.dbf' size 8.5M reuse;
       create tablespace temp
               datafile '$ORACLE_HOME/dbs/orcl_temp_01.dbf' size 5M reuse
               temporary;
       create tablespace users
               datafile '$ORACLE_HOME/dbs/orcl_user_01.dbf' size 10M reuse;
       create rollback segment r1 tablespace rollback storage ( optimal 5M );
       alter rollback segment r1 online;
       connect system/manager
       @$ORACLE_HOME/rdbms/admin/catdbsyn.sql
       connect internal
       @$ORACLE_HOME/rdbms/admin/catproc.sql
       connect system/manager
       @$ORACLE_HOME/sqlplus/admin/pupbld.sql
       spool off
       exit

3.3 µ¥ÀÌÅͺ£À̽º ¼³Ä¡ ½ºÅ©¸³Æ®¸¦ ½ÇÇà

svrmgrl¸í·ÉÀ» ¼öÇàÇÑ ÈÄ ½ºÅ©¸³Æ®¸¦ ½ÇÇàÇÑ´Ù.


        $ cd $ORACLE_HOME/dbs
        $ svrmgrl
        Oracle Server Manager Release 2.3.3.0.0 - Production
        Copyright (c) Oracle Corporation 1994, 1995. All rights reserved.
        Oracle7 Server Release 7.3.3.0.0 - Production Release
        PL/SQL Release 2.3.3.0.0 - Production
        SVRMGR> connect internal
        Connected.
        SVRMGR> startup nomount
        ORACLE instance started.
        Total System Global Area       4313312 bytes
        Fixed Size                       41876 bytes
        Variable Size                  4140364 bytes
        Database Buffers                122880 bytes
        Redo Buffers                      8192 bytes
        SVRMGR> @makedb
        <loads of messages>
        SVRMGR> exit
        Server Manager complete.

3.4 µ¥ÀÌÅͺ£À̽º ±¸µ¿½ÃÅ°±â

¿ì¼±Àº ¼öµ¿À¸·Î(ÀÌÈÄ¿¡´Â ÀÚµ¿À¸·Î ±¸µ¿µÉ °ÍÀÌ´Ù.)µ¥ÀÌÅͺ£À̽º¸¦ ±¸µ¿½ÃųÇÊ¿ä°¡ ÀÖ´Ù. Oracle µ¥ÀÌÅͺ£À̽º¸¦ ½ÃÀÛÇϱâÀ§Çؼ­´Â "connect internal"À» ÇÑÈÄ¿¡ "startup"À̶ó´Â command¸¦ ½ÇÇàÇØ¾ß ÇÑ´Ù.


       $ svrmgrl
      Oracle Server Manager Release 2.3.3.0.0 - Production
      Copyright (c) Oracle Corporation 1994, 1995. All rights reserved.
      Oracle7 Server Release 7.3.3.0.0 - Production Release
       PL/SQL Release 2.3.3.0.0 - Production
      SVRMGR> connect internal
       Connected.
       SVRMGR> startup
       ORACLE instance started.
       Total System Global Area       4313316 bytes
       Fixed Size                       41876 bytes
       Variable Size                  4140368 bytes
       Database Buffers                122880 bytes
       Redo Buffers                      8192 bytes
       Database mounted.
       Database opened.
       SVRMGR> exit
       Server Manager complete.

3.5 µ¥ÀÌÅͺ£À̽º ÁßÁö½ÃÅ°±â

Oracleµ¥ÀÌÅͺ£À̽º¸¦ ÁßÁö½ÃÅ°±â¾Ê°í Linux¼­¹ö¸¦ Àç½ÇÇà½ÃÅ°´Â °ÍÀº µ¥ÀÌÅͺ£À̽º¸¦ Æı«½Ãų ¼ö ÀÖ´Â Å« À§ÇèÀÌ ÀÖ´Ù´Â °ÍÀ» ¸í½ÉÇØ¾ß ÇÑ´Ù. ±×·¯¹Ç·Î,Linux shutdown¸í·ÉÀ» »ç¿ëÇϱâÀü¿¡ µ¥ÀÌÅͺ£À̽º¸¦ ÁßÁö½ÃÅ°´Â °ÍÀÌ ¹Ù¶÷Á÷ÇÑ°ÍÀÌ´Ù.


       $ svrmgrl
      Oracle Server Manager Release 2.3.3.0.0 - Production
      Copyright (c) Oracle Corporation 1994, 1995. All rights reserved.
      Oracle7 Server Release 7.3.3.0.0 - Production Release
       PL/SQL Release 2.3.3.0.0 - Production
      SVRMGR> connect internal
       Connected.
       SVRMGR> shutdown
       Database closed.
       Database dismounted.
       ORACLE instance shut down.
       SVRMGR> exit
       Server Manager complete.

3.6 ±âº»»ç¿ëÀÚ »ý¼º

µ¥ÀÌÅͺ£À̽º°¡ »ý¼ºµÇ¸é¼­ ÀÚµ¿ÀûÀ¸·Î µÎ °³ÀÇ Æ¯º°ÇÑ »ç¿ëÀÚ°èÁ¤ÀÌ »ý¼ºµÈ´Ù. ´ÙÀ½¿¡ ±× ºÎºÐÀ» ¸í½ÃÇÑ´Ù.


       Username                Password
      SYSTEM                  MANAGER
       SYS                     change_on_install

ÀÌ·¯ÇÑ »ç¿ëÀÚ°èÁ¤Àº ÀüÇüÀûÀ¸·Î µ¥ÀÌÅͺ£À̽º¸¦ À§ÇÑ ±âº»ÀûÀÎ µ¥ÀÌÅ͵ñ¼Å³Ê¸®Á¤º¸¸¦ À¯ÁöÇϱâ À§ÇÑ °ÍÀÌ´Ù. °¡´ÉÇÑÇÑ ºü¸¥½Ã°£³»¿¡ ±âº»ÀûÀÎÀ¸·Î ÁöÁ¤µÈ ¾ÏÈ£¸¦ ¹Ù²Ù´Â °ÍÀÌ ÁÁ´Ù. ÀÌ·¯ÇÑ ºÎºÐÀ» ´ÙÀ½°ú °°Àº °úÁ¤À¸·Î º¯°æµÈ´Ù.
        sqlplus system/manager
        SQL*Plus: Release 3.3.3.0.0 - Production on Sat Feb 21 12:43:33 1998
        Copyright (c) Oracle Corporation 1979, 1996.  All rights reserved.

        Connected to:
        Oracle7 Server Release 7.3.3.0.0 - Production Release
        SQL> alter user system identified by <newpassword>;
        User altered.
        SQL> alter user sys identified by <newpassword>;
        User altered.
        SQL> exit;
        Disconnected from Oracle7 Server Release 7.3.3.0.0 - Production Release
        PL/SQL Release 2.3.3.0.0 - Production

system/manager¶ó´Â Oracle »ç¿ëÀÚ °èÁ¤Àº UNIX½Ã½ºÅÛ¿¡¼­ÀÇ root¸¦ »ç¿ëÇÏ´Â °Í°ú À¯»çÇϱ⠶§¹®¿¡ ¿ì¸®´Â ¹®Á¦¸¦ ¹ß»ý½ÃÅ°´Â °ÍÀ» ÃÖ¼ÒÈ­Çϱâ À§ÇØ µÇµµ·Ï ÀûÀº ±ÇÇÑÀ» °®´Â »ç¿ëÀÚ¸¦ »ý¼ºÇÒ ÇÊ¿ä°¡ ÀÖ´Ù. (»ç¿ëÀÚ¸¦ »ý¼ºÇϱâ Àü¿¡ µ¥ÀÌÅͺ£À̽º¸¦ ½ÇÇà½ÃÅ°´Â °ÍÀ» ±â¾ïÇ϶ó) SQL*PLUS¿¡ ¿¬°áÇÏ°í »ç¿ëÀÚ¸¦ »ý¼ºÇÑ´Ù.
       $ sqlplus system/manager
      SQL*Plus: Release 3.3.3.0.0 - Production on Sat Feb 21 12:43:33 1998
      Copyright (c) Oracle Corporation 1979, 1996.  All rights reserved.

      Connected to:
       Oracle7 Server Release 7.3.3.0.0 - Production Release
       PL/SQL Release 2.3.3.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 Oracle7 Server Release 7.3.3.0.0 - Production Release
       PL/SQL Release 2.3.3.0.0 - Production

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

À̺κÐÀÌ ¿¡·¯¸Þ¼¼Áö¾øÀÌ ¼öÇàµÈ´Ù¸é, ¼º°øÀûÀ¸·Î ¿À¶óŬ µ¥ÀÌŸº£À̽º¸¦ ¼³Ä¡ÇÑ°ÍÀÌ´Ù. ÀÌ ¼­¹ö°¡ ¾Æ´Ñ ´Ù¸¥ È£½ºÆ®¿¡¼­ ÀÌ ¿À¶óŬ µ¥ÀÌŸº£À̽º¿¡ Á¢±Ù ÇÏÁö ¾Ê´Â´Ù¸é ¸ðµç ÀÛ¾÷Àº ¿Ï·áµÈ°ÍÀÌ´Ù. ±×·¯³ª, ´ëºÎºÐ »ç¶÷µéÀº ³×Æ®¿öÅ©¸¦ ÀÌ¿ëÇÏ¿© ¿ø°ÝÀ¸·Î µ¥ÀÌŸº£À̽º ¼­¹ö¿¡ Á¢¼ÓÇÏ±æ ¿øÇÒ°ÍÀÌ´Ù. ±×·¸°Ô Çϱâ À§Çؼ­´Â ´ÙÀ½°ú °°Àº °úÁ¤À» ¼öÇàÇؾßÇÑ´Ù.

4. ¼­¹ö¿¡ SQL*NetÀ» ¼³Á¤Çϱâ

¸ðµç ÀÌ·¯ÇÑ ºÎ·ùÀÇ ÆÄÀϵéÀº Oracle ³×Æ®¿öÅ©¿¡ °ü·ÃµÈ ¼ÒÇÁÆ®¿þ¾î(SQL*Net,aka Net8 for Oracle8)¸¦ ¼³Á¤ÇÑ´Ù. ÀÌ·¯ÇÑ ÆÄÀϵéÀº $ORACLE_HOME/network/adminµð·ºÅ丮¾È¿¡ ¼­¹ö·Î½á »ý¼ºµÇ¾îÁ®¾ß ÇÑ´Ù.

4.1 tnsnames.ora

TNSNAMES.ORAÆÄÀÏÀº ¿¬°á °¡´ÉÇÑ µ¥ÀÌŸº£À̽º ÀνºÅϽºµéÀ» ±â¼úÇÏ¿© ÁØ´Ù. »õ·ÎÀÌ »ý¼ºµÈ µ¥ÀÌÅͺ£À̽º ÀνºÅϽº¸¦ À§ÇØ ¾Æ·¡ºÎºÐ°ú °°ÀÌ Ãß°¡ÇÑ´Ù.


       orcl.world =
         (DESCRIPTION =
           (ADDRESS_LIST =
               (ADDRESS =
                 (COMMUNITY = tcp.world)
                 (PROTOCOL = TCP)
                 (Host = <INSERT HOST NAME OF SERVER HERE> )
                 (Port = 1521)
               )
               (ADDRESS =
                 (COMMUNITY = tcp.world)
                 (PROTOCOL = TCP)
                 (Host = <INSERT HOST NAME OF SERVER HERE> )
                 (Port = 1526)
               )
           )
           (CONNECT_DATA = (SID = ORCL)
           )
         )

4.2 listener.ora

LISTENER.ORAÆÄÀÏÀº ´Ù¸¥ ½Ã½ºÅÛ¿¡ ¿¬°áÇÏ´Â °Í¿¡ °ü·ÃµÈ ºÎºÐÀ» ±â¼úÇÏ°í ¼­¹ö listenerÀ» À§ÇØ ¿ä±¸µÇ´Â ´Ù¸¥ ¼³Á¤À» Æ÷ÇÔÇÑ´Ù. listenerÀ̸§, listenerÁÖ¼Ò, listener¿¡ ÀÇÇØ Á¦°øµÇ´Â µ¥ÀÌÅͺ£À̽º, ¼³Á¤¸Å°³º¯¼öµîÀ» ¶ÇÇÑ Æ÷ÇÔÇÑ´Ù. ´ÙÀ½¿¡ ÇÑ ¿¹°¡ ÀÖ´Ù.


       # Name of listener and addresses to listen on
       LISTENER =
               ( ADDRESS_LIST =
                       (ADDRESS =
                               (PROTOCOL=tcp)
                               (HOST=<INSERT HOST>)
                               (PORT=1521)
                               (COMMUNITY=UK_SUP_TCPIP)
                       )
                       (ADDRESS =
                               (PROTOCOL=ipc)
                               (KEY=700)
                               (COMMUNITY=UK_SUP_TCPIP)
                       )
               )
      # List of services served by this listener
       SID_LIST_LISTENER=
               (SID_LIST=
                       (SID_DESC=
                               (SID_NAME=orcl)
                               (ORACLE_HOME=/home/oracle/7.3.3.0.0)
                       )
               )
      # Start of configuration parameters.
       TRACE_LEVEL_LISTENER=OFF
       TRACE_FILE_LISTENER = "listener"
       LOG_FILE_LISTENER = "listener"
       CONNECT_TIMEOUT_LISTENER = 10
       STOP_LISTENER = YES
       DBA_GROUP = dba

4.3 sqlnet.ora

SQLNET.ORAÆÄÀÏÀº ³×Æ®¿öÅ©ÀÇ Æ¯º°ÇÑ ¿¬°áÁöÁ¡(node)¿¡ ´ëÇÑ ¼³Á¤À» Æ÷ÇÔÇÑ´Ù. ÀÌ°ÍÀº µ¥ÀÌÅͺ£À̽º¿Í listenerÀÇ ¼ö¿Í´Â »ó°üÀÌ ¾ø´Ù. ÀÌ ÆÄÀÏ¿¡¼­ °¡Àå Áß¿äÇÑ ºÎºÐÀº Dead Connection Timeout ¼³Á¤º¯¼öÀÌ´Ù.Dead Connection TimeoutÀº µ¥ÀÌÅͺ£À̽º ÀνºÅϽº¿¡ Á¢¼öµÇ´Â °¢°¢ÀÇ ÇÁ·Î¼¼½º¸¦ üũÇÏ°í, °è¼ÓÀûÀÎ ÀÀ´ä¿¡ °ü·ÃµÈ Ŭ¶óÀ̾ðÆ®¸¦ È®ÀÎÇÑ´Ù. Ŭ¶óÀ̾ðÆ®(¾î¶°ÇÑ ÇüÅÂÀÇ)°¡ ÀÀ´äÀÌ µÇÁö ¾Ê´Â´Ù¸é Oracle ¼­¹öÀÇ ½ÇÇàÁßÀÎ ÇÁ·Î¼¼½º´Â ÁßÁöµÈ´Ù. ÀÌ°ÍÀº ¸¹Àº ¼öÀÇ Å¬¶óÀ̾ðÆ®°¡ µ¥ÀÌÅͺ£À̽º¿¡ Á¢±ÙÇÏ·ÁÇÒ ¶§ ¸Å¿ì À¯¿ëÇÑ´Ù. ƯÈ÷, Oracleµ¥ÀÌÅͺ£À̽º·ÎºÎÅÍ Á¤È®È÷ ºüÁ®³ª°¡´Âµ¥ ½ÇÆÐÇϴ Ŭ¶óÀ̾ðÆ®µéÀÌ ¸¹ÀÌ Á¸ÀçÇÒ °¡´É¼ºÀÌ ÀÖ´Â °³¹ß±â°£¿¡ Àû¿ëÀÌ µÈ´Ù°í º¼ ¼ö ÀÖ´Ù. ¾Æ·¡ºÎºÐ¿¡ ´ç½ÅÀÌ »ç¿ëÇÒ sqlnet.oraÆÄÀÏÀÇ ¿¹°¡ ÀÖ´Ù.


        TRACE_LEVEL_CLIENT = OFF
        sqlnet.expire_time = 30         # The number of seconds between
        client checks.
        names.default_domain = world
        name.default_zone = world

4.4 ListenerÀ» ½ÇÇà½ÃÅ°°í Á¾·áÇϱâ

listener¿Í SQL*NetÀÇ ¼³Á¤À» ³¡¸¶ÃÆÀ¸¹Ç·Î, ³×Æ®¿öÅ© ¼ÒÇÁÆ®¿þ¾î¸¦ »ç¿ëÇÏ¿© µ¥ÀÌÅͺ£À̽º¿¡ Á¢±ÙÇÒ ¼ö ÀÖ´Ù.(µ¥ÀÌÅͺ£À̽º¿¡ Á÷Á¢ ¿¬°áÀ» ÇϱâÀü¿¡, ¿ì¸®´Â ¿ø°Ý Ŭ¶óÀ̾ðÆ® ½Ã½ºÅÛ¿¡¼­ Á¢±ÙÇÏ´Â °ÍÀ» ½ÃÇèÇÒ °ÍÀÌ´Ù.) À§ÀÇ ¼³Á¤À» »ç¿ëÇÏ¿© listenerÀ» ½ÇÇà½ÃŲ´Ù.


       $ lsnrctl
        LSNRCTL for SCO System V/386: Version 2.3.3.0.0 - Production 
        on 23-FEB-98 20:38:25
        Copyright (c) Oracle Corporation 1994.  All rights reserved.
        Welcome to LSNRCTL, type "help" for information.
        LSNRCTL> start
        Starting /home/oracle/7.3.3.0.0/bin/tnslsnr: please wait...
        TNSLSNR for SCO System V/386: Version 2.3.3.0.0 - Production
        System parameter file is
        /home/oracle/7.3.3.0.0/network/admin/listener.ora
        Log messages written to
        /home/oracle/7.3.3.0.0/network/log/listener.log
        Listening on:
        (ADDRESS=(PROTOCOL=tcp)(DEV=6)(HOST=192.168.1.1)(PORT=1521))
        Listening on: (ADDRESS=(PROTOCOL=ipc)(DEV=10)(KEY=700))
        Connecting to
        (ADDRESS=(PROTOCOL=tcp)(HOST=magic.com)(PORT=1521)
                (COMMUNITY=UK_SUP_TCPIP))
        STATUS of the LISTENER


        Alias       LISTENER
        Version     TNSLSNR for SCO System V/386: Version 2.3.3.0.0 - Production
        Start Date  23-FEB-98 20:38:50
        Uptime       0 days 0 hr. 0 min. 0 sec
        Trace Level  off
        Security     OFF
        SNMP         ON
        Listener Parameter File
        /home/oracle/7.3.3.0.0/network/admin/listener.ora
        Listener Log File
        /home/oracle/7.3.3.0.0/network/log/listener.log
        Services Summary...
        orcl          has 1 service handler(s)
        The command completed successfully
        LSNRCTL> exit

listenerÀ» ÁßÁö½ÃÅ°±â À§Çؼ­´Â ´ÙÀ½°ú °°´Ù.
        $ lsnrctl
        LSNRCTL for SCO System V/386: Version 2.3.3.0.0 - Production 
        on 23-FEB-98 20:43:20
        Copyright (c) Oracle Corporation 1994.  All rights reserved.
        Welcome to LSNRCTL, type "help" for information.
        LSNRCTL> stop
        Connecting to
        (ADDRESS=(PROTOCOL=tcp)
                 (HOST=magic.com)
                 (PORT=1521)
                 (COMMUNITY=UK_SUP_TCPIP)
        )
        The command completed successfully
        LSNRCTL> exit

¸í½ÃµÈ hostname¸¦ À§ÇÑ IPÁÖ¼Ò¸¦ ¹ÝȯÇÏÁö ¾Ê´Â DNS¼³Á¤À» °®´Â´Ù¸é, listenerÀ» ½ÇÇà½ÃÅ°°í, ÁßÁö½Ãų ¶§¿¡ ¾à°£ÀÇ ½Ã°£ÀÌ ¼Ò¿äµÈ´Ù.(2-3ºÐ, DNS timeout º¯¼ö¿¡ °ü·ÃµÇ¾î) ÀÌ·¯ÇÑ °æ¿ì¿¡´Â °ÆÁ¤ÇÏÁö ¸»°í, Àγ»Ç϶ó. ±â´Ù¸®¶ó.

5. Ŭ¶óÀ̾ðÆ® ȯ°æ ¼³Á¤

5.1 À©µµ¿ìȯ°æ Ŭ¶óÀ̾ðÆ®

ÃÖ±Ù ¹öÁ¯ÀÇ Oracle Client SoftwareÀ» »ç¿ëÇÏ´Â PC¿¡¼­ÀÇ SQL*Net ¼³Á¤Àº ¸Å¿ì ½±´Ù. ¸ðµç ºÎºÐÀÌ µ¿ÀÛÇϴ Ŭ¶óÀ̾ðÆ® ¼³Ä¡¸¦ ¼öÇàÇÏ´Â °¡Àå ÁÁÀº(½¬¿î) ¹æ¹ýÀº Oracle¿¡¼­ Á¦°øÇÏ´Â SQL*Net Easy Configuration ÅøÀ» ÀÌ¿ëÇÏ´Â °ÍÀÌ´Ù. ÀÌ ÅøÀº tnsnames.ora¿Í sqlnet.oraÆÄÀÏÀÇ ¼³Á¤À» º¯°æ ÇÒ ¼ö ÀÖ´Â À§Àúµå ÇüÅÂÀÇ ÀÎÅÍÆäÀ̽º¸¦ °®´Â´Ù. "Add Database Alias"¸¦ ¼±ÅÃÇÏ°í, Ä¿¼­°¡ À§Ä¡ÇÑ °÷¿¡ "Database alias"¿¡ ´ëÇÑ À̸§À» ÀÔ·ÂÇÑ´Ù. ÀÌ alias´Â µ¥ÀÌÅͺ£À̽º ÀνºÅͽº¸¦ ÂüÁ¶ÇÒ À̸§ÀÌ°í, ÀνºÅϽº À̸§(ÀÌ·¯ÇÑ °æ¿ì¿¡´Â orcl)°ú °°Àº À̸§À̾î¾ß ÇÑ´Ù. ÇÁ·ÎÅäÄݷνá TCP/IP¸¦ ¼±ÅÃÇÏ°í, µ¥ÀÌÅͺ£À̽º ½Ã½ºÅÛÀÇ hostname¿Í µ¥ÀÌÅͺ£À̽ºÀÇ ÀνºÅϽº À̸§À» ÀÔ·ÂÇÑ´Ù. ¿Ï·áµÇ¾ú´Ù. ±×·¯³ª, SQL*Net Easy Configuration ToolÀÌ ¾ø´Ù°í °ÆÁ¤ÇÏÁö ¸»¶ó. ¼­¹ö¿¡ Á¸ÀçÇÏ´Â °÷°ú °°Àº Ŭ¶óÀ̾ðÆ® ½Ã½ºÅÛ¿¡¼­ $ORACLE_HOME/network/adminµð·ºÅ丮¿¡ tnsnames.ora¿Í sqlnet.oraÆÄÀÏÀ» »ý¼ºÇÑ´Ù. ÀÌ°ÍÀº ¼­¹ö¿¡¼­(¾î¶² Àǹ̿¡¼­´Â Ç×»ó ÁÁÀº »ý°¢ÀÎ)¿Í °°Àº alias¸¦ Áö¿øÇÒ °ÍÀÌ´Ù.

5.2 Unix Ŭ¶óÀ̾ðÆ®

UNIX Ŭ¶óÀ̾ðÆ®´Â À©µµ¿ì Ŭ¶óÀ̾ðÆ®¿Í ¸Å¿ì ´Ù¸£Áö ¾Ê´Ù. Oracle¿¡¼­ Á¦°øÇÏ´Â Network ManagerÀÌ ÀÖ´Ù¸é, À§¿¡¼­ ¾ð±ÞÇÑ ³»¿ë°ú °°Àº ¹æ¹ýÀ¸·Î ÇÏ¸é µÈ´Ù. ¸¸¾à ±×·¸°Ô ÇÒ ¼ö ¾ø´Ù¸é, ¼­¹ö¿¡ Á¸ÀçÇÏ´Â $ORACLE_HOME/network/adminµð·ºÅ丮¿¡ ÀÖ´Â ÆÄÀϵéÀÇ ¼³Á¤°ú °°Àº °ÍÀ» ÀÌ¿ëÇÏ¸é µÈ´Ù.

6. ÀÚµ¿ ½ÃÀÛ°ú ÁßÁö

6.1 dbstart & dbstop

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


        SID:ORACLE_HOME:AUTO

¿¹)
       orcl:/home/oracle/7.3.3.0.0:Y
       leaveup:/home/oracle/7.3.2.1.0:N

6.2 init.d & rc.d

¸®´ª½º ½Ã½ºÅÛÀÇ ½ÃÀÛ°úÁ¤À̳ª Á¾·á°úÁ¤À» º¯ÇüÇÏ¿© µ¥ÀÌŸº£À̽º¸¦ ½ÃÀÛ½ÃÅ°°í Á¾·á½Ãų¼ö ÀÖ´Ù. ÀÌ°ÍÀº ¸Å¿ì½±Áö¸¸, ¾î¶°ÇÑ Linux(slackware, debian, redhat, etc)½Ã½ºÅÛÀ» »ç¿ëÇÏ´À³Ä¿¡ µû¶ó º¯°æµÉ¼ö ÀÖ´Ù´Â °ÍÀ» ÇÊÀÚ´Â ÁöÀûÇÑ´Ù. ÀÌ ¹®¼­¿¡¼­´Â Redhat Linux 5.0¿¡¼­ µ¿ÀÛÇÏ´Â ¿¹¸¦ º¸¿©ÁÙ °ÍÀÌ´Ù. ÀÚ½ÅÀÇ Linux ½Ã½ºÅÛ¿¡ µû¶ó ¼öÁ¤ÇϱâÀ§Çؼ­´Â ÀÚ½ÅÀÇ Linux ½Ã½ºÅÛ ¹®¼­ ÀڷḦ Âü°íÇÑ´Ù. (ºñ·Ï ±×·¯ÇÑ °ÍÀÌ Unix ½Ã½ºÅÛÀÇ Sys V °è¿­À» À§ÇÑ °Í¿¡ Àû¿ëµÇ´õ¶óµµ) ¿ì¼±, ¿ì¸®´Â /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
          su - oracle -c "lsnrctl stop" >> /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

7. ´Ù¸¥ ºÎºÐµé

7.1 Áö´ÉÇü ¿¡ÀÌÀüÆ®

Oracle Intelligent AgentÀ» ÇÊ¿ä·Î ÇÑ´Ù¸é, ȯ°æ¼³Á¤ÀÇ º¯È­¾øÀÌ °¡´ÉÇÏ´Ù. IA¸¦ ½ÇÇàÇϱâ À§Çؼ­´Â ´ÙÀ½°ú °°´Ù.


       $ lsnrctl dbsnmp_start

IA¸¦ ÁßÁö½ÃÅ°±â À§Çؼ­´Â ´ÙÀ½°ú °°´Ù.
       $ lsnrctl dbsnmp_stop

¼º°øÀ» ³ªÅ¸³»°Å³ª Intelligent Agent¸¦ ½ÇÇàÇϰųª, ÁßÁöÇÏ´Â ¾î¶°ÇÑ ¸Þ½ÃÁöµµ Ãâ·ÂÇÏÁö ¾Ê´Â´Ù. ÀÎÅÚ¸®ÀüÆ® ¸Þ´ÏÀú´Â ¿À¶óŬµ¥ÀÌŸº£À̽º °ü¸® Ŭ¶óÀ̾ðÆ® ¼ÒÇÁÆ®¿þ¾îÀÎ Enterprise Manager¿Í ¿¬°áÇϱâÀ§ÇÑ °ÍÀÌ´Ù. È®ÀÎÇÏ´Â ¹æ¹ýÀº ¿À¶óŬ Enterprise Manager¿¡¼­ ÇÒ ¼ö ÀÖ´Ù.

8. ¹®Á¦ÇØ°á

¿©·¯ °¡Áö ´Ù¾çÇÑ ¹®Á¦ÇØ°á ½Ç¸¶¸®(hints)µéÀº ´ÙÀ½°ú °°´Ù.

8.1 Oracle 7.2.x¸¦ »ç¿ëÇÒ ¶§, ³ª´Â µ¥ÀÌÅͺ£À̽º¸¦ »ý¼ºÇÒ ¼ö ¾ø´Ù.

7.2.x Á¦Ç°Áß¿¡¼­ Oracle¿¡¼­ Á¦°øµÇ´Â ÀÌ·¯ÇÑ ÆÄÀϵéÀº º´·Ä¼­¹öȯ°æÀ» ±¸ÃàÇÏ·Á´Â °ÍÀ» ½ÃµµÇÏ·Á´Â °ÍÀº Á¤È®ÇÏÁö ¾Ê´Ù. Á¦°øµÇ´Â init.oraÆÄÀÏÀº ´ÙÀ½°ú °°Àº ÁÙÀÇ ³»¿ëÀ» Æ÷ÇÔÇÑ´Ù.


       # define parallel server (multi-instance) parameters
       ifile = ora_system:initps.ora

¹®Á¦¸¦ ÇØ°áÇϱâ À§Çؼ­´Â ´Ü¼øÈ÷ ÁÖ¼®Ã³¸®¸¦ ÇϸéµÈ´Ù.
       # define parallel server (multi-instance) parameters
       #ifile = ora_system:initps.ora

8.2 3.4.x.¹öÀü¿¡¼­ svrmgrl½ÇÇàÁß segmentation ¿À·ù¸¦ ¾ò¾ú´Ù.

ÀÌ·¯ÇÑ ¹®Á¦µéÀº ¸¹Àº »ç¶÷µé¿¡°Ô¼­ ¾Ë·ÁÁ³´Ù. Gerald Weber gerald_weber@master.co.at°¡ ÇØ°áÇÏ¿´´Ù.


        ¾È³ç Paul,
        ´ç½ÅÀÇ µµ¿ò¿¡ ¿ì¼± °¨»çÇÑ´Ù. ¹®Á¦´Â iBCS-emulator ÀÚüÀÌ´Ù.
        Oracle½Ã½ºÅÛÀÌ iBCSÀÇ ÇöÀç ¹öÀü¿¡¼­ Áö¿øÇÏÁö ¾Ê´Â sysconf-callsÀ»
        ¼öÇàÇÏ´Â °Í °°´Ù.
        <7>[22]615 sysconf(34)
        <7>iBCS2 unsupported sysconf call 34
        <7>[22]615 sysconf error return linux=-22 -> ibcs=22 <Invalid argument>
        <7>[24]615 sysconf(34)
        <7>iBCS2 unsupported sysconf call 34
        <7>[24]615 sysconf error return linux=-22 -> ibcs=22 <Invalid argument>
 ¹®Á¦ÇØ°á : ´ÙÀ½°ú °°Àº diff-pach¸¦ iBCS-source.apply¿¡ Àû¿ëÇÑ´Ù

 --- sysconf.c   Sun Apr 19 19:19:15 1998
  +++ sysconf.c.ori       Sun Apr 19 19:28:45 1998
  @@ -60,7 +60,6 @@
   #define _SC_JOB_CONTROL        5
   #define _SC_SAVED_IDS  6
   #define _SC_VERSION    7
  -#define _SC_HACK_FOR_ORACLE 34
  #define _SC_PAGESIZE   11
 @@ -97,11 +96,6 @@
                  case _SC_SAVED_IDS: {
                          return (1);
                  }
  -
  -               case _SC_HACK_FOR_ORACLE: {
  -                 return (1);
  -               }
  -
                 case _SC_PAGESIZE: {
                    return PAGE_SIZE;

9. µµ¿ÍÁֽŠºÐµé

À̹®¼­´Â Bob Withers( bwit@pobox.com)°¡ ÀÛ¼ºÇÑ ¹®¼­¸¦ ±âº»À¸·Î ÇÏ¿´°í, Georg Rehfeld( rehfeld@wmd.de)¿Í David Mansfield( david@claremont.com)°¡ Á¦°øÇÑ Á¤º¸¸¦ Ãß°¡ÇÏ¿´½À´Ï´Ù. Bob Withers, Mark Watling( mwatling@mjw-ltd.demon.co.uk), Peter Sodhi( petersodhi@unn.unisys.com)°ú Greg Hankins( greg.hankins@cc.gatech.edu)°¡ ¹®¼­¸¦ °ËÁõÇÏ¿´½À´Ï´Ù. ÇÔ²² Á¶»çÇÏ°í ¹®¼­ÀÛ¾÷À» ÇØÁØ ¸ðµç »ç¶÷µé¿¡°Ô °¨»çÇÕ´Ï´Ù. Ãß°¡ ÁÖ¼®°ú Á¶¾ðÀ» ÇØÁØ Bob Withers °ú Mark Watling ¿¡°Ô Ưº°È÷ °¨»çÇÕ´Ï´Ù.


ID
Password
Join
"Heck, I'm having a hard time imagining the DOM as civilized!" -- Fred L. Drake, Jr.


sponsored by andamiro
sponsored by cdnetworks
sponsored by HP

Valid XHTML 1.0! Valid CSS! powered by MoniWiki
last modified 2003-08-10 11:52:30
Processing time 0.0019 sec