The prompt & quot; database status is currently unavailable, probably because the database status is loaded or not loaded & quot;

Source: Internet
Author: User


The prompt "the database status is currently unavailable may be because the database status is loaded or not loaded". The solution is that EM can be accessed normally after installation. After The customer changed The sys password, they boarded EM through The WEB. The English version of this newspaper "The database status is currently unavailable. it is possible that the database is in mount or nomount state. click 'startup' to obtain the current status and open the database. if the database cannot be opened, click 'perform Recovery 'to Perform an appropriate recovery operation. ", the Chinese version reports" 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 corresponding recovery operation .", Make sure that the Listener and the service are both normal, and the database status is also started. Either restarting dbconsole or reconfiguration does not work. Www.2cto.com solution: 1. Stop dbconsole [oracle @ star ~] $ Emctl stop dbconsole check the status and confirm that dbconsole has stopped [oracle @ star ~] $ Emctl status dbconsole 2. Modify the password of the 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. go to the $ ORACLE_HOME/host_sid/sysman/config directory. set emoms. save properties as emoms. properties. old B. modify emoms. in the properties file, find oracle. sysman. eml. mntr. emdRepPwd = Replace the equivalent encrypted string with the changed password oracle123; find oracle. sysman. eml. mntr. emdRepPwdEncrypted = TR UE replaces "TRUE" with "FALSE. 4. Restart dbconsole and access EM to restore [oracle @ star ~] $ Emctl start dbconsole log on here http://loclahost:5500/em , Prompting you to enter the user name and password. So far, it has recovered to normal. Author mhlstar

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.