768MB is plenty memory. I have 8 databases running with that amount without
problem.
I've seen on W2K with 8.1.7.0.0 Oracle using 400MB of physical memory when
the shared_pool_size = 120M. After adjusting it down to 80M, Oracle would
use 120M of physical memory.
--
Terry Dykstra
Canadian Forest Oil Ltd.
"Jim Kennedy" <kennedy-family_at_home.com> wrote in message
news:PA9L7.57384$XJ4.34589968_at_news1.sttln1.wa.home.com...
> You don't have enough memory. Either increase your ram or decrease the
> amount of ram Oracle is using (init.ora parameters see documentation).
You
> might consider using different schemas instead of running multiple
instances
> (databases). That will probably accomplish what you want and not use a
lot
> of disk space and ram.
> Jim
> "Chris Stephens" <nospamchris-s_at_mailcity.com> wrote in message
> news:3bfd1fa1$0$8510$ed9e5944_at_reading.news.pipex.net...
> > Hi,
> >
> > I am trying to setup multiple databases to be served from a single
Windows
> > NT workstation using Oracl 8.1.7. I can create a new database, using the
> > 'Oracle Database Configuration Assistant' as a typical database, nothing
> > fancy. After this has been created, I then create the empty tables
within
> > the database. All this is fine.
> >
> > The problem starts when I try to create additional databases, firstly I
> have
> > to stop the first database from running as the creation process aborts
> with
> > an insufficient memory error. The pc has 768MB of ram, plenty of disk
> space
> > and very little else installed. Stopping the first database allows the
> > second to be created, but on completion of this, I cannot re-start the
> first
> > database. I am using the 'DBA Studio' to stop and start the databases,
no
> > error is displayed, the startup process displays a dialog window listing
> the
> > three stages of startup, and it stops at the first stage which is
> 'Starting
> > up the database' with an exclamation mark over the animation.
> >
> > Trying a test connection in the "Net8 Assistant" gives an error message
> > 'ORA-01034 Oracle not available', which I assume means that the server
is
> > not running.
> >
> > Both databases have different global database names and sid's.
> >
> > Can anyone suggest where I should start to look?
> >
> > Thanks,
> >
> >
> > Chris Stephens
> >
> >
> >
>
>
Received on Thu Nov 22 2001 - 13:19:54 CST
