DX Application Performance Management

Expand all | Collapse all

Oracle PP for APM using an Oracle 12c database

  • 1.  Oracle PP for APM using an Oracle 12c database

    Posted 04-22-2016 09:35 AM

    Hi, has anyone used the Oracle PP for APM with Oracle 12c, specifically around the multi-tenanted use of a database with a parent/child configuration. Currently the only solution appears to be to run the sql against both DB's and collect the metrics twice but is it possible to collect the data from both parent/child in one data collection?

     

    Paul



  • 2.  Re: Oracle PP for APM using an Oracle 12c database

    Broadcom Employee
    Posted 04-26-2016 08:37 AM

    Hi Paul:

    Did Lynn's response answer your question or do you need additional help?

     

    Thanks

    Hal German



  • 3.  Re: Oracle PP for APM using an Oracle 12c database

    Broadcom Employee
    Posted 04-26-2016 01:30 AM

    The PP isn't designed to work with SIDs, but I do believe we had a fieldpack solution that does. This does mean it's not supported by CA Support and you will have to contact CA Services instead.

    We may be able to provide some limited support from the APM Dev community (http://bit.ly/caapm_dev).



  • 4.  Re: Oracle PP for APM using an Oracle 12c database

    Posted 04-26-2016 09:51 AM

    I'm going to supplement the existing metrics with some additional sql statements in the PP. According to the DBA if the PP Agent is connected to the child database in 12c it should be able to reference values in its parent. I'll get any additional values either via a direct sql statement against the database or get the values put into a new Introscope table in the database. This should remove the requirement to have 2 databases (parent,child) being polled for metrics.



  • 5.  Re: Oracle PP for APM using an Oracle 12c database

    Broadcom Employee
    Posted 04-26-2016 02:06 AM

    Hi Paul,

    I think Hiko meant the PP is only designed to work with SIDs.

     

    I just read up on the Oracle 12c Container Database/PDB option and sounds like & you need to use an Oracle service name.

    If yes my TNS/OCI driver unofficial version here should be able to do that:

    "Using the APM PowerPack for Oracle with the Oracle JDBC OCI driver & TNSNames Alias Syntax"

    https://communities.ca.com/docs/DOC-231163959

     

    Hope it helps

     

    Regards,

     

    Lynn



  • 6.  Re: Oracle PP for APM using an Oracle 12c database

    Broadcom Employee
    Posted 04-26-2016 02:11 AM

    Thanks Lynn for correcting me.