View Single Post
  #1 (permalink)  
Old March 25th, 2008, 01:23
mnlv00 mnlv00 is offline
Junior Member
 
Join Date: Nov 2007
Posts: 8
Thanks: 1
Thanked 0 Times in 0 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
mnlv00 is on a distinguished road
Unhappy Issues with our OTM Env...PL HELP !!!

Hi,
DBA.ADMIN ROLE IS SET TO EXTERNAL, INSTEAD OF ADMIN - HOW TO SET BACK TO ADMIN?

Oracle reco us to do these
1) Make sure O7_DICTIONARY_ACCESSIBILITY is set to TRUE. It was set to FALSE. I changed to TRUE.

2) Reran the insert_security_roles.sql script.

3) update GL_USER set IS_EXTERNAL='N' where gl_user_gid
='DBA.ADMIN'

4) Recycled the DB and app

5) Trying to bring the app, it displays these errors
"cause.ERROR_CONNECTING_TO_SERVER (exception=null, user=DBA.ADMIN)". Message in the logs (glog.exception.log, glog.app.log) when attempting to log in as DBA.ADMIN indicate "oracle.oc4j.rmi.OracleRemoteException: DBA.ADMIN is not allowed to call this EJB method" (complete message text in the attached file).

What am I missing ? PL help
TIA
Mohan
Reply With Quote