Re: Running multiple instances

From: Alex Hudghton <alex_at_alenda.freeserve.co.uk>
Date: Tue, 3 Aug 1999 14:02:48 +0100
Message-ID: <7o6p9t$7v1$1@taliesin.netcom.net.uk>

The 'oracle is already running' message generally applies to the fact that your ORACLE_SID is not set correctly and you are trying to start the instance that is running. How are you starting the instances ?

Alex

wozi wrote in message ...
>I have over 200MB of RAM. The SGA is pretty small. When one instance is
>running, I try to start the second the instance, the error is that oracle
is
>already running. It tell me to shutdown before I can start another
instance.
>
>Alex Hudghton wrote in message <7o66rc$4nr$1_at_taliesin.netcom.net.uk>...
>>
>>wozi wrote in message
>><519E837776452E26.77351C6E0665D2E4.C3C736C3376BBFAB_at_lp.airnews.net>...
>>>Oracle 8.05 on NT 4.0
>>>
>>>I have installed the started database from Oracle 8.05. I am able to
>>connect
>>>from a client. I have also installed another database instance called
>>PROD.
>>>
>>>I am able to start ONLY one instance at a time and connect to it.
>>>BUT, I want both instances 'ORCL' and 'PROD' running on the same
>>>machine at the same time.
>>>
>>>Any suggestion ?
>>>
>>
>>
>>You need more physical memory or to reduce the size of your SGA's - how
big
>>are they ??
>>
>>Alex
>>
>>
>
>
Received on Tue Aug 03 1999 - 08:02:48 CDT