Resolved: Issue with host credentials in OEM 11g Database Control
- From: lisa dobson <lj_dobson@xxxxxxxxxxx>
- To: "Donald.Freeman.ctr@xxxxxxxxxxxxxxxxxxxx" <Donald.Freeman.ctr@xxxxxxxxxxxxxxxxxxxx>, Oracle-L <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 4 Oct 2013 16:21:01 +0100 (BST)
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@xxxxxxxxxxxxxxxxxxxx>
To: lj_dobson@xxxxxxxxxxx; Oracle-L <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
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.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » Resolved: Issue with host credentials in OEM 11g Database Control - lisa dobson
