Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 362
  • Last Modified:

Multiple oracle home advantages

Experts -

Is there any advantage running multiple oracle homes as far as performance concerns?

We're running around 10 databases using a single 11g oracle home. The database are being moved to Linux. Is it the right time to keep multiple oracle home?

Any advantages other than applying patch/upgrades?

Thanks,
Sve.
0
sventhan
Asked:
sventhan
2 Solutions
 
slightwv (䄆 Netminder) Commented:
Benefits on single HOME off the top of my head:
Single tnsnames.ora?

If you have multiple homes, you need to be concerned about which one gets to own which listener (if you have multiple listeners) or the one listener if you only have one.

Benefits of multiple:
You can upgrade one without having to upgrade ALL.
0
 
johnsoneSenior Oracle DBACommented:
I would only keep one home per version of the Oracle software.  If you patch some but not all, create a new home.  If you upgrade, create a new home.

I don't see any advantage in keeping multiple homes for the same version.

For the listener, we usually only have one.  It runs out of the highest home that is on the machine.
0
 
sventhanAuthor Commented:
Thanks
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now