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

¼±¾È£¡£¡£¡Ôõô¶¼Á¬½Ó²»µ½oracleÊý¾Ý¿â

2010-03-02 16:12:01,515 ERROR (Prototyper.java:105) - Prototype
java.sql.SQLException: Io Òì³£: The Network Adapter could not establish the connection
 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:254)
 at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:386)
 at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:413)
 at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:164)
 at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)
 at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:752)
 at java.sql.DriverManager.getConnection(DriverManager.java:582)
 at java.sql.DriverManager.getConnection(DriverManager.java:154)
 at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConnectionBuilder.java:39)
 at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159)
 at org.logicalcobwebs.proxool.Prototyper.sweep(Prototyper.java:102)
 at org.logicalcobwebs.proxool.PrototyperThread.run(PrototyperThread.java:44)


Ïà¹ØÎĵµ£º

oracle×¢ÊÍ£ºcomment onµÄÖØÒªÒâÒå

ÎÞÒÉ×¢ÊÍÏÖÔÚ¶¼±»´ó¼Ò½ÓÊܺÍÈϿɣ¬ÔÚ´ó¼Ò±à³ÌÓõÄIDEÖж¼Ìṩ»òÓеÚÈý·½²å¼þÀ´Ö§³ÖÌáȡעÊÍÄÚÈÝʵÏÖ
¿ìËÙÁ˽â½á¹¹µÄ¹¦ÄÜ¡£µ«ÔÚÊý¾Ý¿âµÄ½Å±¾±àд·½ÃæÎÒÒ²ÊǾ­ÀúÁ˰ٰãÕÛÄ¥ºó×ܽáÁËһЩ¶«Î÷·¢À´Óë´ó¼ÒÇд衣
ÏÂÃæÀ´¿´Ò»¸öOracle½¨±íµÄ·½Ê½¡£
create table ctable_name
(
     ......

oracleÌåϵ½á¹¹¶þÖ®±í¿Õ¼ä¡¢·½°¸¡¢¶Î¡¢Çø¡¢¿é

     Êý¾ÝÎļþºÍÈÕÖ¾ÎļþÊÇÊý¾Ý¿âÖÐ×îÖØÒªµÄÎļþ¡£ËüÃÇÊÇÊý¾Ý´æ´¢µÄµØ·½¡£Ã¿¸öÊý¾Ý¿âÖÁÉÙÓÐÒ»¸öÓëÖ®Ïà¹ØµÄÊý¾ÝÎļþ£¬Í¨³£Çé¿öϲ»Ö»Ò»¸ö£¬ÓкܶࡣÊý¾ÝÔÚÊý¾ÝÎļþÖÐÊÇÈçºÎ×éÖ¯µÄ£¿ÒªÁ˽âÕâЩÄÚÈÝÎÒÃÇÊ×ÏȱØÐëÀí½âʲôÊDZí¿Õ¼ä£¨tablespace£©¡¢¶Î£¨segment£©¡¢Çø£¨extent£©¡¢¿é£¨block£©£¬ÕâЩ¶¼ÊÇoracl ......

Oracle×ܽá


Oracle
Ò»¡¢Êý¾Ý¿âÓïÑÔ£º
DCL:Êý¾Ý¿â¿ØÖÆÓïÑÔ(ÈçÊÂÎñ...)
DQL:Êý¾Ý¿â²éѯÓïÑÔ(select...)
DDL:Êý¾Ý¿â¶¨ÒåÓïÑÔ(create)
DML:Êý¾Ý¿â²Ù×÷ÓïÑÔ(¸üÐÂ....)
¶þ¡¢Oracle°æ±¾£º
Oracle8I   i£º»¥ÁªÍø
Oracle10g g£ºÍø¸ñ£º°Ñ¸´ÔÓµÄÎÊÌâ·Ö²¼´¦Àí£¬×îºó°Ñ½á¹û×ۺϳÉ×î×ܽá¹û
°Ñ¸´ÔÓµÄÎÊÌâ·Ö²¼´¦Àí£¬×îºó°Ñ½á¹û×Ûº ......

ʹÓÃimp/exp½øÐÐORACLEÊý¾Ý¿â±¸·ÝÓë»Ö¸´

 OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹Ô­Ó뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
 
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ ......

OracleÊý¾Ý¿âÖмǼ±»ÁíÒ»¸öÓû§Ëø×¡

oracleÊý¾Ý¿âÖÐÐÞ¸ÄÊý¾ÝʱÌáʾ“¼Ç¼±»ÁíÒ»¸öÓû§Ëø×¡” ½â¾ö·½·¨£º
1>²é¿´Êý¾Ý¿âËø,Õï¶ÏËøµÄÀ´Ô´¼°ÀàÐÍ£º
¡¡¡¡select object_id,session_id,locked_mode from v$locked_object;
      »òÕßÓÃÒÔÏÂÃüÁ
      select b.owner,b.object_name,l.ses ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ