OraFAQ Forum: Enterprise Manager » Enterprise Manager Console from a Web Browser

Home » RDBMS Server » Enterprise Manager » Enterprise Manager Console from a Web Browser (10g, window 2003)

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

Enterprise Manager Console from a Web Browser [message #332841]

Wed, 09 July 2008 23:09

ocaocp
Messages: 9
Registered: May 2008
Location: Singapore

Junior Member

I am not able to login to Enterprise manager through the web, it always result error "Validation Error, Examine and correct the following errors, then retry the operation: "
Where as same user/password works with out any issue in OEM console.
Please let me know the solution for this is there any file I need to check.
I have basic knowledge in Oracle but I really want to learn it, so help me out PLZ.

Thanks,

Report message to a moderator

Re: Enterprise Manager Console from a Web Browser [message #332866 is a reply to message #332841]

Thu, 10 July 2008 00:11

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Those who live by the GUI, die by the GUI!
OEM is NOT required to use Oracle RDBMS!

Report message to a moderator

Re: Enterprise Manager Console from a Web Browser [message #332921 is a reply to message #332866]

Thu, 10 July 2008 02:14

ocaocp
Messages: 9
Registered: May 2008
Location: Singapore

Junior Member

Actully one of the customer want to use that OEM browser to check tablespace and all,I cannot tell him to login to SQL and run the script all the time.

Report message to a moderator

Re: Enterprise Manager Console from a Web Browser [message #332932 is a reply to message #332921]

Thu, 10 July 2008 02:38

Michel Cadot
Messages: 68636
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Why a customer (assuming a user) wants to check tablespace? It is DBA job not user one.

Are you aware that using DB Console requires high privilege?

Regards
Michel

Report message to a moderator

Re: Enterprise Manager Console from a Web Browser [message #332935 is a reply to message #332932]

Thu, 10 July 2008 02:49

ocaocp
Messages: 9
Registered: May 2008
Location: Singapore

Junior Member

Well its actually IT Manager who need to login through OEM browser to check Tablespace.
And they will be login by normal user.

Is there anyone who can actually help me the file need to be check? I need technical suggestion on this matter, Please help me out.

Report message to a moderator

Re: Enterprise Manager Console from a Web Browser [message #332949 is a reply to message #332935]

Thu, 10 July 2008 03:13

Michel Cadot
Messages: 68636
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

And they will be login by normal user.

There is no "normal" user for using DB Console.
You must have at least SELECT_CATALOG_ROLE role or SELECT ANY DICTIONARY system privilege.

By the way, message says "correct the following errors" but you don't post us what they are. How could you expect we can give you actions to correct them?

Regards
Michel

Report message to a moderator

Re: Enterprise Manager Console from a Web Browser [message #332968 is a reply to message #332949]

Thu, 10 July 2008 03:54

ocaocp
Messages: 9
Registered: May 2008
Location: Singapore

Junior Member

Hi Michel,

Thanks for your reply, the error message which is like below,
Database Error

Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor The Connection descriptor used by the client was: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=operadbk)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=opera)))

However the same username/password i am albe to login through OEM console.But for the same listener setting why I am not able to login through OEM browser which address is as below. http://operadbk:1158/em/console/database/login?target=opera&type=oracle_database

Thanks for your help.

Report message to a moderator

Re: Enterprise Manager Console from a Web Browser [message #332992 is a reply to message #332968]

Thu, 10 July 2008 04:41

Michel Cadot
Messages: 68636
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Is the connection descriptpr correct?

Regards
Michel

Report message to a moderator

Re: Enterprise Manager Console from a Web Browser [message #333220 is a reply to message #332992]

Thu, 10 July 2008 21:27

ocaocp
Messages: 9
Registered: May 2008
Location: Singapore

Junior Member

Hi Michel,

Yah connection descriptor is correct, as there is no issue running OEM console. Only issue occur when I try it through browser.

Thks,
Nage

Report message to a moderator

Re: Enterprise Manager Console from a Web Browser [message #333237 is a reply to message #333220]

Fri, 11 July 2008 00:06

Michel Cadot
Messages: 68636
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Try, from server:

sqlplus user/psw@"(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=operadbk)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=opera)))".

Regards
Michel

[Updated on: Fri, 11 July 2008 00:06]

Report message to a moderator

Re: Enterprise Manager Console from a Web Browser [message #333273 is a reply to message #333237]

Fri, 11 July 2008 01:53

ocaocp
Messages: 9
Registered: May 2008
Location: Singapore

Junior Member

Hi Michel,

I try
sqlplus user/psw@"(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=operadbk)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=opera)))"

But it did not work gives error message like ORA-12514:TNS:Listener does not currently know of service requested in connect descriptor
-----
Looks like its TNS issue ,please suggest me which part need to be looked or may have issue.

Also I tried,

Sqlplus "user/pwd@opera as sysdba"

This work fine and I am confuse where could be problem in my TNSlistner.

Please help me out .

Thanks
Nage

Report message to a moderator

Re: Enterprise Manager Console from a Web Browser [message #333287 is a reply to message #333273]

Fri, 11 July 2008 02:43

Michel Cadot
Messages: 68636
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Did you try from server or client?
Copy and paste what you do.
Format your post (see guidelines).

Regards
Michel

[Updated on: Fri, 11 July 2008 02:43]

Report message to a moderator

Re: Enterprise Manager Console from a Web Browser [message #333295 is a reply to message #333287]

Fri, 11 July 2008 03:01

ocaocp
Messages: 9
Registered: May 2008
Location: Singapore

Junior Member

I have try it through DB server itself. Please checkthe screen shot which i have attached

Attachment: eror.JPG
(Size: 41.46KB, Downloaded 993 times)

Report message to a moderator

Re: Enterprise Manager Console from a Web Browser [message #333296 is a reply to message #333295]

Fri, 11 July 2008 03:05

Michel Cadot
Messages: 68636
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Don't post a screenshot, copy and paste in text format.

Execute it with connection string as above, tns alias (opera), then post "tnsping opera".

Regards
Michel

Report message to a moderator

Re: Enterprise Manager Console from a Web Browser [message #333306 is a reply to message #333296]

Fri, 11 July 2008 03:40

ocaocp
Messages: 9
Registered: May 2008
Location: Singapore

Junior Member

TNSPING
---------
C:\Documents and Settings\Administrator>tnsping opera

TNS Ping Utility for 32-bit Windows: Version 10.2.0.2.0 - Production on 11-JUL-2
008 16:18:52

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:
D:\oracle\10gappr2\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 192.168.21.221)(PORT = 1521))) (CONNECT_DATA = (SID = OPERA)))
OK (10 msec)

=============

Tried running sqlplus for listener ERROR below
------------------

C:\Documents and Settings\Administrator>sqlplus Usr/pwd@"(DESCRIPTION=(ADDR
ESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=operadbk)(PORT=1521)))(CONNECT_DATA=(SERVI
CE_NAME=opera)))"

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jul 11 16:30:40 2008

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

---------------------

Report message to a moderator

Re: Enterprise Manager Console from a Web Browser [message #333378 is a reply to message #333306]

Fri, 11 July 2008 07:45

Michel Cadot
Messages: 68636
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

ocaocp wrote on Fri, 11 July 2008 10:40

TNSPING
---------
C:\Documents and Settings\Administrator>tnsping opera

TNS Ping Utility for 32-bit Windows: Version 10.2.0.2.0 - Production on 11-JUL-2
008 16:18:52

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:
D:\oracle\10gappr2\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 192.168.21.221)(PORT = 1521))) (CONNECT_DATA = (SID = OPERA)))
OK (10 msec)

=============

Tried running sqlplus for listener ERROR below
------------------

C:\Documents and Settings\Administrator>sqlplus Usr/pwd@"(DESCRIPTION=(ADDR
ESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=operadbk)(PORT=1521)))(CONNECT_DATA=(SERVI
CE_NAME=opera)))"

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jul 11 16:30:40 2008

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

---------------------

Report message to a moderator

Re: Enterprise Manager Console from a Web Browser [message #337317 is a reply to message #332841]

Wed, 30 July 2008 09:47

efachim
Messages: 42
Registered: July 2008

Member

Hey ocaocp,

Did you finally login to the DB from the browser? I vaguely remember that there is a parameter you have to set, to allow access to the OEM from another IP address. Did you do that for your OEM?

Report message to a moderator

Re: Enterprise Manager Console from a Web Browser [message #337324 is a reply to message #337317]

Wed, 30 July 2008 10:06

Michel Cadot
Messages: 68636
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

As there has been no answer since 20 days, I think he just fixed his wrong parameter.

Regards
Michel

Report message to a moderator

Re: Enterprise Manager Console from a Web Browser [message #340890 is a reply to message #337317]

Thu, 14 August 2008 15:42

deepmachine
Messages: 80
Registered: August 2008
Location: United States

Member

Hi, could you please explain which parameter are you talking about?

I have actually run into a similar issue but not related to TNS.
Please check my post at: http://www.orafaq.com/forum/m/340880/128248/#msg_340880

Thanks

Report message to a moderator

Re: Enterprise Manager Console from a Web Browser [message #340931 is a reply to message #340890]

Fri, 15 August 2008 01:07

Michel Cadot
Messages: 68636
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

The one that is in bold red.

Regards
Michel

Report message to a moderator

Re: Enterprise Manager Console from a Web Browser [message #341010 is a reply to message #340931]

Fri, 15 August 2008 09:07

deepmachine
Messages: 80
Registered: August 2008
Location: United States

Member

Thanks Michel,
But I was referring to efachim's question:

Quote:

Hey ocaocp,

Did you finally login to the DB from the browser? I vaguely remember that there is a parameter you have to set, to allow access to the OEM from another IP address. Did you do that for your OEM?

Thanks,
Pinky

Report message to a moderator

Re: Enterprise Manager Console from a Web Browser [message #341013 is a reply to message #341010]

Fri, 15 August 2008 09:13

Michel Cadot
Messages: 68636
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Oh I see, but as his sentence was:

Quote:

I vaguely remember that there is a parameter you have to set

You will be very lucky if you get a precise answer.

Regards
Michel

Report message to a moderator

Re: Enterprise Manager Console from a Web Browser [message #341026 is a reply to message #341013]

Fri, 15 August 2008 10:08

deepmachine
Messages: 80
Registered: August 2008
Location: United States

Member

True

Sad

Anyhow, would you care to answer me at: http://www.orafaq.com/forum/m/340880/128248/#msg_340880

Thanks,
Pinky

Report message to a moderator

Previous Topic:	Enterprize manager problem
Next Topic:	dbconsole after restore on new host

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 08:26:25 CDT 2024