oracle database installation


i am installing a database for oracle grid control 11R1.

so database which i created will be acts as a repository for grid control.

my question is for the database (not grid control) which acts as a repository.

according to my company standards oracle_home will not come under oracle base

         oracle_base: /ora/oemdev
         oracle_home: /ora/product/11.2.0/dbhome_oem

by doing so is it effect anything on future gridcontrol installations?

thanks in advance.
rcc50886Asked:
Who is Participating?
 
cheers4beersConnect With a Mentor Commented:
Can you give a brief explanation why your company standards don't allow the ORACLE_HOME to be under the ORACLE_BASE?  This is standard for OFA (Oracle Flexible Architecture), but it is NOT required.  So to answer your question, no there should not be any issues, this is just a non-OFA setup.

ORACLE_BASE - ORACLE_BASE is the root of the Oracle Database directory tree. If you install an OFA-compliant database using Oracle Universal Installer defaults, then ORACLE_BASE is X:\oracle\product\10.2.0 where X is any hard drive.

ORACLE_HOME - ORACLE_HOME corresponds to the environment in which Oracle Database products run. This environment includes the location of installed product files, the PATH variable pointing to the binary files of installed products, registry entries, net service names, and program groups.

If you install an OFA-compliant database, using Oracle Universal Installer defaults, then Oracle home (known as ORACLE_HOME in this guide) is located beneath ORACLE_BASE. It contains subdirectories for Oracle Database software executables and network files.


In Oracle 11g, the 11g New Features Guide notes important OFA changes, namely the removal of $ORACLE_HOME as an anchor for diagnostic and alert files:

"The database installation process has been redesigned to be based on the ORACLE_BASE environment variable. Until now, setting this variable has been optional and the only required variable has been ORACLE_HOME.

With this feature, ORACLE_BASE is the only required input, and the ORACLE_HOME setting will be derived from ORACLE_BASE."

============
 text sourced from  http://ozwenolivercoelho.wordpress.com/category/oracle-dba-helpful-notes/

0
 
slightwv (䄆 Netminder) Commented:
What database is used as the repository really doesn't matter.  The environment variables really don't matter.  As long as things are pointing to where they need to, you'll be fine.
0
 
slightwv (䄆 Netminder) Commented:
No split?  Both say: not required.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.