RE: Manually starting database on Windows

Just to clarify. From the manual:

-STARTMODE [auto | manual] - indicates whether to start the instance when the Oracle Database service is started. Default is manual.

-joe
http://www.peaceaday.com

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org

[mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Sweetser, Joe
> Sent: Tuesday, August 29, 2006 1:16 PM
> To: cemail_219_at_hotmail.com; oracle-l_at_freelists.org
> Subject: RE: Manually starting database on Windows
>
> A few things: The OracleService<SID> exists independently of the
> datafiles. That is, you can have a perfectly valid service running
with
> no database underneath. Taking this a bit further, you can recreate
the
> service of a database without damaging anything as long as the
database
> and service are shutdown. Look at the oradim command. Among other
> things, you can specify the startmode (manual or automatic). Hmmm -
> though that might be of the service itself and not the database. I
> guess *I* should go look it up! :-)
>
> Anyway, once the database is up and running, you can go into sqlplus
as
> sysdba and shut it down. If, for some reason, "connect / as sysdba"
> doesn't work, just connect as sys. Even though the database is
> shutdown, the service will still be running. At this point, you can
> issue the startup pfile=<blah> command. You can also create/recreate
> your spfile at this point...which might be an easier way to go. YMMV.
>
> Note that sysdba access via sqlplus when connected via Remote Desktop
> (RDP) does not work for 8i. You need to be on the console. It's fine
> for 9i/10g.
>
> hthmtic (hope this helps more than it confuses),
> -joe
> http://www.peaceaday.com
>
> > -----Original Message-----
> > From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]
> > On Behalf Of J. Dex
> > Sent: Tuesday, August 29, 2006 12:57 PM
> > To: oracle-l_at_freelists.org
> > Subject: Manually starting database on Windows
> >
> > On Windows 2003, how can you manually connect to the database and
then
> > start
> > a database using a new pfile? I am used to UNIX and just being
able
> to
> > login to sqlplus as sysdba but that doesn't work on Windows. If
> > everything
> > isn't first started via "net start OracleService<SID>", then I am
> getting
> > listener errors when just trying to connect to the database.
> Everything
> > was stopped using net stop OracleService<SID>. This is a situation
> where
> > I
> > don't want the database to come back up again using old parameters.
> >
> > _________________________________________________________________
> > Search from any web page with powerful protection. Get the FREE
> Windows
> > Live
> > Toolbar Today! http://get.live.com/toolbar/overview
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
>
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l