CREATE USER webteam_ro identified by webteam_ro
DEFAULT TABLESPACE users
QUOTA UNLIMITED ON users;
GRANT CONNECT TO webteam_ro;
CREATE TABLE webteam_ro.APM_OPP_LIBRARYCACHE_TEMP NOLOGGING AS SELECT namespace, gethitratio FROM V$LIBRARYCACHE;
CREATE TABLE webteam_ro.APM_OPP_LIBRARYCACHE_TEMP1 NOLOGGING AS SELECT reloads, pins FROM V$LIBRARYCACHE;
CREATE TABLE webteam_ro.APM_OPP_DB_OBJECT_CACHE_TEMP NOLOGGING AS SELECT sharable_mem FROM V$DB_OBJECT_CACHE;
CREATE TABLE webteam_ro.APM_OPP_DBA_DATA_FILES_TEMP NOLOGGING AS SELECT file_id, tablespace_name, file_name FROM dba_data_files
Yes with the Oracle PowerPack is no support OOTB for Oracle RAC.
Using this document I recently added to the Community I think you should be able to get it work using a RAC TNS_ALIAS:
Using the APM PowerPack for Oracle with the Oracle JDBC OCI driver & TNSNames Alias Syntax
Hope it helps
Sorry just getting the connection setup to Oracle RAC is not going to help you due to the Global Views (GV$) you want to get the data from
There used to a CA Professional Services Field Pack version of the OraclePP that did support RAC. Hiko_Davis may know more.
I did try using the amended connection class to connect to each instance. I needed a separate oracle Id and tables etc on each instance as each instance contains its own v$ views just for that instance. Looks like the new jar was created with Java 1.8 and my servers run 1.7 so haven't got it to work.
Sent from my iPhone
Sorry my bad I did not compile with correct backward compatibility parameters.
I have uploaded new zip file to that post with new class & jar files.
However that is only going to give you OCI/TNS_ALIAS support and you would need the fieldpack confirmed by Hiko_Davis if you want the query changes.
Thanks for the updated jar. I have it working now. As a workaround to the RAC issue, I have a different user set up for each instance so that I can see the data for that instance.
We do have a fieldpack which was updated to support RAC option.
Please contact your CA Pre-sales or Services contact for details.