Re: oracle on startup

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Thu, 06 Nov 2003 10:38:23 +0100
Message-ID: <3FAA168F.4010001@science-computing.de>

Howard J. Rogers wrote:
> "Holger Baer" <holger.baer_at_science-computing.de> wrote in message
[snip]

>>
>>This is the setup that I use at home, because I don't want the
>>instance to startup all the time (there are times I use a computer and
>>Oracle ain't involved ;-) ) but I love to fire up sql*plus, realise that
>>the instance is not started yet and then connect / as sysdba; startup
>>is my friend....

>
>
> Quite right, and my mistake. I still think, however, that the service to
> manual and then creating a simple batch file to do a "net start" when
> required is the easiest way to go. I have that as a shortcut on my Windows
> desktops, and it works fine. I don't see that it's any Less 'like setting
> 'N' in /etc/oratab' than the alternative.
>
> Regards
> HJR
>

I think the difference is solely that since most of the time i connect as sysdba and then I get 'connected to an idle instance' instead of one out of ORA-12560 , ORA-1034/ORA-27101.

Isn't it nice to have two ways to achieve the same? ;-)

Cheers
Holger Received on Thu Nov 06 2003 - 03:38:23 CST