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

Home -> Community -> Usenet -> c.d.o.misc -> Re: What is the difference between oradim and startup?

Re: What is the difference between oradim and startup?

From: Peter <peter_at_nomorenewsspammin.ca>
Date: Sat, 19 Apr 2003 18:30:50 GMT
Message-ID: <ce53avcogfvufbncmvo6d72i5o9vvpea9b@4ax.com>


On 19 Apr 2003 08:43:23 -0700, rs_arwar_at_hotmail.com (Rauf Sarwar) wrote:

>Peter <peter_at_nomorenewsspammin.ca> wrote in message news:<ch62av4ag4017imebqfs9llns6ijvk02es_at_4ax.com>...
>> On 18 Apr 2003 22:22:56 -0700, rs_arwar_at_hotmail.com (Rauf Sarwar)
>> wrote:
>>
>> >Peter <peter_at_nomorenewsspammin.ca> wrote in message news:<i101avcbgslcu9ddg1g4lcfcctc8e836ab_at_4ax.com>...
>> >> On 16 Apr 2003 23:06:16 -0700, rs_arwar_at_hotmail.com (Rauf Sarwar)
>> >> wrote:
>> >>
>> >> Your explanation is very clear.
>> >> I have this to ask.
>> >> The OracleServiceSID is the service/process that is needed before you
>> >> can start an Oracle instance. We can have more than one instances
>> >> connected to the same OracleServiceSID?
>> >
>> >No you cannot. All Oracle processes are unique to a particular SID.
>> >Oracle process is started with SID name as a parameter. If you have 5
>> >instances running on your server, you would have 5 Oracle processes.
>> >
>>
>> What if I open up several DOS Windows and then run sqlplus in each one
>> and then run "startup" ? Do I now have many instances connected to the
>> same OracleServiceSID?
>
>
>Yes, if you really try hard enough... like standing on your head and
>spinning for few hours -:)
>

Another situation is when two users connect remotely from sqlplus. Then there will be two instances? Received on Sat Apr 19 2003 - 13:30:50 CDT

Original text of this message

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