Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

eclipseÖÐÁ¬½ÓoracleµÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

eclipse 3.3Æô¶¯web¹¤³Ì£¬ÒªÁ¬½Óoracle9iÊý¾Ý¿â±¨

ÑÏÖØ: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12518, TNS:listener could not hand off client connection
The Connection descriptor used by the client was:
localhost:1521:orcl
)

¿ÉÊÇͨ¹ýpl/sqlµÈ¹¤¾ß²Ù×÷Êý¾Ý¿âûÓÐÎÊÌâ¡£ÖØ×°Êý¾Ý¿â»¹ÊDz»ÐУ¬»»eclipseÒ²²»ÐУ¬¶¼ÊÇÕâ¸öÎÊÌâ
¿´ÉÏÈ¥¾ÍÊÇÏîÄ¿ÀïÅäÖÃÎļþд´íÁË¡£¡£

¿´¿´ÅäÖÃÎļþ°É

ÎÒËùÓÐÁ¬½ÓoracleµÄÏîÄ¿¶¼³öÁËÕâ¸öÎÊÌ⣬²»ÊÇÒ»¸ö¹¤³Ì£¬¶øÇÒ֮ǰ¶¼ÊÇ¿ÉÓõġ£
ʹÓñðµÄÊý¾Ý¿âµÄÏîĿҲûÓÐÎÊÌ⣬Á¬½Óµ½·Ç±¾µØ¿âÒ²²»»á³öÕâ¸öÎÊÌâ¡£

localhost:1521:orcl 
¸ÄΪ
127.0.0.1:1521:ORCL
ÊÔÊÔ¿´£¿


ÁíÍâÊÇ·ñÄãµÄ±¾µØÃ»ÓÐORCLÕâ¸öSID°¡

ÒýÓÃ
localhost:1521:orcl
¸ÄΪ
127.0.0.1:1521:ORCL
ÊÔÊÔ¿´£¿


ÎÒÊÔÁ˲»ºÃʹ£¬ÎÒÓÃPL/SQL devÊÇ¿ÉÒÔ´ò¿ª±¾µØµÄÕâ¸ösid
¶øÇÒ²»Ö»ÊÇÕâ¸ösid£¬±¾µØµÄÆäËüµÄÒ²²»ÐС£

ÏÖÔÚ¾ÍÊǹ¤³Ì²»ÄÜÁª½ÓOracleÊý¾Ý¿â£¬Ö®Ç°¶¼ÊÇ¿ÉÒÔÓõŤ³Ì

ÒýÓÃ
ÎÒÊÔÁ˲»ºÃʹ£¬ÎÒÓÃPL/SQL devÊÇ¿ÉÒÔ´ò¿ª±¾µØµÄÕâ¸ösid
¶øÇÒ²»Ö»ÊÇÕâ¸ösid£¬±¾µØµÄÆäËüµÄÒ²²»ÐС£

ÏÖÔÚ¾ÍÊǹ¤³Ì²»ÄÜÁª½ÓOracleÊý¾Ý¿â£¬Ö®Ç°¶¼ÊÇ¿ÉÒÔÓõŤ³Ì


°Ñ±¾µØµÄ·À»ðǽ¹ØÁËÊÔÊÔ¿´¡£
ÁíÍâ£¬ÖØÐÂÅäÖÃһϷþÎñÃû¡£

¿´Êý¾Ý¿âµÄ¼àÌýÊÇ·ñ´ò¿ª¡£

ÁíÍâºÃÏñͨ¹ýeclipseÁ¬½ÓµÄsidÃû³ÆÊDz»Çø·Ö´óСдµÄ¡£

°ÑÄãµÄÁ¬¿âÓï¾äÌùÉÏÀ´¿


Ïà¹ØÎÊ´ð£º

ÊÇoracleµÄbugô£¿É¢·ÖÁË£¡ - Oracle / »ù´¡ºÍ¹ÜÀí

±¾À´ÒªÐ´¸öupdateÓï¾ä
update table_a A
  set A.flag=1
  where A.id in (select B.id from table_b B)
½á¹ûÎóд³É
update table_a A
  set A.flag=1
  where ......

OracleÀëÏß·ÃÎÊ---ÇóÖú - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄԭʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
    ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

oracle²¢·¢´¦ÀíSOS - Oracle / ¿ª·¢

ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾ­ºÜ³ÉÊìÁË

ÒýÓÃ
oracle ......

server 2000Êý¾Ý×ªÒÆµ½oracle - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔ­À´oracleÀïµÄÔ­ÓеÄÊý¾Ý¿â,Ö»ÄÜн¨

ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ