Compare server Oracle 11.1.0.6 to 11.2.0.2 do not support SELECT with a parallel hint. Set the SP_DEQ_PARALLELISM parameter to 0 for those Oracle versions (4300296)

The following warning messages are observed when running a compare:

sp_ctrl> show log reverse

Info     2016-12-09 12:09:58.737561 16219 1 Compare server exited normally, pad = 17211  [sp_desvr]

Warning  2016-12-09 12:09:32.781480 17211 1 Compare server: Oracle 11.1.0.6 to 11.2.0.2 do not support SELECT with a parallel hint. Set the SP_DEQ_PARALLELISM parameter to 0 for those Oracle versions  [sp_desvr] [module deq]

Info     2016-12-09 12:09:32.523961 17211 1 Compare server completed

The  parallelism is not supported for Oracle versions 11.1.0.6 thru 11.2.0.2.

The Oracle versions 11.1.0.6 to 11.2.0.2 does not support the use of parallelism in compare/repair by way of setting the parameter SP_DEQ_PARALLELISM or using the option PARALLELISM in compare/repair commands.

You can set the following parameter on sp_ctrl on source and target:

sp_ctrl>set param SP_DEQ_PARALLELISM 0

You can then run another compare/repair.