Win2k Oracle9i Startup\Shutdown Actions

[Michael42]

Hello,

I recently installed Oracle 9i on a Windows 2000 system. Is this version of Oracle smart enough to deal with system boots (startup\shutdown)?

Other than the services; I guess I am asking if I need to do anything special to ensure my Oracle DB starts upon boot and does a shutdonw when the system being shutdown.

Any feedback or examples on how you handle this would be greatly appreciated.

Thanks!

 

[AOLEURO]

Hi

Then Windows startup, Oracle services starts and also your listener - so Oralce is running after boot.

Then Windows shutdown Oracle services makes a "shutdown abort". Next time Oracle starts, it makes a instance recovery from redo log files.

However Oracle 9i is changed from Oracle 8i, so recovery operation after a abort is very fast. - In some cases it is faster to do a abort and restart than a "shutdown immediate|normal".

If you want to make a Oracle shutdown before windows shutdown you need to make a "shutdown immediate" command.

NB: It is important to understand, if you want to do some important changes in the instance ex. Oralce updates|migration, then you need to make a "shutdown normal", because none recovery must exists during upgrade|migration. I always make a "shutdown immediate", "startup" and then a "shutdown normal" so Oralce is clean and no recovery is needed on datafiles.

Regards
Allan
Icq: 346225948
! If you can't prove it - don't bother try to teach me !

 

[Michael42]

AOLEURO,

Thanks for the very detailed reply. That was very helpful.

How do you make Oracle do a shutdown immediate when Win2k shuts down?

Thanks again,

Michael42

 

[Turkbear]

Hi,
You need to do it manually (when connected as SYSDBA)..
Then restart the Windows box..

 

[Turkbear]

Hi again,
A little quick on the 'submit' button..
After shutting down the DB manually, you can then shutdown and/or restart the Windows box...

afaik,
The 'automatic' shutdown ( when Windows shuts down) will always be a 'shutdown abort' since it cannot 'wait' to hear from Oracle that is is shutdown...

 

[AOLEURO]

Hi Michael42

I do not think it is possible to make an auto shutdown immediate then Windows closes, because if you just close oracle services then Oracle makes a shutdown immediate – and Oracle makes an abort then Windows is closed.

I also like it this way of the following reasons:

1. I always have a DBA menu on Server Console Desktop where I got (Stop databases with password protection, start databases, dump database structure (exp full=yes rows=no), and so on).

2. I always beg on my knees that IT personal NEVER reboot the Oracle Windows Server “because something strange happens” – call DBA to see the reasons – at least read the ALERT.LOG and use the menu items before reboot.

3. Before a Windows shutdown always run menu item Stop databases with password protection. Because Oracle flush buffers and close files in a consistent state.

4. If Oracle “hangs” or something other strange thinks happened, then I want to make a Windows Shutdown (Oracle abort) because I want Windows to flush buffers. I do not like Windows to hang because Oracle hangs.

So I never want Windows to make an Oracle shutdown process then Windows closes – I have already tried to close Oracle from menu on Console Desktop.

Regards
Allan
Icq: 346225948
! If you can't prove it - don't bother try to teach me !

 

[Michael42]

AOLEURO,

Thanks very much - great advice!

Sounds like you have learned by pain in some instances.