Re: 11g RAC oraenv question

How was this RAC created? I have a 11.2 RAC that I created a few weeks ago on Linux using DBCA and the oratab was correct.

RF


 Robert G. Freeman
Master Principal Consultant, Oracle Corporation
Oracle ACE
Author:
Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON ITS WAY SOON!
OCP: Oracle Database 11g Administrator Certified Professional Study Guide (Sybex)
Oracle Database 11g New Features (Oracle Press)
Oracle Database 10g New Features (Oracle Press)
Other various titles
Blog: http://robertgfreeman.blogspot.com




________________________________
From: "Bobak, Mark" <Mark.Bobak_at_proquest.com>
To: "TESTAJ3_at_nationwide.com" <TESTAJ3_at_nationwide.com>; "cjnewman@uillinois.edu" <cjnewman@uillinois.edu>
Cc: "oracle-l_at_freelists.org" <oracle-l@freelists.org>; "oracle-l-bounce@freelists.org" <oracle-l-bounce@freelists.org>
Sent: Tue, March 30, 2010 7:54:16 AM
Subject: RE: 11g RAC oraenv question

 
Same here….
 
Rather annoying that Oracle *still* hasn’t fixed this! 
Even in 11.2.0.1.0……
 
-Mark
 
From:oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce@freelists.org] On
Behalf Of TESTAJ3_at_nationwide.com
Sent: Tuesday, March 30, 2010 8:56 AM
To: cjnewman_at_uillinois.edu
Cc: oracle-l_at_freelists.org; oracle-l-bounce@freelists.org
Subject: Re: 11g RAC oraenv question
 

I always add
the instance to the oratab file. 

joe 

_______________________________________
Joe Testa, Oracle Certified Professional 
Senior Engineering & Administration Lead
(Work) 614-677-1668
(Cell) 614-312-6715





From:  "Newman, Christopher" <cjnewman_at_uillinois.edu>  
To:  "oracle-l_at_freelists.org" <oracle-l@freelists.org>  
Date:  03/30/2010 08:54 AM  
Subject:  11g RAC oraenv question  
Sent by:  oracle-l-bounce_at_freelists.org 
 

________________________________
 



Greetings, 
  
We have a database named ‘T’,
with instances T1 and T2.  The default entry in the oratab looks something
like this: 
  
T:/u01/app/oracle/product/11.2.0/dbhome_1:N
            # line added by Agent 
  
. oraenv T, sets the *home*
correctly, but does not set the instance.  We have to manually export
ORACLE_SID=T1. 
  
Does anyone have a good way to
overcome this?  We have some aliases set up and I’m having a heck of a
time getting them to work with this current setup. 
  
For example, we have an alias
that does a less on the alert log, and it’s based off the ORACLE_SID: 
  
alert='less
$ORACLE_BASE/admin/$ORACLE_SID/bdump/alert*log' 
  
In our RAC instances, I think it
will look something like this, but I’m missing a piece, with INSTANCE_NAME
being a variable I’m not sure how to grab (multiple databases/instances on the box). 
  
alert='less
$ORACLE_BASE/diag/rdbms/$ORACLE_SID/$INSTANCE_NAME /trace/alert*log' 
  
Thanks- Chris 

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