DX Unified Infrastructure Management

  • Private Community

  • 1.  Oracle DB monitoring

    Posted Dec 29, 2016 01:29 AM

    Hi,

    We have installed UIM 8.47 on windows 2008 R2 ent edition.

     

    We have Oracle 11.2 installed on Linux 6.x and robot installed on DB server. I want to monitor oracle DB databases locally.

     

    Can anyone help in providing steps to monitor these databases locally through UIM.



  • 2.  Re: Oracle DB monitoring

    Broadcom Employee
    Posted Dec 29, 2016 07:15 AM

    HI,

     

    You would need to install the oracle probe on the local robot on the db server.

    Then configure the probe to point to the oracle client for the database

    and configure the robot environment.

    Below are some trouble shooting KB articles.

     

    Need to make sure the oracle client Bit level matches the os.

    We do not support using 32 bit oracle client on 64 bit OS to make connection and it must be the full client not the instance client.

    oracle (Oracle Database Monitoring) - CA Unified Infrastructure Management Probes - CA Technologies Documentation 

     

    https://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.tec000002426.html 



  • 3.  RE: Re: Oracle DB monitoring

    Posted Dec 25, 2019 12:16 PM
    Hi Gene,

    Could you let me know if the oracle client to be installed on the UIM server????
    Original Message


  • 4.  RE: Re: Oracle DB monitoring

    Broadcom Employee
    Posted Dec 25, 2019 01:36 PM
    Hi,
    So if you are using an Oracle back end you should not install the Oracle client on the primary hub. 
    The Oracle  client is not needed to be installed for the uim primary hub if using an Oracle back end as it installs an instant client.

    The oracle probe ca  not use the instant client but requires the full oracle client.
    You will need to install the full Oracle  client on the robot with the Oracle probe that supports the target  databse and that the bit level matches the os bit level where the client is being installed..

    ------------------------------
    Gene Howard
    Principal Support Engineer
    Broadcom
    ------------------------------

    Original Message


  • 5.  RE: Oracle DB monitoring
    Best Answer

    Broadcom Employee
    Posted Dec 26, 2019 09:53 AM
    Just updating from the old KD article link to the new one:

    Old one: https://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.tec000002426.html 

    New one: 
    oracle probe connection errors: Create OCI environment failed with rc = -1 or OCIEnvCreate failed with rc = -1
    https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=34400

    ------------------------------
    Senior Support Engineer
    Broadcom
    ------------------------------

    Original Message