You should be able to confirm this by reviewing you current Service.
oradim -NEW -SID boston -INTPWD password -STARTMODE manual
We are having a problem with active dataguard (real-time query) being enabled after a switchover or a reboot of the standby. We are not licensed for it and have no intention of using it, but we cannot seem to avoid it. Is anyone else having this problem?
Oracle DB 18.104.22.168
Grid Ctrl 22.214.171.124
64 bit windows 2008 R2
This is a "feature"/trap in Windows. ORADIM -STARTMODE AUTO, attempts to open the database. If it's a Data Guard standby, DG broker gets hold of and resets it to OPEN READ ONLY state, which is Real Time Query/Active Data Guard and requires an additional licence.
Oracle should add a new option to ORADIM so database -startmode AUTO can be set to -openmode MOUNT. Otherwise customers might be tempted to think they deliberately left this "defect" in place to try and entrap some customers into paying for a potentially expensive feature - list US$10,000 per CPU - they have not decided to use.
If you set -startmode MANUAL, on Windows 2008 you can setup a scheduler task that's actually triggered on system startup.
The Action can be set to something like:
C:\Windows\System32\cmd /c "sqlplus /@YOURDB as sysdba @c:\scripts\startupmount.sql >>c:\scripts\log\startupMOUNT.log"
Where startupmount.sql does STARTUP MOUNT.