Oracle administrative group

Posted on 2010-08-26
Last Modified: 2013-12-12
Hey guys how do I check whether my name is added in Oracle administrative group so that I can do patching as a administrator. If it is not added than how can I add my name in administrator group. Thanks for your help in advance.
Question by:hussainkhan22
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 33531052
What OS?

If Windows, you can go to control panel then check users/groups.

>>how can I add my name in administrator

If you aren't an Admin, you can't.  You will need to get an Admin to do this.

Author Comment

ID: 33531439
In control panel there is no users/group. Can you please tell me the exact location.
LVL 77

Accepted Solution

slightwv (䄆 Netminder) earned 500 total points
ID: 33531517
What OS?

It might be: User Accounts or something similar.  It's under Control Panel.  Or you could right-click on My Computer and select Manage.  Then you might see, depending on the Windows version: Local Users and Groups.
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.


Author Comment

ID: 33531626
As an Oracle DBA What I need to look in groups and users. I mean which group should be present and which user must be present for Oracle DBA. I got that location by right click on my computer and select manage.
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 33531980
You need to be in the ORA_DBA group to do things like startup and shutdown the database.

To install Oracle software you need to be a Local Administrator.  This one you might not get in some shops depending on their security policies.  

I've seen some operations where you will have to 'ask' to install Oracle and be granted ADmin for the day/task.

I've also seen shops where the Admin sits with you and logs in as local admin while you perform the install.

Author Comment

ID: 33533591
One last question than I will close this question. Oracle DBA user must be assign to ORA_DBA group or not. If yes than how can I check whether Oracle user is assign to ORA_DBA group. thanks alot for your help in advance.
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 33533640
Are you talking about OS users or actual Oracle database users?

ORA_DBA is an operating system group and should ONLY be set for Oracle DBAs.

If OS group, when you are in viewing the groups in Windows, you should see the users assigned to that group.

Featured Post

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Oracle Listener Not Starting 11 66
form builder not starting 3 72
Oracle 12c Default Isolation Level 17 56
Oracle create type table from existing table%rowtype ? 6 63
This post first appeared at Oracleinaction  ( Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question