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. Modify the password of A sysman user, I changed the password 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 modified:
SQL> conn sysman/oracle123 @ CSC
connected.
3. Go to the $ ORACLE_HOME/host_sid/sysman/config directory.
. set emoms. save properties as emoms. properties. old
B. modify emoms. properties file
Find oracle. sysman. eml. mntr. emdreppwd = Replace the equivalent encrypted string with the changed password oracle123.
Find oracle. sysman. eml. mntr. emdreppwdencrypted = true and change true to false.
4. Restart dbconsole and access em again
[Oracle @ star ~] $ Emctl start dbconsole
log on to http: // loclahost: 5500/EM and enter the user name and password.
now, it is normal.