Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 10g webµÇ½EMµÄÎÊÌ⣿ - Oracle / »ù´¡ºÍ¹ÜÀí

°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿

1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......

oracle 10g°²×°µ½85%ʱ±¨´í

¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿

ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..

ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......

OracleµÄblob×Ö¶ÎÎÊÌâ - Oracle / ¿ª·¢

²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......

oracle ×Ô¶¨Òå·Ö×é - Oracle / »ù´¡ºÍ¹ÜÀí

select sum£¨a.t)from ta a group by ta.a,ÕâÌõÓï¾ä½«±ítaÖеÄÊý¾Ý°´ÕÕa×ֶηÖ×é»ã×Üt×ֶΡ£
½á¹û±ÈÈ磺
3 30
4 50
ÎÒÏëµÃµ½Õâ¸ö½á¹û£º
1 0
2 0
3 30
4 50
5 0
Õâ¸ö½á¹û£¬ÇëÎÊsqlÓï¾äÔõôд£¿¶àл
nobody ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ