oraenv ownership in RAC
- From: "Ruel, Chris" <Chris.Ruel@xxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 22 May 2014 13:48:34 +0000
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@nc2tldb04c ~]$ cd /usr/local/bin
[oracle@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@nc2tldb04c bin]$
Node 2:
[oracle@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@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@nc2tldb04c ~]$ export ORACLE_BASE=/u01/app/oracle
[oraloads@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@xxxxxxx<mailto:cruel@xxxxxxx> * 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.**
Other related posts:
