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?
Did Lynn's response answer your question or do you need additional help?
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).
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.
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"
Hope it helps
Thanks Lynn for correcting me.