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

ÇóÖú£ºoracleÁ¬½ÓÎÊÌâ

Á¬½ÓÊý¾Ý¿â³öÏÖÏÂÃæµÄ´íÎó£¬Ë­°ïæ½â¾öÏ¡£Ð»À²¡£
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
ʵÀýûÓÐÆô¶¯

sqlplus /nolog
connect / as sysdba
startup

°´Äã˵µÄÊÔÁËÏ£¬ÓÖ³öÏÖÕâÖÖ´íÎó£º
ORA-01263:Name given for file destination directory is invalid
OSD-04018:Unable to access the specified directory or device.
O/S-Error: <OS 2> ???????????????????
ÊÇÔõô»ØÊ°¡£¿

´Ó·þÎñÖаÉoracleµÄOracleOraHome90TNSListener ºÍOracleServiceSidÁ½¸ö·þÎñÆô¶¯ÆðÀ´ÊÔÊÔ

ÄãµÄinit.oraÎļþµÄdb_create_file_dest ·¾¶ÊDz»ÊÇÉèµÄ²»¶Ô£¿

ÒýÓÃ
´Ó·þÎñÖаÉoracleµÄOracleOraHome90TNSListener ºÍOracleServiceSidÁ½¸ö·þÎñÆô¶¯ÆðÀ´ÊÔÊÔ


ÍüÁË˵ÎÒÓõÄÊÇ oracle 10g ¡£¸ÃÆô¶¯µÄ·þÎñ¶¼ÆðÁË£¬»¹ÊDz»ÐС£

ÒýÓÃ
ÄãµÄinit.oraÎļþµÄdb_create_file_dest ·¾¶ÊDz»ÊÇÉèµÄ²»¶Ô£¿

oracleÀïÓÐÄǸöÎļþÂð£¿ÎÒÓÃÁËËÑË÷¶¼Ã»ÕÒµ½£¬ÊÇÔÚÄĸö°üÏ£¿ÎÒ¸ÕÓÃoracle,ºÜ¶à¶¼²»¶®¡£


Ïà¹ØÎÊ´ð£º

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

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

ÊÇ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 / ¿ª·¢

abnormal end of export file
IMP-00028: partial import of previous table rolled back: 3828 rows rolled back
  
ÓÐûÓÐÒ»ÖÖ·½·¨Èõ¼Èë¼ÌÐø½øÐжø²»Òì³£Ìø³ö»Ø¹ö£¿
ignore=y

Äã² ......

oracleÊý¾Ý¿âµÄÃû×ÖÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÔÚ´´½¨Êý¾Ý¿âµÄʱºòÓõÄÃû×ÖΪoracle10£¬µ«ÊÇ´´½¨ºÃºó£¬ÔÚĬÈϵÄĿ¼ÏÂÏÔʾµÄÃû³ÆÈ´ÊÇoracle10g£¬ÕâÊÇΪʲô£¿
Äã¿´µÄ 10gÊǰ²×°Ä¿Â¼°É 

SQL> select name from v$database;
NAME
---------
ORCL ......

¶à±í¹ØÁª²éѯµÄ sqlд·¨ - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ£¬ÎÒ×î½üά»¤Ò»¸öÏîÄ¿£¬100¶à¸ö±í
Ö»ÄÜÓÃjdbcÖ±Á¬
Óöµ½Á˶à¸ö±í ¹ØÁª ²éѯµÄÇé¿ö Çë´ó¼ÒÖ¸½Ì
±ÈÈç
student(studentid,classid)
class(classid,classname)
class_teacher(classid,teacherid)Õâ¸öÊÇÖмä±í ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ