Home » RDBMS Server » Enterprise Manager » What are the host credentials for Enterprise Manager 11g (Oracle 11g R1, OEL 6.3)
What are the host credentials for Enterprise Manager 11g [message #584451] Tue, 14 May 2013 07:45 Go to next message
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?
Re: What are the host credentials for Enterprise Manager 11g [message #584452 is a reply to message #584451] Tue, 14 May 2013 07:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68617
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So the user or password are not correct for the host.

Regards
Michel
Re: What are the host credentials for Enterprise Manager 11g [message #584454 is a reply to message #584451] Tue, 14 May 2013 08:18 Go to previous messageGo to next message
John Watson
Messages: 8919
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;
Re: What are the host credentials for Enterprise Manager 11g [message #584790 is a reply to message #584454] Fri, 17 May 2013 12:48 Go to previous messageGo to next message
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.
Re: What are the host credentials for Enterprise Manager 11g [message #584794 is a reply to message #584790] Fri, 17 May 2013 13:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68617
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is not able to connect with these credentials.

Regards
Michel
Re: What are the host credentials for Enterprise Manager 11g [message #584796 is a reply to message #584794] Fri, 17 May 2013 13:53 Go to previous messageGo to next message
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.
Re: What are the host credentials for Enterprise Manager 11g [message #584797 is a reply to message #584796] Fri, 17 May 2013 13:56 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: What are the host credentials for Enterprise Manager 11g [message #584799 is a reply to message #584798] Fri, 17 May 2013 14:07 Go to previous messageGo to next message
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.
Re: What are the host credentials for Enterprise Manager 11g [message #584801 is a reply to message #584798] Fri, 17 May 2013 14:11 Go to previous messageGo to next message
John Watson
Messages: 8919
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.
Re: What are the host credentials for Enterprise Manager 11g [message #584804 is a reply to message #584801] Fri, 17 May 2013 14:38 Go to previous messageGo to next message
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/

I think it has something to do with sql net configuration.
Re: What are the host credentials for Enterprise Manager 11g [message #584806 is a reply to message #584804] Fri, 17 May 2013 14:43 Go to previous messageGo to next message
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.

Re: What are the host credentials for Enterprise Manager 11g [message #584813 is a reply to message #584804] Fri, 17 May 2013 18:32 Go to previous messageGo to next message
John Watson
Messages: 8919
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?
Re: What are the host credentials for Enterprise Manager 11g [message #584816 is a reply to message #584813] Sat, 18 May 2013 00:15 Go to previous messageGo to next message
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/
Re: What are the host credentials for Enterprise Manager 11g [message #584822 is a reply to message #584816] Sat, 18 May 2013 05:56 Go to previous messageGo to next message
John Watson
Messages: 8919
Registered: January 2010
Location: Global Village
Senior Member
So use the command line interface. I've already shown you what to do.
Re: What are the host credentials for Enterprise Manager 11g [message #584823 is a reply to message #584822] Sat, 18 May 2013 06:18 Go to previous message
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
Previous Topic: deinstall issue
Next Topic: Upgrade 11g Grid control to 12c Cloud
Goto Forum:
  


Current Time: Tue Mar 19 01:25:51 CDT 2024