‘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

by mawundaga | Jan 9, 2018 | oracle Administration, Patching | 0 Comments

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...

How to Remove One Standby Database from a Data Guard Configuration

by mawundaga | Jan 9, 2018 | Dataguard, oracle Administration, oracle Backup & Recovery | 0 Comments

Find the LAD (log_archive_dest_n) and the db_unique_name for the Standby that is being removed: show parameter log_archive_dest_ Take note of those that have values such as: log_archive_dest_1 string LOCATION=+RECOC1 VALID_FOR=(AL...

How to apply a typical Oracle PATCH SET UPDATE (12.1.0.2.0–CPUOCT2017)

by Choma | Nov 9, 2017 | oracle Administration, Oracle Patch, Patching | 0 Comments

Oracle Critical Patch Update A Critical Patch Update (CPU) is a collection of patches for multiple security vulnerabilities. Critical Patch Update patches are usually cumulative, but each advisory describes only the security fixes added since the previous Critical...

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.