启用密码管理之前创建的用户连接Oracle报ORA-28002处理一则

     处理方法其实很简单、只要：
     alter user identified by ;  这个操作后，恢复正常了
     

     下面作个简单测试：

SQL> conn hr/hr
ERROR:
ORA-28002: the password will expire within 2 daysConnected.
SQL> conn / as sysdba
Connected.
SQL> alter user hr identified by hr;User altered.SQL> conn hr/hr
Connected.
SQL> conn scott/tiger
ERROR:
ORA-28002: the password will expire within 2 daysConnected.
SQL> conn / as sysdba
Connected.
SQL> alter user scott identified by tiger;User altered.SQL> conn scott/tiger
Connected.

By DBA_WaterBin

2013-08-02

Good Luck

转载于:https://www.cnblogs.com/jiangu66/p/3233801.html

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！