Resolved: Issue with host credentials in OEM 11g Database Control
Date: Fri, 4 Oct 2013 16:21:01 +0100 (BST)
Message-ID: <1380900061.65030.YahooMailNeo_at_web28805.mail.ir2.yahoo.com>
Thanks Guys - we've now managed to get this resolved. MOS were working on it and Niall's tip around local vs external Oracle accounts pointed us in the right direction.
Basically, we had both. SSH connections direct to the server were the externally authenticated accounts. OEM agent was using the local one. Updated local accounts to new password and all appears to be working as expected.
I'm now going to push to get these servers reconfigured to only use local oracle accounts.
Thanks for the responses.
Lisa.
From: "Freeman, Donald CONT (ABL)" <Donald.Freeman.ctr_at_nets.nemais.navy.mil> To: lj_dobson_at_yahoo.co.uk; Oracle-L <oracle-l_at_freelists.org> Sent: Friday, 4 October 2013, 12:31
Subject: RE: Issue with host credentials in OEM 11g Database Control
It's been a little while but I believe if you go into that targets.xml file
you'll find an encrypted username and password for the target. There is a
procedure on MOS that leads you through changing that password if it's out
of sync with what the database thinks it is.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Lisa Dobson
Sent: Thursday, October 03, 2013 4:57 PM
To: Oracle-L
Subject: RE: Issue with host credentials in OEM 11g Database Control
Hi All,
Hoping someone can help shed some light on an issue that has me completely puzzled.
Environment:
Enterprise Manager Database Control 11g
Oracle database 11.2.0.2 (Enterprise Edition)
RHEL5 I attempted to schedule an ad-hoc backup via OEM today. This is something I've done many, many times before without any issues at all.
However, the 'oracle' user password was changed recently on our Linux boxes and we're now hitting a problem when needing to specify host credentials on the schedule backup page in OEM. This is happening on multiple servers, all set up as above.
If I specify the current password when asked for host credentials it errors
out with: 'Error
<https://fig.dur.ac.uk:1158/em/console/database/rec/backup?event=start&targe
t=rem7dev.dur.ac.uk&type=oracle_database> - Connection to host as user
oracle failed.ERROR: Invalid username and/or password'
If I specify the old previous password then I am able to proceed and the backup runs.
There are currently no preferred credentials set within the preferences section of OEM.
If I try to set preferred credentials with username oracle and the current password it errors out.
I've raised an SR with MOS and they are currently working on it, but no luck so far. They asked for an upload of target.xml file but that doesn't appear to me to indicate any stored config for host username/password.
Oracle haven't got back to me yet since I uploaded the file so I can include here if anyone wants to double check.
I need to understand why OEM thinks the old oracle user password is still valid and is not recognising the new one - how is it authenticating and how can I change this?
I feel like I'm missing something obvious, but can't for the life of me think of what it is. Any pointers would be greatly appreciated.
Thanks,
Lisa.
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 04 2013 - 17:21:01 CEST