Solved

Oracle administrative group

Posted on 2010-08-26
7
395 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
  • 4
  • 3
7 Comments
 
LVL 76

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 76

Accepted Solution

by:
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.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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 76

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 76

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Article by: Swadhin
From the Oracle SQL Reference (http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm) we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to recover a database from a user managed backup

809 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