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行。

此时改完之后,重新刷新https://vm2003:1158/em

就弹出正常的登陆界面了。

[@more@]

请使用浏览器的分享功能分享到微信等