What to do when Enterprise Manager is not able to connect to the database instance (ORA-28001)
If you are trying to connect to the Oracle enterprise Manger and you get the following errors:
Enterprise Manager is not able to connect to the database instance.
And in the “Agent connection to instance” section:
Status: Failed
Details: ORA-28001: the password has expired (DBD ERROR: OCISessionBegin)
One of the reasons could be that the password for the SYSMAN user is expired. However, changing the password alone will not solve this issue. Several additional steps are required in order to make Oracle Enterprise Manager connect:
Before you start: Verify that ORACLE_HOME, ORACLE_SID environment variables are set. – If not, set them using as environment variables or open a command line and type SET ORACLE_SID=<The database SID>
1. Stop the dbconsole: emctl stop dbconsole (dos and Unix) or using the windows services stop the OrcleDBConsole<The database SID>.
2. Connect to the database as a user with DBA privilege with SQL*Plus
and run the following command:
alter user sysman identified by <the new password> ;
3. Verify that the new password works
SQL> connect sysman/<the new password>
4. Go to ORACLE_HOME/<HostName_SID>/sysman/config and save a backup of the emoms.properties file.
a) Open the file emoms.properties and search for:
oracle.sysman.eml.mntr.emdRepPwd=<some encrypted value>
Replace the encrypted value with the new password value
b) Search for oracle.sysman.eml.mntr.emdRepPwdEncrypted=TRUE
and change TRUE to FALSE
c) Save and close emoms.properties
5. Restart the dbconsole:
emctl start dbconsole (dos and Unix) or using the windows services start the OrcleDBConsole<The database SID>.
6. Open emoms.properties again and Search for:
a)oracle.sysman.eml.mntr.emdRepPwd=
verify that the password is encrypted
b) oracle.sysman.eml.mntr.emdRepPwdEncrypted=
verify that the value is set to TRUE
7. Refresh Oracle Enterprise Manager
相关推荐
- Oracle Enterprise Manager Database Control可以在系统上运行,并可通过Web浏览器访问。 #### 未涵盖的任务 本指南专注于基本安装场景,未涉及以下高级任务: - 使用高级安装选项进行软件安装。 - 在已有...
### Enterprise Manager配置失败解决方法 在Oracle环境中,Enterprise Manager(EM)是用于管理数据库实例、应用服务器以及其他Oracle产品的重要工具。然而,在配置过程中可能会遇到一些问题导致配置失败。本文将...
标题与描述均提到了“EnterpriseManager配置失败”的问题,这主要涉及到Oracle的Enterprise Manager(EM)在Windows XP系统上安装Oracle 10g时遇到的配置错误。在处理这一问题时,用户首先尝试了删除现有的EM配置,...
### HP Virtual Connect Enterprise Manager 6.2 用户指南关键知识点 #### 概述 HP Virtual Connect Enterprise Manager (VCEM) 6.2 是一款专为管理多个 HP 刀片系统机箱并控制网络连接设计的工具。该软件适用于...
《Oracle 9i Enterprise Manager:深入解析与应用》 一、Oracle 9i Enterprise Manager概述 Oracle 9i Enterprise Manager(EM),是Oracle公司为Oracle 9i数据库系统设计的一款全面的管理工具,旨在简化数据库的...
win10安装Oracle创建数据库实例的时候到85%报出,由于以下错误,Enterprise Manager配置失败,点击确认后显示数据库实例安装成功,但是监听程序TNS一直不能连接本地数据库,用了网上的好多方法都没有解决(win10安装...
This book is your guide to becoming the go-to advisor for the enterprise agile transition. Many organizations have brought in agile coaches and achieved great progress in software development ...
详细的Oracle Enterprise Manager使用基础帮助入门
Oracle Enterprise Manager for Oracle TimesTen In-Memory Database 是一个专门针对Oracle TimesTen In-Memory Database的管理工具,其Release 12.1.0.3.0版本提供了最新的更新和信息,这些信息可能尚未包含在正式...
总的来说,Oracle Enterprise Manager Database Tuning with the Oracle Tuning Pack是Oracle数据库管理中不可或缺的一部分,它提供了强大的性能优化和管理功能,帮助用户实现高效、稳定的数据库运行环境。
Oracle Enterprise Manager 概念指南概述 Oracle Enterprise Manager 是 Oracle 公司开发的一款企业级管理软件,旨在帮助 IT 管理员和数据库管理员对 Oracle 数据库和相关系统进行监控、管理和维护。以下是 Oracle ...
在IT管理领域,Enterprise Manage(通常指的是Oracle Enterprise Manager,简称OEM)是一个强大的工具,用于监控、管理和维护Oracle数据库及相关的IT基础设施。在本场景中,用户遇到了在配置Enterprise Manage时启动...
Oracle Enterprise Manager Administrator’s Guide Release 2.2 Oracle Enterprise Manager Administrator’s Guide Release 2.2 是一份详细的管理员指南,旨在帮助管理员快速掌握 Oracle Enterprise Manager 的...
Oracle Enterprise Manager Administrator’s Guide Release 9.2.0 Oracle Enterprise Manager Administrator’s Guide Release 9.2.0是Oracle Corporation发布的官方管理员指南,该指南旨在帮助管理员更好地管理和...
《Oracle Enterprise Manager消息手册》(Release 2.2)详细介绍了在使用该工具时可能会遇到的各种消息和错误代码,帮助管理员识别和解决问题。 手册中涵盖的主题可能包括: 1. **系统监控**:Oracle Enterprise ...
Oracle Enterprise Manager Configuration Guide Release 2.2 Oracle Enterprise Manager 是 Oracle 公司的一款企业级管理软件,旨在提供一个统一的管理平台,帮助管理员管理和监控 Oracle 数据库和相关应用程序。...
### ORACLE 10G Enterprise Manager Command Line Interface (EM CLI) 官方文档解析 #### 概述 ORACLE 10G Enterprise Manager Command Line Interface(简称EM CLI)是Oracle 10g Release 5(10.2.0.5)版本中...