DX Application Performance Management

  • 1.  CA APM Oracle Power Pack

    Posted Dec 21, 2016 07:28 AM
      |   view attached

    Hi All,

     

    We have configured Remote Oracle power pack monitoring for oracle 11g.

    We configured  Power pack in app server where 5001 port is open and able to telnet database instances. 

    Database instances is running on another server where 5001 port is not open which we want to monitor.

    My query is here

    1:-Should be port 5001 is open on where database  instances is running ?

    2:-Where i need to run PPOracleDB_UserPrivileges.sql script ?

        1:-in database instances server where database is running ?

        2:-where CA APM power pack configured in  app server ?

              Path:-/tools/CAAPM_Tomcat/PPOracleDB/deploy

             ./PPOracleDB_UserPrivileges.sql with DBA admin access ?

     

    Note:-I am using app server as remote machine for oracle power pack.

     

    Regards

    Vinay nayak

     



  • 2.  Re: CA APM Oracle Power Pack
    Best Answer

    Broadcom Employee
    Posted Dec 21, 2016 10:38 AM

    Hi Vinay,

     

    1:-Should be port 5001 is open on where database  instances is running ?

     

     

    5001 is the default port for the agent or powerpack to talk to the EM.  Any server that it resides on must have 5001 port opened (or whatever port you configure for the agent or the powerpack to talk to the EM on).

     

    2:-Where i need to run PPOracleDB_UserPrivileges.sql script ?

    This should be run from <PPOracleDBHome>\deploy directory.  

     

    Please see https://docops.ca.com/ca-apm/9-6/en/extending/oracle-database-monitoring/install-and-configure-ca-apm-for-oracle-databases

     

    Thanks,

    Matt



  • 3.  Re: CA APM Oracle Power Pack

    Broadcom Employee
    Posted Dec 21, 2016 11:13 AM

    Hi Vinay:

        Please review Matt's answers and the reference provided and let us know if they were helpful. 

    Thanks

    Hal German



  • 4.  Re: CA APM Oracle Power Pack

    Posted Dec 23, 2016 11:25 AM

    Hi All,

     

    This solution is working fine without Database servers port open.Need to port open on where remote agent  located/installed.

    At my environment there are two Oracle instance and both are reporting fine.

    Thanks to all for review and comment.

    Regards

    Vinay Nayak



  • 5.  Re: CA APM Oracle Power Pack

    Broadcom Employee
    Posted Dec 27, 2016 01:24 PM

    Hi Vinay,

     

    Glad to hear it worked.  Please mark the answer as correct.

     

    Thanks,
    Matt