ORA-28001: the password has expired (DBD ERROR: OCISessionBegin)
问题描述:当登陆em时使用sys帐号登陆进去后,数据库实例提示ORA-28001: the password has expired (DBD ERROR: OCISessionBegin)
解决办法如下:
- SQL> select username,account_status from dba_users;
- USERNAME ACCOUNT_STATUS
- -------------------- --------------------
- MGMT_VIEW OPEN
- SYS OPEN
- SYSTEM OPEN
- DBSNMP EXPIRED
- SYSMAN EXPIRED
- OUTLN EXPIRED & LOCKED
- FLOWS_FILES EXPIRED & LOCKED
- MDSYS EXPIRED & LOCKED
- ORDSYS EXPIRED & LOCKED
- EXFSYS EXPIRED & LOCKED
- WMSYS EXPIRED & LOCKED
- APPQOSSYS EXPIRED & LOCKED
- APEX_030200 EXPIRED & LOCKED
- OWBSYS_AUDIT EXPIRED & LOCKED
- ORDDATA EXPIRED & LOCKED
- CTXSYS EXPIRED & LOCKED
- ANONYMOUS EXPIRED & LOCKED
- XDB EXPIRED & LOCKED
- ORDPLUGINS EXPIRED & LOCKED
- OWBSYS EXPIRED & LOCKED
- SI_INFORMTN_SCHEMA EXPIRED & LOCKED
- OLAPSYS EXPIRED & LOCKED
- SCOTT EXPIRED & LOCKED
- ORACLE_OCM EXPIRED & LOCKED
- XS$NULL EXPIRED & LOCKED
- BI EXPIRED & LOCKED
- PM EXPIRED & LOCKED
- MDDATA EXPIRED & LOCKED
- IX EXPIRED & LOCKED
- SH EXPIRED & LOCKED
- DIP EXPIRED & LOCKED
- OE EXPIRED & LOCKED
- APEX_PUBLIC_USER EXPIRED & LOCKED
- HR EXPIRED & LOCKED
- SPATIAL_CSW_ADMIN_US EXPIRED & LOCKED
- R
- SPATIAL_WFS_ADMIN_US EXPIRED & LOCKED
- R
- 已选择36行。
修改sysman密码
- alter user sysman identified by [passwd]
- alter user sysman account unlocked;
oracle 默认的profile的password有效期是180天,之后会过期。
- SQL> select profile,resource_name,limit from dba_profiles where profile like 'DEFAULT';
- PROFILE RESOURCE_NAME LIMIT
- -------------------- ------------------------------ --------------------
- DEFAULT COMPOSITE_LIMIT UNLIMITED
- DEFAULT SESSIONS_PER_USER UNLIMITED
- DEFAULT CPU_PER_SESSION UNLIMITED
- DEFAULT CPU_PER_CALL UNLIMITED
- DEFAULT LOGICAL_READS_PER_SESSION UNLIMITED
- DEFAULT LOGICAL_READS_PER_CALL UNLIMITED
- DEFAULT IDLE_TIME UNLIMITED
- DEFAULT CONNECT_TIME UNLIMITED
- DEFAULT PRIVATE_SGA UNLIMITED
- DEFAULT FAILED_LOGIN_ATTEMPTS 10
- DEFAULT PASSWORD_LIFE_TIME 180
- DEFAULT PASSWORD_REUSE_TIME UNLIMITED
- DEFAULT PASSWORD_REUSE_MAX UNLIMITED
- DEFAULT PASSWORD_VERIFY_FUNCTION NULL
- DEFAULT PASSWORD_LOCK_TIME 1
- DEFAULT PASSWORD_GRACE_TIME 7
实验环境可以改为无限制日期的。
- alter profile default limit password_life_time unlimited;
本文出自 “lkl_1981” 博客,请务必保留此出处http://lkl1981.blog.51cto.com/610669/920937