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

发表于2019年1月31日由oracle

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

 

  处理方法其实很简单、只要：

     alter user <username> identified by <same password>;

 这个操作后，恢复正常了

     

     下面作个简单测试：

[plain]SQL> conn hr/hr  ERROR:  ORA-28002: the password will expire within 2 days      Connected.  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 passoracle账号word will expire within 2 days      Connected.  SQL> conn / as sysdba  Connected.  SQL> alter user scott identified by tiger;    User altered.    SQL> conn scott/tiger  Connected.

 

 

此条目发表在oracle metalink账号分类目录，贴了标签。将固定链接加入收藏夹。