Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: What is the difference between oradim and startup?
"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
![]() |
![]() |