Re: 11g RAC oraenv question

  • From: TESTAJ3@xxxxxxxxxxxxxx
  • To: cjnewman@xxxxxxxxxxxxx
  • Date: Tue, 30 Mar 2010 08:56:15 -0400

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

"Newman, Christopher" <cjnewman@xxxxxxxxxxxxx>
"oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
03/30/2010 08:54 AM
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:
T:/u01/app/oracle/product/11.2.0/dbhome_1:N             # line added by 
. 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 
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 
Thanks- Chris

Other related posts: