Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews2.google.com!not-for-mail
From: sybrandb@yahoo.com
Newsgroups: comp.databases.oracle.server
Subject: Re: Windows ORADIM -startup -sid .... command
Date: 9 Sep 2004 04:00:00 -0700
Organization: http://groups.google.com
Lines: 28
Message-ID: <a1d154f4.0409090300.52092629@posting.google.com>
References: <RAS%c.1855$6b4.54168@twister1.libero.it>
NNTP-Posting-Host: 145.13.42.4
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1094727601 10382 127.0.0.1 (9 Sep 2004 11:00:01 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 9 Sep 2004 11:00:01 +0000 (UTC)
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:224569

"Luca Li Greci" <luca.ligreci@libero.it> wrote in message news:<RAS%c.1855$6b4.54168@twister1.libero.it>...
> Hi all,
> 
> I'm a beginner DBA, my experience is limited to windows environmet.
> 
> My doubt and question are on ORADIM command and the windows service
> Oracle<ORACLE_HOME><SID>. ????
> 
> In windows environment why have to check if this service is started before
> type in sql*plus the startup  command ??
> 
> Isn't startup command (in sql*plus) that allocate memory structure (SGA+PGA)
> and startup background processes (DBWn + LGWR + CKPT .....) ?
> 
> 
> Thanks for your comments,
> Luca


In Windows you need to start the Oracle service before you can
actually startup the database. The background 'processes' are
implemented as threads within the Oracle service. Without the service
you can't do anything.
Just to make life easier the -startup switch on the oradim command
automagically starts up the database for you.

Sybrand Bakker
Senior Oracle DBA