Host Credentials for Oracle Enterprise Manager 11g not working?

My server is Windows 2003 64bit and just recently my host logon for Enterprise Manager 11g has failed to work when I try to do a schedule backup or anywhere host credential's are needed.  The error i get is:

Valadation Error:
Connection to host as user company\oracle failed.

***company is the domain and this logon worked 3 days's ago

I have also tried just Username: oracle psw: XXXXX
without the domain and no luck.

I have done nothing new that I am aware of to the server it just stop working.  I have tried adding the user to the "Logon as batch job" local security policy. the user is also a member of ora_dba group. I have tried alot of the suggestion I have found around the internet but nothing seems to be working.  Any help would be greatly appreciated.
BAYEXPERTZAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
I have to ask the obvious:  Is the user account in question locked or has the password expired?
0
BAYEXPERTZAuthor Commented:
The user account is not locked and not expired it actually works fine on our Windows XP test server that has Oracle 11g on it as well.
0
BAYEXPERTZAuthor Commented:
Sounds good thank you much appreciated!
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

MikeOM_DBACommented:

If "oracle" is a local account, then you need to set the credentials as "{localhost name}\oracle"

Otherwise if oracle is network account you need to set the credentials as "{local-domain name}\oracle"

0
BAYEXPERTZAuthor Commented:
Yes it is a network account and I have tried company\oracle
0
MikeOM_DBACommented:

What about password being case-sensitive?
0
BAYEXPERTZAuthor Commented:
I've tried every single combination. I have just read that removing and re-installing EM, using the
emca -deconfig and emca -config commands is a possible solution does anybody know the proper way step by step how to do this?
0
MikeOM_DBACommented:
Re-installing EM is not the answer.
I was experiencing the same issue dome time ago.

Create a "company\oracle" externally identified account in the database with DBA privileges -- don't know if it has anything to do with it, but that is the way I had it configured and it worked.

0
BAYEXPERTZAuthor Commented:
I'm pretty sure I've tried that Mike but please provide step by step instructions on how you created "an externally identified account in the database with DBA privileges"
0
slightwv (䄆 Netminder) Commented:
The docs provide the external syntax:  EXTERNALLY Clause

http://download.oracle.com/docs/cd/E11882_01/server.112/e17118/statements_8003.htm

Pay attention to this note:

Caution:
Oracle strongly recommends that you do not use IDENTIFIED EXTERNALLY with operating systems that have inherently weak login security.


0
BAYEXPERTZAuthor Commented:
Should I create the user like this
CREATE USER "ORACLE"  IDENTIFIED EXTERNALLY;

or with the Domain in front?

CREATE USER "COMPANY\ORACLE"   IDENTIFIED EXTERNALLY;
0
BAYEXPERTZAuthor Commented:
My Last one please or can you edit it to  oracle "company\oracle"
0
BAYEXPERTZAuthor Commented:
I have tried the IDENTIFIED EXTERNALLY user  and it didn't work I also tried the statements below to re create the EM also never worked

emca -deconfig dbcontrol db -repos drop

emca -config dbcontrol db -repos create

Any more suggestions? I'm starting to run out of options.
0
slightwv (䄆 Netminder) Commented:
Sorry.  I can't help much.  All I know is Oracle has never really liked domain level accounts.

I always created local admin accounts for all my Oracle installs on Windows and haven't had any problems.

If it used to work and now doesn't, something changed.  If you cannot figure out what changed, try creating a local admin account for this.
0
BAYEXPERTZAuthor Commented:
thanks slightwv I've tried that I even disconnected the server from the network to make sure it was grabing a domain account....I'm quite surprised that more experts haven't made suggestions here?
0
slightwv (䄆 Netminder) Commented:
If you've tried with a local admin account there's a problem somewhere.  I suggest you open an SR with Oracle Support.

Not sure why other Experts haven't commented.  Feel free to click 'Request Attention' above and a Moderator can put out a call for help.
0
Mark GeerlingsDatabase AdministratorCommented:
We have the same problem trying to pass host credentials to Oracle on Linux from OEM, so this may be more of an OEM problem, than a Windows-specific problem.

(I'm posting this partly to be notifed if/when others post suggestions that may help.)
0
Richard OlutolaConsultantCommented:
Check Oracle Support Note 1080647.1

The first recommendation is that the oracle user is a local administrator with ORA_DBA group membership. There are other requirements that I suggest you check and implement.

R.
0
BAYEXPERTZAuthor Commented:
Yes that is how my user is set up but it doesn't work.  However a couple of weeks ago it did but like I said I am not sure what has changed or updated somewhere because I can't get no host user to work.
0
brainsurf1Commented:
Did you figure this out? I am having the same problem.
0
BAYEXPERTZAuthor Commented:
No not yet brainsurf1: I'm thinking it's something to do with our windows 2008 Domain Controller and authenticating with it.
0
MikeOM_DBACommented:
Should I create the user like this
CREATE USER "ORACLE"  IDENTIFIED EXTERNALLY;

or with the Domain in front?

CREATE USER "COMPANY\ORACLE"   IDENTIFIED EXTERNALLY;

The second way as follows:

For local account:  HOSTNAME\ORACLE
For network account: DOMAIN\ORACLE
0
BAYEXPERTZAuthor Commented:
close this question, please.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
BAYEXPERTZAuthor Commented:
Abandon question all together
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.