Solved

Multiple oracle home advantages

Posted on 2014-09-18
3
336 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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to return an OUT parameter from and ORACLE 3 66
Oracle and DateTime math 6 37
1 FROM DUAL wont work with additional columns ?? 4 36
MULTIPLE DATE QUERY 15 76
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
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

785 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