Database Counter Monitor Showing 'n/a

Hi Expert,

 

I am Using Sitescope 11.24 on linux platform

 

I have added database counter monitor for monitoring Oracle Database.

 

Pre-requisite for monitoring Oracle database is already configured.

 

DB URL :- jdbc:oracle:thin:@hostname:1521:instance

Query :- select * from v$instance

Database drivers:- oracle.jdbc.drivers.OracleDriver

 

Now, 

 I am getting all the counter result as 'na'

 

but while check from Use tools all the data populates successfully.

 

I have tried apply monitor it is also not helpful......please suggest

 

 

 

 

 

Parents
  • Can you post the result of your query? The format needed is the following:

     

     

                       Counter1   Counter2

    Label1      Value1       Value1

    Label2      Value2       Value2

    Label3      Value3       Value3

     

     

    Also make sure the checkboxes No cummulative and No divide counters are checked.

Reply
  • Can you post the result of your query? The format needed is the following:

     

     

                       Counter1   Counter2

    Label1      Value1       Value1

    Label2      Value2       Value2

    Label3      Value3       Value3

     

     

    Also make sure the checkboxes No cummulative and No divide counters are checked.

Children
  • Verified Answer

    Hi Kenneth,

     

    Thanks alot for your reply.....

     

    Issue got resolved.

     

    Actually I have written the query and after clicking on get counter I am getting the data which is selected in query...but I am making selection in that populated counters ,thats why the query is getting failed.

     

    After checking the no cumulative counters and no divide counters now I am able to get the data.....

     

    I have set the threshold also......

     

    Thanks......for all ur support

     

    Regards

     

    Prasanna