oraenv ownership in RAC

From: Ruel, Chris <Chris.Ruel_at_lfg.com>
Date: Thu, 22 May 2014 13:48:34 +0000
Message-ID: <1AFD62082EEAF0448EF1815139687F131F78B40C_at_NC2PWEX504.us.ad.lfg.com>



Cluster details:

GI 11.2.0.3
DB 11.2.0.3

2 node cluster on OEL with RH compatible kernel.

2 owner install: grid owns GI, oracle owns DB

Question: When the DB software is installed, running root.sh gives you the option of overwriting the files in /usr/local/bin. Should I leave them as the grid root.sh put them there or should the DB software overwrite them? What is considered "correct" or "best practice"? They seem to be quite different. For example, currently, on the cluster on which I am working, it seems on one node, the scripts were overwritten and on the other they were not (I did not do the installs):

Node 1:

[oracle_at_nc2tldb04c ~]$ cd /usr/local/bin
[oracle_at_nc2tldb04c bin]$ ls -l

total 64
-rwxr-xr-x 1 grid root 5778 Jun 4 2013 coraenv -rwxr-xr-x 1 grid root 2415 Jun 4 2013 dbhome ...
-rwxr-xr-x 1 grid root 6183 Jun 4 2013 oraenv ...
[oracle_at_nc2tldb04c bin]$

Node 2:

[oracle_at_nc2tldb03c bin]$ ls -l

total 64
-rwxr-xr-x 1 oracle root 4143 Aug 5 2013 coraenv -rwxr-xr-x 1 oracle root 2415 Aug 5 2013 dbhome ...
-rwxr-xr-x 1 oracle root 4785 Aug 5 2013 oraenv ...
[oraloads_at_nc2tldb03c bin]$

I am actually running into an issue where I have a user which runs our ETL jobs can't successfully execute oraenv where it is owned by grid:

[oraloads_at_nc2tldb04c ~]$ export ORACLE_BASE=/u01/app/oracle
[oraloads_at_nc2tldb04c ~]$ . oraenv

ORACLE_SID = [oraloads] ? por09r2
ORACLE_BASE environment variable is not being set since this information is not available for the current user ID oraloads. You can set ORACLE_BASE manually if it is required.

You can see, I actually am setting ORACLE_BASE manually, but, I still get the error. This works fine on the node where oraenv is owned by the oracle user.

FWIW, the connect still works after running oraenv and getting the error, but, I want to make things consistent, right, and clean as possible.

Thanks for any insight!

Chris Ruel..

Chris Ruel * Oracle Database Administrator cruel_at_lfg.com<mailto:cruel_at_lfg.com> * Desk:317.759.2172 * Cell 317.523.8482

Notice of Confidentiality: **This E-mail and any of its attachments may contain Lincoln National Corporation proprietary information, which is privileged, confidential, or subject to copyright belonging to the Lincoln National Corporation family of companies. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. Thank You.**

--
http://www.freelists.org/webpage/oracle-l
Received on Thu May 22 2014 - 15:48:34 CEST

Original text of this message