Hi,
On 2016-04-13 07:52, Nathan Scott wrote:
> ----- Original Message -----
>> [...]
>> connect.pl says "OK", after PMDA installation there are no oracle
>> metrics available and the Oracle PMDA log is silent.
>
> Hmm, I've not seen anything like that. Usually theres a big warning
> in the pmcd/oracle.log file ... and usually its that initial connect
> that fails.
>
>> Are there any recommended sanity checks that could be done in this case?
>
> I'd verify the connection with sqlplus, issuing queries like those
> listed in the pmdaoracle.pl code (near the start - bunch of 'em you
> could try there). Those should all show columns/values returned by
> sqlplus.
Here are some additional details and perhaps a clue:
* RHEL 6 + RHEL 6.8 Beta PCP RPMs
* SELinux disabled
* sqlplus works for basics:
$ echo 'select * FROM v$version;' | sqlplus $username/$password@$sid
SQL*Plus: Release 12.1.0.1.0 Production on Thu Apr 14 10:56:18 2016
...
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application
Testing options
...
SQL>
BANNER
--------------------------------------------------------------------------------
CON_ID
----------
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
0
PL/SQL Release 12.1.0.2.0 - Production
0
CORE 12.1.0.2.0 Production
0
...
* connect.pl works:
# ./connect.pl
Attempting Oracle login SID=<sid> ... OK
* PMDA installation and pminfo -f test:
...
Please enter c(ollector) or m(onitor) or b(oth) [b] c
Updating the Performance Metrics Name Space (PMNS) ...
Terminate PMDA if already installed ...
Updating the PMCD control file, and notifying PMCD ...
Waiting for pmcd to terminate ...
Starting pmcd ...
Check oracle metrics have appeared ... 266 warnings, 266 metrics and 0
values
# pminfo -f oracle
oracle: pmLookupName: No PMCD agent for domain of request
* Finally, pmcd.log has:
[Thu Apr 14 11:05:35] pmcd(13925) Warning: pduread: timeout (after 5.000
sec) while attempting to read 12 bytes out of 12 in HDR on fd=18
[Thu Apr 14 11:05:35] pmcd(13925) Info: CleanupAgent ...
Cleanup "oracle" agent (dom 32): protocol failure for fd=18
Thanks,
--
Marko Myllynen
|