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
Solved

Oracle administrative group

Posted on 2010-08-26
7
396 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 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 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 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

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

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
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, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

828 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