On oracle 11g, the homepage for a Database gives the error:
‘The database target is currently unavailable. The state of the components are listed below.’
Database Instance: Status Open
Listener: Status Up
Agent Connection to Instance: Status Unavailable Details
Please make sure that status of the dbsnmp database user is NOT locked.
Then run “emctl clearstate agent” and “emctl upload agent” to resolve the issue