Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Two instances?

Re: Two instances?

From: Randy Harris <randy_at_SpamFree.com>
Date: Mon, 13 Jun 2005 18:11:47 GMT
Message-ID: <D%jre.836$G55.710@newssvr33.news.prodigy.com>

<fitzjarrell_at_cox.net> wrote in message
news:1118678289.797705.45380_at_o13g2000cwo.googlegroups.com...
>
>
> 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.
>
> On a single server, with a single software user, you are advocating TWO
> INSTANCES? I think not. Each DBA will have access to the 'oracle'
> user account, meaning they will have access to each other's instances.
> This sends security sailing straight out the proverbial window. And,
> with ONE software installation how can TWO DBA's implement differing
> software patch/update strategies? Patches applied to the software
> apply to BOTH instances. Arguments may ensue over WHICH patches are
> relevant, but, in the end, the patches applied affect ALL instances
> running on that server. So, patch management differences don't really
> matter.
>
> I can agree differences in performance management may arise due to
> multiple DBAs on a single server. The issue is not with differing
> ideas on performance between the two instances, the issue here is one
> of licencing and security. Only the person or enterprise holding the
> Oracle licence can legally operate an instance for production purposes;
> as stated in the original post only ONE of the two parties legally
> possesses a valid Oracle licence. Also, as I've proven in another
> thread where two instances were created in the hope of data security,
> neither instance is secure and violates Sarbanes-Oxley and HIPAA if
> you're in the United States. Also, there is the liability issue, as
> stated by Daniel Morgan, should either DBA damage data or any
> functionality inherent in a database instance for which he/she is not
> responsible. Truly, two instances on the same server is folly, and I
> can't understand how anyone could possibly recommend such an 'option'
> with a straight face. Such a recommendation is a certain recipe for
> disaster.
>
>
> David Fitzjarrell

Why have you assumed a single software user and a single software installation? I had thought that suggesting differing patch/upgrade requirements would automatically imply more than one Oracle Home and that no further explanation would be needed. Received on Mon Jun 13 2005 - 13:11:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US