Íêȫɾ³ýOracle 10g
Èí¼þ»·¾³:
1¡¢Windows XP + Oracle 10g
2¡¢Oracle°²×°Â·¾¶Îª:d:\Oracle
ʵÏÖ·½·¨:
1¡¢¿ªÊ¼£>ÉèÖã>¿ØÖÆÃæ°å£>¹ÜÀí¹¤¾ß£>·þÎñÍ£Ö¹ËùÓÐOracle·þÎñ;
2¡¢¿ªÊ¼£>³ÌÐò£>Oracle – OraDb10g_home1>Oracle Installation Products£> Universal Installer жװËùÓÐOracle²úÆ·,µ«Universal Installer±¾Éí²»Äܱ»É¾³ý;
3¡¢ÔËÐÐregedit,Ñ¡ÔñHKEY_LOCAL_MACHINE\SOFTWARE\ORACLE,°´del¼üɾ³ýÕâ¸öÈë¿Ú;
4¡¢ÔËÐÐregedit,Ñ¡ÔñHKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services,¹ö¶¯Õâ¸öÁбí,ɾ³ýËùÓÐOracleÈë¿Ú;
5¡¢ÔËÐÐrefedit,Ñ¡ÔñHKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application,ɾ³ýËùÓÐOracleÈë¿Ú;
6¡¢ÓÒ¼üÎҵĵçÄÔ£>ÊôÐÔ£>¸ß¼¶£>»·¾³±äÁ¿,ɾ³ý»·¾³±äÁ¿CLASSPATHºÍPATHÖÐÓйØOracleµÄÉ趨;
7¡¢´Ó×ÀÃæÉÏ¡¢STARTUP(Æô¶¯)×é¡¢³ÌÐò²Ëµ¥ÖÐ,ɾ³ýËùÓÐÓйØOracleµÄ×éºÍͼ±ê;
8¡¢É¾³ýc:\Program Files\OracleĿ¼;
9¡¢ÖØÐÂÆô¶¯¼ÆËã»ú£¬ÖØÆðºó²ÅÄÜÍêȫɾ³ýOracleËùÔÚĿ¼;
10¡¢É¾³ýÓëOracleÓйصÄÎļþ,Ñ¡ÔñOracleËùÔÚµÄȱʡĿ¼C:\Oracle,ɾ³ýÕâ¸öÈë¿ÚĿ¼¼°ËùÓÐ×ÓĿ¼,²¢´ÓWindows XPĿ¼(Ò»°ãΪd:\WINDOWS)ÏÂɾ³ýÒÔÏÂÎļþORACLE.INI¡¢oradim73.INI¡¢oradim80.INI¡¢oraodbc.iniµÈµÈ;
11¡¢WIN.INIÎļþÖÐÈôÓÐ[ORACLE]µÄ±ê¼Ç¶Î,ɾ³ý¸Ã¶Î;
12¡¢ÈçÓбØÒª,ɾ³ýËùÓÐOracleÏà¹ØµÄODBCµÄDSN;
13¡¢µ½Ê¼þ²é¿´Æ÷ÖÐ,ɾ³ýOracleÏà¹ØµÄÈÕÖ¾ ˵Ã÷:Èç¹ûÓиö±ðDLLÎļþÎÞ·¨É¾³ýµÄÇé¿ö,Ôò²»ÓÃÀí»á,ÖØÐÂÆô¶¯,¿ªÊ¼Ðµİ²×°,°²×°Ê±,Ñ¡ÔñÒ»¸öеÄĿ¼,Ôò,°²×°Íê±Ï²¢ÖØÐÂÆô¶¯ºó,ÔÀ´µÄĿ¼¼°Îļþ¾Í¿ÉÒÔɾ³ýµôÁË¡£
Ïà¹ØÎĵµ£º
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
ÔÎĵØÖ·£ºhttp://book.csdn.net/bookfiles/732/10073222578.shtml
¶ÔÓÚDMLÓï¾äÀ´Ëµ£¬Ö»ÒªÐÞ¸ÄÁËÊý¾Ý¿é£¬OracleÊý¾Ý¿â¾Í»á½«ÐÞ¸ÄǰµÄÊý¾Ý±£ÁôÏÂÀ´£¬±£´æÔÚundo segmentÀ¶øundo segmentÔò±£´æÔÚundo±í¿Õ¼äÀï¡£´ÓOracle 9iÆð£¬ÓÐÁ½ÖÖundoµÄ¹ÜÀí·½Ê½£º×Ô¶¯Undo¹ÜÀí£¨Automatic Undo Management£¬¼ò³ÆAUM£©ºÍÊÖ¹¤Undo¹ÜÀí£¨ ......
·¢ÏÖ´íÎó£ºÊý¾Ý¿âδ´ò¿ª: ½öÔÊÐíÔڹ̶¨±í/ÊÓͼÖвéѯ
½â¾ö·½°¸£º
1. ÔÚÔËÐÐ-->ÃüÁîÀïÊäÈësqlplus /nologÈ»ºó»Ø³µ£¬
2. ÒÔsysdbaµÄ½ÇÉ«µÇ¼£ºconnect sys/¿ÚÁî as sysdba
3. ÏÈÖ´ÐДalter database open”£¬»á³öÏÖÈçϵĴíÎó
µÚ 1 ÐгöÏÖ´íÎó:
ORA-01157: ÎÞ·¨±êʶ/Ëø¶¨Êý¾ÝÎļþ 6 - Çë² ......
oracle¾Þ´ó±íµÄÊý¾Ýɾ³ýµÄ·½·¨£¬20·ÖÖӸ㶨
Ò»¸ö¿Í»§µÄÈÕÖ¾±í£¬ÒѾÓÐ3000¶àǧÍòµÄ¼Ç¼ÁË£¬ÈÝÁ¿´óÔ¼30G£¬´òËãά»¤Ò»Ï£¬¿´ÁËÒ»ÏÂ×ֶΣ¬·¢ÏÖÈÕÖ¾Êǰ´ÈÕÆÚ¼Ç¼µÄ£¬´òËãÖ»±£Áô3¸öÔµÄÈÕÖ¾¾ÍºÃÁË¡£
µÚÒ»¸ö˼·£º
°´Ìõ¼þ²é³öÀ´£¬Ö±½ÓDELETE
ÊÔÁËÒ»ÏÂ
delete from NTLS_LOGS where to_char(START ......