Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Multiple oracle home advantages

Posted on 2014-09-18
3
340 Views
Last Modified: 2014-09-18
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
Comment
Question by:sventhan
3 Comments
 
LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 250 total points
ID: 40331338
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
 
LVL 34

Accepted Solution

by:
johnsone earned 250 total points
ID: 40331351
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
 
LVL 18

Author Closing Comment

by:sventhan
ID: 40331657
Thanks
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question