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 - 10:19:59 CST
