Question

Groovy script for Oracle Datagurd status

  • 13 November 2023
  • 9 replies
  • 34 views

Userlevel 1
Badge +2

Is there any sample Groovy script for Oracle Datagurd status. please advise.


9 replies

Userlevel 7
Badge +8

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

Userlevel 1
Badge +2

Hi

 

I have checked Logicmonitor support team, they said that, as of now there is no datasource available for Oracle Dataguard monitoring

 

Userlevel 7
Badge +8

@Manog1978 this is correct.  I’m the Product Manager for the team that creates the official (non-Cloud) LogicModules.

Userlevel 1
Badge +2

@Patrick Rouse  : is there any alternate way workaround to achieves like custom SQL Script.

Please advise.

Userlevel 7
Badge +8

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

Userlevel 1
Badge +2

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,

Userlevel 7
Badge +8

Want to share the script?

Userlevel 1
Badge +2

Here it is

sqlQuery = "select decode(synchronized,'YES',0,1) output from v\$archive_dest_status where type='PHYSICAL'"

Userlevel 1
Badge +2

in the datapoint i specified the output !=0.

Reply