Re: 11g RAC oraenv question

From: Robert Freeman <>
Date: Tue, 30 Mar 2010 18:40:57 -0700 (PDT)
Message-ID: <>

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.


 Robert G. Freeman
Master Principal Consultant, Oracle Corporation
Oracle ACE
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

From: "Bobak, Mark" <>
To: "" <>; "" <>
Cc: "" <>; "" <>
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……
-Mark [] On
Behalf Of
Sent: Tuesday, March 30, 2010 8:56 AM
Subject: Re: 11g RAC oraenv question

I always add
the instance to the oratab file. 


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

From:  "Newman, Christopher" <>  
To:  "" <>  
Date:  03/30/2010 08:54 AM  
Subject:  11g RAC oraenv question  
Sent by: 


We have a database named ‘T’,
with instances T1 and T2.  The default entry in the oratab looks something
like this: 
            # line added by Agent 
. oraenv T, sets the *home*
correctly, but does not set the instance.  We have to manually export
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: 
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). 
$ORACLE_BASE/diag/rdbms/$ORACLE_SID/$INSTANCE_NAME /trace/alert*log' 
Thanks- Chris 
Received on Tue Mar 30 2010 - 20:40:57 CDT

Original text of this message