Re: What is the difference between oradim and startup?

Norman Dunbar wrote:
> Morning.
>
> Interestingly enough, I discovered yesterday that connecting to SQLPlus
> and typing 'shutdown' on my Win2k system running 9i release 2 EE, only
> shuts down the listener service. Startup then starts the listener
> service. The database service thingy itself has to be manually shutdown
> and started either through services or through oradim. (I have no
> setting for AUTOSTART by the way)
>
> On Unix, the listener stays up, and the database and instance come down.
>
> Big difference !
>
> Cheers,
> Norm.

Norman,

as soon as I read your post, I thought that's just impossible. What has a 'shutdown' in SQL*Plus to do with the listener on a Win2K machine? Lukily, nothing.

I don't know what you actually did and how you draw your conclusions, but shutting down the database should not lead to a listener shutdown.

Just think what would happen if you had 2 Instances on 1 Server...

Oh, and of course I tested it on my test system with the listener whistling a little tune while the database was shutdown. And as expected, only the instance went down, the database service itself keeps up and running.

To shutdown the listener, you have to use 'lsnrctl stop', which effectively stops the listener service. Not so different to unix, then ;-)

(But I hasten to admit that I've almost no experience with oracle on unix, so please bear with me if my last sentence was utterly wrong...)

Cheers,

Holger Received on Thu Apr 17 2003 - 03:05:27 CDT