ÍêÈ«Ð¶ÔØOracle
ÍêÈ«Ð¶ÔØOracle
Èí¼þ»·¾³£º
1¡¢Windows 2000+ORACLE 8.1.7
2¡¢ORACLE°²×°Â·¾¶Îª£ºC:\ORACLE
ʵÏÖ·½·¨£º
1¡¢ ¿ªÊ¼££¾ÉèÖ㣾¿ØÖÆÃæ°å££¾¹ÜÀí¹¤¾ß££¾·þÎñ
Í£Ö¹ËùÓÐOracle·þÎñ¡£
2¡¢ ¿ªÊ¼££¾³ÌÐò££¾Oracle - OraHome81££¾Oracle Installation Products££¾
Universal Installer
жװËùÓÐOracle²úÆ·£¬µ«Universal Installer±¾Éí²»Äܱ»É¾³ý
5¡¢ ÔËÐÐregedit£¬Ñ¡ÔñHKEY_LOCAL_MACHINE\SOFTWARE\ORACLE£¬°´del¼üɾ³ýÕâ¸öÈë¿Ú¡£
6¡¢ ÔËÐÐregedit£¬Ñ¡ÔñHKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services£¬¹ö¶¯
Õâ¸öÁÐ±í£¬É¾³ýËùÓÐOracleÈë¿Ú¡£
7¡¢ ÔËÐÐrefedit£¬
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application£¬
ɾ³ýËùÓÐOracleÈë¿Ú¡£
8¡¢ ¿ªÊ¼££¾ÉèÖ㣾¿ØÖÆÃæ°å££¾ÏµÍ³££¾¸ß¼¶££¾»·¾³±äÁ¿
ɾ³ý»·¾³±äÁ¿CLASSPATHºÍPATHÖÐÓйØOracleµÄÉ趨
9¡¢ ´Ó×ÀÃæÉÏ¡¢STARTUP£¨Æô¶¯£©×é¡¢³ÌÐò²Ëµ¥ÖУ¬É¾³ýËùÓÐÓйØOracleµÄ×éºÍͼ±ê
10¡¢ ɾ³ý\Program Files\OracleĿ¼
11¡¢ ÖØÐÂÆô¶¯¼ÆËã»ú£¬ÖØÆðºó²ÅÄÜÍêȫɾ³ýOracleËùÔÚĿ¼
12¡¢ ɾ³ýÓëOracleÓйصÄÎļþ£¬Ñ¡ÔñOracleËùÔÚµÄȱʡĿ¼C:\Oracle£¬É¾³ýÕâ¸öÈë
¿ÚĿ¼¼°ËùÓÐ×ÓĿ¼£¬²¢´ÓWindows 2000Ŀ¼£¨Ò»°ãΪC:\WINNT£©ÏÂɾ³ýÒÔÏÂÎÄ
¼þORACLE.INI¡¢oradim73.INI¡¢oradim80.INI¡¢oraodbc.iniµÈµÈ¡£
13¡¢ WIN.INIÎļþÖÐÈôÓÐ[ORACLE]µÄ±ê¼Ç¶Î£¬É¾³ý¸Ã¶Î
14¡¢ ÈçÓбØÒª£¬É¾³ýËùÓÐOracleÏà¹ØµÄODBCµÄDSN
15¡¢ µ½Ê¼þ²é¿´Æ÷ÖУ¬É¾³ýOracleÏà¹ØµÄÈÕÖ¾
˵Ã÷£º
Èç¹ûÓиö±ðDLLÎļþÎÞ·¨É¾³ýµÄÇé¿ö£¬Ôò²»ÓÃÀí»á£¬ÖØÐÂÆô¶¯£¬¿ªÊ¼Ðµİ²×°£¬
°²×°Ê±£¬Ñ¡ÔñÒ»¸öеÄĿ¼£¬Ôò£¬°²×°Íê±Ï²¢ÖØÐÂÆô¶¯ºó£¬ÀϵÄĿ¼¼°Îļþ¾Í¿ÉÒÔɾ³ýµôÁË
ÌìÀÇÐÇ µÚ 1 Ò³ 2003-4-8
Oracle 9i for Windows DBA ÊÖ²á ————¹ØÓÚÊÖ¶¯É¾³ýOracleµÄ¼¸µãÎÊÌâ ÓÐЩʱºò£¬OUIɾ³ýOracle²úÆ·ºó£¬½«»áÔÚϵͳÉÏÒÅÁôһЩע²áÉèÖá¢ÎļþºÍÎļþ¼Ð¡£Èç¹ûÏ£ÍûÇåÀíϵͳÉϵÄOracle°²×°£¬Ôò¿ÉÒÔÊÖ¹¤É¾³ýOracle×é¼þ¡£Enterprise Edition¿ÉÒÔ²ÉÓÃÈçÏ·½Ê½½øÐÐɾ³ý£º 1£©¡¢ÒÔAdministratorÉí·ÝµÇ¼µ½Windows 2000 ϵͳ¡£Ñ¡ÔñService applet ÒÔ±ãÍ£Ö¹ËùÓÐOracle ·þÎñ¡£Oracle µÄ·þÎñÃû¶¼¾ßÓÐÒ»¸öoracle»òora µÄǰ׺¡£Ò»µ©Í£Ö¹ÁËËùÓеÄOracle·þÎñ£¬ÎÒÃǽ¨Ò齫ËüÃÇÉèÖÃΪÊÖ¹¤Æô¶¯Ä£Ê½£¨manual start mode£©¡£ ¾¯¸æ Microsoft ½¨Òé²»ÒªÊÖ¹¤¸ü¸ÄWindows
Ïà¹ØÎĵµ£º
ǰÕó×Ó¿´µ½Ò»Æª¹ØÓÚDELETE²Ù×÷µÄ¾ßÌåµÄÁ÷³Ì£¬½ñÌìÎÞÒâ¼äÓÖ¿´µ½Ò»¸öUPDATEµÄ²Ù×÷Á÷³Ì£¬Í¦ÓÐȤµÄ£¬×ª¹ýÀ´Ñ§Ï°Ñ§Ï°£¡
================================================================================
1£¬Óû§Ìá½»Ò»¸öupdateÓï¾ä
2£¬server process¼ì²éÄڴ滺´æ
i Èç¹ûûÓÐÓÐЧÄÚ´æ¿Õ¼ ......
ASM
ASM¿ÉÒÔÌõ´ø»¯ºÍ¾µÏñ´ÅÅÌ£¬Òò´Ë¿ÉÒÔÔÚÊý¾Ý¿â±¸¼ÓÔØµÄÇé¿öÏÂÌí¼Ó¡¢É¾³ý´ÅÅÌ¡¢ÒÔ¼°×Ô¶¯Æ½ºâIO¡£
ASM²»ÊÇÒ»¸öÎļþϵͳ£¬ËùÒÔÎÞ·¨´Ó²Ù×÷ϵͳ·ÃÎÊASM´æ´¢µÄÎļþ£¬¶ÔÓÚʹÓÃASMµÄÊý¾Ý¿âÖ»ÄÜÓÃRMAN½øÐб¸·ÝºÍ»Ö¸´¡£
ASM×÷Ϊµ¥¶ÀµÄORACLEʵÀýʵʩ£¬Ö»ÓÐASMÔËÐÐʱÊý¾Ý¿â²ÅÄÜ·ÃÎÊ¡£
Ò»¡¢´ÅÅÌ×é
ASMÌṩÁËÈýÖдÅÅÌ×éÀà ......
oracle ASM ÅäÖà ת
2008-04-30 11:14
oracle ASM ÅäÖÃ
2006Äê12ÔÂ11ÈÕ ÐÇÆÚÒ» 11:09
×Ô¶¯´æ´¢¹ÜÀí (ASM)
ASM ÊÇ Oracle Êý¾Ý¿â 10g
ÖÐÒ»¸ö·Ç³£³öÉ«µÄÐÂÌØÐÔ£¬ËüÒÔÆ½Ì¨Î޹صķ½Ê½ÌṩÁËÎļþϵͳ¡¢Âß¼¾í¹ÜÀíÆ÷ÒÔ¼°Èí¼þ RAID µÈ·þÎñ¡£ASM
¿ÉÒÔÌõ´ø»¯ºÍ¾µÏñ´ÅÅÌ£¬´Ó¶øÊµÏÖÁËÔÚÊý¾Ý¿â±»¼ÓÔØµ ......
ORACLEÖ÷ÒªÓÉÁ½²¿·Ö×é³É£ºInstanceºÍDatabase¡£InstanceÊÇÖ¸Ò»×éºǫ́½ø³Ì/Ï̺߳ÍÒ»¿é¹²ÏíÄÚ´æÇøÓò£¬¶øDatabaseÊÇÖ¸´æ´¢ÔÚ´ÅÅÌÉϵÄÒ»×éÎïÀíÎļþ¡£
ORACLEÊý¾Ý¿âµÄÆô¶¯Ö÷Òª·Ö3¸ö²½Ö裺
1¡¢Æô¶¯µ½nomount״̬£»
2¡¢Æô¶¯µ½mount״̬£»
3¡¢Æô¶¯µ½open״̬¡£
ÏÂÃæ·ÖÎöÒ»ÏÂÆô¶¯µÄ¸÷¸ö²½Ö裺
Ò»¡¢Æô¶¯µ½nomount״̬
......
¶þÁãÁã¾ÅÄêʮԶþÊ®ÈÕ£¬´ò´ÓÈýÄêÇ°ÍÆ³öOracle¼Ó½ô¼Æ»®ÒÔÀ´£¬¼×¹ÇÎĹ«Ë¾ÒѾÔö¼ÓÁËÆß,000¶à¼ÒÖÎÀíÈí¼þÖÐÐÍÆóÒµ¿Í»§£¬µ±Ç°ÖÐÐÍÆóÒµ¿Í»§×ÜÁ¿ÒѾ³¬¹ý25,000¼Ò¡£
͸¹ýÍÆ³öÂíÏòÖÐÐÍÆóÒµ¿Í»§µÄOracle¼Ó¿ì¼Æ»®Ð¹¦ÄÜ£¬°üÀ¨ÐÂʽ¼Ó¿ì¼Æ»®½â¾ö·½°¸¡¢OracleÆóÒµ¼ÓËÙÆ÷¡¢²ÆÎñÑ¡¼þºÍµ÷¶È²½ÖèµÈ£¬¼×¹ÇÎÄÔÚ²»Í£¶ÒÏÖ˳Àû¡£
ÃæÁÙÖÐÐÍ ......