‘ORA-01031: insufficient privileges’ Error Observed when Using EMCA to Create or Drop DBconsole

Written by mawundaga

January 12, 2018

Blog

I am running Oracle rdbms 11.2.0 on Windows Server 2012. I ran into a peculiar issue when I dropped dbconsole schema and then attempted recreating it.

emca -config dbcontrol db -repos create -PORT 1521 
Error:
Enter the following information:
Jan 11, 2018 10:36:48 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
WARNING: ORA-01031: insufficient privileges
 
Jan 11, 2018 10:36:48 AM oracle.sysman.emcp.DatabaseChecks throwDBUnavailableException
SEVERE:
Database instance is unavailable. Fix the ORA error thrown and run EM Configuration Assistant again.
Some of the possible reasons may be : …
After many hours of research, I found MOS Doc ID 358201.1 that gives many suggestions and one of them worked for me.

My solution: I didn’t have the correct privileges at the O/S level.

Check that the user who is creating the dbconsole, is a member of the oracle_dba group.

 

For example:

Go to control panel/administrative tools/computer management/local users and groups/groups/ora_dba (double click to see the members of that group)
That’s it.

Oracle Patches and Application

Patching  is one  of  the  most  common  task  performed  by  DBA's  in  day-to-day  life  . Here , we  will discuss  about  the various  types  of  patches  which  are  provided  by  Oracle  . Oracle  issues  product fixes  for  its  software called...

Follow Along

Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Sed molestie, velit ut eleifend sollicitudin, neque orci tempor nulla, id sagittis nisi ante nec arcu.

Free Courses

Duis egestas aliquet aliquet. Maecenas erat eros, fringilla et leo eget, viverra pretium nulla. Quisque sed augue tincidunt, posuere dui tempor.

Premium Courses

Duis egestas aliquet aliquet. Maecenas erat eros, fringilla et leo eget, viverra pretium nulla. Quisque sed augue tincidunt, posuere dui tempor.

Ready to get started?

Get in touch, or create an account

You May Also Like…

Annotation example

This is an example of annotation, hover the highlighted "annotation" word to see it in action!If you find the plugin...

1 Comment

Submit a Comment

Your email address will not be published. Required fields are marked *