Planet CakePHP

Problem:
You are trying to access the Oracle Enterprise Manager and are getting the following error.
Error:
Invalid Connection Pool. ERROR = ORA-28000: the account is locked
Explanation:
In my instance, the password for the SYSMAN database user was different than the emctl SYSMAN password. Every refresh I could see the errors messages indicating it was trying to connect, and then the account would become locked as the connection failed.
1) you need to track down the sysman/log directory

cd /u01/app/oracle/product/11.2.0/dbhome_1/example.com_orcl/sysman/log

2) tail the following log file

tail -f emoms.log

3) refresh your web browser and you should see the following error message pop up

Invalid Connection Pool. ERROR = ORA-28000: the account is locked

4) as the oracle user, login as sysdba

sqlplus / as sysdba

5) unlock the account

alter user sysman account unlock;

6) set a new password (don’t do this on production unless you have to)

alter user sysman identified by 'YOUR_NEW_PASSWORD';

7) now go to your command prompt and type

emctl setpasswd dbconsole

8) when it asks for your password, enter your new password

Please enter new repository password: YOUR_NEW_PASSWORD

9) close your web browser, open it and head to your em link
example.com:1160/em/console
10) enter following
User: sysman
Password: YOUR_NEW_PASSWORD