oracle11gÃÜÂë¹ýÆÚ
oracle11gÓû§ÃÜÂë¹ýÆÚ½â¾ö·½·¨ - °Ù¶È¾Ñé
1 1.ÔÚoracle11gÖÐд´½¨µÄÓû§ÃÜÂëÓÐЧÆÚĬÈÏΪ180Ìì 2 2.ÔÚÐÞ¸ÄÃÜÂë֮ǰÏȲéѯÓû§Ê¹ÓõĸÅÒªÎļþÊÇ...
ÈçºÎ´¦ÀíOracle 11g ÃÜÂë¹ýÆÚÎÊÌâ - °Ù¶È¾Ñé
7 ¼ì²éÃÜÂëµÄÓÐЧÆÚÊÇ·ñΪĬÈϵÄ180Ì죺SQL> SELECT * FROM dba_profiles WHERE profile='DEFAULT'...
oracle 11g Êý¾Ý¿âÃÜÂë¹ýÆÚÔõô°ì?
ÃÜÂë¹ýÆÚÁË£¬¿ÉÒÔÓÃsys as sysdbaÓû§½øÈ¥£¬Ê¹ÓÃalter user username identified by passwd;ÐÞ¸Äһϡ£\x0d\x0aÃÜÂë¶àÉÙÌì¹ýÆÚÒÔ...
OracleÃÜÂë¹ýÆÚ ÔõôÐÞ¸Ä - °Ù¶È¾Ñé
¾ÙÀýÈçÏ£º$sqlplus / as sysdbasql> alter user smsc identified by <ÔÀ´µÄÃÜÂë> ---²»Óû»ÐÂÃÜÂëoracle11gÆô¶¯²ÎÊýresource_limitÎÞÂÛÉèÖÃ...
OracleÃÜÂë¹ýÆÚ ÔõôÐÞ¸Ä
sql> alter user smsc identified by <ÔÀ´µÄÃÜÂë> ---²»Óû»ÐÂÃÜÂë oracle11gÆô¶¯²ÎÊýresource_limitÎÞÂÛÉèÖÃΪfalse»¹ÊÇtrue£¬...
oracleÊý¾Ý¿âÃÜÂë¹ýÆÚÔõô°ì?
$sqlplus / as sysdba\x0d\x0a sql> alter user smsc identified by ---²»Óû»ÐÂÃÜÂë\x0d\x0aoracle11gÆô¶¯²ÎÊýre...
ÈçºÎ´¦ÀíOracle 11g ÃÜÂë¹ýÆÚÎÊÌâ
£¨1£©ÖØÉèÃÜÂë £¨2£©ÐÞ¸Äprofile£¬²»ÊÇprofileÎļþ£¬¶øÊÇoracleµÄĬÈÏÉèÖõÄÒ»¸öÓû§¹æÔò£¬½«ÃÜÂëÆÚÏÞ¸ÄһϾͿÉÒÔÁË¡£Õâ¸öÍøÉÏÓÐ...
oracleÃÜÂë´íÎó´ÎÊý¶à¾Ãºó»áÇå³ý
Oracle11gÖÐĬÈÏÔÚdefault¸ÅÒªÎļþÖÐÉèÖÃÁË¡°PASSWORD_LIFE_TIME=180Ì족£¬ÒòΪÓû§ÃÜÂë¹ýÆÚ£¬»áÔì³ÉÓû§ÎÞ·¨µÇ½OracleÊý¾Ý¿â¡£ÃÜÂëÒÑ...
oracle»·¾³,ÓÐÒ»¸öÓû§µÄÃÜÂëÍüµôÁË,²¢ÇÒÓû§¹ýÆÚ,ÔõôÄܹ»...
Oracle 11g ֮ǰĬÈϵÄÓû§Ê±ÊÇûÓÐÃÜÂë¹ýÆÚµÄÏÞÖƵģ¬ÔÚOracle 11g ÖÐĬÈϵÄprofileÆôÓÃÁËÃÜÂë¹ýÆÚʱ¼äÊÇ180Ìì¡£ÈçÏ£ºselect * ...
ORA - 28002: the password will expire½â¾ö°ì·¨ - °Ù¶È¾Ñé
Oracle11g R2Êý¾Ý¿âÌáʾORA-28002: the password will expire within 5 days£¬ÊÇ˵ÃÜÂë¹ýÆÚ£¬½«OracleÃÜÂëÉèÖóÉ...