This discussion is archived
5 Replies Latest reply: Nov 13, 2012 9:01 AM by user2420150 RSS

ORA-01031: insufficient privileges  after run:  emca -config dbcontrol db

user2420150 Newbie
Currently Being Moderated
Hi everyone:

I have sought all discussion in term of ORA-01031 and no good solution for me:
my case is:
OS=WINDOW SERVER 2005
DB=ORACLE 11GR2
Single instance

I was able to drop repository and recreate it again. However, I can not configure the newly created repository and got error message like:

CONFIG: SQLEngine connecting with SID: MDORCL3, oracleHome: C:\app\lium\product\11.2.0\dbhome_1, and user:
Nov 9, 2012 11:10:33 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
CONFIG: ORA-01031: insufficient privileges

oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-01031: insufficient privileges

     at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1655)
     at oracle.sysman.assistants.util.sqlEngine.SQLEngine.connect(SQLEngine.java:978)
     at oracle.sysman.emcp.util.GeneralUtil.initSQLEngineLoacly(GeneralUtil.java:445)
     at oracle.sysman.emcp.util.GeneralUtil.initSQLEngine(GeneralUtil.java:637)
     at oracle.sysman.emcp.DatabaseChecks.checkDbAvailabilityImpl(DatabaseChecks.java:118)
     at oracle.sysman.emcp.DatabaseChecks.checkDbAvailability(DatabaseChecks.java:163)
     at oracle.sysman.emcp.DatabaseChecks.getDbServiceName(DatabaseChecks.java:582)
     at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1272)
     at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:574)
     at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:522)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points