RE: Server Architecture

If your oratab file is up to date, then yes, that takes care of it for you. But if you're not maintaining your oratab, or you accidentally forget to update it, or fat-finger the change, or, and we see this a lot, you are running Veritas Cluster Server or something similar, where just because a home was created on one node does not mean that two weeks later it will still be on that node, you're stuck.  

In fact, I have three or four customers I can think of where they follow this one home + one user model, and at least one of them wrote a custom bash_login script that automatically sets all of the environment variables as they log in based on the directory name of the home and the userid. Very clean and simple.  

Thanks,

Matt  

From: Bobak, Mark [mailto:Mark.Bobak_at_proquest.com] Sent: Thursday, January 03, 2008 1:11 PM To: Matthew Zito; dannorris_at_dannorris.com; tanel.poder.003_at_mail.ee; Oracle L
Subject: RE: Server Architecture  

Doesn't the oraenv script provide the knowledge of "what the home is purely by virtue of the instance name"?  

Just do:

. oraenv

At the ORACLE_SID = prompt, enter the sid you want, and you (should be) guaranteed the correct ORACLE_HOME, right?  

-Mark
   

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jan 03 2008 - 12:19:17 CST