Problem solve Get help with specific problems with your technologies, process and projects.

Installing multiple Oracle homes

An Oracle user asks what to consider when installing multiple Oracle homes.

While installing multiple Oracle homes, is it better to have a single owner for all the homes or different owners for each?

What other things should be considered while creating multiple homes?
I have always used a single user to own all Oracle software. This just makes my life easier. But there is nothing to stop you from using one user for each home. The security experts might tell you this is a more secure system. But from a management perspective, I have always made my life easier by having one user own all Oracle software on the server.

For the most part, as long as you keep each Oracle piece of software and each version in their own home directory, you really don't have to think about this too much. The only time I really give this any concern is when dealing with the Oracle Universal Installer and patching. The OUI keeps an inventory of all software that user has installed. Applying Oracle patches uses the OUI. If you always use the OUI to install software and patches, then the OUI will keep the inventory up to date. But if you do not use the OUI, there is no method of updating the inventory which can cause problems with future OUI operations. So always use the OUI for patches and installs.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.