RE: Permissions question

  • From: "John Hallas" <john.hallas@xxxxxxxxxx>
  • To: <JSweetser@xxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • 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. 

John

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Sweetser, Joe
Sent: 14 January 2008 16:14
To: oracle-l@xxxxxxxxxxxxx
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:

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

Thanks,
-joe
 




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 2TW


--
//www.freelists.org/webpage/oracle-l


Other related posts: