Oracle Data Guard Real-Time Query - How to Disable

Real-Time Query (RTQ) is an extra cost option for Oracle Data Guard. And it's turned on by fucking default. It's easy to accidentally use it.

Anyway, disable that shit by using the following:

1. Change the following system parameter:

alter system set "_query_on_physical"=false scope=spfile;

shutdown immediate;
startup mount;

This works in 11.2.0.4.18.

2. Stop Managed Recovery BEFORE opening the fucking standby database.

Also, your COMPATIBLE parameter has to be at least 11.0.

http://docs.oracle.com/cd/E11882_01/server.112/e41134/manage_ps.htm#SBYDB00707

"The COMPATIBLE database initialization parameter must be set to 11.0 or higher to use the real-time query feature of the Oracle Active Data Guard option."

Haha! I LOLLED hard when I read that. See, on a standby database I had stopped the DG broker, restarted the database (so real-time apply was not used) and opened the db read-only. Now OEMGC keeps ticked the option "Real-Time Query" on the Data Guard Status page even though it's disabled! Nothing I do can remove that fucking green tick.

I mean, FFS, can't I just use the fucking database without wasting fucking time on licensing shit?

Well, thank God I kept the COMPATIBLE parameter to 10.2.0.3.

I checked dba_feature_usage_statistics, and it confirmed that in no fucking way did I use that shit.

Force refresh of dba_feature_usage_statistics

connect / as sysdba
alter session set "_SWRF_TEST_ACTION"=53;
alter session set NLS_DATE_FORMAT='DD/MM/YYYY HH24:MI:SS';
select MAX(LAST_SAMPLE_DATE) from dba_feature_usage_statistics;

The plug-in configuration for the oracle.sysman.oh monitoring plug-in may have failed

If you're having trouble installing the OEMGC Agent on Windows, and receiving that error despite having the file 12.1.0.3.0_PluginsOneoffs_233.zip present in the agent installation folder, then create the following batch file and run it:

runme.bat:

set PERL5LIB=
set ORACLE_HOME=
set path=%CD%;%WINDIR%;%WINDIR%\SYSTEM32
set ORATMP=c:\TMP
MKDIR %ORATMP%
SET TMP=%ORATMP%
SET TEMP=%ORATMP%
DEL %ORATMP%\*.* /Q
sc delete Oracleagent12c1Agent

call agentDeploy.bat AGENT_BASE_DIR=c:\oemgc\agent12c RESPONSE_FILE=%CD%\agent.rsp
pause


Comments: This batch file is attempting to pre-empt a whole bunch of pitfalls.Unset PERL5LIB, unset ORACLE_HOME, clean up the PATH, create a clean TMP directory, delete any service from a previous installation attempt.