Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with OEM 10gR2

Re: Problem with OEM 10gR2

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 08 Aug 2007 11:40:20 -0700
Message-ID: <1186598418.302507@bubbleator.drizzle.com>


francois.archambault5_at_gmail.com wrote:
> Hi all,
>
> I hope someone whos reads this can help me.
>
> In Oracle Enterprise Manager 10g web interface, I am not able to view
> User detail to add role and privileage to it.
> An error message pops : "An error occured when processing this
> request. Please check the log file emoms.log for a complete stack
> trace.Failed to initialize object:ORA-00979: not a GROUP BY
> expression"
>
> I would be able to correct this if it was in one of our query but it
> seems the problem is into OEM.
>
> I am able to view other object detail like Table of SP put users wont
> open.
>
> Here is the error collected in the emoms.log :
>
> 2007-08-08 09:02:23,019 [EMUI_09_02_20_/console/database/security/
> user] ERROR adm.misc logException.3446 -
> oracle.sysman.emSDK.admObj.AdminObjectException: ORA-00979: not a
> GROUP BY expression
>
> at
> oracle.sysman.emo.adm.security.DBGranteeInitializer.initializeConsumerGroupPrivs(DBGranteeInitializer.java:
> 456)
> at
> oracle.sysman.emo.adm.security.DBGranteeInitializer.initialize(DBGranteeInitializer.java:
> 120)
> at
> oracle.sysman.emo.adm.security.user.DBUserInitializer.initialize(DBUserInitializer.java:
> 86)
> at oracle.sysman.emo.adm.DBObject.initialize(DBObject.java:152)
> at oracle.sysman.emo.adm.security.user.User.initialize(User.java:195)
> at oracle.sysman.emo.adm.security.user.User.initializeAll(User.java:
> 178)
> at
> oracle.sysman.db.adm.DBController.getBeanForInstantiation(DBController.java:
> 686)
> at
> oracle.sysman.db.adm.DBController.instantiateBeanForCreateLike(DBController.java:
> 883)
> at
> oracle.sysman.db.adm.DBController.instantiateBean(DBController.java:
> 605)
> at oracle.sysman.db.adm.DBController.getNewBean(DBController.java:
> 1008)
> at oracle.sysman.db.adm.DBController._getBean(DBController.java:542)
> at oracle.sysman.db.adm.DBController.getBean(DBController.java:523)
> at
> oracle.sysman.db.adm.sec.UserController.getUserBean(UserController.java:
> 1269)
> at
> oracle.sysman.db.adm.sec.UserController.getBean(UserController.java:
> 1059)
> at
> oracle.sysman.db.adm.DBController.validateFileNameState(DBController.java:
> 3275)
> at oracle.sysman.db.adm.DBController.handleEvent(DBController.java:
> 3080)
> at
> oracle.sysman.emSDK.svlt.PageHandler.handleRequest(PageHandler.java:
> 376)
> at
> oracle.sysman.db.adm.RootController.handleRequest(RootController.java:
> 170)
> at
> oracle.sysman.db.adm.DBControllerResolver.handleRequest(DBControllerResolver.java:
> 114)
> at oracle.sysman.emSDK.svlt.EMServlet.myDoGet(EMServlet.java:688)
> at oracle.sysman.emSDK.svlt.EMServlet.doGet(EMServlet.java:291)
> at oracle.sysman.eml.app.Console.doGet(Console.java:285)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:
> 65)
> at
> oracle.sysman.emSDK.svlt.EMRedirectFilter.doFilter(EMRedirectFilter.java:
> 101)
> at
> com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:
> 16)
> at
> oracle.sysman.db.adm.inst.HandleRepDownFilter.doFilter(HandleRepDownFilter.java:
> 151)
> at
> com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:
> 20)
> at
> oracle.sysman.eml.app.ContextInitFilter.doFilter(ContextInitFilter.java:
> 282)
> at
> com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:
> 600)
> at
> com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:
> 317)
> at
> com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:
> 793)
> at
> com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:
> 270)
> at
> com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:
> 112)
> at com.evermind.util.ReleasableResourcePooledExecutor
> $MyWorker.run(ReleasableResourcePooledExecutor.java:192)
> at java.lang.Thread.run(Thread.java:534)
>
>
>
> Thanks in advance.

Wish I could be more helpful but ... http://metalink.oracle.com. Check the docs and if no help open an SR.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Wed Aug 08 2007 - 13:40:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US