RE: :Oracle - with ora10g oci.dll

Are you running the PERL script in command prompt? Or via web server?

Check if you set the TNS_ADMIN environment variable.

-----Original Message-----
From: Mitchell, Louise M [mailto:Louise.Mitchell@pnl.gov]
Sent: Friday, December 30, 2005 3:05 PM
To: Mitchell, Louise M; Kong, Alan
Cc: dbi-users@perl.org
Subject: RE: :Oracle - with ora10g oci.dll


Typo below...

'now sure' should be 'not sure'

L=20

-----Original Message-----
From: Mitchell, Louise M=20
Sent: Friday, December 30, 2005 12:03 PM
To: Kong, Alan
Cc: dbi-users@perl.org
Subject: RE: :Oracle - with ora10g oci.dll

I can connect via sqlplus and sqlplusw.

We don't use tnsnames.ora because we run nameservers. We only have
sqlnet.ora files which contain nameserver info.

I was an oracle dba for a number of years, so am familiar with
configuring and setting up the oracle client and so far as I can tell
the 9.2.0 client is set up correctly.

But the DBD:Oracle is using the 10g oci/client files. So now sure how
it's getting it's configuration information.

L=20

-----Original Message-----
From: Kong, Alan [mailto:KongA@coned.com]
Sent: Friday, December 30, 2005 12:02 PM
To: Mitchell, Louise M; dbi-users@perl.org
Subject: RE: :Oracle - with ora10g oci.dll

Check to see if you can connect to sqlplus in the command prompt.

You should also check the tnsnames.ora entry.

-----Original Message-----
From: Mitchell, Louise M [mailto:Louise.Mitchell@pnl.gov]
Sent: Friday, December 30, 2005 2:57 PM
To: dbi-users@perl.org
Subject: 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