Solved

Oracle administrative group

Posted on 2010-08-26
7
394 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)
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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)
Comment Utility
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
Comment Utility
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)
Comment Utility
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.

Join & Write a Comment

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

728 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now