linux°²×°oracle xeÔ¶³ÌÁ¬½ÓÎÊÌâ
ÎÒÔÚһ̨ÈËradhat 5.2·þÎñÆ÷ϰ²×°ÁËÒ»¸öoracle10g xeÊý¾Ý¿â£¬±¾µØÁ¬½ÓÒ²ÊÇ¿ÉÒԵ쬵«ÊDz»ÖªµÀÔõôµÄ£¬ÎÒÔ¶³ÌÁ¬½ÓÄÇ̨Êý¾Ý¿â£¬×ÜÊDZ¨´í£¬ÎÒ°´ÕÕÊéÉϽ²µÄ»·¾³±äÁ¿Ê²Ã´µÄ¶¼ÉèÖúÃÁ˰¡£¬¶øÕâ¸ö°æ±¾Ò²ÊÇÖ§³ÖÔ¶³ÌÊý¾Ý¿âÁ¬½ÓµÄ°¡£¬·À»ðǽÎÒÒ²¹ØÁË£¬ÕæµÄ²»ÖªµÀÄı߳öʲôÎÊÌ⣬Çë¸ßÊÖ°ï°ï棬Íò·Ö¸Ðл£¡£¡£¡
tnsnames.ora ÅäÖùýÁËû£¿
tnsping sid ÄÜ·ñpingͨ£¿
------------------------------------------------------------------------------
Blog£º http://blog.csdn.net/tianlesoftware
ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net
Ïà¹ØÊÓÆµ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q Ⱥ£º62697716
tnsnames.oraÅäÖùýÁË£¬pingÒ²ÊÇ¿ÉÒÔpingͨµÄ£¬¾ÍÊDz»ÖªµÀÄı߳öµÄÎÊÌâ
°Ñ±¨µÄ´íÌù³öÀ´...
------------------------------------------------------------------------------
Blog£º http://blog.csdn.net/tianlesoftware
ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net
Ïà¹ØÊÓÆµ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q Ⱥ£º62697716
´íÎó´úÂëÊÇora-12545
ÆÚ´ý¡£¡£
×Ô¼º¶¥ÏÂ
½ñÌìÓа²×°ÁËһ̨Êý¾Ý¿â£¬ÊÇÔÚred hat5.2ÏÂÃæ°²×°oracle11gµÄ£¬ÏÖÔÚ·¢ÏÖ»¹ÊÇÔ¶³ÌÁ¬½ÓÊý¾Ý¿âʵÏÖ²»ÁË£¬¶þ¥˵µÄtnsping sidÊÇÔÚ±¾µØµÄ»¹ÊÇÔÚÔ¶³Ì×öµÄ°¡£¿¸Õ¸ÕÔÚÔ¶³ÌµÄ·´Õý²»ÐУ¬´íÎóÊÇ£º
TNS-12545: ÒòÄ¿±êÖ÷»ú»ò¶ÔÏó²»´æÔÚ, Á¬½Óʧ°Ü
×Ô¼ºÔÙ¶¥ÏÂ
Ê×Ïȿͻ§»úÖ±½ÓpingÊý¾Ý¿âËùÔÚÖ÷»úµÄIP£¬¿´ÊÇ·ñͨµÄ¡£¡£¡£Í¨µÄ»°£¬
Ïà¹ØÎÊ´ð£º
¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮
ÎÒÉèÖÃÁËÒ»¸öoracle×ֶΣ¬varchar(3000),È»ºó²åÈëÒ»ÌõÊý¾Ý³¤¶È²Å1000,¾Í±¨´íÁË£®È磺net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
Caused ......
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿
ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..
ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......