OracleÓû§±í¿Õ¼ä±¦µä
Oracle»¹ÊDZȽϳ£Óõģ¬ÓÚÊÇÎÒÑо¿ÁËÒ»ÏÂOracleÓû§±í¿Õ¼ä£¬ÔÚÕâÀïÄóöÀ´ºÍ´ó¼Ò·ÖÏíһϣ¬Ï£Íû¶Ô´ó¼ÒÓÐÓá£ÔÚÎÒÃÇΪ΢ÈíµÄNTFS·ÖÇø¸ñʽÖеÄÓû§´ÅÅÌÅä¶î¹ÄÕƵÄʱºò£¬OracleÊý¾Ý¿âÖÐÒ²ÒѾʵÏÖÁËÓû§´ÅÅÌÅä¶îµÄ¼¼Êõ¡£¿ÉÒÔ½èÖú±í¿Õ¼ä£¬À´¶ÔÓû§½øÐдÅÅÌÅä¶î¹ÜÀí¡£ÀûÓñí¿Õ¼äµÄÓû§´ÅÅÌÅä¶î£¬¿ÉÒÔʵÏֺܶ๦ÄÜ¡£
Èç¿ÉÒÔÀûÓÃÓû§´ÅÅÌÅä¶î£¬À´¹ÜÀíÓû§´´½¨Êý¾Ý¿â¶ÔÏóµÄÄÜÁ¦¡£ÎÒÃǶ¼ÖªµÀ£¬ÈôÓû§ÏëÒªÔÚij¸ö±í¿Õ¼äÖд´½¨·½°¸¶ÔÏóµÄ»°£¬±ØÐëͬʱÂú×ãÁ½¸ö¶ÔÏó¡£Ò»ÊÇÓû§¾ßÓÐÊý¾Ý¿âϵͳÖÐCREATE TABLEµÈÏà¹ØµÄȨÏÞ;¶þÊÇÔÚÕâ¸ö·½°¸¶ÔÏóʹÓõıí¿Õ¼äÖоßÓÐÅä¶î¡£ÒòΪÕâÁ½¸öÌõ¼þ±ØÐëͬʱÂú×㣬Óû§²ÅÄܹ»³É¹¦µÄ½¨Á¢¶ÔÏó¡£ËùÒÔ£¬ÈôÎÒÃÇ¿ÉÒÔ²»¸øÓû§Ä³¸ö±í¿Õ¼äµÄÅä¶î£¬Èç´ËµÄ»°£¬¾Í¿ÉÒÔÏÞÖÆÓû§µÄÏà¹Ø²Ù×÷¡£
ÁíÍ⣬ÎÒÃÇÒ²¿ÉÒÔÀûÓôÅÅÌÅä¶îÀ´¶ÔÓû§½øÐÐÊý¾Ý´óСµÄÏÞÖÆ¡£ÒòΪÓÐʱºòÎÒÃÇ¿ÉÄÜÔÚͬһ̨Êý¾ÝÆ÷ÖØ»áÔËÐжà¸öÓ¦Ó÷þÎñ¡£Èç±ÊÕßÒÔÇ°ÔÚͬһ̨·þÎñÆ÷ÀïͬʱÔËÐÐÓÊÏäÓëOracleÊý¾Ý¿âϵͳ¡£ÎªÁËÈüõÉÙÕâ¸öÁ½¸öϵͳ¶ÔÓ²ÅÌ¿Õ¼äµÄ¹ý¶ÉÓ¦Óã¬ËùÒÔ£¬ÓбØÒª¶ÔËûÃǽøÐдÅÅÌÅä¶îµÄÏÞ¶¨¡£¹Ê£¬ÈçÓÃÊý¾Ý¿â¹ÜÀíÔ±ÐèÒª½«×ÊÔ´ÏÞÖÆ×÷Ϊ×Ô¼ºÊý¾Ý¿â°²È«²ßÂÔµÄÒ»²¿·ÖµÄ»°£¬¾Í¿ÉÒÔ¿¼ÂÇΪÿ¸öÓû§ÉèÖñí¿Õ¼äÅä¶î¡£
×ÜÖ®£¬±ÊÕßÈÏΪ£¬±í¿Õ¼äÅä¶îÊÇÒ»¸öºÜ²»´íµÄ¸¨Öú¹ÜÀí¹¤¾ß¡£±ÊÕßÔÚÕâ·½Ãæ¹ÜÀíÉÏ£¬ÉÔÓÐÐĵ㬸úÓÐʶ֮ʿ£¬ÌÖÂÛÌÖÂÛ¡£
Ò»¡¢¸øÓû§·ÖÅä±í¿Õ¼ä¡£
ÔÚOracleÊý¾Ý¿âÖУ¬¶ÔÓÚÓû§µÄ´ÅÅÌÅä¶îÊÇͨ¹ý±í¿Õ¼äÀ´ÊµÏֵġ£¸øij¸öÓû§·ÖÅäÁ˶àÉٵıí¿Õ¼ä£¬Õâ¸öÓû§¾ÍÓжàÉٵĴÅÅÌÅä¶î¡£ËùÒÔ£¬¶ÔÓÚÓû§½øÐдÅÅÌÅä¶îµÄ¹ÜÀí£¬¾ÍÊǶÔÓû§½øÐбí¿Õ¼äµÄÏÞÖÆ¡£
ÔÚ´´½¨Óû§µÄʱºò£¬ÈôûÓйØÁª±í¿Õ¼ä£¬ÔòÆäÒ»°ãÇé¿öÏ£¬¾ÍÊôÓÚĬÈϵıí¿Õ¼ä¡£¶øÆäÓµÓбí¿Õ¼äµÄ´óС£¬ÔòÊǸù¾ÝÆäËùÊô½ÇÉ«µÄ²»Í¬¶øÓÐËùÇø±ð¡£ÈçÆäÊôÓÚresource×éµÄ»°£¬ÔòÆä±í¿Õ¼äÊÇûÓдóСÏÞÖƵġ£
Ò»°ãÇé¿öÏ£¬ÈôÊý¾Ý¿â¹ÜÀíÔ±ÐèÒª¶Ô±í¿Õ¼ä½øÐдÅÅÌÅä¶î¹ÜÀíµÄ»°£¬Ôò±ÊÕß½¨Ò飬ÔÚÓû§½¨Á¢µÄʱºò£¬ÎªÓû§Ö¸¶¨±í¿Õ¼ä£¬²¢ÉèÖñí¿Õ¼äµÄ´óС¡£ÈçÎÒÃÇ¿ÉÒÔÀûÓÃÈçÏÂÕâÌõÃüÁîÅäÖÃÓû§µÄ´ÅÅÌ¿Õ¼äÅä¶î£ºALTER USER user_name QUOTA ** ON tablespace¡£ÆäÖвÎÊýUser_name±íʾÓû§Ãû£¬¶ø²ÎÊýTablespace±íʾÓû§ËùÊôµÄ±í¿Õ¼ä¡£ÈôÎÒÃDzÎÊýÉèÖÃΪUNLIMITEDµÄ»°£¬±íʾÕâ¸öOracleÓû§±í¿Õ¼äûÓÐÏÞÖÆ£¬Ö±µ½ËùÓеĿռäÓÃÍêΪֹ¡£
ËùÒÔ£¬ÔÚÒ»°ãÇé¿öÏ£¬Á½ÖÖÇéÐÎϵÄÓû§¾ßÓÐÎÞÏÞÖƵĴÅÅÌÅä¶î¡£Ò»ÊÇÕâ¸öÓû§ÊôÓÚresourceÕâ¸ö½ÇÉ«£¬ÒòΪÕâ¸ö½ÇɫĬÈÏÇé¿öÏ£¬ÆäÊÇ
Ïà¹ØÎĵµ£º
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
·¢ÏÖ´íÎó£ºÊý¾Ý¿âδ´ò¿ª: ½öÔÊÐíÔڹ̶¨±í/ÊÓͼÖвéѯ
½â¾ö·½°¸£º
1. ÔÚÔËÐÐ-->ÃüÁîÀïÊäÈësqlplus /nologÈ»ºó»Ø³µ£¬
2. ÒÔsysdbaµÄ½ÇÉ«µÇ¼£ºconnect sys/¿ÚÁî as sysdba
3. ÏÈÖ´ÐДalter database open”£¬»á³öÏÖÈçϵĴíÎó
µÚ 1 ÐгöÏÖ´íÎó:
ORA-01157: ÎÞ·¨±êʶ/Ëø¶¨Êý¾ÝÎļþ 6 - Çë² ......
WINDOWSÏ ORACLE ÕìÌý³ÌÐòÒ쳣ֹͣ¹ÊÕÏ´¦Àí
WINDOWSÏ ORACLE ÕìÌý³ÌÐòÒ쳣ֹͣ¹ÊÕÏ´¦Àí
¼ÒÀïÓÃÀ´µĄ̈ʽ»úÉÏ×°Á˸öWINDOWSϵÄORACLE 10G,ºÃ¾ÃûÓÃÁË£¬½ñÌì´ò¿ª´òËãÓÃһϣ¬Æô¶¯Êý¾Ý¿â£¬Æô¶¯ÕìÌý£¬¿´×źÜÕý³££¬µ«ÊÇÔÚ¿Í»§¶ËµÄTNSPING
C:\>tnsping homedb
TNS Ping Utility for 32-bit Window ......
ɾ³ýORACLE FOR windows µÄoci.dll´íÎóµÄ½â¾ö·½·¨
ɾ³ýORACLE FOR windows µÄoci.dll´íÎóµÄ½â¾ö·½·¨
½ñÌì·¢ÏÖ×Ô¼ºÌ¨Ê½»úÉϵÄORACLEÓÐÎÊÌ⣬´òËãÖØװһϣ¬·¢ÏÖÕû¸öORACLEĿ¼ɾ³ý£¬±¨OCI.DLLÎÞ·¨É¾³ý´íÎó£¬Ñо¿ÁËһϣ¬
·¢ÏֹصôMSDTC·þÎñ¾Í¿ÉÒÔÁË£¬MSDTC·þÎñÔÚϵͳÖеķþÎñÃûΪ
Distributed T ......
ÔÚORACLE8Öж¨ÒåÁË£º±êÁ¿(Scalar)¡¢¸´ºÏ(COMPOSITE)¡¢ÒýÓÃ(REFERENCE)ºÍLOBËÄÖÖÊý¾ÝÀàÐÍ¡£
£¨Ò»£©±êÁ¿(Scalar)
±êÁ¿ÀàÐÍÓëÊý¾Ý¿âµÄÁÐËùʹÓõÄÀàÐÍÏàͬ£¬´ËÍâËü»¹ÓÐһЩÀ©Õ¹¡£
ËüÓÖ·ÖΪÆ߸ö×飺Êý×Ö¡¢×Ö·û¡¢ÐС¢ÈÕÆÚ¡¢Ðбêʶ¡¢²¼¶ûºÍ¿ÉÐÅ¡£
¢ÙÊý×Ö
¡¡
ÓÐÈ ......