DB/Oracle/Instant Client
Ìܼ¡†
XE ¤òΩ¤Æ¤¿¥µ¡¼¥Ð¤Ë¤Û¤«¤Î¥Þ¥·¥ó¤Î SQL*Plus ¤«¤é¤µ¤ï¤ì¤ë¤è¤¦¤Ë¤¹¤ë¡£SQL*Plus ¤½¤Î¤â¤Î¤Ï Oracle Instant Client ¤Ã¤Æ¤¤¤¦¥Ñ¥Ã¥±¡¼¥¸¤È¤·¤Æ Oracle ¤µ¤ó¤¬¸ø³«¤·¤Æ¤¯¤ì¤Æ¤¤¤ë¤Î¤Ç¡¢¤³¤³¤Ç¤Ï¤½¤Î¥¤¥ó¥¹¥È¡¼¥ëÊýË¡¤òÀâÌÀ¡£
»²¾È¥É¥¥å¥á¥ó¥È†
SQL*Plus ¤Î¥æ¡¼¥¶¡¼¥º¥¬¥¤¥É¤È¥ê¥Õ¥¡¥ì¥ó¥¹¤ÎÃæ¤Ë Instant Client ¤Î²òÀ⤬¤¢¤ë¤Î¤Ç¤½¤³¤ò»²¾È¡£¥¤¥ó¥¹¥È¡¼¥ë¤Î¼ê½ç¤â½ñ¤¤¤Æ¤¢¤ë¡£
¥¤¥ó¥¹¥È¡¼¥ë†
¥¤¥ó¥¹¥È¡¼¥é¤Ç¤µ¤¯¤Ã¤È½ª¤ï¤ë¤«¤È»×¤¤¤¤ä°Õ³°¤È¤ä¤ä¤³¤·¤«¤Ã¤¿¡£¥¤¥ó¥¹¥È¡¼¥é¤Ê¤ó¤Æ¤Ê¤«¤Ã¤¿¡£
Windows ´Ä¶¤Ç¤Î¥¤¥ó¥¹¥È¡¼¥ë†
¥À¥¦¥ó¥í¡¼¥É¤ÈŸ³«†
- ɬÍפʥե¡¥¤¥ë¤Î¥À¥¦¥ó¥í¡¼¥É
- Instant Client ¤Î¥À¥¦¥ó¥í¡¼¥É¥Ú¡¼¥¸ ¤«¤é³Æ OS ¤Î¥Ú¡¼¥¸¤Ë¿Ê¤à
- instantclient-basic-*.zip ¤È instantclient-sqlplus-*.zip ¤ÎÆó¤Ä¤ò¥À¥¦¥ó¥í¡¼¥É¤¹¤ë
- ²òÅह¤ë
- ¹¥¤¤Ê¤È¤³¤í¤Ë¿Æ¥Ç¥£¥ì¥¯¥È¥ê¤ò¤Ä¤¯¤ë
- ¤É¤³¤Ç¤â¤¤¤¤¤Î¤ÇÎ㤨¤Ð [c:\tools\sqlplus] ¤È¤«
- ¥À¥¦¥ó¥í¡¼¥É¤·¤¿Æó¤Ä¤Î zip ¥Õ¥¡¥¤¥ë¤ÎÃæ¿È¤ò¿Æ¥Ç¥£¥ì¥¯¥È¥êÆâ¤Ë²òÅह¤ë
- ¹¥¤¤Ê¤È¤³¤í¤Ë¿Æ¥Ç¥£¥ì¥¯¥È¥ê¤ò¤Ä¤¯¤ë
¹½À®ÀßÄê†
- ´Ä¶ÊÑ¿ô¤ÎÀßÄê
- ´Ä¶ÊÑ¿ô PATH ¤Ë SQL*Plus ¤òÊü¤ê¹þ¤ó¤À¥Ç¥£¥ì¥¯¥È¥ê¡Ê¤³¤³¤Ç¤Ï [c:\tools\sqlplus\]¡Ë¤òÄɲ乤ë
¥Í¥Ã¥È¥µ¡¼¥Ó¥¹Ì¾¤ÎÅÐÏ¿†
- ŬÅö¤Ê¾ì½ê¤Ë tnsnames.ora ¤ò¤Ä¤¯¤Ã¤ÆÊݸ¤¹¤ë
- º£²ó¤Ï [c:\tools\sqlplus\admin\tnsnames.ora] ¤Ë¤·¤¿
- Ãæ¿È¤Ï¤³¤ó¤Ê¤ó¡£XE ¤Î¥µ¡¼¥Ó¥¹Ì¾¤Ï ORCL ¤¸¤ã¤Ê¤¯¤Æ XE ¤À¤Ã¤¿
<net-service-name> = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = <ip-addr>)(PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = XE) ) )
- ´Ä¶ÊÑ¿ô¤ÎÄɲÃ
- ´Ä¶ÊÑ¿ô TNS_ADMIN ¤È¤·¤Æ tnsnames.ora ¤Î¤¢¤ë¥Ç¥£¥ì¥¯¥È¥ê¤ò»ØÄꤹ¤ë¡£º£²ó¤Ï [c:\tools\sqlplus\admin\]¡£
Àܳ³Îǧ†
- ¥³¥Þ¥ó¥É¥×¥í¥ó¥×¥È¤«¤é SQL*Plus ¤òµ¯Æ°¤¹¤ë
sqlplus /nolog
- ¤³¤Î»þÅÀ¤Çµ¯Æ°¤Ç¤¤Ê¤±¤ì¤Ð¥Ñ¥¹¤¬Ä̤äƤʤ¤¤Ã¤Æ¤³¤È¤Ê¤Î¤ÇºÆ³Îǧ
- Àܳ³Îǧ
-- ¤Ò¤È¤Þ¤º´Ê°×Àܳ¤Ç³Îǧ¡£ÊÌ¤Ë sysdba ¤¸¤ã¤Ê¤¯¤Æ¤â¤¤¤¤¤Î¤è conn sys@<ip-addr>:1521 as sysdba -- ¤Ç¤¤¿¤é¥Í¥Ã¥È¥µ¡¼¥Ó¥¹Ì¾¤ÇÀܳ³Îǧ conn sys@<net-service-name> as sysdba
ÊØÍø¤Ê¾ðÊó†
Linux ´Ä¶²¼¤Ç¾å²¼º¸±¦¤Î¥«¡¼¥½¥ë¤ä¥³¥Þ¥ó¥ÉÍúÎò¤ò͸ú¤Ë¤¹¤ë†
Linux ´Ä¶¤Ç SQL*Plus ¤ò»È¤Ã¤Æ¤¤¤Æ¥¹¥È¥ì¥¹¤¬¤¿¤Þ¤ë¤Î¤¬¡¢¾å²¼¥¡¼¤ÇÍúÎò¤ò¤¿¤É¤ì¤Ê¤¤¾å¤Ëº¸±¦¥¡¼¤â¸ú¤«¤Ê¤¤¤È¤¤¤¦ÅÀ¡£¥¹¥È¥ì¥¹¥Õ¥ë¤¹¤®¤Æ¥¢¥ì¤À¤Ã¤¿¤Î¤ÇÄ´¤Ù¤¿¤é¡¢ÅöÁ³¤Î¤³¤È¤Ê¤¬¤éƱ»Ö¤¬¤¤¤Ã¤Ñ¤¤¤¤¤Æ¡¢²ò·èºö¤â¤¢¤Ã¤¿¡£Ä¶ÊØÍø¡£
³µÍ׆
Ä̾ï¤Î¥·¥§¥ë¤Ç¥«¡¼¥½¥ë¥¡¼¤È¤«¥³¥Þ¥ó¥ÉÍúÎò¡ÊCtrl + R¡Ë¤È¤«»È¤¨¤ë¤Î¤Ï readline ¤Ã¤Æ¤¤¤¦¤â¤Î¤¬Æ°¤¤¤Æ¤ë¤«¤é¤Ê¤ó¤À¤±¤É¡¢²æ¤é¤¬ SQL*Plus ¤Ï readline ¤ËÂбþ¤·¤Æ¤Ê¤¤¤Ã¤Æ¤¤¤¦Ïá£
¤Ç¡¢¤¢¤ê¤È¤¢¤é¤æ¤ë¤â¤Î¤ò readline Âбþ¤Ë¤¹¤ëĶÊØÍø¤Ê rlwrap ¤È¤¤¤¦¥é¥Ã¥Ñ¤¬¤¢¤ë¤Î¤Ç¤½¤ì¤ò»È¤¦¤Ã¤ÆÏá£
¥À¥¦¥ó¥í¡¼¥É¤È¥¤¥ó¥¹¥È¡¼¥ë†
¥ê¥Ý¥¸¥È¥ê¤Ë¤è¤Ã¤Æ¤Ï yum ¤ÇÆþ¤ë¡£Æþ¤é¤Ê¤¤¾ì¹ç¤Ï rpm ¤òõ¤·¤Æ»ý¤Ã¤Æ¤¯¤ë¤«¡¢¥½¡¼¥¹¤«¤é¥Ó¥ë¥É¤¹¤ë¡£
- yum ¤ÇÆþ¤ì¤é¤ì¤¿¤éÆþ¤ì¤ë
yum install rlwrap
- ¤Ê¤«¤Ã¤¿¤é¥½¡¼¥¹¤ò»ý¤Ã¤Æ¤¯¤ë¡£ÌÌÅݤÀ¤Ã¤¿¤é¤°¤°¤ì¤Ð¤É¤³¤«¤Ë rpm ¤¬¤¢¤ë¤Ï¤º¤À¤«¤é¤½¤ì¤Ö¤Á¤³¤ó¤Ç¤â¤è¤¤
- ¤Æ¤¤È¤¦¤Ë¤³¤³¤é ¤«¤é¥À¥¦¥ó¥í¡¼¥É
- ²òÅष¤Æ¥Ó¥ë¥É¤·¤Æ¥¤¥ó¥¹¥È¡¼¥ë¤¹¤ë
-- ²òÅà tar zxvf rlwrap-0.37.tar.gz -- °ÜÆ° cd rlwrap-0.37 -- ¥Ó¥ë¥É¤·¤Æ¥¤¥ó¥¹¥È¡¼¥ë ./configure make make install
»È¤¤Êý†
¼Â¹Ô¤·¤¿¤¤¥³¥Þ¥ó¥É¤ÎÁ°¤Ë rlwrap ¤ò¤¯¤Ã¤Ä¤±¤ë¤À¤±¡£
- ¼Â¹ÔÊýË¡¤ÎÎã
rlwrap sqlplus /nolog
Ëè²ó¤³¤ì¤ò¤ä¤ë¤Î¤¹¤éÌÌÅݤÀ¤Ã¤¿¤é¥¨¥¤¥ê¥¢¥¹¤ò¤Ä¤¯¤ì¤Ð¤µ¤é¤ËÊØÍø¡£
- ~/.bashrc ¤Ë
alias sqlplus='rlwrap sqlplus'
¤³¤¦¤¹¤ë¤È¥·¥§¥ë¤Ç»È¤¨¤ë¥¡¼¥Ü¡¼¥É¥·¥ç¡¼¥È¥«¥Ã¥È¤Ã¤Ý¤¤¤Î¤Ï¤À¤¤¤¿¤¤»È¤¨¤ë¡£Ä¶ÊØÍø¡£
Last-modified: 2011-11-02 (¿å) 09:45:46