Re: Two instances?

On Mon, 13 Jun 2005 00:30:41 -0800, David & Sarah Grove interested us by writing:

> Folks,
>
> Consider a single machine (Sun V480/Solaris 10) running Oracle 10g. Two
> parties are interested in cooperating (one brings the machine, the other
> brings the Oracle license). Disk space (>500 GB) is more than enough for

At some point, the organizations are going to have common, or at least coordinated, administration. That will be required for the OS and for the disks, so why not for the databases? Same security issues as any other files.

The idea that the database contains sensitive stuff that can be separated only at the DB is ludicrous as any semi-competent sys admin will be able to open the database files and look at the data for all databases. It's really not that hard to unscramble the internal format.

It's all about acceptable risk. And that should keep a few lawyers happy for a while.

Paying for common DBA should start the discussions towards a single instance and resource manager. Otherwise two instances, two OS userids owning the two instances,

Better idea .... talk to Oracle about their hosting service. Get some ideas from that as they have been in that arena for a while.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***