RE: Permissions question
Date: Mon, 14 Jan 2008 16:34:10 -0000
You might need to re-run root.sh and check the permissions of files in the /usr/local/bin directory.
If I was using this as a production server I think I would re-install now just to save any issues. It does not take long to install 10g and the database can be copied out and copied back in again after the install.
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sweetser, Joe Sent: 14 January 2008 16:14
Subject: Permissions question
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:
- Shutdown everything
- 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.
- Do a chgrp -R dba on ALL oracle-related files including ORACLE_HOME and all the datafiles
The information included in this email and any files transmitted with it may contain information that is confidential and it must not be used by, or its contents or attachments copied or disclosed, to persons other than the intended addressee. If you have received this email in error, please notify BJSS. In the absence of written agreement to the contrary BJSS’ relevant standard terms of contract for any work to be undertaken will apply. Please carry out virus or such other checks as you consider appropriate in respect of this email. BJSS do not accept responsibility for any adverse effect upon your system or data in relation to this email or any files transmitted with it. BJSS Limited, a company registered in England and Wales (Company Number 2777575), VAT Registration Number 613295452, Registered Office Address, First Floor, Coronet House, Queen Street, Leeds, LS1 2TWReceived on Mon Jan 14 2008 - 10:34:10 CST