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 ²ÅÍêȫɾ³ý£¡×îºó£¬×£´ó¼ÒºÃÔË£¬Í¬Ã㣡
Ïà¹ØÎĵµ£º
ÏëÔÚLinuxϵͳ°ÑOralce°²×°ºÃ£¬È·ÊµÊǸö²»Ð¡µÄÌôÕ½£¬×îÆðÂëµÄ£¬Ê×ÏÈÒª¶ÔLinuxϵͳÓÐËùÁ˽⣬²»Ëµ¶àµÄ£¬¼òµ¥µÄһЩÅäÖÃÎļþºÍ³£ÓÃÃüÁî×ÜÒªÖªµÀ£¬Òª²»Õæ²»ÖªµÀÈçºÎÏÂÊÖ¡£½ñÌì°´Êé±¾µÄÆôʾ£¬ºÍÍøÉϱðÈËдµÄÎÄÕ»¹ÓÐOralce¹Ù·½µÄ°ïÖú¸Ð¾õ¶¼¶ÔÎÒ°ïÖúÉõ΢°¡¡£¡£¡£²»¹ý¸Ð¾õ×îºó»¹ÊÇÔÚQQȺºÍ°Ù¶ÈµÄ°ïÖúÏ£¬µ±È»Êé±¾ºÍÄÇЩÎÄÕ¶¼Æðµ½ ......
Ò»¡¢SQLµÄʹÓÃ
CREATE¡¢ALTERºÍDROPÊÇÖ÷ÒªµÄ3ÖÖDDLÓï¾ä£¬ÕâЩÓï¾ä±»ÓÃÓÚÔÚÊý¾Ý¿âÖÐÌí¼Ó¡¢Ð޸Ļòɾ³ý¶ÔÏó¡£
DCLÓï¾ä°üÀ¨GRANTºÍREVOKEÃüÁËüÃÇ¿ÉÒÔ±»ÓÃÓÚΪÓû§»ò½ÇÉ«ÊÚÓè»òÈ¡ÏûȨÏÞ£¬¿ÉÒÔ±»ÊÚÓèºÍÈ¡ÏûµÄÁ½ÖÖȨÏÞÊÇϵͳȨÏ޺ͶÔÏóȨÏÞ¡£È¡¾öÓÚ²»Í¬µÄ¶ÔÏóÀàÐÍ£¬¶ÔÏóȨÏÞ¿ÉÄܲ»Í¬¡£
²Ù×Ý»ò¼ìË÷Êý¾Ý¶¼ÐèҪʹÓÃDMLÓï¾ä¡£D ......
1¡¢±¸·Ý¹¤¾ß
Ö±½ÓʹÓòÙ×÷ϵͳʵÓóÌÐòcopy¡¢cp¾Í¿ÉÒÔ½øÐб¸·Ý²Ù×÷¡£µ«£¬OracleÇ¿ÁÒ½¨ÒéʹÓÃRecovery Manager£¨»Ö¸´¹ÜÀíÆ÷£¬¼òдRMAN£©¡£
RMANÄܹ»±¸·ÝÊý¾ÝÎļþ¡¢¿ØÖÆÎļþ¡¢¹éµµÈÕÖ¾ÒÔ¼°·þÎñÆ÷²ÎÊýÎļþ£¨spfile£©¡£±¸·Ý¿ÉÒÔ±»Ð´Èë´ÅÅÌ»ò´Å´ø¡£
2¡¢¸ÅÄîÓëÊõÓï
2.1¡¢È«²¿±¸·ÝÓ벿·Ö±¸·Ý
È«²¿±¸·Ý£¨whole backup£©ÊÇËùÓÐÊ ......
ÔÎÄ: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 ......
oracle clob ºÍblobÎÊÌâµÄ½â¾ö
ÕûÀíÁËoracle clob ºÍblobÎÊÌâµÄ½â¾ö°ì·¨£º
1£º½¨ÒéʹÓÃoracle 10µÄojdbc14.jar,·ñÔòµ±±£´æclobµÄʱºò¿ÉÄÜ»á³öÏÖÌ×½Ó×Ö´íÎó£»
2£ºspringÅäÖÃÈçÏ£º
java´úÂë:
<bean id="sessionFact ......