DB/Oracle/XE ´Ä¶­¹½ÃÛ

Top/DB/Oracle/XE ´Ä¶­¹½ÃÛ

Ìܼ¡

̵½þ¤Ç»È¤¨¤ë Oracle Database Express Edition¡ÊOracle XE¡Ë¤ò²È¤Î RedHat Enterprise Linux 6¡ÊRHEL 6¡Ë¤Ë¥¤¥ó¥¹¥È¡¼¥ë¤¹¤ë¤ªÏᣥС¼¥¸¥ç¥ó¤Ï 2011 ǯ 11 ·î 1 Æü¸½ºß¤ÇºÇ¿·¤Î¡¢11g Release 2¡£

°Ê¹ß¤ÎÀâÌÀ¤Ï CentOS ¤ä¤é Fedora ¤ä¤é¤Î RedHat·Ï¤Ê¤é¤À¤¤¤¿¤¤°ì½ï¤Î¤Ï¤º¡£


³µÍ×

Oracle Database Express Edition ¤Ï¡¢RDBMS ¤Î¥Ç¥Õ¥¡¥¯¥È¥¹¥¿¥ó¥À¡¼¥É¤Ç¤¢¤ë Oracle Database ¤Î̵½þÈÇ¡£Ìµ½þ¤Ê¤ê¤ÎÀ©Ìó¤Ï¤¢¤ë¤â¤Î¤Î¡¢¾®µ¬ÌϤʴĶ­¤Ç¤¢¤ì¤Ð½¼Ê¬¼ÂÍѤËÂѤ¨¤é¤ì¤ë¡£

À©Ìó¤Ï°Ê²¼¤Î¤È¤ª¤ê¡£

  • CPU ¤Ï 1 ¥³¥¢¤·¤«»È¤ï¤Ê¤¤
  • ¥¤¥ó¥¹¥¿¥ó¥¹¤Ï 1 ¤Ä¤Î¤ß
  • ¥æ¡¼¥¶¥Ç¡¼¥¿¤Ï 11 GB ¤Þ¤Ç
  • ¥á¥â¥ê¤Ï 1 GB ¤Þ¤Ç
  • HTTPS ¤Ï¥µ¥Ý¡¼¥È¤µ¤ì¤Ê¤¤

¥À¥¦¥ó¥í¡¼¥É¤È»²¾È¥É¥­¥å¥á¥ó¥È

Oracle ¤Î Web ¥µ¥¤¥È¤«¤é¥¤¥ó¥¹¥È¡¼¥ëÍѤΥѥ屡¼¥¸¡Êº£²ó¤Ï x64 ´Ä¶­ÍѤΠ*.rpm.zip¡Ë¤ò¥À¥¦¥ó¥í¡¼¥É¤·¤Æ¤¯¤ë¡£

¥¤¥ó¥¹¥È¡¼¥ë¤Ë¤¢¤¿¤Ã¤Æ»²¾È¤¹¤Ù¤­¥É¥­¥å¥á¥ó¥È¤Ï¤³¤³¡£±Ñ¸ì¤·¤«¤Ê¤¤¤ß¤¿¤¤¡£»ÅÊý¤Ê¤¤¡£

´Ä¶­¤Î³Îǧ

ºÇ½é¤Ë¥¤¥ó¥¹¥È¡¼¥ë¤ÎÍ×·ï¤ò³Îǧ¡£¥½¡¼¥¹¤Ï¸ø¼°¥É¥­¥å¥á¥ó¥È¡£

¥·¥¹¥Æ¥à¤ÎÍ×·ï

RHEL6 ¤ËÂбþ¤·¤Æ¤¤¤Ê¤¤¡Ä¡Ä ¤À¤È¡Ä¡Ä¡£¤Þ¤¢¤É¤¦¤Ë¤«¤Ê¤ë¤À¤í¤¦¡£¤¿¤Ö¤ó¡£¤È»×¤Ã¤Æ¤ä¤Ã¤¿¤é¤É¤¦¤Ë¤«¤Ê¤Ã¤¿¤Î¤ÇÂç¾æÉס£

¤¶¤Ã¤¯¤ê½ñ¤¯¤È¡¢OS ¤¬ OEL ¤Î 4 ¤« 5¡¢RHEL 4 ¤« 5¡¢SUSE ¤Î 10 ¤« 11¡£´ë¶ÈÁê¼ê¤À¤·¤³¤¦¤Ê¤ë¤ï¤Í¡£

RAM ¤ÏºÇÄã¤Ç 256MB¡£512MB °Ê¾å¤ò¿ä¾©¡£HDD ¤Î¶õ¤­¤Ï 1.5GB¡£

ɬÍפʥѥ屡¼¥¸¤Ï°Ê²¼¤Î¤È¤ª¤ê¡£¤Ê¤±¤ì¤Ð yum ¤Ç¤¢¤é¤«¤¸¤áÆþ¤ì¤Æ¤ª¤¯¡£

  • ¥Ñ¥Ã¥±¡¼¥¸¤ÎÍ×·ï
    ¥Ñ¥Ã¥±¡¼¥¸¥Ð¡¼¥¸¥ç¥ó
    glibc2.3.4-2.41 °Ê¾å
    make3.80 °Ê¾å
    binutils2.16.91.0.5 °Ê¾å
    gcc4.1.2 °Ê¾å
    libaio0.3.104 °Ê¾å

SWAP Îΰè¤ÎÍ×·ï

2GB ¤« RAM ¤ÎÆóÇܤΤɤÁ¤é¤«¾¯¤Ê¤¤¤Û¤¦¤À¤±É¬Íס¢¤À¤½¤¦¡£

³Îǧ¤·¤Þ¤·¤ç¤¦¡£

  • SWAP Îΰè¤Î³Îǧ

¥«¡¼¥Í¥ë¥Ñ¥é¥á¡¼¥¿Í×·ï

¥«¡¼¥Í¥ë¥Ñ¥é¥á¡¼¥¿¤âÍ׳Îǧ¡£¤È¤Ï¤¤¤¨Í×·ï¤è¤ê¾¯¤Ê¤«¤Ã¤¿¤é¥¤¥ó¥¹¥È¡¼¥é¤¬¾¡¼ê¤Ë½¤Àµ¤·¤Æ¤¯¤ì¤ë¤è¤¦¤Ê¤Î¤Ç¤¢¤Þ¤êµ¤¤Ë¤·¤Ê¤¯¤Æ¤â¤¤¤¤¤«¤â¤·¤ì¤Ê¤¤¡£

³Îǧ¤·¤Þ¤·¤ç¤¦¡£

  • ¥«¡¼¥Í¥ë¥Ñ¥é¥á¡¼¥¿¤Î³Îǧ
    
    
    • ¥ê¥ó¥¯Àè¤Î¥É¥­¥å¥á¥ó¥È¤ò»²¾È¤·¤ÆÁ´Éô¸«¤ë

¤â¤·¼êư¤Ç½¤Àµ¤ò¤«¤±¤ë¾ì¹ç¤Ï°Ê²¼¤Î¥Õ¥¡¥¤¥ë¤òÊÔ½¸¤¹¤ë¡£

  • /etc/sysctl.conf ¤ËÄɵ­¤·¤Æ¤¤¤¯

¼êư¤Ç½¤Àµ¤·¤¿¤é¡¢ºÆµ¯Æ°¤¹¤ë¤«°Ê²¼¤ò¼Â¹Ô¤·¤ÆÀßÄê¤òÈ¿±Ç¤µ¤»¤ë¡£

  • sysctl.conf ¤ÎÈ˱É
    sysctl -p
    

¸¢¸Â¤ÎÍ×·ï

¥¤¥ó¥¹¥È¡¼¥ë»þ¤Ï root ¤Ç¤Í¡¢¤È¡£

¥¤¥ó¥¹¥È¡¼¥ë

´Ä¶­¤¬ÌäÂê¤Ê¤±¤ì¤Ð¥¤¥ó¥¹¥È¡¼¥ë¡£°Ê²¼¤ò½çÈ֤ˤä¤Ã¤Æ¤¤¤¯¡£

¥Ñ¥Ã¥±¡¼¥¸¤Î¥¤¥ó¥¹¥È¡¼¥ë¤È¹½À®

  1. root ¤Ë¤Ê¤ë
    su -
    
  2. ¥À¥¦¥ó¥í¡¼¥É¤·¤¿ zip ¥Õ¥¡¥¤¥ë¤ò²òÅष¤Æ¥¤¥ó¥¹¥È¡¼¥ë¤¹¤ë
  3. ɬÍפʽé´üÀßÄê¤ò¤¹¤ë
    
    
    • ÆþÎϤ¹¤ë¾ðÊó¤Ï°Ê²¼¡£
      • Oracle Application Express¡ÊWeb ¥Ù¡¼¥¹¤Î´ÉÍý UI¡Ë¤¬»È¤¦ HTTP ¥Ý¡¼¥È¡Ê8080¡Ë
      • ¥ê¥¹¥Ê¤Î´Æ»ë¥Ý¡¼¥È¡Ê1521¡Ë
      • SYS ¤È SYSTEM ¤Î¥Ñ¥¹¥ï¡¼¥É
      • ¥·¥¹¥Æ¥àµ¯Æ°»þ¤Î¼«Æ°¼Â¹Ô¤ÎÀßÄê
  4. ÂÔ¤Ä
    • Installation completed successfully. ¤Ã¤Æ½Ð¤¿¤é´°Î»¡£¤¹¤Ç¤Ë¥ê¥¹¥Ê¤âΩ¤Á¾å¤¬¤Ã¤Æ¤¤¤ë

´Ä¶­ÊÑ¿ô¤ÎÀßÄê

¥Ç¡¼¥¿¥Ù¡¼¥¹¤Î¼Â¹Ô¤ËɬÍפʴĶ­ÊÑ¿ô¤ÎÀßÄê¡£

¼ê¤ÇÀßÄꤷ¤Æ¤â¤¤¤¤¤ó¤À¤±¤É¡¢¤´ÃúÇ«¤Ë¥¹¥¯¥ê¥×¥È¤¬ÍѰդµ¤ì¤Æ¤¤¤ë¤Î¤Ç¡¢¤³¤ì¤òɬÍפʥ桼¥¶¤Î ~/.bash_profile ¤«¤é¸Æ¤Ó½Ð¤¹¤è¤¦¤Ë¤¹¤ë¡£

  1. ~/.bash_profile ¤ËÄɵ­¤¹¤ë
    . /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh
    
  2. ³Îǧ¤¹¤ë

Àܳ³Îǧ

¤³¤³¤Þ¤Ç¤Ç¤­¤¿¤éÀܳ³Îǧ¡£¤Þ¤º¤Ï¥í¡¼¥«¥ë´Ä¶­¤Ç SQL*Plus ¤«¤éÁàºî¤Ç¤­¤ë¤«³Îǧ¤¹¤ë¡£

  1. SQL*Plus ¤Îµ¯Æ°
    sqlplus /nolog
    
    • ¤³¤Î»þÅÀ¤Çµ¯Æ°¤Ç¤­¤Ê¤±¤ì¤Ð²¿¤«¤¬¤ª¤«¤·¤¤¡£¤À¤¤¤¿¤¤¤Î¾ì¹ç´Ä¶­ÊÑ¿ô¤ÎÀßÄꤢ¤¿¤ê¤À¤È»×¤ï¤ì¤ë¤Î¤ÇºÆ³Îǧ
  2. Àܳ³Îǧ

´ÉÍý UI ¤Î¹½À®

¤³¤Î»þÅÀ¤Ç¤¹¤Ç¤Ë´Ä¶­¤Ï¤Ç¤­¤¢¤¬¤Ã¤Æ¤¤¤ë¤Î¤Ç¡¢°Ê¹ß¤Ï SQL*Plus ¤òΩ¤Á¾å¤²¤ì¤Ð²¿¤Ç¤â¤Ç¤­¤ë¡£

¤Ç¡¢XE ¤Ë¤Ïɸ½à¤Ç Web ¥Ù¡¼¥¹¤Î´ÉÍý UI ¤¬¤Ä¤¤¤Æ¤¯¤ë¤ó¤À¤±¤É¡¢¤³¤ì¤Ïɸ½à¤Ç¤Ï¥í¡¼¥«¥ë´Ä¶­¤«¤é¤·¤«¥¢¥¯¥»¥¹¤Ç¤­¤Ê¤¤¡£¤³¤ì¤ò¥ê¥â¡¼¥È¤«¤é¤Ç¤â¥¢¥¯¥»¥¹¤Ç¤­¤ë¤è¤¦¤ËÀßÄꤹ¤ë¡£

¤¿¤À¤· XE ¤Ç¤Ï HTTPS ¤¬¥µ¥Ý¡¼¥È¤µ¤ì¤Ê¤¤¤Î¤Ç¡¢´ÉÍý UI ¤È¤Î¤ä¤ê¤È¤ê¤Ï°Å¹æ²½¤µ¤ì¤Ê¤¤¡£¤³¤Î´ÉÍý UI ¤ò»È¤¦ºÝ¤Ï DBA ¸¢¸Â¤Ç¥í¥°¥¤¥ó¤¹¤ëɬÍפ¬¤¢¤ë¤ó¤À¤±¤É¡¢¤³¤Î»þ¤Î¥Ñ¥¹¥ï¡¼¥É¤âÅöÁ³°Å¹æ²½¤µ¤ì¤Ê¤¤¤³¤È¤Ë¤Ê¤ë¤Î¤Ç¡¢8080 È֥ݡ¼¥È¤Î¸ø³«ÈϰϤϿµ½Å¤Ë¹Í¤¨¤Ê¤¤¤È¤¤¤±¤Ê¤¤¡£¥Õ¥¡¥¤¥¢¥¦¥©¡¼¥ë¤ÎÀßÄê¤â¤ï¤¹¤ì¤º¤Ë¡£

  1. SQL*Plus ¤Îµ¯Æ°
  2. ÀßÄê

ÀßÄꤷ¤¿¤é¡¢¥Í¥Ã¥È¥ï¡¼¥¯¾å¤ÇÆÏ¤¯ÈÏ°ÏÆâ¤Î¥Û¥¹¥È¤«¤é¤Ç¤¢¤ì¤Ð°Ê²¼¤Î URL ¤Ç¥¢¥¯¥»¥¹²Äǽ¡£

  • ´ÉÍý UI ¤Î URL
    http://<ip-addr>:8080/apex/f?p=4950
    
    • ´ÉÍý²èÌÌ¤ËÆþ¤ëºÝ¤Ï SYSTEM ¥¢¥«¥¦¥ó¥È¤Ç¥í¥°¥¤¥ó¤¹¤ì¤Ð¤è¤¤
  • Oracle Application Express ¤Î URL
    http://<ip-addr>:8080/apex/
    
    • ¤³¤ì¤Ï Oracle DB ¤òÍøÍѤ·¤¿¥¢¥×¥ê¥±¡¼¥·¥ç¥ó³«È¯¤Ç»È¤¦ Web ¥¢¥×¥ê¥±¡¼¥·¥ç¥ó¡£¾ÜºÙ¤Ï¤°¤°¤ë¤Ã¤¿¤ê¥É¥­¥å¥á¥ó¥È¸«¤¿¤ê¤¹¤ì¤Ð¤ï¤«¤ë

µ¯Æ°¤È½ªÎ»

¼êư¤Çµ¯Æ°¤È½ªÎ»¤ò¤¹¤ë¾ì¹ç¡¢¤¢¤ë¤¤¤Ï¼«Æ°¼Â¹Ô¤òÀßÄꤷ¤Ê¤ª¤¹¾ì¹ç¤Ê¤É¤Ï°Ê²¼¤ÎÄ̤ꡣ´ðËܤǤ¹¤Í¡£

  • ¥³¥Þ¥ó¥É¤«¤éµ¯Æ°¤ä½ªÎ»¤ò¤¹¤ë
  • ¼«Æ°¼Â¹Ô¤ò¹½À®¤¹¤ë

¥¯¥é¥¤¥¢¥ó¥È¤ÎÀßÄê

¥µ¡¼¥Ð¤¬Ìµ»ö¤Ë¹½ÃۤǤ­¤¿¤é¡¢¥¯¥é¥¤¥¢¥ó¥È¡ÊÊ̤ÎʪÍý¥Þ¥·¥ó¡Ë¤«¤é¤â SQL*Plus ¤Ç¤Ä¤Ê¤¬¤ë¤è¤¦¤Ë¤·¤Æ¤ª¤¯¤È²¿¤«¤È³Ú¡£¾ÜºÙ¤ÏÊÌ¥Ú¡¼¥¸¤Ë¡£

¤â¤Á¤í¤ó¡¢¤ï¤¶¤ï¤¶¥¯¥é¥¤¥¢¥ó¥È¥Þ¥·¥ó¤Ë SQL*Plus ¤òÆþ¤ì¤ë¤Î¤¬·ù¤Ê¤é¡¢SSH ¤Ç¥µ¡¼¥Ð¤Ë¤Ä¤Ê¤¤¤Ç¤«¤é¥µ¡¼¥Ð¾å¤Ç SQL*Plus ¤òÁö¤é¤»¤ë¤Î¤Ç¤âÌäÂê¤Ê¤¤¡£

±¿ÍÑ

´Ä¶­¤¬¤Ç¤­¤¿¤é±¿ÍÑ¡£Î㤨¤Ð¥Ç¥Õ¥©¥ë¥È¤ÇɽÎΰè USERS ¤¬¤¢¤ë¤±¤É¤µ¤é¤ËÄɲä·¤¿¤ê¡¢¥æ¡¼¥¶¤òÄɲä·¤¿¤ê¸¢¸Â¤òÍ¿¤¨¤¿¤ê¡¢¤¤¤í¤¤¤í¤È¤ä¤ë¤Ù¤­¤³¤È¤Ï¤¢¤ë¡£ÊÌ¥Ú¡¼¥¸¤Ë¥³¥Þ¥ó¥É¤Ë¤è¤ë´ÉÍýÁàºî¤ò¤Þ¤È¤á¤Æ¤¢¤ë¤Î¤ÇŬµ¹»²¾È¤Î¤³¤È¡£

  • DB/Oracle/¥³¥Þ¥ó¥É
    • ±¿ÍѤä´ÉÍý¤Î¤¿¤á¤Î¥³¥Þ¥ó¥ÉÁàºî
    • ¥æ¡¼¥¶ºîÀ®¡¢É½ÎΰèºîÀ®¤Ê¤É
  • DB/SQL
    • SQL ʸ¤Î´ðÁÃŪ¤Ê¤È¤³¤í

¾å¤Î¥Ú¡¼¥¸¤Ï XE ¤Ç¤Ï¤Ê¤¤À½ÉÊÈǤΠ11g ¤ò¥Ù¡¼¥¹¤Ë½ñ¤¤¤¿¤Î¤Ç¼ã´³°ã¤¦¤È¤³¤í¤â¤¢¤ë¤«¤â¤·¤ì¤Ê¤¤¡£¤Ç¤â¤À¤¤¤¿¤¤´ðËܤϰì½ï¤Î¤Ï¤º¡£


Last-modified: 2011-11-08 (²Ð) 11:47:19