我不能再login到Oracle企业pipe理器11g。 我得到这个错误消息:
ORA-28001: the password has expired (DBD ERROR: OCISessionBegin)
我可以使用SQL Pluslogin到服务器。 我警告说密码将在7天内过期(这与已经过期的不一样)。 遵循几个文档的build议,我从SQL Plus 运行这些命令 :
ALTER USER sys IDENTIFIED BY new_password; ALTER USER system IDENTIFIED BY new_password;
SQL * Plus不再警告密码,但我仍然无法使用企业pipe理器。 然后我按照这个去掉密码到期:
ALTER PROFILE default LIMIT password_life_time UNLIMITED
而且我也重新启动了Oracle服务。 如果它使用caching的凭据,我试图从几台计算机上的几个浏览器连接。
没办法:我仍然在企业pipe理器中获得ORA-28001。 我错过了什么?
SQL> select username,ACCOUNT_STATUS,EXPIRY_DATE from dba_users; USERNAME ACCOUNT_STATUS EXPIRY_D ------------------------------ -------------------------------- -------- MGMT_VIEW OPEN SYS OPEN SYSTEM OPEN [...] DBSNMP EXPIRED 24/05/10 SYSMAN EXPIRED 24/05/10 OUTLN EXPIRED & LOCKED 16/11/09 FLOWS_FILES EXPIRED & LOCKED 16/11/09 USERNAME ACCOUNT_STATUS EXPIRY_D ------------------------------ -------------------------------- -------- MDSYS EXPIRED & LOCKED 16/11/09 ORDSYS EXPIRED & LOCKED 16/11/09 EXFSYS EXPIRED & LOCKED 16/11/09 WMSYS EXPIRED & LOCKED 16/11/09 WKSYS EXPIRED & LOCKED 16/11/09 WK_TEST EXPIRED & LOCKED 16/11/09 CTXSYS EXPIRED & LOCKED 16/11/09 ANONYMOUS EXPIRED & LOCKED 16/11/09 XDB EXPIRED & LOCKED 16/11/09 WKPROXY EXPIRED & LOCKED 16/11/09 ORDPLUGINS EXPIRED & LOCKED 16/11/09 USERNAME ACCOUNT_STATUS EXPIRY_D ------------------------------ -------------------------------- -------- FLOWS_030000 EXPIRED & LOCKED 16/11/09 OWBSYS EXPIRED & LOCKED 16/11/09 SI_INFORMTN_SCHEMA EXPIRED & LOCKED 16/11/09 OLAPSYS EXPIRED & LOCKED 16/11/09 SCOTT EXPIRED & LOCKED 16/11/09 ORACLE_OCM EXPIRED & LOCKED 16/11/09 TSMSYS EXPIRED & LOCKED 16/11/09 XS$NULL EXPIRED & LOCKED 16/11/09 BI EXPIRED & LOCKED 16/11/09 PM EXPIRED & LOCKED 16/11/09 MDDATA EXPIRED & LOCKED 16/11/09 USERNAME ACCOUNT_STATUS EXPIRY_D ------------------------------ -------------------------------- -------- IX EXPIRED & LOCKED 16/11/09 SH EXPIRED & LOCKED 16/11/09 DIP EXPIRED & LOCKED OE EXPIRED & LOCKED 16/11/09 APEX_PUBLIC_USER EXPIRED & LOCKED 16/11/09 HR EXPIRED & LOCKED 16/11/09 SPATIAL_CSW_ADMIN_USR EXPIRED & LOCKED 16/11/09 SPATIAL_WFS_ADMIN_USR EXPIRED & LOCKED 16/11/09
无耻的自我推销当企业pipe理器无法连接到数据库实例(ORA-28001)时该怎么办?
看看你的SYSMAN和DBSNMP用户。 AFAIK EM使用它们。
DBSNMP EXPIRED 24/05/10 SYSMAN EXPIRED
请更改这两个用户密码,然后重试。