Home » RDBMS Server » Enterprise Manager » Enterprise Manager Console from a Web Browser (10g, window 2003)
Enterprise Manager Console from a Web Browser [message #332841] Wed, 09 July 2008 23:09 Go to next message
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,
Re: Enterprise Manager Console from a Web Browser [message #332866 is a reply to message #332841] Thu, 10 July 2008 00:11 Go to previous messageGo to next message
BlackSwan
Messages: 23134
Registered: January 2009
Senior Member
Those who live by the GUI, die by the GUI!
OEM is NOT required to use Oracle RDBMS!
Re: Enterprise Manager Console from a Web Browser [message #332921 is a reply to message #332866] Thu, 10 July 2008 02:14 Go to previous messageGo to next message
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.
Re: Enterprise Manager Console from a Web Browser [message #332932 is a reply to message #332921] Thu, 10 July 2008 02:38 Go to previous messageGo to next message
Michel Cadot
Messages: 59978
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
Re: Enterprise Manager Console from a Web Browser [message #332935 is a reply to message #332932] Thu, 10 July 2008 02:49 Go to previous messageGo to next message
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.
Re: Enterprise Manager Console from a Web Browser [message #332949 is a reply to message #332935] Thu, 10 July 2008 03:13 Go to previous messageGo to next message
Michel Cadot
Messages: 59978
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
Re: Enterprise Manager Console from a Web Browser [message #332968 is a reply to message #332949] Thu, 10 July 2008 03:54 Go to previous messageGo to next message
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.


Re: Enterprise Manager Console from a Web Browser [message #332992 is a reply to message #332968] Thu, 10 July 2008 04:41 Go to previous messageGo to next message
Michel Cadot
Messages: 59978
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Is the connection descriptpr correct?

Regards
Michel
Re: Enterprise Manager Console from a Web Browser [message #333220 is a reply to message #332992] Thu, 10 July 2008 21:27 Go to previous messageGo to next message
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
Re: Enterprise Manager Console from a Web Browser [message #333237 is a reply to message #333220] Fri, 11 July 2008 00:06 Go to previous messageGo to next message
Michel Cadot
Messages: 59978
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 Go to previous messageGo to next message
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


Re: Enterprise Manager Console from a Web Browser [message #333287 is a reply to message #333273] Fri, 11 July 2008 02:43 Go to previous messageGo to next message
Michel Cadot
Messages: 59978
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 Go to previous messageGo to next message
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 188 times)
Re: Enterprise Manager Console from a Web Browser [message #333296 is a reply to message #333295] Fri, 11 July 2008 03:05 Go to previous messageGo to next message
Michel Cadot
Messages: 59978
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
Re: Enterprise Manager Console from a Web Browser [message #333306 is a reply to message #333296] Fri, 11 July 2008 03:40 Go to previous messageGo to next message
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

---------------------
Re: Enterprise Manager Console from a Web Browser [message #333378 is a reply to message #333306] Fri, 11 July 2008 07:45 Go to previous messageGo to next message
Michel Cadot
Messages: 59978
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

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

Re: Enterprise Manager Console from a Web Browser [message #337317 is a reply to message #332841] Wed, 30 July 2008 09:47 Go to previous messageGo to next message
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?
Re: Enterprise Manager Console from a Web Browser [message #337324 is a reply to message #337317] Wed, 30 July 2008 10:06 Go to previous messageGo to next message
Michel Cadot
Messages: 59978
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
Re: Enterprise Manager Console from a Web Browser [message #340890 is a reply to message #337317] Thu, 14 August 2008 15:42 Go to previous messageGo to next message
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
Re: Enterprise Manager Console from a Web Browser [message #340931 is a reply to message #340890] Fri, 15 August 2008 01:07 Go to previous messageGo to next message
Michel Cadot
Messages: 59978
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The one that is in bold red.

Regards
Michel
Re: Enterprise Manager Console from a Web Browser [message #341010 is a reply to message #340931] Fri, 15 August 2008 09:07 Go to previous messageGo to next message
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
Re: Enterprise Manager Console from a Web Browser [message #341013 is a reply to message #341010] Fri, 15 August 2008 09:13 Go to previous messageGo to next message
Michel Cadot
Messages: 59978
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
Re: Enterprise Manager Console from a Web Browser [message #341026 is a reply to message #341013] Fri, 15 August 2008 10:08 Go to previous message
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
Previous Topic: Enterprize manager problem
Next Topic: dbconsole after restore on new host
Goto Forum:
  


Current Time: Thu Dec 18 07:07:38 CST 2014

Total time taken to generate the page: 0.07330 seconds