Starting databases automatically – M.S Windows

By default, Windows services are enabled for starting Oracle databases at boot time. On a standby database server, the Window service would not start the standby database in the correct mode, when the server gets started or rebooted. Also on Oracle >= 12c multitenant databases, the PDBs will not open.

Our partner Dbvisit manages Oracle Standard Edition standby databases using the same principle based on the Windows Task Scheduler:

ℹ️The “database.ps1” script manages Oracle >= 12c pluggable databases as well as Oracle standby databases depending on their role, like for Oracle Data Guard environments.

• Set the Windows services of the database „OracleService<ORACLE_SID>“ to manual

• Ensure the task scheduler service is started

• Open Task Scheduler „taskschd.msc“

• Right click and chose „Create Task…“

• Define your task in the „General“ tab

• Add a trigger to the task

• Add an action to the task