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 ¤Ç¤¢¤é¤«¤¸¤áÆþ¤ì¤Æ¤ª¤¯¡£
- ¥Ñ¥Ã¥±¡¼¥¸¤ÎÍ×·ï
¥Ñ¥Ã¥±¡¼¥¸ ¥Ð¡¼¥¸¥ç¥ó glibc 2.3.4-2.41 °Ê¾å make 3.80 °Ê¾å binutils 2.16.91.0.5 °Ê¾å gcc 4.1.2 °Ê¾å libaio 0.3.104 °Ê¾å
SWAP Îΰè¤ÎÍ×·ï †
2GB ¤« RAM ¤ÎÆóÇܤΤɤÁ¤é¤«¾¯¤Ê¤¤¤Û¤¦¤À¤±É¬Íס¢¤À¤½¤¦¡£
³Îǧ¤·¤Þ¤·¤ç¤¦¡£
- SWAP Îΰè¤Î³Îǧ
¥«¡¼¥Í¥ë¥Ñ¥é¥á¡¼¥¿Í×·ï †
¥«¡¼¥Í¥ë¥Ñ¥é¥á¡¼¥¿¤âÍ׳Îǧ¡£¤È¤Ï¤¤¤¨Í×·ï¤è¤ê¾¯¤Ê¤«¤Ã¤¿¤é¥¤¥ó¥¹¥È¡¼¥é¤¬¾¡¼ê¤Ë½¤Àµ¤·¤Æ¤¯¤ì¤ë¤è¤¦¤Ê¤Î¤Ç¤¢¤Þ¤êµ¤¤Ë¤·¤Ê¤¯¤Æ¤â¤¤¤¤¤«¤â¤·¤ì¤Ê¤¤¡£
³Îǧ¤·¤Þ¤·¤ç¤¦¡£
- ¥«¡¼¥Í¥ë¥Ñ¥é¥á¡¼¥¿¤Î³Îǧ
- ¥ê¥ó¥¯Àè¤Î¥É¥¥å¥á¥ó¥È¤ò»²¾È¤·¤ÆÁ´Éô¸«¤ë
¤â¤·¼êư¤Ç½¤Àµ¤ò¤«¤±¤ë¾ì¹ç¤Ï°Ê²¼¤Î¥Õ¥¡¥¤¥ë¤òÊÔ½¸¤¹¤ë¡£
- /etc/sysctl.conf ¤ËÄɵ¤·¤Æ¤¤¤¯
¼êư¤Ç½¤Àµ¤·¤¿¤é¡¢ºÆµ¯Æ°¤¹¤ë¤«°Ê²¼¤ò¼Â¹Ô¤·¤ÆÀßÄê¤òÈ¿±Ç¤µ¤»¤ë¡£
- sysctl.conf ¤ÎÈ˱É
sysctl -p
¸¢¸Â¤ÎÍ×·ï †
¥¤¥ó¥¹¥È¡¼¥ë»þ¤Ï root ¤Ç¤Í¡¢¤È¡£
¥¤¥ó¥¹¥È¡¼¥ë †
´Ä¶¤¬ÌäÂê¤Ê¤±¤ì¤Ð¥¤¥ó¥¹¥È¡¼¥ë¡£°Ê²¼¤ò½çÈ֤ˤä¤Ã¤Æ¤¤¤¯¡£
¥Ñ¥Ã¥±¡¼¥¸¤Î¥¤¥ó¥¹¥È¡¼¥ë¤È¹½À® †
- root ¤Ë¤Ê¤ë
su -
- ¥À¥¦¥ó¥í¡¼¥É¤·¤¿ zip ¥Õ¥¡¥¤¥ë¤ò²òÅष¤Æ¥¤¥ó¥¹¥È¡¼¥ë¤¹¤ë
- ɬÍפʽé´üÀßÄê¤ò¤¹¤ë
- ÆþÎϤ¹¤ë¾ðÊó¤Ï°Ê²¼¡£
- Oracle Application Express¡ÊWeb ¥Ù¡¼¥¹¤Î´ÉÍý UI¡Ë¤¬»È¤¦ HTTP ¥Ý¡¼¥È¡Ê8080¡Ë
- ¥ê¥¹¥Ê¤Î´Æ»ë¥Ý¡¼¥È¡Ê1521¡Ë
- SYS ¤È SYSTEM ¤Î¥Ñ¥¹¥ï¡¼¥É
- ¥·¥¹¥Æ¥àµ¯Æ°»þ¤Î¼«Æ°¼Â¹Ô¤ÎÀßÄê
- ÆþÎϤ¹¤ë¾ðÊó¤Ï°Ê²¼¡£
- ÂÔ¤Ä
- Installation completed successfully. ¤Ã¤Æ½Ð¤¿¤é´°Î»¡£¤¹¤Ç¤Ë¥ê¥¹¥Ê¤âΩ¤Á¾å¤¬¤Ã¤Æ¤¤¤ë
´Ä¶ÊÑ¿ô¤ÎÀßÄê †
¥Ç¡¼¥¿¥Ù¡¼¥¹¤Î¼Â¹Ô¤ËɬÍפʴĶÊÑ¿ô¤ÎÀßÄê¡£
¼ê¤ÇÀßÄꤷ¤Æ¤â¤¤¤¤¤ó¤À¤±¤É¡¢¤´ÃúÇ«¤Ë¥¹¥¯¥ê¥×¥È¤¬ÍѰդµ¤ì¤Æ¤¤¤ë¤Î¤Ç¡¢¤³¤ì¤òɬÍפʥ桼¥¶¤Î ~/.bash_profile ¤«¤é¸Æ¤Ó½Ð¤¹¤è¤¦¤Ë¤¹¤ë¡£
- ~/.bash_profile ¤ËÄɵ¤¹¤ë
. /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh
- ³Îǧ¤¹¤ë
Àܳ³Îǧ †
¤³¤³¤Þ¤Ç¤Ç¤¤¿¤éÀܳ³Îǧ¡£¤Þ¤º¤Ï¥í¡¼¥«¥ë´Ä¶¤Ç SQL*Plus ¤«¤éÁàºî¤Ç¤¤ë¤«³Îǧ¤¹¤ë¡£
- SQL*Plus ¤Îµ¯Æ°
sqlplus /nolog
- ¤³¤Î»þÅÀ¤Çµ¯Æ°¤Ç¤¤Ê¤±¤ì¤Ð²¿¤«¤¬¤ª¤«¤·¤¤¡£¤À¤¤¤¿¤¤¤Î¾ì¹ç´Ä¶ÊÑ¿ô¤ÎÀßÄꤢ¤¿¤ê¤À¤È»×¤ï¤ì¤ë¤Î¤ÇºÆ³Îǧ
- Àܳ³Îǧ
´ÉÍý UI ¤Î¹½À® †
¤³¤Î»þÅÀ¤Ç¤¹¤Ç¤Ë´Ä¶¤Ï¤Ç¤¤¢¤¬¤Ã¤Æ¤¤¤ë¤Î¤Ç¡¢°Ê¹ß¤Ï SQL*Plus ¤òΩ¤Á¾å¤²¤ì¤Ð²¿¤Ç¤â¤Ç¤¤ë¡£
¤Ç¡¢XE ¤Ë¤Ïɸ½à¤Ç Web ¥Ù¡¼¥¹¤Î´ÉÍý UI ¤¬¤Ä¤¤¤Æ¤¯¤ë¤ó¤À¤±¤É¡¢¤³¤ì¤Ïɸ½à¤Ç¤Ï¥í¡¼¥«¥ë´Ä¶¤«¤é¤·¤«¥¢¥¯¥»¥¹¤Ç¤¤Ê¤¤¡£¤³¤ì¤ò¥ê¥â¡¼¥È¤«¤é¤Ç¤â¥¢¥¯¥»¥¹¤Ç¤¤ë¤è¤¦¤ËÀßÄꤹ¤ë¡£
¤¿¤À¤· XE ¤Ç¤Ï HTTPS ¤¬¥µ¥Ý¡¼¥È¤µ¤ì¤Ê¤¤¤Î¤Ç¡¢´ÉÍý UI ¤È¤Î¤ä¤ê¤È¤ê¤Ï°Å¹æ²½¤µ¤ì¤Ê¤¤¡£¤³¤Î´ÉÍý UI ¤ò»È¤¦ºÝ¤Ï DBA ¸¢¸Â¤Ç¥í¥°¥¤¥ó¤¹¤ëɬÍפ¬¤¢¤ë¤ó¤À¤±¤É¡¢¤³¤Î»þ¤Î¥Ñ¥¹¥ï¡¼¥É¤âÅöÁ³°Å¹æ²½¤µ¤ì¤Ê¤¤¤³¤È¤Ë¤Ê¤ë¤Î¤Ç¡¢8080 È֥ݡ¼¥È¤Î¸ø³«ÈϰϤϿµ½Å¤Ë¹Í¤¨¤Ê¤¤¤È¤¤¤±¤Ê¤¤¡£¥Õ¥¡¥¤¥¢¥¦¥©¡¼¥ë¤ÎÀßÄê¤â¤ï¤¹¤ì¤º¤Ë¡£
- SQL*Plus ¤Îµ¯Æ°
- ÀßÄê
ÀßÄꤷ¤¿¤é¡¢¥Í¥Ã¥È¥ï¡¼¥¯¾å¤ÇÆÏ¤¯ÈÏ°ÏÆâ¤Î¥Û¥¹¥È¤«¤é¤Ç¤¢¤ì¤Ð°Ê²¼¤Î 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