Re: Manually starting up oracle service on windows

From: Randy Harris <randy_at_SpamFree.com>
Date: Thu, 20 Oct 2005 04:53:30 GMT
Message-ID: <epF5f.341$jV2.24@newssvr17.news.prodigy.com>

"anish" <anish.kanti.ghosh_at_gmail.com> wrote in message news:1129782715.489683.84570_at_g44g2000cwa.googlegroups.com...
> I am trying to startup the oracle service in windows manully .Is that
> possible using 'sqlplus /nolog' by connecting as 'conn / as sysdba' and
> issuing the 'startup' command.When i am trying to do that system is
> unable to detect the listener for the service.Is there any way for
> starting an oracle service manually from command prompt in windows.
>

sqlplus can't start the service. You can do it from the command prompt with:

C:\> net start OracleServiceMySID

You can start the listener the same way.

C:\> net start OracleOraHomeTNSListener

Substitute, of course, your service names.

HTH,
Randy Received on Wed Oct 19 2005 - 23:53:30 CDT