OracleÆô¶¯Ê±ORA 00600´íÎó´¦Àí·½·¨
oracle startupʱ ±¨´íORA-00600: ÄÚ²¿´íÎó´úÂ룬²ÎÊý: [kcratr1_lostwrt], [], [], [], [], [], [], []
ÔÒò¿ÉÄÜÊÇ·Ç·¨¹Ø»ú»òµôµçÔì³É,ÒÔÏÂÊdzöÏÖµÄÎÊÌâ¼°½â¾ö·½·¨:
C:\Documents and Settings\Administrator>sqlplus
ÇëÊäÈëÓû§Ãû: /as sysdba
SQL> startup
ORA-01081: ÎÞ·¨Æô¶¯ÒÑÔÚÔËÐÐµÄ ORACLE --- ÇëÊ×ÏȹرÕ
SQL> shutdown abort
ORACLE Àý³ÌÒѾ¹Ø±Õ¡£
SQL> startup
ORACLE Àý³ÌÒѾÆô¶¯¡£
Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Êý¾Ý¿â×°ÔØÍê±Ï¡£
ORA-00600: ÄÚ²¿´íÎó´úÂ룬²ÎÊý: [kcratr1_lostwrt], [], [], [], [], [], [], []
SQL> shutdown immediate
ORA-01109: Êý¾Ý¿âδ´ò¿ª
ÒÑ¾Ð¶ÔØÊý¾Ý¿â¡£
ORACLE Àý³ÌÒѾ¹Ø±Õ¡£
SQL> startup mount
ORACLE Àý³ÌÒѾÆô¶¯¡£
Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Êý¾Ý¿â×°ÔØÍê±Ï¡£
SQL> recover database;
Íê³É½éÖʻָ´¡£
SQL> alter database open;
Êý¾Ý¿âÒѸü¸Ä¡£
SQL>exit;
Ïà¹ØÎĵµ£º
Ò»¡£²é¿´oracleÊý¾Ý¿âÊÇ·ñΪ¹éµµÄ£Ê½£º
1.select name,log_mode from v$database;
NAME LOG_MODE
------------------ ------------------------
QUERY NOARCHIVELO ......
ǰЩÈÕ×ÓÕÛÌÚµÄÔÚÏßÅÄÕÕ£¬ÓÉÓÚÖ»ÊǸüÐÂblob×ֶΣ¬Ã»ÓÐÔÚ±¾µØ±£´æÕÕÆ¬£¬µ¼Ö¿ͻ§ÅÄÄÔÃÅÏëÒªµÄʱºò²»ÄÜÂíÉÏÄóöÀ´¡£Ã»ËµµÄËÈù˿ÍÊÇÉϵÛÄØ£¬×ö°É¡£Ê¹ÓÃÏ̳߳ش´½¨Èý¸öÏß³ÌÈÃ×Ô¶¨Ò»¸öÏß³ÌÄ¿±ê¹²Ïí£¨Ò²¾ÍÊǰѱíÀïµÄ¼Ç¼·Ö³Én×éͬʱִÐе¼³ö£©¡£³ÌÐòºÜ¼òµ¥£¬Ò»¹²ËĸöÀàºÍÒ»¸öojdbc14.jar°ü¡£ÓÉÓÚsqlÓï¾äд´íÁËÔì³É¶à¸öÏ̶߳ÔÒ»¸ ......
1£©´ÓʹÓÃÉÏÀ´Ëµ£¬oci±ØÐëÔÚ¿Í»§»úÉϰ²×°oracle¿Í»§¶Ë»ò²ÅÄÜÁ¬½Ó£¬¶øthin¾Í²»ÐèÒª£¬Òò´Ë´ÓʹÓÃÉÏÀ´½²thin»¹ÊǸü¼Ó·½±ã£¬ÕâÒ²ÊÇthin±È½Ï³£¼ûµÄÔÒò¡£
2£©ÔÀíÉÏÀ´¿´£¬thinÊÇ´¿javaʵÏÖtcp/ipµÄc/sͨѶ£»¶øoci·½Ê½,¿Í»§¶Ëͨ¹ýnative java methodµ÷ÓÃc library·ÃÎÊ·þÎñ¶Ë£¬¶øÕâ¸öc library¾ÍÊÇoci(oracle called interface ......
×Ö·ûÀàÐÍ£º
CHAR(size)£º¹Ì¶¨³¤¶È×Ö·û´®£¬×î´ó³¤¶È2000 bytes
VARCHAR2(size)£º¿É±ä³¤¶ÈµÄ×Ö·û´®£¬×î´ó³¤¶È4000 bytes£¬¿É×öË÷ÒýµÄ×î´ó³¤¶È749
NCHAR(size)£º¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ¹Ì¶¨³¤¶È×Ö·û´®£¬×î´ó³¤¶È2000 bytes
NVARCHAR2(size)£º¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ¿É±ä³¤¶È×Ö·û´®£¬×î´ó³¤¶È4000 byte
LONG£º±ä³¤µÄ×Ö·û´®£¬×î´ó³¤¶ÈÏÞ ......