Re: What is the difference between oradim and startup?

On Sat, 19 Apr 2003 18:30:50 GMT, Peter <peter_at_nomorenewsspammin.ca> wrote:

>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?
>
>
>

No. The Oracle service serving the instance will just spawn 2 new threads on the server to communicate with the clients. Time to read the Oracle Concepts Manual I guess, or the Winblows getting started manual.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Apr 19 2003 - 16:43:58 CDT