Understanding Oracle Database Windows Services
Hello,
I have just installed Oracle Database 12C on Windows and would like to get some clarification about how to handle startup and shutdown. Our Windows Admins like to apply Windows updates once a month which usually requires a reboot and they would like to see the process automated.
I'm currently applying the Windows updates manually using the following process:
net STOP Oracle%ORAHOME%TNSListener
net STOP OracleService%ORASID%
Apply the Windows Updates and then reboot the server. The database is automatically started after the reboot because the above services are set to Startup Type = Automatic and the Instance option is checked to 'Start up the instance when the service is started'. This was set up by the installation.