十四、Oracle用户密码过期

king's blog
在使用oracle的过程中,会经常遇到oracle用户密码过期的情况,遇到这种情况,我们该如何处理呢?本节我们就来聊聊这个话题。

问题描述

Oracle用户密码有效期一般为180天,过了有效期,则无法登录

具体步骤

步骤一:用DBA权限的用户查看有哪些具体的oracle用户

sqlplus / as sysdba
SQL> select username,PROFILE from dba_users;
oracle密码过期

步骤二:查询账户密码的有效期

sql>SELECT * FROM dba_profiles s where s.profile=’DEFAULT’ AND s.resource_name=’PASSWORD_LIFE_TIME’;
oracle密码过期

步骤三:将用户密码有效期修改为永不过期

SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
oracle密码过期

步骤四:alter user ** identified by password

将步骤一查到到数据库用户,再执行一遍,具体如下:
alter user SS identified by excel;
alter user RPT_USER identified by excel;
alter user RPT_ENG identified by excel;
alter user REAPS_DEV identified by excel;
alter user REAPS_USER identified by excel;
alter user DIP identified by excel;
alter user ORACLE_OCM identified by excel;
alter user DBSNMP identified by excel;
alter user WMSYS identified by excel;
alter user APPQOSSYS identified by excel;
alter user SYS identified by excel;
alter user SYSTEM identified by excel;
alter user OUTLN identified by excel;

Tags:
文 / 甲乙丙丁
LEAVE A REPLY

loading