Groovy script for Oracle Datagurd status
Is there any sample Groovy script for Oracle Datagurd status. please advise.
Manog1978
Posted 2 years ago·Last reply 2 years ago
9 comments
Is there any sample Groovy script for Oracle Datagurd status. please advise.
Manog1978
OP2 years agoin the datapoint i specified the output !=0.
Manog1978
OP2 years agoHere it is
sqlQuery = "select decode(synchronized,'YES',0,1) output from v\$archive_dest_status where type='PHYSICAL'"
Patrick Rouse
·2 years agoWant to share the script?
Manog1978
OP2 years agoI have made custom SQl Script and got out put in the datasource. however, when i pull the data , am getting below error
any suggestion,
Patrick Rouse
·2 years agoNothing we’re currently aware of. This is what we tried, but it required elevated Oracle permissions which we will not use.
https://forums.oracle.com/ords/apexds/post/check-status-of-sync-to-standby-7435
Manog1978
OP2 years ago@Patrick Rouse : is there any alternate way workaround to achieves like custom SQL Script.
Please advise.
Patrick Rouse
·2 years ago@Manog1978 this is correct. I’m the Product Manager for the team that creates the official (non-Cloud) LogicModules.
Manog1978
OP2 years agoHi
I have checked Logicmonitor support team, they said that, as of now there is no datasource available for Oracle Dataguard monitoring
Patrick Rouse
·2 years agoIn our initial research, the first method we tried (at a customer’s request) required elevated privileges, so we chose not to implement it. However, if you’re aware of a non-privileged method please send me a DM.
Thanks