OraFAQ Forum: Enterprise Manager » What are the host credentials for Enterprise Manager 11g

Home » RDBMS Server » Enterprise Manager » What are the host credentials for Enterprise Manager 11g (Oracle 11g R1, OEL 6.3)

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

What are the host credentials for Enterprise Manager 11g [message #584451]

Tue, 14 May 2013 07:45

neellohitc
Messages: 7
Registered: May 2013

Junior Member

I am trying to use Database Replay in 11g Release 1 using Enterprise Manager. In the last step it asks for 'Host Credentials' to start the capture. But when i give the username and password for the host, it throws error as 'Invalid username/password' all the time.

where am i going wrong?

Report message to a moderator

Re: What are the host credentials for Enterprise Manager 11g [message #584452 is a reply to message #584451]

Tue, 14 May 2013 07:52

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

So the user or password are not correct for the host.

Regards
Michel

Report message to a moderator

Re: What are the host credentials for Enterprise Manager 11g [message #584454 is a reply to message #584451]

Tue, 14 May 2013 08:18

John Watson
Messages: 8989
Registered: January 2010
Location: Global Village

Senior Member

If I were you, I would start by using the command line interface. When you are comfortable with that, try using the OEM interface. To do a capture is simple. For example, from SQL*Plus:

host mkdir c:\tmp\d1
create directory d1 as 'c:\tmp\d1';
grant all on directory d1 to public;
exec dbms_workload_capture.start_capture('jcap','D1');

--do whatever you want to do....

exec dbms_workload_capture.finish_capture;

Report message to a moderator

Re: What are the host credentials for Enterprise Manager 11g [message #584790 is a reply to message #584454]

Fri, 17 May 2013 12:48

neellohitc
Messages: 7
Registered: May 2013

Junior Member

Thanks for your advice. But the problem is not with Database Replay. The problem is with the host credentials in the Enterprise Manager.
For example, when i try to startup or shutdown the instance using the OEM, it asks for host credentials. But it throws this error 'Error Message'.
I guess it is not able to verify the host credentials.

Report message to a moderator

Re: What are the host credentials for Enterprise Manager 11g [message #584794 is a reply to message #584790]

Fri, 17 May 2013 13:20

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It is not able to connect with these credentials.

Regards
Michel

Report message to a moderator

Re: What are the host credentials for Enterprise Manager 11g [message #584796 is a reply to message #584794]

Fri, 17 May 2013 13:53

neellohitc
Messages: 7
Registered: May 2013

Junior Member

Yes, i know that but why? I have given the correct linux username and password that i use to login to my OEL box.
The user is oracle and it is in the oinstall group.

Report message to a moderator

Re: What are the host credentials for Enterprise Manager 11g [message #584797 is a reply to message #584796]

Fri, 17 May 2013 13:56

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Oracle is too dumb to lie.

If you are correct & Oracle wrongly throw error, then your only recourse is to file a Bug Report with Oracle.

BTW, Oracle V11.1 is NOT certified on V6 Kernel!

[Updated on: Fri, 17 May 2013 13:57]

Report message to a moderator

Re: What are the host credentials for Enterprise Manager 11g [message #584798 is a reply to message #584797]

Fri, 17 May 2013 14:00

neellohitc
Messages: 7
Registered: May 2013

Junior Member

But i can login with the same username and password to the OEL box.
And i can also do : connect / as sysdba

But the problem is only with EM host credentials.
i am putting username:oracle and password:*******

Am i missing anything here?

Regards
Neellohit

Report message to a moderator

Re: What are the host credentials for Enterprise Manager 11g [message #584799 is a reply to message #584798]

Fri, 17 May 2013 14:07

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>And i can also do : connect / as sysdba

above does NOT use SQL*Net and will succeed regardless of the strings entered to the right & to the left of the slash character; like below!

connect fubar/ID10T as sysdba

EM uses & requires SQL*Net & the listener and validates the password against the content of the external password file.

Report message to a moderator

Re: What are the host credentials for Enterprise Manager 11g [message #584801 is a reply to message #584798]

Fri, 17 May 2013 14:11

John Watson
Messages: 8989
Registered: January 2010
Location: Global Village

Senior Member

Have you done any tests? I would change my Linux password to something very simple (such as lower case oracle) log off and on Linux to be sure, then try it as host cedentials.

Report message to a moderator

Re: What are the host credentials for Enterprise Manager 11g [message #584804 is a reply to message #584801]

Fri, 17 May 2013 14:38

neellohitc
Messages: 7
Registered: May 2013

Junior Member

I changed my password to something similar, logged off and then again tried for the host credentials. But i get the same error
/forum/fa/10802/0/

/forum/fa/10802/0/

I think it has something to do with sql net configuration.

Attachment: Screen Shot 2013-05-18 at 1.05.23 AM.png
(Size: 256.97KB, Downloaded 8248 times)

Report message to a moderator

Re: What are the host credentials for Enterprise Manager 11g [message #584806 is a reply to message #584804]

Fri, 17 May 2013 14:43

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

password for networked access for "as sysdba" is NOT stored in the DB along with all the "regular" passwords.

Report message to a moderator

Re: What are the host credentials for Enterprise Manager 11g [message #584813 is a reply to message #584804]

Fri, 17 May 2013 18:32

John Watson
Messages: 8989
Registered: January 2010
Location: Global Village

Senior Member

In your screen shot, there is no message that says the credentials are wrong. Why do you think that is that problem?

Report message to a moderator

Re: What are the host credentials for Enterprise Manager 11g [message #584816 is a reply to message #584813]

Sat, 18 May 2013 00:15

neellohitc
Messages: 7
Registered: May 2013

Junior Member

I think that host credentials are the problem because in many sections of OEM like Database Replay and Backup it gives error as 'Failed to verify credentials'.

Here is a screenshot of the error in the last step of Database Replay.

/forum/fa/10804/0/

/forum/fa/10804/0/

Attachment: ScreenshotDR.png
(Size: 156.59KB, Downloaded 8034 times)

Report message to a moderator

Re: What are the host credentials for Enterprise Manager 11g [message #584822 is a reply to message #584816]

Sat, 18 May 2013 05:56

John Watson
Messages: 8989
Registered: January 2010
Location: Global Village

Senior Member

So use the command line interface. I've already shown you what to do.

Report message to a moderator

Re: What are the host credentials for Enterprise Manager 11g [message #584823 is a reply to message #584822]

Sat, 18 May 2013 06:18

neellohitc
Messages: 7
Registered: May 2013

Junior Member

Okay, yes i think i should do it through SQL*plus and not waste my time anymore with this. I just wanted to do an upgrade case study as done by Arup Nanda.
Thank you all for your support.

I will revisit this post if i find out what the problem was.

Regards
Neellohit

Report message to a moderator

Previous Topic:	deinstall issue
Next Topic:	Upgrade 11g Grid control to 12c Cloud

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 15 06:45:58 CDT 2025