RE: Group ownership for rdbms files in the diagnostic dest

  • From: John Hallas <John.Hallas@xxxxxxxxxxxxxxxxxx>
  • To: "cichomitiko@xxxxxxxxx" <cichomitiko@xxxxxxxxx>, Oracle-L Group <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 7 Mar 2012 07:25:30 +0000

11.2.0.1 
id oracle
uid=500(oracle) gid=504(oinstall)
id grid
uid=591(grid) gid=504(oinstall)
drwxr-x---   2 oracle     asmadmin      1024 Jan 31 10:56 alert
drwxr-x---   3 oracle     asmadmin      1024 Mar  2 00:16 cdump
drwxr-x---   2 oracle     asmadmin        96 Feb 14  2011 hm
drwxr-x---  201 oracle     asmadmin      6144 Feb 22 22:15 incident
drwxr-x---   2 oracle     asmadmin        96 Feb 14  2011 incpkg
drwxr-x---   2 oracle     asmadmin        96 Nov 18 12:57 ir
drwxr-x---   2 oracle     asmadmin      2048 Feb 22 22:16 lck
drwxr-x---   2 oracle     asmadmin      2048 Feb 14  2011 metadata
drwxr-x---   2 oracle     asmadmin     13312 Feb 22 22:16 stage
drwxr-x---   2 oracle     asmadmin      1024 Feb 22 22:16 sweep
drwxr-xr-x  10 oracle     asmadmin    248832 Mar  7 06:54 trace

We do not seem to have any problems with the 10g Grid agents 

We did have to make changes re the permissions of tnsnames.ora in o0ut 
TNS_ADMIN directory

/app/gridsoft/11.2.0.1/network/admin $ls -l
total 14
-rw-r--r--   1 grid       oinstall       434 Feb 14  2011 listener.ora
-rw-r--r--   1 grid       oinstall       368 Feb 14  2011 
listener.ora.bak.tshvm03
drwxr-xr-x   2 grid       oinstall        96 Feb 14  2011 samples
-rw-r--r--   1 grid       oinstall       187 May  7  2007 shrept.lst
-rw-r--r--   1 grid       oinstall       200 Feb 14  2011 sqlnet.ora
-rw-r--r--   1 oracle     oinstall      2394 Feb  7 16:26 tnsnames.ora

www.jhdba.wordpress.com


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Radoulov, Dimitre
Sent: 06 March 2012 22:37
To: ORACLE-L
Subject: Group ownership for rdbms files in the diagnostic dest

Hi all,

RAC 11.2.0.3.1 on RHEL 5.7
with role separation (different groups for sysasm and sysdba)

I've noticed that the directory <diagnostic_dest>/rdbms and the files 
inside it
are owned by the group asmadmin (not oinstall).

The oracle software owner is defined like this:

$ id oracle
uid=xxxx(oracle) gid=xxxx(oinstall) 
groups=xxxx(dba),xxxx(asmdba),xxxx(oinstall)


______________________________________________________________________
Wm Morrison Supermarkets Plc is registered in England with number 358949. The 
registered office of the company is situated at Gain Lane, Bradford, West 
Yorkshire BD3 7DL. This email and any attachments are intended for the 
addressee(s) only and may be confidential. 

If you are not the intended recipient, please inform the sender by replying to 
the email that you have received in error and then destroy the email. 
If you are not the intended recipient, you must not use, disclose, copy or rely 
on the email or its attachments in any way. 

This email does not constitute a contract in writing for the purposes of the 
Law of Property (Miscellaneous Provisions) Act 1989.

Our Standard Terms and Conditions of Purchase, as may be amended from time to 
time, apply to any contract that we enter into. The current version of our 
Standard Terms and Conditions of Purchase is available at: 
http://www.morrisons.co.uk/gscop

Although we have taken steps to ensure the email and its attachments are 
virus-free, we cannot guarantee this or accept any responsibility, 
and it is the responsibility of recipients to carry out their own virus checks. 
______________________________________________________________________
--
//www.freelists.org/webpage/oracle-l


Other related posts: