当前位置:Gxlcms > mysql > Oracle提示错误消息ORA

Oracle提示错误消息ORA

时间:2021-07-01 10:21:17 帮助过:25人阅读

Oracle提示错误消息ORA-28001: the password has expired 解决办法: 1、利用SYSDBA权限登陆; 2、查看账户信息: select username,account_status from dba_users 3、如果账户locked/ expired, 得先解锁: alter user BJMMIS account unlock; 再修改密码 a

Oracle提示错误消息ORA-28001: the password has expired


解决办法:

1、利用SYSDBA权限登陆;

2、查看账户信息:

select username,account_status from dba_users

3、如果账户locked/expired,

得先解锁:

alter user BJMMIS account unlock;

再修改密码

alter user BJMMIS identified by newpwd;

一劳永逸破解11G180天自动密码失效的办法:

查询密码有效期

SELECT * FROM dba_profiles WHERE profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME'

修改为无限制:

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED

人气教程排行