Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps

 E-mail Us
 Oracle Articles
New Oracle Articles

 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog

 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Oracle Support

 SQL Tuning

 Oracle UNIX
 Oracle Linux
 Remote s
 Remote plans
 Application Server

 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S


 Consulting Staff
 Consulting Prices
 Help Wanted!


 Oracle Posters
 Oracle Books

 Oracle Scripts

Don Burleson Blog 







ora_dba group tips

Oracle Database Tips by Donald BurlesonFebruary 25, 2015

Question: What is the ora_dba group used for?  Why is it important to have an ora_dba group in Windows?

Answer: When you install Oracle on Windows, a special Windows local group called ora_dba is created.  This is the equivalent of the /etc/group concept in UNIX/Linux.  When a Windows user is assigned to the ora_dba group, they are OS-level DBA work such as starting and stopping the database and listener services. This is referred as SYSDBA privileges.  For information on dba group membership in Linux/UNIX, see my notes on etc/group.

Attempting a privileged Windows operation without being assigned to the ora_dba group leads to the ORA-0103 insufficient privileges error.

There are two or three key groups on Windows: Administrators, ora_dba, and ora_oper. The first two are musts, and the ora_oper is entirely optional.

You do not necessarily have to belong to the ora_dba, administrators group, but you or someone else does when Oracle is first installed.

With Oracle on Windows, you get the ora_dba group for free. Creating groups on Windows is typically in the purview of an administrator. The ora_dba group is similar to the oinstall or dba groups created on UNIX, and membership does have its privileges.



Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


Copyright © 1996 -  2020

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.



Oracle Training at Sea
oracle dba poster

Follow us on Twitter 
Oracle performance tuning software 
Oracle Linux poster