Permissions question

From: Sweetser, Joe <>
Date: Mon, 14 Jan 2008 09:14:05 -0700
Message-ID: <E323160E08E560459CD05A883546C3CE0B3FFA44@earthquake.ICAT.COM>

New server. RH 5. 10gR2.

Oracle account was set up a default group of oracle (not dba, though the dba group does exist). Foolhardy DBA (moi) did not check the group before installing the s/w and creating the database. I would like to "correct" this as quickly as possible and wonder what anyone thinks about the following idea:

  1. Shutdown everything
  2. Get the default group changed to dba in /etc/passwd. I know I can change the group when I am logged in, but want to make it "clean" for everyone going forward.
  3. Do a chgrp -R dba on ALL oracle-related files including ORACLE_HOME and all the datafiles
  4. Restart


Confidentiality Note: This message contains information that may be confidential and/or privileged. If you are not the intended recipient, you should not use, copy, disclose, distribute or take any action based on this message. If you have received this message in error, please advise the sender immediately by reply email and delete this message. Although ICAT Managers, LLC scans e-mail and attachments for viruses, it does not guarantee that either are virus-free and accepts no liability for any damage sustained as a result of viruses. Thank you.

Received on Mon Jan 14 2008 - 10:14:05 CST

Original text of this message