转ï¼
et oracle_sid=æ°æ®åºå称ï¼è¾å
¥sqlplusâ/ as sysdba
Select username,password from dba_users where username=âallready'
è¯å¥ä¸ºï¼alter user system identified by oracle ;
alter user allready identified 123456ard
connect system/oracle
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;
ä¿®æ¹ä¹åä¸éè¦éå¯å¨æ°æ®åºï¼ä¼ç«å³çæã
温馨提示:答案为网友推荐,仅供参考