DBD::Oracle - with ora10g oci.dll

Hi,

I am having some issues with the DBD::Oracle.

I'm running Perl 5.8.7 build 813 from active state on a win2k3 server.

I installed Oracle 9.2.0 client.

I then installed DBI and DBD::Oracle (1.16), which installs the oci.dll
as well as oraociei10.dll.

I can connect using sqlplus manually from the command window, but my
connection through the dbi fails with the following error:

*******************************
DBI connect('irmops.prod.irm','batchrun',...) failed: ORA-12154:
TNS:could not resolve the connect identifier specified (DBD ERROR:
OCIServerAttach) at D:\apps\test\test.pl line 9
ORA-12154: TNS:could not resolve the connect identifier specified (DBD
ERROR: OCIServerAttach) at D:\apps\test\test.pl line 10.
************************

This would indicate an sqlnet configuration error. We use nameservers,
so I have my sqlnet.ora file properly set up in my 9.2.0 installation
under the /network/admin directory.

I'm guessing that the 10i oci is not properly configured to understand
how to get to our nameservers.

I'm a little puzzled and not sure how to handle this error, since the
10g installation is really just a few files in the /perl/bin directory.

Any help is appreciated.

Thanks,
LouiseM
.

Relevant Pages

  • status on DBI installation on AIX 5.2
    ... I have compiled successfully the DBI by following your suggestion. ... when I re-built Perl 5.8.7 from source code, ... I tried Perl 5.8.6 installation from source code, ... Onderwerp: RE: DBI installation failure on AIX 5.2, ...
    (perl.dbi.users)
  • RE: DBI and DBD::Oracle throw error Had to create DBD::Oracle::dr::imp_data_size unexpectedly
    ... on the system of the dbd to build a new one. ... perl is running without the recommended perl -w option ... Subject: DBI and DBD::Oracle throw error Had to create ... identical installation on some new quad core servers the script fails ...
    (perl.dbi.users)
  • Re: DBI and DBD::Oracle throw error Had to create DBD::Oracle::dr::imp_data_size unexpectedly
    ... on the system of the dbd to build a new one. ... perl is running without the recommended perl -w option ... Subject: DBI and DBD::Oracle throw error Had to create ... identical installation on some new quad core servers the script fails ...
    (perl.dbi.users)
  • RE: :Oracle - with ora10g oci.dll
    ... I agree it's not a DBD or DBI error. ... your connection descriptor seems suspect: ... how to get to our nameservers. ... 10g installation is really just a few files in the /perl/bin directory. ...
    (perl.dbi.users)
  • RE: :Oracle - with ora10g oci.dll
    ... This is most likely not a DBD::Oracle nor DBI error. ... your connection descriptor seems suspect: ... TNS:could not resolve the connect identifier specified (DBD ERROR: ... 10g installation is really just a few files in the /perl/bin directory. ...
    (perl.dbi.users)