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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
cheers4beersCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
slightwv (䄆 Netminder) Commented:
No split?  Both say: not required.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.