RE: 11.2.0.2 RAC Directory Structure

From: Uzzell, Stephan <SUzzell_at_MICROS.COM>
Date: Thu, 22 Dec 2011 12:59:17 +0000
Message-ID: <DF78EADE484D37419A53F5C898629DB701301902_at_USMAIL2K1001.us.micros.int>



I think I didn't ask exactly what I needed to ask...

In 10g we separated the CRS and ASM homes (the question of whether that was best practice or not can be set aside for now); in 11g we cannot, they are both now the "Grid Infrastructure".

The question is about how to best set up the directory structure for 11g, on Windows (Linux is something we are looking to in the future - for now we're a Windows shop):

As a side note - does anyone know why the ORACLE_HOME should be outside the ORACLE_BASE for GI? Ideally, I'd love to have a D:\oracle\11202 folder as the ORACLE_BASE for both GI and DB, and have a GI and a DB folder within that...

Since the GI HOME has to be outside the GI BASE, we're moving towards a structure like:

D:\oracle\GI_BASE    --> GI BASE
D:\oracle\11201\GRID --> GI HOME
D:\oracle\11201      --> DB BASE
D:\oracle\11201\DB   --> DB HOME

Some of our earliest installs, though, are not quite that neat. :-)

I'm wondering if there is a best practice, and what will we find when we move to 11.2.0.3? Will we be able to re-use the same BASE folders, and just install new HOMEs?

Thanks,
stephan

Stephan Uzzell

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Uzzell, Stephan Sent: Wednesday, 21 December, 2011 11:04 To: 'oracle-l_at_freelists.org'
Subject: 11.2.0.2 RAC Directory Structure

Morning, all,
We're slowly starting to work with 11.2.0.2 for more of our environments, and learning some of the tricks and gotchas with it.

One question that we have not found a logical answer for is handling the directory structure (we're on Windows, but I suspect this is broader than a Windows question). In our 10g installs, we aimed for a very simple directory structure for our three Oracle Homes:

D:\oracle\1020\CRS
D:\oracle\1020\ASM
D:\oracle\1020\DB
D:\oracle\admin\... for the ASM and DB dump destinations.

11g has changed things by a) adding the ORACLE_BASE as something we need to explicitly define; and b) the out-of-place upgrades. The out-of-place upgrades are not too much trouble - we'll simply change the directory name from D:\oracle\11201\... to D:\oracle\11202\... and so on.

The Oracle Base, however, is something we're struggling to find a best practice for. For the Grid Infrastructure, the recommendation (and OUI very strongly suggests this) is to put the ORACLE_HOME outside of the ORACLE_BASE; for the Database, the Home should be within the Base.

How do people handle this? Can the two Oracle Bases be the same?

Any advice on this would be appreciated... stephan

Stephan Uzzell

--

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

--

http://www.freelists.org/webpage/oracle-l Received on Thu Dec 22 2011 - 06:59:17 CST

Original text of this message