DX Unified Infrastructure Management

 View Only
  • 1.  Probe oracle solo despliega información de DB_ALIVE sobre una instancia en el servidor

    Posted Oct 15, 2019 12:27 PM
    Edited by oscar mendoza Oct 16, 2019 09:54 AM
    Hi team.
    we have an issue with the oracle probe, we have several instances on one server.
    On IM on the status tab,  show the instances on green and show metrics, but on  SLM dont show any metrics for db_alive or any other, are metrics only for the first instance. .

    is this  the normal function?

    the client is asking a availability report of all the instances an i have no data for db_alive

    any suggestion?

    Hola a todos

    Tenemos el siguiente tema nos solicitaron un reporte de disponibilidad de las bases de datos, y lo queremos realizar con la metrica de db_alive de la probe oracle sin ambargo solo nos muestra metricas de una instancia por servidor de base de datos aunque el servidor tenga hasta 5 instanacias viviendo en el. 

    ¿Esto es normal ?
    alguna sugerencia para poder realizar el reporte de disponibilidad de todas las instancias de oracle


  • 2.  RE: Probe oracle solo despliega información de DB_ALIVE sobre una instancia en el servidor

    Broadcom Employee
    Posted Oct 17, 2019 05:56 AM
    Hi,

    we have a QOS to check the instance status of all participating instances in RAC Cluster.
    QOS_ORACLE_instance_status is the checkpoint you can use to check the status of all instances in a cluster.
    QOS_ORACLE_instance_status can be configured from Admin Console.
    If you want to monitor from IM, then you can create a customer check point using gv$instance view  and monitor the status.


    Regards,
    Dhanunjay




  • 3.  RE: Probe oracle solo despliega información de DB_ALIVE sobre una instancia en el servidor

    Posted Oct 21, 2019 12:23 PM
    Edited by oscar mendoza Oct 21, 2019 12:23 PM
    hi already enable on IM the checkpoint for instance_status, if i test the query response that the instance is active, but dont insert any data into database i cant find any data on the SLM


  • 4.  RE: Probe oracle solo despliega información de DB_ALIVE sobre una instancia en el servidor
    Best Answer

    Broadcom Employee
    Posted Oct 21, 2019 02:12 PM
    Oscar -

    Per the oracle (Oracle Database Monitoring) Release Notes techdoc page, the probe supports Real Application Cluster (RAC) only through Admin Console.

    You cannot configure RAC oracle database monitoring through Infrastructure Manager (IM) and you cannot mix configuring the oracle probe with both the Admin Console and IM.  Delete your connections to the RAC oracle databases, then from the oracle probe Configure Page opened from Admin Console, enable and configure the instance status checkpoint in the RAC Specific Checkpoints set of checkpoints, then configure the connection to the RAC oracle database (make sure that you select the RAC option on this connection profile).  The probe should then start to monitor the instance status for all of the RAC instances for each of the RAC oracle database connection profiles that you configure.

    ------------------------------
    Kathy Maguire
    Technical Support Engineer 4
    Broadcom
    ------------------------------



  • 5.  RE: Probe oracle solo despliega información de DB_ALIVE sobre una instancia en el servidor

    Posted Oct 22, 2019 11:34 AM
    Thanks Kathy  and thanks to all
    we delete the conexions and create new conexion with RAC enable with this the instance status metrics show up

    regards