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
相关推荐
Database Quick Installation Guide.pdf
The Enterprise Manager Command Line Interface (EM CLI) is the administrator's key to unlocking the power of Enterprise Manager 12c (EM12c) with scalability, repeatability, and confidence. In previous...
Oracle Enterprise Manager Database Tuning with the Oracle Tuning Pack Release 9.0.1
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使用基础帮助入门
Expert Oracle Enterprise Manager 12c is a book for the latest version of Oracle Database
oracle enterprise manager on linux
Oracle Enterprise Manager Oracle Enterprise Manager Messages Manual Release 2.2
win10安装Oracle创建数据库实例的时候到85%报出,由于以下错误,Enterprise Manager配置失败,点击确认后显示数据库实例安装成功,但是监听程序TNS一直不能连接本地数据库,用了网上的好多方法都没有解决(win10安装...
Oracle Enterprise Manager for Oracle TimesTen In-Memory Database Release Notes Release 12.1.0.3.0
ORACLE10G Enterprise Manager Command Line Interface(官方文档)
Oracle Enterprise Manager的数据库管理
This is the first complete, practical guide to architecting, designing, and building Database Clouds with Oracle 12c. Written by a veteran author team of Oracle gurus and ACE Directors, Building ...
The collection of information stored in the database at a particular moment is called an instance of the database. The overall design of the database is called the database schema. The physical schema...
ORACLE 9I ENTERPERISE MANAGER
Since the database is at the heart of any application architecture, the book should have a broad audience. As the title suggests, Expert Oracle Database Architecture concentrates on the database ...
EnterpriseManager配置失败
the Definitive Guide to SUSE Linux Enterprise Server 12 is a task-oriented book designed for self-study as well as classroom environments, which will also serve you as a reference guide. The book ...
The main advantage of running in-process is that the system usually does not need to perform a context switch. The disadvantage to running in-process is that DLL has access to the process address ...