Re: Oracle connection debugging (was Re: [pcp] Handling Oracle PMDA Latencies)

[Nathan Scott <nathans@xxxxxxxxxx>]

----- Original Message -----
> 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:
> 

Ah - does this patch help?

diff --git a/src/pmdas/oracle/pmdaoracle.pl b/src/pmdas/oracle/pmdaoracle.pl
index ec4731b..e4e0d5c 100644
--- a/src/pmdas/oracle/pmdaoracle.pl
+++ b/src/pmdas/oracle/pmdaoracle.pl
@@ -3624,6 +3624,7 @@ WRITETIM column of the V$FILESTAT view.');
 
 # $ENV{PCP_PERL_DEBUG} = 'LIBPMDA';
 $pmda = PCP::PMDA->new('oracle', 32);
+$pmda->connect_pmcd;
 $pmda->set_user($os_user);
 
 oracle_control_setup();


cheers.

--
Nathan