5 Replies Latest reply: Nov 13, 2012 11:01 AM by user2420150 RSS

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

    user2420150
      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)