Hello,
I'm trying to get the Oracle InstantClient to work so we can connect to
some remote data sources. It works...sort of. sqlplus works perfectly,
but DBD::Oracle has some nasty side effects, even though it connects and
gets data properly works.
Basically, DBD::Oracle looks for a Kerberos config file in
/krb5/krb.conf, which is elsewhere (/etc/krb5.conf). DBD::Oracle can't
find it, and then Kerberos is hosed for the rest of the process, such
that I can't connect via Kerberos to a Postgres database.
I can "fix" it by adding the following line to my sqlnet.ora (there's an
inconsequential blown assertion on program exit but everything else
works as expected):
SQLNET.KERBEROS5_CONF=/etc/krb5.conf
But the main issue is that we don't use Kerberos to connect to the
Oracle server (we just use straight password authentication). Why is it
trying to use Kerberos to connect, and how can I make it not use Kerberos?
Note that sqlplus doesn't try to use Kerberos, and DBD::Oracle even
tries to use Kerberos even when I set SQLNET.AUTHENTICATION_SERVICES to
"(none)".
Peter
Gritty details:
I followed the instructions in
DBD-Oracle-1.21/err_build/err_instantclient.msg to fix the Makefile and
allow DBD::Oracle to compile.
Gritty details:
DBI - 1.602
Kerberos 5 - 1.6.2
DBD-Oracle - 1.21
Perl - 5.8.8
OS - RHEL 5