Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h78Cser22138 for ; Fri, 8 Aug 2003 07:54:40 -0500 X-ClientAddr: 66.27.56.210 Received: from ns3.fatcity.com (rrcs-west-66-27-56-210.biz.rr.com [66.27.56.210]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h78Csap22129 for ; Fri, 8 Aug 2003 07:54:37 -0500 Received: from ns3.fatcity.com (localhost.localdomain [127.0.0.1]) by ns3.fatcity.com (8.12.5/8.12.5) with ESMTP id h78AUOfk016275 for ; Fri, 8 Aug 2003 03:31:16 -0700 Received: (from root@localhost) by ns3.fatcity.com (8.12.5/8.12.5/Submit) id h78APSKS014722 for oracle-l@orafaq.net; Fri, 8 Aug 2003 03:25:29 -0700 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005C9A18; Fri, 08 Aug 2003 03:19:23 -0800 Message-ID: Date: Fri, 08 Aug 2003 03:19:23 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Adams, Matthew (GECP, MABG, 088130)" Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Adams, Matthew (GECP, MABG, 088130)" Subject: RE: 100 instances on same server !!! Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 73; ListGuru (c) 1996-2003 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPartTM-000-5727afa0-f04b-4ab7-8c9e-dd9303df043e" ------=_NextPartTM-000-5727afa0-f04b-4ab7-8c9e-dd9303df043e Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C35D96.E5AB3A6C" ------_=_NextPart_001_01C35D96.E5AB3A6C Content-Type: text/plain; charset="iso-8859-1" Right now I have 37 instances on an hp-ux server, a mix of 8.1.7.4 and 9.2.0.3 ---- Matt Adams - GE Appliances - matt.adams@appl.ge.com We are pentium of Intel. Division is futile. You will be approximated. -----Original Message----- Sent: Thursday, August 07, 2003 6:54 PM To: Multiple recipients of list ORACLE-L Thanks for the replies so far. Considering the fact that my database is tiny ( just around 3 GB ), How many of them can work on same server? I can just test with 5 instances, with limited hardware. Will the CPUs be able to take load of 100 instances? Is it worth experimenting this? I am on 8.1.7.4 and the application is already built. I stand no chance of changing the code. That is why using individual schemas for individual users is not an option. Right now I am just asked if 100 instances can run on same server and I don't have solid answer. Just on side note, can I ask, What is the maximum number of instances anyone has ever worked/heard being installed with in same server? Thanks again. Dilip. ----- Original Message ----- To: Multiple recipients of list ORACLE-L Sent: Thursday, August 07, 2003 11:54 AM 100 instances wohhhhh . If you are in 9i look at possibilities like context or label security . or creating another schema . -ak ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" < ORACLE-L@fatcity.com > Sent: Wednesday, August 06, 2003 9:24 PM > I have not heard installing hundred database instances on same server. > Maybe you should think creating one instance, and then hundred schemas in > it. > > Guang > > On Wed, 6 Aug 2003, Dilip Patel wrote: > > > Hi All, > > Need some suggestions/Input. > > > > My application database is 8.1.7, NOARCHIVELOG, WIN200, > > total size 4 GB, more of single user OLTP client-server application. > > > > Now the customer wants to give training on this application to hundred trainees > > at a time. For this he wants to install hundred database instances on same > > server machine, which *each* will be accessed simultaneously from 100 different > > client workstations. > > > > The reasons for installing all instances on same machine are > > - to avoid re-installing databases on 100 workstations after each round of > > training. > > - No user should see any other user's data. > > > > Please suggest if this approach is feasible or is it at all possible. Tested this with upto 5 instances, and > > it seems to work. The customer is willing to upgrade to any hardware needed for > > this setup. > > > > Thanks in advance for your time. > > > > Dilip. > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Guang Mei > INET: gmei@incyte.com > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: AK INET: oramagic@hotmail.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ------_=_NextPart_001_01C35D96.E5AB3A6C Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Right now I have 37 instances on = an hp-ux=20 server,
a mix of 8.1.7.4 and = 9.2.0.3
 

----
Matt Adams - GE Appliances - matt.adams@appl.ge.com
We = are pentium=20 of Intel. Division is futile.
You will be approximated.

 
-----Original=20 Message-----
From: Dilip Patel=20 [mailto:patel_dil@msn.com]
Sent: Thursday, August 07, 2003 = 6:54=20 PM
To: Multiple recipients of list = ORACLE-L
Subject: Re: 100=20 instances on same server !!!

Thanks for the replies so far. Considering the fact that my = database is=20 tiny ( just around 3 GB ), How many of them can work on same server? I = can just=20 test with 5 instances, with limited hardware. Will the CPUs be able to = take load=20 of 100 instances? Is it worth experimenting this?
 
I am on 8.1.7.4 and the application is already built. I stand no = chance of=20 changing the code. That is why using individual schemas for individual = users is=20 not an option. Right now I am just asked if 100 instances can run on = same server=20 and I don’t have solid answer.
 
Just on side note, can I ask, What is the maximum number of = instances=20 anyone has ever worked/heard being installed with in same server? =
 
Thanks again.
 
Dilip.
----- Original Message -----
From: AK
To: Multiple recipients of list = ORACLE-L=20
Sent: Thursday, August 07, = 2003 11:54=20 AM
Subject: Re: What books = recommended for=20 Data Modeling ?

100 instances wohhhhh .  If you are in 9i look at = possibilities like context
or label security . or creating another = schema=20 .

-ak



----- Original Message -----
To: = "Multiple=20 recipients of list ORACLE-L" <ORACLE-L@fatcity.com>
Sen= t:=20 Wednesday, August 06, 2003 9:24 PM


> I have not heard = installing=20 hundred database instances on same server.
> Maybe you should = think=20 creating one instance, and then hundred schemas in
> = it.
>
>=20 Guang
>
> On Wed, 6 Aug 2003, Dilip Patel = wrote:
>
>=20 > Hi All,
> > Need some suggestions/Input.
> = >
>=20 > My application database is 8.1.7, NOARCHIVELOG, WIN200,
> = >=20 total size 4 GB, more of single user OLTP client-server = application.
>=20 >
> > Now the customer wants to give training on this = application=20 to hundred
trainees
> > at a time. For this he wants to = install=20 hundred database instances on
same
> > server = machine,  which=20 *each* will be accessed simultaneously from 100
different
> = >=20 client workstations.
> >
> > The reasons for = installing all=20 instances on same machine are
> > - to avoid re-installing = databases=20 on 100 workstations after each round
of
> > = training.
> >=20 - No user should see any other user's data.
> >
> > = Please=20 suggest if this approach is feasible or is it at all = possible.
Tested this=20 with upto 5 instances, and
> > it seems to work. The = customer is=20 willing to upgrade to any hardware
needed for
> > this=20 setup.
> >
> > Thanks in advance for your = time.
>=20 >
> > Dilip.
> >
>
> --
> = Please see=20 the official ORACLE-L FAQ: http://www.orafaq.net
> -- =
>=20 Author: Guang Mei
>   INET: gmei@incyte.com
>
> = Fat City=20 Network Services    -- 858-538-5051 http://www.fatcity.com
> = San Diego,=20 California        -- Mailing list = and web=20 hosting services
>=20 = --------------------------------------------------------------------->=20 To REMOVE yourself from this mailing list, send an E-Mail = message
> to:=20 ListGuru@fatcity.com = (note EXACT=20 spelling of 'ListGuru') and in
> the message BODY, include a = line=20 containing: UNSUB ORACLE-L
> (or the name of mailing list you = want to be=20 removed from).  You may
> also send the HELP command for = other=20 information (like subscribing).
>
--
Please see the = official=20 ORACLE-L FAQ: http://www.orafaq.net
--=20
Author: AK
  INET: oramagic@hotmail.com

Fat= City=20 Network Services    -- 858-538-5051 http://www.fatcity.com
San = Diego,=20 California        -- Mailing list = and web=20 hosting=20 = services
------------------------------------------------------------= ---------
To=20 REMOVE yourself from this mailing list, send an E-Mail message
to: = ListGuru@fatcity.com (note = EXACT=20 spelling of 'ListGuru') and in
the message BODY, include a line = containing:=20 UNSUB ORACLE-L
(or the name of mailing list you want to be removed = from).  You may
also send the HELP command for other = information (like=20 subscribing).
------_=_NextPart_001_01C35D96.E5AB3A6C-- ------=_NextPartTM-000-5727afa0-f04b-4ab7-8c9e-dd9303df043e-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Adams, Matthew (GECP, MABG, 088130) INET: MATT.ADAMS@APPL.GE.COM Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).