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

ÇóÖúÓÚOracle¸ßÊÖ

ÎÒÊÇÒ»¸öOracleÐÂÊÖ ÎÒ°²×°ÍêÈí¼þºó ÊäÈëScott ºÍtiger ºó×ÜÊǵ¯³ö
error£º
ora-12560:tns:ЭÒéÊÊÅäÆ÷´íÎó¡£
¶ÔÁË
ÇëÎÊÔõô²ÅÄܳ¹µ×ɾ³ýORACLE°¡
ÎÒûÓÐÕÒµ½×Ô¶¯É¾³ýµÄÄǸöÈí¼þ
лл´ó¼ÒÁË

windowÏ£¬ÓÃOUIɾ³ý£¬È»ºóɾ³ý×¢²á±í

Äã¿ÉÒÔgһϣ¬ÍøÉÏÓв»ÉÙ½éÉܵÄ

error£º
ora-12560:tns:ЭÒéÊÊÅäÆ÷´íÎó¡£

Ó¦¸ÃÊÇÄãµÄ·þÎñûÓÐÆô¶¯¡£

ÒýÓÃ
windowÏ£¬ÓÃOUIɾ³ý£¬È»ºóɾ³ý×¢²á±í

Äã¿ÉÒÔgһϣ¬ÍøÉÏÓв»ÉÙ½éÉܵÄ

error£º
ora-12560:tns:ЭÒéÊÊÅäÆ÷´íÎó¡£

Ó¦¸ÃÊÇÄãµÄ·þÎñûÓÐÆô¶¯¡£


ÀàËÆ
OracleServiceSIDÕâÑùµÄ·þÎñûÓÐÆô¶¯¡£


¼àÌýÆ÷ÓëʵÀýÒªÆô¶¯²Å¿ÉÒÔÁ¬

OracleÍêÃÀÐ¶ÔØ²½Ö裺
1.ÓÃDBCAɾ³ýÊý¾Ý¿â
2.Í£Ö¹OracleËùÓеķþÎñ(Oracle Services)
3.ÓÃOracle Universal Installerɾ³ýOracle×é¼þ
4.ÊÖ¹¤É¾³ý×¢²á±íÖÐÓÚOracleÏà¹ØµÄÄÚÈÝ(ËÑË÷×¢²á±íÕÒµ½inst_locµÄÖµ£¬inst_locµÄֵͨ³£ÊÇC:\Program Files\Oracle\Inventory  ËÑË÷ÒÔOra¡¢Oracle¡¢Orcl¡¢EnumOra¿ª  Í·µÄÖµ²¢É¾³ý)
5.³ýÓëOracleÏà¹ØµÄ»·¾³±äÁ¿

×Ô¼º¶à×°¼¸´Î¾ÍÖªµÀÎÊÌâ³öÄÄÁË¡£¡£¡£

¼àÌý£¡£¡£¡

ÊÊÅäÆ÷ÄãÅä´íÁË£¬ÄãÔÙÅäÒ»¸ö¾Í¿ÉÒÔÁË¡£

È·±£¼àÌýºÍ·þÎñ¶¼Æô¶¯ÁË

ÔõôÆô¶¯·þÎñ°¡  ÎÒ²»¶®

ÔÙ»¨Îå¸öСʱѧϰһÏÂÎÊÌâ¾Í¸ãµôÁË
ŬÁ¦°É

Äãûװ·þÎñÆ÷°É£¬¹À¼ÆÖ»×°Á˿ͻ§¶Ë

×î¼òµ¥Æô¶¯·þÎñ
¿ØÖÆÃæ°å--¹ÜÀí¹¤¾ß--·þÎñ


Ïà¹ØÎÊ´ð£º

¼±ÎÊÒ»¸öoracle×Ö¶ÎÉèÖõÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮
ÎÒÉèÖÃÁËÒ»¸öoracle×ֶΣ¬varchar(3000),È»ºó²åÈëÒ»ÌõÊý¾Ý³¤¶È²Å1000,¾Í±¨´íÁË£®È磺net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
Caused ......

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø

private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......

linuxÏÂCÓïÑÔ¿ª·¢oracleµÄÎÊÌâ¡£

Á½¸öÎļþ1.PC£¬1.inc
1.PCÓвÙ×÷oracleÊý¾Ý¿âµÄ ,1.incÒ²ÓвÙ×÷oracleÊý¾Ý¿â 
ÔÚÆäËûÊý¾ÝÖÐÈçinformix ÖÐ$include 1.inc¾Í¿ÉÒÔʹÓÃÁË
ÔÚORACLEÊý¾Ý¿âÖØ $include 1.inc²»¿ÉÓà EXEC SQL include 1.incÒ²²»¿É ......

sql - Oracle / ·Ç¼¼ÊõÇø

score±í
scoreid course studentid score
1 Êýѧ 2 99
2 Êýѧ 3 60
3 Êýѧ 4 80
4 ÓïÎÄ 5 79
5 ÓïÎÄ 6 58
6 ÓïÎÄ 1 66
7 Ó¢Óï 6 76
8 Ó¢Óï 4 87
9 Ó¢Óï 3 100
10Ó¢Óï 2 69
ÔõÑùµÃµ½Ã»ÃÅ¿ÎÖзÖÊý×î¸ßµÄÄÇ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ