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"

Source: Internet
Author: User


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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.