Oracle 11g´æÔÚÃÜÂë¹ýÆÚÎÊÌâ
¡¾ÔÒò/´¥·¢ÒòËØ¡¿
È·¶¨ÊÇÓÉÓÚoracle11gÖÐĬÈÏÔÚdefault¸ÅÒªÎļþÖÐÉèÖÃÁË“PASSWORD_LIFE_TIME=180Ìì”Ëùµ¼Ö¡£
¡¾Ó°ÏìºÍ·çÏÕ¡¿
Ó°Ïì
ÃÜÂë¹ýÆÚºó£¬ÒµÎñ½ø³ÌÁ¬½ÓÊý¾Ý¿âÒì³££¬Ó°ÏìÒµÎñʹÓá£
ÎÊÌâ·¢ÉúƵÂÊ
Êý¾Ý¿âÃÜÂë¹ýÆÚºó£¬ÒµÎñ½ø³ÌÒ»µ©ÖØÆô»áÌáʾÁ¬½Óʧ°Ü¡£
¡¾½â¾ö·½°¸¡¿
°´ÕÕÈçϲ½Öè½øÐвÙ×÷£º
1¡¢²é¿´Óû§µÄproifleÊÇÄĸö£¬Ò»°ãÊÇdefault£º
sql>SELECT username,PROFILE from dba_users;
2¡¢²é¿´Ö¸¶¨¸ÅÒªÎļþ£¨Èçdefault£©µÄÃÜÂëÓÐЧÆÚÉèÖãº
sql>SELECT * from dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
3¡¢½«ÃÜÂëÓÐЧÆÚÓÉĬÈϵÄ180ÌìÐ޸ijɓÎÞÏÞÖÆ”£º
sql>ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
ÐÞ¸ÄÖ®ºó²»ÐèÒªÖØÆô¶¯Êý¾Ý¿â£¬»áÁ¢¼´ÉúЧ¡£
4¡¢Ð޸ĺ󣬻¹Ã»Óб»ÌáʾORA-28002¾¯¸æµÄÕÊ»§²»»áÔÙÅöµ½Í¬ÑùµÄÌáʾ£»
ÒѾ±»ÌáʾµÄÕÊ»§±ØÐëÔÙ¸ÄÒ»´ÎÃÜÂ룬¾ÙÀýÈçÏ£º
$sqlplus / as sysdba
sql> alter user smsc identified by <ÔÀ´µÄÃÜÂë> ----²»Óû»ÐÂÃÜÂë
oracle11gÆô¶¯²ÎÊýresource_limitÎÞÂÛÉèÖÃΪfalse»¹ÊÇtrue£¬ÃÜÂëÓÐЧÆÚ¶¼ÊÇÉúЧµÄ£¬ËùÒÔ±ØÐëͨ¹ýÒÔÉÏ·½Ê½½øÐÐÐ޸ġ£ÒÔÉϵÄÕÊ»§ÃûÇë¸ù¾Ýʵ¼ÊʹÓõÄÕÊ»§Ãû¸ü¸Ä¡£
¶þ¡¢¡¾ÎÊÌâÃèÊö¡¿
½üÈÕH¾Öµã·´À¡£¬Ê¹ÓÃsqlplusµÇ½¶ÌÏûÏ¢oracleÊý¾Ý¿âʱÌáʾ“ORA-28000: Õʺű»Ëø¶¨”¡£
¡¾ÔÒò/´¥·¢ÒòËØ¡¿
È·¶¨ÊÇÓÉÓÚoracle11gÖÐĬÈÏÔÚdefault¸ÅÒªÎļþÖÐÉèÖÃÁË“FAILED_LOGIN_ATTEMPTS=10´Î”£¬µ±ÊäÈëÃÜÂë´íÎó´ÎÊý´ïµ½ÉèÖÃÖµ½«µ¼Ö´ËÎÊÌâ¡£
¡¾Ó°ÏìºÍ·çÏÕ¡¿
Ó°Ïì
Õʺű»Ëø¶¨ºó£¬ÒµÎñ½ø³ÌÁ¬½ÓÊý¾Ý¿âÒì³££¬Ó°ÏìÒµÎñʹÓá£
ÎÊÌâ·¢ÉúƵÂÊ
Êý¾Ý¿âÕʺű»Ëø¶¨ºó£¬ÒµÎñ½ø³ÌÒ»µ©ÖØÆô»áÌáʾÁ¬½Óʧ°Ü¡£
¡¾½â¾ö·½°¸¡¿
°´ÕÕÈçϲ½Öè½øÐвÙ×÷£º
1¡¢²é¿´Óû§µÄproifleÊÇÄĸö£¬Ò»°ãÊÇdefault£º
sql>SELECT username,PROFILE from dba_users;
2¡¢²é¿´Ö¸¶¨¸ÅÒªÎļþ£¨Èçdefault£©µÄÃÜÂëÓÐЧÆÚÉèÖãº
sql>SELECT * from dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='FAILED_LOGIN_ATTEMPTS';
3¡¢½«³¢ÊԵǼʧ°Ü´ÎÊýÓÉĬÈϵÄ10´ÎÐ޸ijɓÎÞÏÞÖÆ”£º
sql>ALTER PROFILE DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED;
4¡¢Ð޸ĺ󣬻¹Ã»Óб»ÌáʾORA-28000¾¯¸æµÄÓû§²»»áÔÙÅöµ½Í¬ÑùµÄÌáʾ£»
ÒѾ±»Ëø¶¨µÄÕÊ»§±ØÐë½
Ïà¹ØÎĵµ£º
select * from (
select cw2.NO WHOLENO,sp1.ARGUMENTNAME TYPENAME,sp2.ARGUMENTNAME BRANDNAME,sp3.ARGUMENTNAME STYLENAME,sp4.ARGUMENTNAME DEPART,so.OPERATORNAME USERNAME
from COM_WHOLE_INFO cw2,SYS_OPERATOR so, SYS_PUBLICARGUMENT sp1, SYS_PUBLICARGUMEN ......
¸Õ¿ªÊ¼Ñ§Ï°Orace£¬Óöµ½Ò»Ð©·Ç³£ºÃµÄÊ飬ÔÚÏÂÃæÁгö£¬Ëæ×ÅѧϰµÄÉîÈë»á°ÑÓöµ½µÄºÃÊ鶼ÁгöÀ´£¬¹©Ñ§Ï°OracleµÄÅóÓѲο¼£¬
Ò²»¶Ó¸÷λÅóÓѲ¹³ä£º
»ù´¡£º
1. ORACLE DBA»ù´¡Åàѵ½Ì³Ì ºÎÃ÷Öø Ç廪´óѧ³ö°æÉç
&n ......
Íâ¼üÔ¼Êø±£Ö¤²ÎÕÕÍêÕûÐÔ¡£Íâ¼üÔ¼ÊøÏÞ¶¨ÁËÒ»¸öÁеÄÈ¡Öµ·¶Î§¡£Ò»¸öÀý×Ó¾ÍÊÇÏÞ¶¨ÖÝÃûËõдÔÚÒ»¸öÓÐÏÞÖµ¼¯ºÏÖУ¬Õâ¸öÖµ¼¯ºÏÊÇÁíÍâÒ»¸ö¿ØÖƽṹ——Ò»ÕŸ¸±í
ÏÂÃæÎÒÃÇ´´½¨Ò»ÕŲÎÕÕ±í£¬ËüÌṩÁËÍêÕûµÄÖÝËõдÁÐ±í£¬È»ºóʹÓòÎÕÕÍêÕûÐÔÈ·±£Ñ§ÉúÃÇÓÐÕýÈ·µÄÖÝËõд¡£µÚÒ»ÕűíÊÇÖݲÎÕÕ±í£¬State×÷Ϊ ......
OracleµÄÔÚÏßÖض¨Òå±í¹¦ÄÜ
http://blog.itpub.net/post/468/12855
http://blog.itpub.net/post/468/12962
ÔÚÒ»¸ö¸ß¿ÉÓÃϵͳÖУ¬Èç¹ûÐèÒª¸Ä±äÒ»¸ö±íµÄ¶¨ÒåÊÇÒ»¼þ±È½Ï¼¬ÊÖµÄÎÊÌ⣬ÓÈÆäÊǶÔÓÚ7×24ϵͳ¡£OracleÌṩµÄ»ù±¾Óï·¨»ù±¾¿ÉÒÔÂú×ãÒ»°ãÐÔÐ޸ģ¬µ«ÊǶÔÓÚ°ÑÆÕͨ¶Ñ±í¸ÄΪ·ÖÇø±í£¬°ÑË÷Òý×éÖ¯±íÐÞ¸ÄΪ¶Ñ±íµÈ²Ù×÷¾ÍÎÞ ......
Á©Ì¨²»Í¬µÄÊý¾Ý¿â·þÎñÆ÷£¬´Óһ̨Êý¾Ý¿â·þÎñÆ÷µÄÒ»¸öÓû§¶ÁÈ¡Áíһ̨Êý¾Ý¿â·þÎñÆ÷ϵÄij¸öÓû§µÄÊý¾Ý£¬Õâ¸öʱºò¿ÉÒÔʹÓÃdblink¡£
ÆäʵdblinkºÍÊý¾Ý¿âÖеÄview²î²»¶à£¬½¨dblinkµÄʱºòÐèÒªÖªµÀ´ý¶ÁÈ¡Êý¾Ý¿âµÄipµØÖ·£¬ssidÒÔ¼°Êý¾Ý¿âÓû§ÃûºÍÃÜÂë¡£
´´½¨¿ÉÒÔ ......