Solved

Host Credentials for Oracle Enterprise Manager 11g not working?

Posted on 2011-02-15
28
3,549 Views
Last Modified: 2013-11-11
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.
0
Comment
Question by:BAYEXPERTZ
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 13
  • 4
  • 4
  • +3
28 Comments
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34896869
I have to ask the obvious:  Is the user account in question locked or has the password expired?
0
 

Author Comment

by:BAYEXPERTZ
ID: 34896951
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
 

Author Comment

by:BAYEXPERTZ
ID: 34897174
Sounds good thank you much appreciated!
0
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 34899412

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
 

Author Comment

by:BAYEXPERTZ
ID: 34899545
Yes it is a network account and I have tried company\oracle
0
 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 34900339

What about password being case-sensitive?
0
 

Author Comment

by:BAYEXPERTZ
ID: 34900694
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
 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 34902147
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
 

Author Comment

by:BAYEXPERTZ
ID: 34906264
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
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34906774
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
 

Author Comment

by:BAYEXPERTZ
ID: 34907129
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
 

Author Comment

by:BAYEXPERTZ
ID: 34907444
My Last one please or can you edit it to  oracle "company\oracle"
0
 

Author Comment

by:BAYEXPERTZ
ID: 34907875
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
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34908384
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
 

Author Comment

by:BAYEXPERTZ
ID: 34908769
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
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34909787
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
 
LVL 35

Expert Comment

by:Mark Geerlings
ID: 34929587
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
 
LVL 16

Expert Comment

by:Richard Olutola
ID: 34939571
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
 

Author Comment

by:BAYEXPERTZ
ID: 34972890
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
 

Expert Comment

by:brainsurf1
ID: 35208565
Did you figure this out? I am having the same problem.
0
 

Author Comment

by:BAYEXPERTZ
ID: 35208773
No not yet brainsurf1: I'm thinking it's something to do with our windows 2008 Domain Controller and authenticating with it.
0
 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 35209016
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
 

Accepted Solution

by:
BAYEXPERTZ earned 0 total points
ID: 35973908
close this question, please.
0
 

Author Closing Comment

by:BAYEXPERTZ
ID: 36001463
Abandon question all together
0

Featured Post

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Via a live example, show how to take different types of Oracle backups using RMAN.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question