Oracle Database Status Unavailable – emca

When i try to login to Oracle Enterprise Manager, i got this message 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 [...]

How to clear Oracle Enterprise Manager’s Alert

first, check this – SELECT * FROM SYSMAN.MGMT_CURRENT_SEVERITY ORDER BY COLLECTION_TIMESTAMP if the result is that you want to delete then go with this sql, – DELETE SYSMAN.MGMT_CURRENT_SEVERITY ^_^

Enterprise Manager is not able to connect to the database instance

Today i got this message from OEM, “Enterprise Manager is not able to connect to the database instance. The state of the components are listed below.” I have search the solution that help me to fix this problem, - first, check DBSNMP, SYSMAN, and SYS not locked and password value is ok. default password for DBSNMP is DBSNMP, SYSMAN is SYSMAN, SYS is MANAGER or CHANGE_ON_INSTALL. to ensure the correct password, it is better to alter it with new password. - emca -deconfig dbcontrol db Database SID : [...]

Follow

Get every new post delivered to your Inbox.