æ¯ç±äº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天修æ¹æâæ éå¶âï¼
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ï¼å¯ç æææé½æ¯çæçï¼æ以å¿
é¡»éè¿ä»¥ä¸æ¹å¼è¿è¡ä¿®æ¹ã以ä¸çå¸æ·åè¯·æ ¹æ®å®é
使ç¨çå¸æ·åæ´æ¹ã
温馨提示:答案为网友推荐,仅供参考