RE: :Oracle - with ora10g oci.dll

Typo below...

'now sure' should be 'not sure'

L

-----Original Message-----
From: Mitchell, Louise M
Sent: Friday, December 30, 2005 12:03 PM
To: Kong, Alan
Cc: dbi-users@xxxxxxxx
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

-----Original Message-----
From: Kong, Alan [mailto:KongA@xxxxxxxxx]
Sent: Friday, December 30, 2005 12:02 PM
To: Mitchell, Louise M; dbi-users@xxxxxxxx
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@xxxxxxx]
Sent: Friday, December 30, 2005 2:57 PM
To: dbi-users@xxxxxxxx
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
.

Relevant Pages

  • RE: :Oracle - with ora10g oci.dll
    ... We don't use tnsnames.ora because we run nameservers. ... Check to see if you can connect to sqlplus in the command prompt. ... This would indicate an sqlnet configuration error. ... 10g installation is really just a few files in the /perl/bin directory. ...
    (perl.dbi.users)
  • RE: :Oracle - with ora10g oci.dll
    ... Check to see if you can connect to sqlplus in the command prompt. ... I then installed DBI and DBD::Oracle, ... 10g installation is really just a few files in the /perl/bin directory. ...
    (perl.dbi.users)
  • Re: connect system/password@xe doesnt work
    ... > I have a problem with my new Oracle XE installation. ... > sqlplus system/manager@xe CONNECTS OK ... It is conceivable that the xe service defined on computer2 is pointing at a different database with a different system password. ...
    (comp.databases.oracle.server)
  • Re: Installation problem Oracle 10g on FC3
    ... tnsping or sqlplus etc since one of recommended assistants fail. ... configuration assistants -> Enterprise Manager Repository Creation ... > installation process cant connect to oracle using tns ...
    (Fedora)