hi,

Depending on your OS : Unix / Windows.

On Windows You will have no choice to install once Oracle and create 2
database.

But on Unix it depends of your need.

Personnaly, I prefer use 2 Oracle user, install twice Oracle, have 2
listeners, ...

Main advantages :
- if you want to upgrade one database (patch, ...) you can only do
it on 1 instance and leave the other instance alive.

But if it is only development instance, I generally don't care.

regs,

Olivier

"KatrinaH" <kcheathcote@nospam.yahoo.com> wrote in message news:<430b2c05d973eb94debdb1ffa9465318@localhost.t alkaboutdatabases.com>...
> I need to set up 2 databases on one host. What is the best way to do this?