?
Solved

Oracle administrative group

Posted on 2010-08-26
7
Medium Priority
?
403 Views
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.
0
Comment
Question by:hussainkhan22
[X]
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
7 Comments
 
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.
0
 

Author Comment

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

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 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.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:hussainkhan22
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.
0
 
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.
0
 

Author Comment

by:hussainkhan22
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.
0
 
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.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by 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 information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

743 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