Re: What is the difference between oradim and startup?

From: Stephan Bressler <stephan.bressler_at_siemens.com>
Date: Thu, 17 Apr 2003 07:21:30 +0200
Message-ID: <b7ldi0$496$1@news.mch.sbs.de>

"Peter" <peter_at_nomorenewsspammin.ca> wrote in message news:t2lr9v4p2un6d5eu3lkp8ercg3pg2ou3tp_at_4ax.com...
> What is the difference between
>
> oradim -NEW -SID
>
> and
> (from within sqlplus)
> startup nomount pfile=.....
>
>
> With oradim, you start an Oracle service, but is an Oracle service the
> same as an Oracle instance (with SGA, background processes) ?
>
> Does "startup" start an oracle instance or an oracle service?
>
>

Hi,
oradim creates a service. It is used only once in the lifetime of a oracle database (unless you use it to change service parameters like startup mode, etc).
Once a service is created and started, you can use "startup" to start the instance. So, the service may run while the instance is down. But starting the instance (in fact, even starting svrmgrl sucessfully) requires the service running.

Your statement "With oradim, you start an Oracle service" is wrong.

Regards
Stephan Received on Thu Apr 17 2003 - 00:21:30 CDT