ora-28001 and agent connect

From: "Storey, Robert (DCSO)" <RStorey@xxxxxxxxxxxxxxxxxx>
To: Oracle L <oracle-l@xxxxxxxxxxxxx>
Date: Fri, 14 Jun 2013 17:43:47 +0000

Afternoon,
I slipped up and forgot to change the password time limit on the default 
profile (now corrected) so they sysman and dbsnmp accounts passwords expired.

I reset them both to the same passwords as previous and can log into sqlplus 
with them.

I have a single 11.2 db that I use for training that I us local dbcontrol on 
instead of grid.  When I log in to em, I get an error message saying the agent 
did not connect due to ora-28001.

After much googling and search of MOS, I tried the following,

1 - editing the targets.xml file and putting the unencrypted password in and 
setting the encrypted password flag to false.  Then, restarted the dbconsole, 
causing it to encrypt the password.  Did not work.

2 - ran the emca -deconfig dbcontrol db followed by emca -confgi dbcontrol db.  
Set all the passwords when requested.  Config runs fine.  Still can't get the 
agent to connect.

Emctl status agent shows the agent running, no files pending upload, etc.  
However, it does show the Collection Status as "disabled by upload manager".

When on the EM console page I sometimes get the green arrows for Database and 
LIstner being up, but red arrow for the agent.  Sometimes the page will just 
show an agent disconnect message.  Either way I can always access the database 
itself.

SR open with Oracle, as all the MOS notes only reference the issue with Grid 
Control.  Their remedies all involve accessing the targets tab on GC.  I have 
no Targets tab.

Anyone run into this and have a good fix for this?

Thanks
Bob

--
//www.freelists.org/webpage/oracle-l

ora-28001 and agent connect

Other related posts: