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.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center