Re: installing multiple databases on one host

From: Hans Forbrich <news.hans_at_telus.net>
Date: Thu, 30 Sep 2004 12:17:50 GMT
Message-ID: <OPS6d.2705$eq.223@edtnps84>

Remigiusz Boguszewicz wrote:

> Hi,
>
> I am standing right now before a task to install many databases on one
> host. I know this is waste of resources and that all shoul be put to one
> instance and managed with different schemas - but please just leave the
> discussion asaid.
>

Binaries = ORACLE_HOME ...

I look at an ORACLE_HOME as being the unit of software patching & upgrading maintenance.

If your instances need to be patched and upgraded separately, (different test cycles, different service agreements, different user community demands) then use separate Oracle Homes.

If you need to be able to hold an instance back on an old release (eg: vendor application) - separate ORACLE_HOME

The big advantage to separate INVENTORY is that a test environment can be totaly blown away in one 'rm -r'. Otherwise removal deletes the inventory items - one at a time. But - since the inventory is MY database, I'd prefer to have one, not many.

/Hans Received on Thu Sep 30 2004 - 07:17:50 CDT