Re: Avoiding oracle automatic startup

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 15 Jan 2003 09:21:29 -0000
Message-ID: <3e25281a$0$235$ed9e5944@reading.news.pipex.net>

"Anna" <mail_at_pallina.ch> wrote in message news:b02cc4$13ou$1_at_news.imp.ch...
> Thanks Ted!
>
> In order to start it then, do I just open SQL Plus and this automatically
> starts everything I need, or do I need to do something else?

I'd write two command shell scripts.

StartOracle.cmd

---

net start oracleservice<sidname>
net start oracle<orahomename>TNSListener

and

StopOracle.cmd

---

net stop oracle<orahomename>TNSListener
net stop oracleservice<sidname>

I.E starting and stopping the listener and database services. If you don't use a tnsnames alias then the listener service is entirely optional.

Then just double click the appropriate file before running sqlplus.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************

Received on Wed Jan 15 2003 - 03:21:29 CST