This blog has moved here.

Wednesday, February 24, 2010

INS-32018 Warning for Standalone Server

When it comes to installing Oracle you should always follow the procedures written into the installation guides. As you already know, Oracle 11.2 packages ASM within a new separate component called Oracle Grid Infrastructure. So, if you want to install the database files into ASM then you must install Grid Infrastructure. As a good practice, Oracle recommends to install it under a different user, typically named "grid".
As far as the OFA directories structure is concerned the installation guide recommends:

  • to create an "/u01/app/grid" directory to be used as an ORACLE_BASE for this "grid" user;

  • to create an "/u01/app/11.2.0/grid" directory to be used as an ORACLE_HOME for this "grid" user.


If you're like me, the above configuration looks a little bit weird because I used to think that the ORACLE_HOME should be somewhere under the ORACLE_BASE directory. Nevertheless, the documentation clearly states the following:

Caution:

For grid infrastructure for a cluster installations, the Grid home must not be placed under one of the Oracle base directories, or under Oracle home directories of Oracle Database installation owners, or in the home directory of an installation owner. During installation, ownership of the path to the Grid home is changed to root. This change causes permission errors for other installations.

However, the above applies just to cluster installations. If you just want ASM installed for a single instance database then it's fine (and recommended) to place the ORACLE_HOME under the ORACLE_BASE. If not doing so, you'll get the following warning:



So, to sum up the above ideas, remember that if you are going to install a RAC then you need to create the grid ORACLE_HOME out of the ORACLE_BASE of any oracle software owner. If you choose to install the Oracle Grid Infrastructure for a standalone server then the ORACLE_HOME of the grid user should be under its ORACLE_BASE.

2 comments:

Paul said...

Alexandru,
Your notes about the Oracle Home directory for Grid Infrastructure for a standalone server are really helpful. I wanted to install Grid Infrastructure in order to use ASM on a standalone server. The Oracle docs should really make a clearer distinction between the Oracle Home path for cluster vs standalone.

I was trying to follow the OFA standard but was attempting to perform the "Install Grid Infrastructure Software Only" installation. It wouldn't let me use /u01/app/grid for Oracle Base and /u01/app/grid/product/11.2.0/grid as my Oracle Home for Grid as suggested by OFA. After reading your note, I can only assume that the "Software Only" install assumes cluster setup rather than standalone.

Japan Chronicle's said...

can i install ex: ORACLE BASE on drive c: and ORACLE_HOME on drive D: ? because i dont have big space on drive c:(hp server) but the drive d: im using on actually is a compellen/storage