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