RE: Group ownership for rdbms files in the diagnostic dest
Date: Wed, 7 Mar 2012 07:25:30 +0000
Message-ID: <EC65ECF8123FEE4D8FC5B212637C3040012BBE58CE3D_at_EXCH1.morrisonsplc.co.uk>
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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.
--
http://www.freelists.org/webpage/oracle-l Received on Wed Mar 07 2012 - 01:25:30 CST