Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Two instances?
fitzjarrell_at_cox.net wrote:
>
> Randy Harris wrote:
>
>>"David & Sarah Grove" <dg_at_ieee.org> wrote in message >>news:11aqgnp7s38v0df_at_corp.supernews.com... >> >>>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 >>>both. Memory (16 GB) is more than enough for both. There are no common >>>users. There are no common applications. There are no common schemas. >>>There will be separate administration with possibly separate DBAs. Each >>>party will have several schemas (total of 10 - 20 schemas). Three of one >>>party's schemas each have in excess of 1000 tables and 1000 stored >>>procedures. >>> >>>We are considering whether to just put both parties schemas together in a >>>single instance, or, perhaps, make two instances. >>> >>>Might I be able to determine from vmstat whether there is sufficient >>>"headroom" in cpu usage for a second instance? In other words, if I get >> >>one >> >>>of the parties set up, can I use vmstat to determine whether, assuming >>>everything else is adequate, there is enough horsepower to bring the >> >>second >> >>>party in as a second instance? >>> >>>Thanks for any thoughts. >>> >>>DG >>> >> >>IMO, the most significant statement you've made is "There will be separate >>administration with possibly separate DBAs". Potential for differing >>performance management, differing backup/recovery management, possibly >>differing patch/upgrade needs. I'd use separate instances.
Actually David there is no requirement that multiple installations of the Oracle binaries be installed with the userid Oracle or that any of them are installed as Oracle. Nor is there a requirement that the users belong to groups named OINSTALL and DBA.
One possible workaround would be something like this:
But I don't like it and before I'd touch it I'd want the attorney's, not the CIO's, of both companies to sign off on it along with their auditors.
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Mon Jun 13 2005 - 11:19:55 CDT