oracle´´½¨±í¿Õ¼ä¡¢Óû§¡¢ÊÚȨ
//´´½¨Êý¾Ý±í¿Õ¼ä
create tablespace zfmi logging datafile 'D:\oracle\oradata\zfmi\zfmi.dbf' size 100m autoextend on next 32m maxsize 2048m extent management local;
//´´½¨Óû§²¢Ö¸¶¨±í¿Õ¼ä
create user zfmi identified by zfmi default tablespace zfmi temporary tablespace zfmi_temp;
//¸øÓû§ÊÚÓèȨÏÞ
grant connect,resource,dba to zfmi; (dba£ºÖ¸¶¨ËùÓÐȨÏÞ)
Ïà¹ØÎĵµ£º
ÔÚ°²×°ÍêOracle
10gÖ®ºó£¬Ïë´ò¿ªsql*plusÀ´Ñ§Ï°£¬È»ºó°´ÕÕÊéÉϵIJ½ÖèÓÃscottÓû§À´Á¬½ÓÊý¾Ý¿â£¬¿ÉÊäÁ˺ü¸´Î¶¼Ìáʾһ¸ö´íÎó¡£
error£º the account is locked
È»ºóÉÏÍø²éÁËÒ»ÏÂÖ®ºó·¢ÏÖÕâ¸öÓû§±»Ëø¶¨ÁË£¬ÖÁÓÚËüΪʲô±»Ëø¶¨£¬¿ÉÄÜÊÇÏÂÃæ¼¸¸öÔÒò¡£
1.³¢ÊÔ¶à´ÎµÇ¼δ³É¹¦.(¿ÉÄÜÃÜÂë²»ÕýÈ·)
2.´ËÓû§±»¹ÜÀíÔ±ÊÖ¹¤Ëø¶¨ ......
oracleÀïµÄ³£ÓÃÃüÁîÏê½â
±¾ÎÄÕë¶ÔoracleÈÕ³£µÄÃûÁî×öÁ˽éÉÜ£¬»¶Ó¸÷λ´óÏÀ¶àÌᱦ¹óÒâ¼ûºÍ¶à¶à²¹³ä£¡
Ò»
ÈÕÖ¾¹ÜÀí
1.forcing log switches
sql> alter system switch logfile;
2.forcing checkpoints
sql> alter system checkpoint;
3.adding online redo log groups
sql> alter database add logfil ......
½ñÌì×ö¸ß¼¶¸´ÖÆÊµÑ飬ִÐе½Ìí¼Ómaster siteʱÓöµ½´ËÎÊÌ⣬ÉÏÍøËÑÁËËÑ£¬ÓÐÈçϼ¸ÖÖÒâ¼û£º
1.ÊÚȨ¹ý³Ì²»¶Ô——Çë×Ðϸ°´ÕÕÎĵµÉϵÄ˵Ã÷½øÐС£
2.°æ±¾ÎÊÌâ——¿É²é¿´v$optionÊÓͼÖÐÏà¹Ø²ÎÊýÊÇ·ñΪtrue¡£
3.°æ±¾ÎÊÌâ——ÓиöתÌùmetalinkµÄÎÄÕÂÉÏ˵ֻÓÐoracleÆóÒµ°æÖ§³Ö¸ß¼¶¸´ÖÆ¡£
¶¼Ã»Óн⾠......
ÔÚORACLEʵÀýÆô¶¯Ê±³ýÁË·ÖÅäÒ»¿éºÜ´óÇøÓòµÄÄÚ´æÍ⣬»¹»áÆô¶¯Ò»ÏµÁеĽø³Ì¡£OracleÖеĽø³ÌÓÐÄÄÐ©ÌØµã£¿
ORACLE½ø³Ì¿ÉÒÔ·ÖΪÓû§½ø³Ì¡¢·þÎñÆ÷½ø³Ì¡¢ºǫ́½ø³Ì¡£
Óû§½ø³Ì£ºÓû§Á¬½ÓÊý¾Ý¿âʱ»á´´½¨Ò»¸öÓû§½ø³Ì£¬¸Ã½ø³ÌÓÃÓںͷþÎñÆ÷½øÐлỰ£¬ÏòÊý¾Ý¿â·þÎñÆ÷·¢ÉúÇëÇ󣬽ÓÊÕÊý¾Ý¿âµÄÏìÓ¦¡£
·þÎñÆ÷½ø³Ì£ºÓÉORACLEÊý¾Ý¿â·þÎñÆ÷ ......
ÈÏʶ´æ´¢¹ý³ÌºÍº¯Êý
´æ´¢¹ý³ÌºÍº¯ÊýÒ²ÊÇÒ»ÖÖPL/SQL¿é£¬ÊÇ´æÈëÊý¾Ý¿âµÄPL/SQL¿é¡£µ«´æ´¢¹ý³ÌºÍº¯Êý²»Í¬ÓÚÒѾ½éÉܹýµÄPL/SQL³ÌÐò£¬ÎÒÃÇͨ³£°ÑPL/SQL³ÌÐò³ÆÎªÎÞÃû¿é£¬¶ø´æ´¢¹ý³ÌºÍº¯ÊýÊÇÒÔÃüÃûµÄ·½Ê½´æ´¢ÓÚÊý¾Ý¿âÖеġ£ºÍPL/SQL³ÌÐòÏà±È£¬´æ´¢¹ý³ÌÓкܶàÓŵ㣬¾ßÌå¹éÄÉÈçÏ£º
* ´æ´¢¹ý³ÌºÍº¯ÊýÒÔÃüÃûµÄÊý¾Ý¿â¶ÔÏóÐÎʽ´æ´¢ ......