After logging on to oracle 10g EM, the system prompts "the database status is currently unavailable, probably because the database status is loaded or not loaded ".

After logging on to oracle 10g EM, the system prompts "the database status is currently unavailable, probably because the database status is loaded or not loaded ".

After the password such as sys and system is changed during database creation, EM can log on normally, but the system prompts "the database status is currently unavailable. It may be because the database is in the load or not loaded state. Click Start to obtain the current status and open the database. If you cannot open the database, click 'Restore 'to perform the recovery operation ."

 
The solution is as follows:
 
1. Stop dbconsole
[Oracle @ star ~] $ Emctl stop dbconsole
Check the status and confirm that dbconsole is stopped.
[Oracle @ star ~] $ Emctl status dbconsole

** If you execute emctl stop dbconsole
Error: Environment variable ORACLE_SID not defined. Please define it.
Run: set ORACLE_SID = Database Name
 
2. Change the password of the sysman user to oracle123.
[Oracle @ star ~] $ Sqlplus/as sysdba
SQL> alter user sysman identified by oracle123;
 
Unlock User:
SQL> alter user sysman account unlock;
 
Confirm that the password has been changed:
SQL> conn sysman/oracle123 @ csc
Connected.
 
3. Go to the $ ORACLE_HOME/host_sid/sysman/config directory.
A. Save emoms. properties as emoms. properties. old.
B. Modify the emoms. properties file.
Find oracle. sysman. eml. mntr. emdRepPwd = and replace the encrypted string with oracle123;
Find oracle. sysman. eml. mntr. emdRepPwdEncrypted = TRUE and change TRUE to FALSE.
 
4. Restart dbconsole and access EM to restore normal
[Oracle @ star ~] $ Emctl start dbconsole
 
Log on to http: // loclahost: 5500/em and enter the user name and password.
So far, it has recovered to normal.