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

OracleµÄÐ¶ÔØ·½·¨

   ֮ǰ¸ø´ó¼Ò½éÉÜÁËÔÚWIN7ÉÏOracle 10gµÄ°²×°·½·¨£¬½ÓÏÂÀ´¾Í¸Ã¸ø´ó¼Ò½éÉÜËüµÄÐ¶ÔØ·½·¨ÁË¡£ºÜ¶àÈ˲»¸Ò°²×°Oracle¾ÍÊǵ£Ðݲװºó»áÐ¶ÔØ²»¸É¾»£¬Æäʵµ±³õÎÒÒ²ÓйýÕâ¸ö¹ËÂÇ£¬ºÇºÇ¡£µ«ºóÀ´·¢ÏÖ£¬ÆäÊµÐ¶ÔØÊǺÜÈÝÒ×µÄÊ¡£¾Í¼¸²½¶øÒÑ£¬²»ÐžÍÇë¿´£º
 
¿ÉÒÔʹÓòúÆ·×Ô´øµÄÐ¶ÔØ¹¤¾ßÈ¥Ð¶ÔØ¡£
1£®    °´ÕÕ²½ÖèÖ´ÐУº¿ªÊ¼→³ÌÐò→Oracle→Oracle - OraDb10g_home1→Oracle Installation Products→Universal Installer½øÐвÙ×÷¡£µ¥»÷Ð¶ÔØ²úÆ·°´Å¥£¬½øÈëÒѰ²×°²úÆ·½çÃæ¡£Ò»´Î¿ÉÒÔÐ¶ÔØÈ«²¿²úÆ·£¬Ò²¿ÉÒÔÖ»Ð¶ÔØ²¿·Ö²úÆ·¡£½¨Òéµ±¼ÆËã»úϵͳ×ÊÔ´£¬ÓÈÆäÊÇÄÚ´æ²»ÊÇ×ã¹»´óʱ£¬²»ÒªÒ»´ÎÐ¶ÔØÈ«²¿²úÆ·£¬·ñÔòÐ¶ÔØËٶȺÜÂý»òÕß²»Äܳɹ¦Ð¶ÔØ¡£ÕâµãµÃÌØ±ð×¢ÒâÁË£¬×îºÃÏÈÐ¶ÔØ¿Í»§¶ËÈ»ºóÔÙÐ¶ÔØ·þÎñÆ÷¡£ÄÍÐĵȴý½ø¶ÈÌõ´ïµ½100%£¬Ð¶ÔØÍê±Ïºó£¬ÔÚ“InventoryĿ¼”ÖУ¬Ìáʾδ°²×°µÄ²úÆ·£¬²¢ÇÒOracleÑ¡ÏîÔÚ“³ÌÐò”²Ëµ¥ÖÐÏûʧÁË¡£
2£®    °Ñ×¢²á±íÖÐËùÓÐOracleÈë¿Úɾ³ý¡£Ò»¸ö¶¼²»ÄÜÁôÏ£¬·ñÔò¾ÍÓпÉÄÜÔì³ÉÐ¶ÔØ²»¸É¾»£¡
°´ÕÕ²½ÖèÖ´ÐУº¿ªÊ¼→¸½¼þ→ÔËÐУ¬´ò¿ª“ÔËÐД½çÃæ¡£ÔÚ“´ò¿ª”Îı¾¿òÖÐÊäÈë“regedit”£¬
µ¥»÷“È·¶¨”°´Å¥£¬“½øÈë×¢²á±í±à¼­Æ÷”½çÃæ¡£
°Ñ“HKEY_LOCAL_MACHINE\SYSTEM\CURRENTCONTROLSET\SERVIES”ϵÄËùÓÐOracleÈë¿Úɾ³ý¡£¹²ÓÐ5¸ö£¨OracleDBConsoleXSCJ£¬OracleJobSchedulerXSCJ£¬OracleOraDb10g_home1iSQL*Plus£¬OracleOraDb10g_home1TNSListener£¬OracleServiceXSCJ£©¡£
°Ñ“HKEY_LOCAL_MACHINE\SYSTEM\CURRENTCONTROLSET\SERVIES\EVENTLOG\APPLICATION”ϵÄËùÓÐOracleÈë¿Úɾ³ý¡£¹²ÓÐ3¸ö£¨Oracle.xscj£¬OracleDBConsoleXSCJ£¬OracleOraDb10g_home1iSQL*Plus£©¡£
3. ɾ³ýËùÓÐOracleĿ¼¡£°Ñ°²×°Â·¾¶ÏºͲÙ×÷ϵͳĿ¼ÏµÄOracleĿ¼ɾ³ý£¬Õâʱ²¢²»ÄÜÍêȫɾ³ý£»ÖØÐÂÆô¶¯¼ÆËã»úºó£¬²ÅÄÜÍêȫɾ³ýOracleĿ¼¡£
 
ÖÁ´Ë£¬Oracle ²ÅÍêȫɾ³ý£¡×îºó£¬×£´ó¼ÒºÃÔË£¬Í¬Ã㣡


Ïà¹ØÎĵµ£º

ÈçºÎÔÚOracleÖн¨±í¸ñʱ¾ÍÖ¸¶¨Ö÷¼üºÍÍâ¼ü


´´½¨±íµÄÓï·¨
-´´½¨±í¸ñÓï·¨:
create table ±íÃû(
   ×Ö¶ÎÃû1  ×Ö¶ÎÀàÐÍ(³¤¶È) ÊÇ·ñΪ¿Õ,
   ×Ö¶ÎÃû2  ×Ö¶ÎÀàÐÍ       ÊÇ·ñΪ¿Õ
);
-Ôö¼ÓÖ÷¼ü
alter table ±íÃû add constraint Ö÷¼üÃû primary key (×Ö¶ÎÃû1);
-Ôö¼ÓÍâ¼ü:
alter table ±íÃû
  ......

oracle´íÎó˵Ã÷

ORA-00001: Î¥·´Î¨Ò»Ô¼ÊøÌõ¼þ (.)
ORA-00017: ÇëÇó»á»°ÒÔÉèÖøú×Ùʼþ
ORA-00018:
³¬³ö×î´ó»á»°Êý
ORA-00019: ³¬³ö×î´ó»á»°Ðí¿ÉÊý
ORA-00020: ³¬³ö×î´ó½ø³ÌÊý ()
ORA-
00021: »á»°¸½ÊôÓÚÆäËüijЩ½ø³Ì£»ÎÞ·¨×ª»»»á»°
ORA-00022: ÎÞЧµÄ»á»° ID£»·ÃÎʱ»¾Ü¾ø
ORA-00023:
»á»°ÒýÓýø³Ì˽ÓÃÄڴ棻ÎÞ·¨·ÖÀë»á» ......

Oracle±¾µØ¿Í»§¶ËÔ¶³ÌÁ¬½Ó·þÎñÆ÷

µ½Oralce·¾¶ÏÂ
D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN
ZHG =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = leehong)(PORT = 1521))
    )
    (CONNECT_DATA =
    & ......

°¸ÀýѧϰOracle´íÎó£ºORA 00600

Ô­ÎÄ:ORA-00600 internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]
¡¡¡¡Cause This is the generic internal error number for Oracle program exceptions. It indicates that a process has encountered a low-level, unexpected condition. Causes of t ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ