OraFAQ Forum: Enterprise Manager » Host Credentials error

Home » RDBMS Server » Enterprise Manager » Host Credentials error (OEM Load Data Utility)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Host Credentials error [message #273969]

Fri, 12 October 2007 07:47

fully28
Messages: 2
Registered: October 2007

Junior Member

Hi guys,
I have 10g on Windows and I am new to using OEM.

I was attempting to use the 'Load Data from file' utility but kept getting following error on entering username/password
for Host Credentials:
"Error - RemoteOperationException: ERROR: Wrong password for user"

I tried different users including SYS , SYSTEM , scott and users I created ... I confirmed passwords correct by logging into OEM with theses users.

...
If unable to get this working, is there a SQL load utility for command line?

Thanks..

Report message to a moderator

Re: Host Credentials error [message #273985 is a reply to message #273969]

Fri, 12 October 2007 10:12

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Huh ... "wrong password" is a wrong password. If you say that you provided the correct password, OK. I wouldn't know how to fix that.

However, there is another possibility: SQL*Loader utility or, if you prefer it, external tables feature.

Report message to a moderator

Re: Host Credentials error [message #274839 is a reply to message #273969]

Wed, 17 October 2007 06:47

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Quote:

but kept getting following error on entering username/password
for Host Credentials:

It was wanted host Credentials and you provided database Credentials.

Report message to a moderator

Re: Host Credentials error [message #274906 is a reply to message #274839]

Wed, 17 October 2007 11:20

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

1. Control Panel, Administrative Tools.
2. Click on Local Security Policy.
3. Local Policies, User Rights Assignment.
4. Double click, 'Log on as a batch job'.
5. Add your local user that you are supplying for the Host Credentials (Administrator).

Log out of Windows, then log back in. Hit the EM web site, log in and attempt to schedule, import/export, etc.

Report message to a moderator

Re: Host Credentials error [message #276649 is a reply to message #274906]

Thu, 25 October 2007 17:27

fully28
Messages: 2
Registered: October 2007

Junior Member

Hi Guys,
Sorry for the delay in responding and Thanks so much for the feedback and assistance.

I had seen the solution provided by Dreamz elsewhere .. tried it.. but it did not work for me.

Unfortunately - I needed to direct my attention to rest of my assignment so settled with using the command line utility "sqlldr username/password <control-file>" and that worked fine...

Very soon I may get the chance to revisit it, if I figure it out I will post the 'solution' here.

Thanks again..

Report message to a moderator

Previous Topic:	EM stop working after system name change
Next Topic:	Purge/Free up OEM_Repository Tablespace

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 08:28:23 CST 2024