Re: oraenv for RAC
- From: Charles Schultz <sacrophyte@xxxxxxxxx>
- To: Dan Norris <dannorris@xxxxxxxxxxxxx>
- Date: Thu, 4 Mar 2010 08:46:25 -0600
Interesting. Also interesting that you did not respond from your "other"
email address. =)
We do modify oraenv and choose the default [n] when root.sh asks us to
overwrite the "local/bin" files. That part makes it easy to remember for us;
"just hit enter at all the prompts".
Thanks for shedding light on this.
On Thu, Mar 4, 2010 at 08:41, Dan Norris <dannorris@xxxxxxxxxxxxx> wrote:
> I typically add the right stuff to the /etc/oratab. I think there's a DBCA
> enhancement request for putting the actual ORACLE_SID in /etc/oratab when
> the DB is created too (not sure the status of that ER though).
>
> I've also used code like this on Linux bash to derive the SID number
> (assuming your hostnames end with a number corresponding to the instance
> number):
> sidprefix=dan
> host=`hostname -s`
> num=${host#${host%?}}
> ORACLE_SID=${sidprefix}${num}
>
> I don't modify oraenv--too hard to do and remember to do after each
> install, patch, etc. I'm also not a fan of menus as that often messed up
> scripting (especially when that scripting involves an ssh to remote node for
> running a command). Any menus would have to be enclosed in a block that
> checks if a terminal is attached or not so that the menu can be skipped for
> scripting purposes.
>
> Good luck.
>
> Dan
>
>
> On Thu, Mar 4, 2010 at 8:26 AM, Charles Schultz <sacrophyte@xxxxxxxxx>wrote:
>
>> Good day, list,
>>
>> I am reviving this 2.5 year-old thread and asking if Oracle plans to
>> improve oraenv at all. I also reference a similar
>> discourse<//www.freelists.org/post/oracle-l/RAC,4>started by Sanjay
>> Mishra, in which Finn Jorgensen observes many of the same
>> things. At this point, I am just curious. Do Oracle developers manually
>> modify oraenv each time they reinstall the software? Do they get around it
>> by "export ORACLE_SID=$ORACLE_SID$NODE"? Do they add the instance name to
>> the oratab? Right now we do pretty much what Jay Caviness
>> does<http://grumpy-dba.com/tag/olsnodes-rac-oraenv/>
>> .
>>
>> I acknowledge this is a really small thing. I just find it sorta funny how
>> it has slipped through the cracks.
>>
>> On Fri, Jul 13, 2007 at 13:09, Charles Schultz <sacrophyte@xxxxxxxxx>wrote:
>>
>>> Good day,
>>>
>>> For those of you who have used RAC for a while and have some good oraenv
>>> tricks/scripts, do you mind sharing? Obviously, it is not hard to modify it
>>> (and we have), but I am looking for the "best" oraenv. *grin*
>>> What I have now will set two different variables, one for the instance on
>>> the local node and another for the database (defaulting the ORACLE_SID to
>>> the local instance). I found it is also handy to have a "chooser" (pick
>>> list) for those that are slowly getting over the idea that the instance is
>>> not the same as the database.
>>>
>>> I found some simple examples from google, but nothing that was really
>>> satisfying.
>>>
>>> tia
>>>
>>> --
>>> Charles Schultz
>>
>>
>>
>>
>> --
>> Charles Schultz
>>
>
>
--
Charles Schultz
Other related posts:
