Oracle Restart - Is it really worth all the effort to implement it for automating database and liste
I have been testing Oracle Restart to replace the old dbora scripts we've used in the past to stop and start our databases and listeners when the server is rebooted. Since we do not use ASM or Data Guard, I'm not sure how to weigh the benefits vs the costs of maintenance of this product.
O/S patching is becoming such a re-occurring event for us, that having the auto shutdown would be a big advantage. Adding databases and listeners would not require changing the shutdown script, which is also a plus.
On the negative side, Oracle Restart adds a layer of complexity (especially the PSU patching) and the fact that the dbconsoles are not a component and must be shutdown separately.