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 recovery operation.

Then the options are button to Startup and Perform Recovery. When i click Startup then i have to input the OS user name and password to login to target database machine and the credentials for the target database.

Then got this error, SQLException
ORA-28000: the account is locked

I have try to use emca, but after I input some parameter to run, finally i stuck again with this message,
SEVERE: Repository already exists. Fix the error(s) and run EM Configuration As
sistant again in standalone mode.
Could not complete the configuration. Refer to the log file for details

After read emca help, then i try to use emca -r to skip creation of repository schema then at last I got Oracle EM run without no error

Advertisements

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 : <dbsid>

Listener port number : 1521 (usually)

– emca -config dbcontrol db,

Database SID : <dbsid>

Listener port number : 1521 (usually)

Password for SYS user: <SYS pwd>

Password for DBSNMP user: <DBSNMP pwd>

Password for SYSMAN user: <SYSMAN pwd>
If above step cannot resolve the problem then you can try the others,

–  C:\Documents and Settings\Administrator>set oracle_sid=<dbsid>

– C:\Documents and Settings\Administrator>emctl stop dbconsole

–  connect to database as user with DBA privilege with SQL*Plus

– SQL >alter user sysman identified by <new_password>;

– SQL >exit

– SQL >connect sysman/<new_password>;

– if connected then go to $ORACLE_HOME/host_sid/sysman/config

– locate file “emoms.properties” and backup this file

– open and locate “oracle.sysman.eml.mntr.emdRepPwd”, replace the encrypted value by the<new_password> value

– locate “oracle.sysman.eml.mntr.emdRepPwdEncrypted”, replace TRUE by FALSE

– save file

– C:\Documents and Settings\Administrator>emctl start dbconsole

– if you reopen  “emoms.properties” file, “oracle.sysman.eml.mntr.emdRepPwd” is encrypted

and the value “oracle.sysman.eml.mntr.emdRepPwdEncrypted” is TRUE