MacLochlainns Weblog

Michael McLaughlin's Technical Blog

Site Admin

Set up Gnome for Oracle

with 6 comments

Back in September, I showed how to setup Oracle Database 11g XE on Fedora. It was straightforward more or less, but tonight I ran into a problem while working with the Oracle Stop Database menu option. When I selected it form the menu, I got the user must be in the DBA OS group to stop the database.

Since the database started automatically on boot and shutdown when closing the operating system, I missed this nuance in the setup. The screen shot for the error is:

Oracle Database 11g XE automatically creates an oracle user with a dba group. While the mclaughlinm user was in the wheel group and an authorized sudoer, the mclaughlinm user needed to also be in the dba group. That’s more tricky in Fedora 15 and 16 because they’ve removed the System menu and the options that let you install and modify users.

Here are the steps to add your user to the dba group. Open a terminal session, and launch the User Manager application with the following command:

system-config-users

You have to enter the root password to get this to work. Then, it launches the User Manager application. Click on the target user, and click the Properties button.

The User Manager application launches the User Properties dialog. Click on the Groups tab.

Scroll in the groups list to the dba group. Click the checkbox for the dba group and the OK button.

Now, you’ll be able to navigate to through the menu to Stop Database to shutdown and Start Database to restart the Oracle database.

Hope this helps a few folks.

Written by maclochlainn

December 3rd, 2011 at 11:15 pm

6 Responses to 'Set up Gnome for Oracle'

Subscribe to comments with RSS or TrackBack to 'Set up Gnome for Oracle'.

  1. […] put your privileged sudoer in the dba group […]

  2. Thank you. You really helped me a lot with this.

    Sravan

    19 Feb 12 at 5:49 am

  3. Thank you. It was very helpful.

    All best!

    kamilos

    13 Jun 12 at 3:55 am

  4. Thank you!

    Carlos Matos

    24 Jul 13 at 5:16 pm

  5. It is easy but was easier to find it in Google and to come here do know how to do it.

    Pablohn

    20 Nov 13 at 4:57 pm

  6. Thank u so much… It really helped me alot.

    Krithika

    26 Nov 14 at 4:00 am

Leave a Reply