| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> What is the difference between oradim and startup?
Morning Holger,
I know it sounds stupid that 'shutdown' only closes down the listener, but here's what I did :
in Control panel, admin options, services :
Started 'OracleServiceORCL92' manually.
Started 'OracleOraHome92TNSListener' service manually.
Both now have 'started' in the status column.
Sqlplus and connect / as sysdba.
SQL> shutdown
wait for message saying that everything is down.
Back in services applet, press F5 (or Action, Refresh) to refresh - the 'OracleOraHome92TNSListener' is now stopped, the 'OracleServiceORCL92' is still running.
'OracleServiceORCL92' still has 'started' in the status column. 'OracleOraHome92TNSListener' has nothing in the status column - it is no longer running. If I highlight it, I activate the button to start it up again !
Back in SQLPlus, I type startup and wait for 'Database opened' message.
Return to services applet, refresh the view and viola (as French musicians would say) both services now show 'started' in the status column.
I have to agree that the shutdown must be doing more than taking down the listener because the startup takes far longer to open the database than manually starting the listener.
Confused - not half !!
Next test,
in SQLPlus, shutdown the database.
in Services applet, restart the listener manually.
Back in SQLplus, 'select table_name from user_tables' - ORA-01043:
ORACLE not available.
So, it looke like Oracle *is* shutting down correctly, but Windows is not showing the true picture in the Services applet.
>> 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...)
Nothing wrong at all !
Cheers,
Norman.
PS. I don't have the room to build another database on this PC, so I'm unable to test whether the listener is really closed or not ....
Tel: 0113 289 6265 Fax: 0113 289 3146 URL: http://www.Lynx-FS.com -------------------------------------Received on Thu Apr 17 2003 - 04:06:37 CDT
 |
 |