oracle 11.2.0.1 oem(企業管理器)無法正常登陸：提示例項未啟動

值得注意的是，從sqlplus中執行命令檢查資料庫的狀態，資料庫是open 的。如下：

Microsoft Windows [版本 5.2.3790]
(C) 版權所有 1985-2003 Microsoft Corp.

C:Documents and SettingsAdministrator>hostname
vm2003

C:Documents and SettingsAdministrator>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on 星期日 7月 31 17:57:17 2011

Copyright (c) 1982, 2010, Oracle. All rights reserved.

連線到:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select open_mode from v$database;

OPEN_MODE
--------------------
READ WRITE

問題分析：

資料庫是已經open的，但是網頁版的oem無法正常登陸，提示資料庫例項未啟動（向下指的紅色箭頭），連線到例項的代理未啟動（向下指的紅色箭頭），還有ora-28001的提示：ORA-28001: the password has expired (DBD ERROR: OCISessionBegin)

過期？？？oem 的正常使用需要dbsnmp和sysman這兩個使用者，莫非這兩個使用者過期了？然後繼續向下看。

SQL> select username from dba_users;

USERNAME
------------------------------
CW0030002
CW0038888
CW0033333
CW0030003
CW0030001
LC0039999
LC0029999
LC0069999
CW0011111
LC0019999
SCOTT

USERNAME
------------------------------
ORACLE_OCM
XS$NULL
MDDATA
DIP
APEX_PUBLIC_USER
SPATIAL_CSW_ADMIN_USR
SPATIAL_WFS_ADMIN_USR
DBSNMP
SYSMAN
FLOWS_FILES
MDSYS

USERNAME
------------------------------
ORDSYS
EXFSYS
WMSYS
APPQOSSYS
APEX_030200
OWBSYS_AUDIT
ORDDATA
CTXSYS
ANONYMOUS
XDB
ORDPLUGINS

USERNAME
------------------------------
OWBSYS
SI_INFORMTN_SCHEMA
OLAPSYS
MGMT_VIEW
SYS
SYSTEM
OUTLN

已選擇40行。

SQL>
SQL>
SQL> desc dba_users;
名稱 是否為空? 型別
----------------------------------------- -------- ----------------------------

USERNAME NOT NULL VARCHAR2(30)
USER_ID NOT NULL NUMBER
PASSWORD VARCHAR2(30)
ACCOUNT_STATUS NOT NULL VARCHAR2(32)
LOCK_DATE DATE
EXPIRY_DATE DATE
DEFAULT_TABLESPACE NOT NULL VARCHAR2(30)
TEMPORARY_TABLESPACE NOT NULL VARCHAR2(30)
CREATED NOT NULL DATE
PROFILE NOT NULL VARCHAR2(30)
INITIAL_RSRC_CONSUMER_GROUP VARCHAR2(30)
EXTERNAL_NAME VARCHAR2(4000)
PASSWORD_VERSIONS VARCHAR2(8)
EDITIONS_ENABLED VARCHAR2(1)
AUTHENTICATION_TYPE VARCHAR2(8)

SQL> select username, account_status from dba_users;

USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
CW0030002 OPEN
CW0038888 OPEN
CW0033333 OPEN
CW0030003 OPEN
CW0030001 OPEN
LC0039999 OPEN
LC0029999 OPEN
LC0069999 OPEN
CW0011111 OPEN
LC0019999 OPEN
SCOTT EXPIRED

USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
ORACLE_OCM EXPIRED & LOCKED
XS$NULL EXPIRED & LOCKED
MDDATA EXPIRED & LOCKED
DIP EXPIRED & LOCKED
APEX_PUBLIC_USER EXPIRED & LOCKED
SPATIAL_CSW_ADMIN_USR EXPIRED & LOCKED
SPATIAL_WFS_ADMIN_USR EXPIRED & LOCKED
DBSNMP EXPIRED
SYSMAN EXPIRED

FLOWS_FILES EXPIRED & LOCKED
MDSYS EXPIRED & LOCKED

USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
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

USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
OWBSYS EXPIRED & LOCKED
SI_INFORMTN_SCHEMA EXPIRED & LOCKED
OLAPSYS EXPIRED & LOCKED
MGMT_VIEW OPEN
SYS OPEN
SYSTEM OPEN
OUTLN EXPIRED & LOCKED

已選擇40行。

SQL> alter user dbsnmp identified by aaaaaa;

使用者已更改。

此時改完之後，連線到例項的代理已經啟動（向上指的綠色箭頭）。但是資料庫例項依然顯示未啟動。

SQL> select username, account_status from dba_users;

USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
CW0030002 OPEN
CW0038888 OPEN
CW0033333 OPEN
CW0030003 OPEN
CW0030001 OPEN
LC0039999 OPEN
LC0029999 OPEN
LC0069999 OPEN
CW0011111 OPEN
LC0019999 OPEN
SCOTT EXPIRED

USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
ORACLE_OCM EXPIRED & LOCKED
XS$NULL EXPIRED & LOCKED
MDDATA EXPIRED & LOCKED
DIP EXPIRED & LOCKED
APEX_PUBLIC_USER EXPIRED & LOCKED
SPATIAL_CSW_ADMIN_USR EXPIRED & LOCKED
SPATIAL_WFS_ADMIN_USR EXPIRED & LOCKED
DBSNMP OPEN
SYSMAN EXPIRED

FLOWS_FILES EXPIRED & LOCKED
MDSYS EXPIRED & LOCKED

USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
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

USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
OWBSYS EXPIRED & LOCKED
SI_INFORMTN_SCHEMA EXPIRED & LOCKED
OLAPSYS EXPIRED & LOCKED
MGMT_VIEW OPEN
SYS OPEN
SYSTEM OPEN
OUTLN EXPIRED & LOCKED

已選擇40行。

SQL>
SQL> alter user sysman identified by aaaaaa;

使用者已更改。

SQL> select username, account_status from dba_users;

USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
CW0030002 OPEN
CW0038888 OPEN
CW0033333 OPEN
CW0030003 OPEN
CW0030001 OPEN
LC0039999 OPEN
LC0029999 OPEN
LC0069999 OPEN
CW0011111 OPEN
LC0019999 OPEN
SCOTT EXPIRED

USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
ORACLE_OCM EXPIRED & LOCKED
XS$NULL EXPIRED & LOCKED
MDDATA EXPIRED & LOCKED
DIP EXPIRED & LOCKED
APEX_PUBLIC_USER EXPIRED & LOCKED
SPATIAL_CSW_ADMIN_USR EXPIRED & LOCKED
SPATIAL_WFS_ADMIN_USR EXPIRED & LOCKED
DBSNMP OPEN
SYSMAN OPEN

FLOWS_FILES EXPIRED & LOCKED
MDSYS EXPIRED & LOCKED

USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
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

USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
OWBSYS EXPIRED & LOCKED
SI_INFORMTN_SCHEMA EXPIRED & LOCKED
OLAPSYS EXPIRED & LOCKED
MGMT_VIEW OPEN
SYS OPEN
SYSTEM OPEN
OUTLN EXPIRED & LOCKED

已選擇40行。

此時改完之後，重新重新整理

就彈出正常的登陸介面了。

[@more@]