Forum Discussion
- Patrick_RouseProduct Manager
In 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 - Manog1978Neophyte
Hi
I have checked Logicmonitor support team, they said that, as of now there is no datasource available for Oracle Dataguard monitoring
- Patrick_RouseProduct Manager
@Manog1978 this is correct. I’m the Product Manager for the team that creates the official (non-Cloud) LogicModules. - Manog1978Neophyte
@Patrick Rouse : is there any alternate way workaround to achieves like custom SQL Script.Please advise.
- Patrick_RouseProduct Manager
Nothing 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 - Manog1978Neophyte
I have made custom SQl Script and got out put in the datasource. however, when i pull the data , am getting below error
Attribute not valid or not found in output - (method=namevalue, param)
any suggestion,
- Patrick_RouseProduct Manager
Want to share the script?
- Manog1978Neophyte
Here it is
sqlQuery = "select decode(synchronized,'YES',0,1) output from v\$archive_dest_status where type='PHYSICAL'"
- Manog1978Neophyte
in the datapoint i specified the output !=0.
Related Content
- 2 years ago
- 9 months ago
- 4 years ago