DBI DBD-Oracle connection failure woth ORA-12705

------=_NextPart_000_0013_01C5AA1C.E95ADEE0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Environment = Windows XP, perl 5.6 (activestate)



I recently upgraded my DBI module to 1.32

And DBD-Oracle to 1.16



I have an Oracle 9 database on my PC, and have been connecting to it using
DBI with no problems.



On upgrading to the above versions (I think the prior DBD was 1.12)

My connection no longer works



Here is the code which has not changed

# $!perl -w





use strict;

use DBI;





DBI->trace(2,"my_trace.txt");

my %attr = (RaiseError => 0, AutoCommit =>1);

my $dbh = DBI->connect("dbi:Oracle:host=127.0.0.1;sid=GAV", 'tdf', 'bike',
\%attr)

or die "Failed to connect to database: $DBI::errstr";

my $sth = $dbh->prepare("

SELECT distinct (owner)

FROM tdf_results

" );

$sth->execute();









Here is the error





C:\databases\perl\eg>perl tdftest4.pl

DBI connect('host=127.0.0.1;sid=GAV','tdf',...) failed: ORA-12705: invalid
or unknown NLS parameter

value specified (DBD ERROR: OCISessionBegin) at tdftest4.pl line 10

Failed to connect to database: ORA-12705: invalid or unknown NLS parameter
value specified (DBD ERRO

R: OCISessionBegin) at tdftest4.pl line 10.



Is this a known issue, or am I unlucky? Can anyone help, or point me in the
right direction?



Thanks



Gavin


------=_NextPart_000_0013_01C5AA1C.E95ADEE0--

RE: DBI DBD-Oracle connection failure woth ORA-12705

Metalink not 158654.1

-----------------
Ron Reidy
Lead DBA
Array BioPharma, Inc.


-----Original Message-----
From: Gavin W [mailto:gavin.s.williams@btinternet.com]
Sent: Friday, August 26, 2005 2:03 AM
To: dbi-users@perl.org
Subject: DBI DBD-Oracle connection failure woth ORA-12705


Environment =3D Windows XP, perl 5.6 (activestate)

=20

I recently upgraded my DBI module to 1.32

And DBD-Oracle to 1.16

=20

I have an Oracle 9 database on my PC, and have been connecting to it =
using
DBI with no problems.

=20

On upgrading to the above versions (I think the prior DBD was 1.12)

My connection no longer works

=20

Here is the code which has not changed

# $!perl -w

=20

=20

use strict;

use DBI;

=20

=20

DBI->trace(2,"my_trace.txt");

my %attr =3D (RaiseError =3D> 0, AutoCommit =3D>1);

my $dbh =3D DBI->connect("dbi:Oracle:host=3D127.0.0.1;sid=3DGAV", 'tdf', =
'bike',
\%attr)=20

or die "Failed to connect to database: $DBI::errstr";

my $sth =3D $dbh->prepare("

SELECT distinct (owner)

FROM tdf_results

" );

$sth->execute();

=20

=20

=20

=20

Here is the error

=20

=20

C:\databases\perl\eg>perl tdftest4.pl

DBI connect('host=3D127.0.0.1;sid=3DGAV','tdf',...) failed: ORA-12705: =
invalid
or unknown NLS parameter

value specified (DBD ERROR: OCISessionBegin) at tdftest4.pl line 10

Failed to connect to database: ORA-12705: invalid or unknown NLS =
parameter
value specified (DBD ERRO

R: OCISessionBegin) at tdftest4.pl line 10.

=20

Is this a known issue, or am I unlucky? Can anyone help, or point me in =
the
right direction?

=20

Thanks

=20

Gavin


This electronic message transmission is a PRIVATE communication which =
contains
information which may be confidential or privileged. The information is =
intended=20
to be for the use of the individual or entity named above. If you are =
not the=20
intended recipient, please be aware that any disclosure, copying, =
distribution=20
or use of the contents of this information is prohibited. Please notify =
the
sender of the delivery error by replying to this message, or notify us =
by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: DBI DBD-Oracle connection failure woth ORA-12705

SOLVED Thanks Ron,

I have another oracle home for Oracle9ias . NLS_LANG was set right in
The database oracle_home, but set as NA in the IAS home.

I have set an environment variable NLS_LANG so that all homes will pick it
up.

The connect now works. I am just puzzled as to why
DBI and DBD-Oracle in previous versions worked, then did not work
When I updated them. Which Oracle home was it looking at?

Anyway thanks again

Gavin


-----Original Message-----
From: Reidy, Ron [mailto:Ron.Reidy@arraybiopharma.com]
Sent: 26 August 2005 14:45
To: Gavin W; dbi-users@perl.org
Subject: RE: DBI DBD-Oracle connection failure woth ORA-12705

Metalink not 158654.1

-----------------
Ron Reidy
Lead DBA
Array BioPharma, Inc.


-----Original Message-----
From: Gavin W [mailto:gavin.s.williams@btinternet.com]
Sent: Friday, August 26, 2005 2:03 AM
To: dbi-users@perl.org
Subject: DBI DBD-Oracle connection failure woth ORA-12705


Environment = Windows XP, perl 5.6 (activestate)



I recently upgraded my DBI module to 1.32

And DBD-Oracle to 1.16



I have an Oracle 9 database on my PC, and have been connecting to it using
DBI with no problems.



On upgrading to the above versions (I think the prior DBD was 1.12)

My connection no longer works



Here is the code which has not changed

# $!perl -w





use strict;

use DBI;





DBI->trace(2,"my_trace.txt");

my %attr = (RaiseError => 0, AutoCommit =>1);

my $dbh = DBI->connect("dbi:Oracle:host=127.0.0.1;sid=GAV", 'tdf', 'bike',
\%attr)

or die "Failed to connect to database: $DBI::errstr";

my $sth = $dbh->prepare("

SELECT distinct (owner)

FROM tdf_results

" );

$sth->execute();









Here is the error





C:\databases\perl\eg>perl tdftest4.pl

DBI connect('host=127.0.0.1;sid=GAV','tdf',...) failed: ORA-12705: invalid
or unknown NLS parameter

value specified (DBD ERROR: OCISessionBegin) at tdftest4.pl line 10

Failed to connect to database: ORA-12705: invalid or unknown NLS parameter
value specified (DBD ERRO

R: OCISessionBegin) at tdftest4.pl line 10.



Is this a known issue, or am I unlucky? Can anyone help, or point me in the
right direction?



Thanks



Gavin


This electronic message transmission is a PRIVATE communication which
contains
information which may be confidential or privileged. The information is
intended
to be for the use of the individual or entity named above. If you are not
the
intended recipient, please be aware that any disclosure, copying,
distribution
or use of the contents of this information is prohibited. Please notify the
sender of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: DBI DBD-Oracle connection failure woth ORA-12705

Gavin,

I'm not sure which OH itt was looking at, but more importantly, it had =
an incorrect value for the NLS var.

-----------------
Ron Reidy
Lead DBA
Array BioPharma, Inc.


-----Original Message-----
From: Gavin W [mailto:gavin.s.williams@btinternet.com]
Sent: Friday, August 26, 2005 9:59 AM
To: Reidy, Ron; dbi-users@perl.org
Subject: RE: DBI DBD-Oracle connection failure woth ORA-12705


SOLVED Thanks Ron,

I have another oracle home for Oracle9ias . NLS_LANG was set right in
The database oracle_home, but set as NA in the IAS home.

I have set an environment variable NLS_LANG so that all homes will pick =
it
up.

The connect now works. I am just puzzled as to why=20
DBI and DBD-Oracle in previous versions worked, then did not work
When I updated them. Which Oracle home was it looking at?

Anyway thanks again

Gavin


-----Original Message-----
From: Reidy, Ron [mailto:Ron.Reidy@arraybiopharma.com]=20
Sent: 26 August 2005 14:45
To: Gavin W; dbi-users@perl.org
Subject: RE: DBI DBD-Oracle connection failure woth ORA-12705

Metalink not 158654.1

-----------------
Ron Reidy
Lead DBA
Array BioPharma, Inc.


-----Original Message-----
From: Gavin W [mailto:gavin.s.williams@btinternet.com]
Sent: Friday, August 26, 2005 2:03 AM
To: dbi-users@perl.org
Subject: DBI DBD-Oracle connection failure woth ORA-12705


Environment =3D Windows XP, perl 5.6 (activestate)

=20

I recently upgraded my DBI module to 1.32

And DBD-Oracle to 1.16

=20

I have an Oracle 9 database on my PC, and have been connecting to it =
using
DBI with no problems.

=20

On upgrading to the above versions (I think the prior DBD was 1.12)

My connection no longer works

=20

Here is the code which has not changed

# $!perl -w

=20

=20

use strict;

use DBI;

=20

=20

DBI->trace(2,"my_trace.txt");

my %attr =3D (RaiseError =3D> 0, AutoCommit =3D>1);

my $dbh =3D DBI->connect("dbi:Oracle:host=3D127.0.0.1;sid=3DGAV", 'tdf', =
'bike',
\%attr)=20

or die "Failed to connect to database: $DBI::errstr";

my $sth =3D $dbh->prepare("

SELECT distinct (owner)

FROM tdf_results

" );

$sth->execute();

=20

=20

=20

=20

Here is the error

=20

=20

C:\databases\perl\eg>perl tdftest4.pl

DBI connect('host=3D127.0.0.1;sid=3DGAV','tdf',...) failed: ORA-12705: =
invalid
or unknown NLS parameter

value specified (DBD ERROR: OCISessionBegin) at tdftest4.pl line 10

Failed to connect to database: ORA-12705: invalid or unknown NLS =
parameter
value specified (DBD ERRO

R: OCISessionBegin) at tdftest4.pl line 10.

=20

Is this a known issue, or am I unlucky? Can anyone help, or point me in =
the
right direction?

=20

Thanks

=20

Gavin


This electronic message transmission is a PRIVATE communication which
contains
information which may be confidential or privileged. The information is
intended=20
to be for the use of the individual or entity named above. If you are =
not
the=20
intended recipient, please be aware that any disclosure, copying,
distribution=20
or use of the contents of this information is prohibited. Please notify =
the
sender of the delivery error by replying to this message, or notify us =
by
telephone (877-633-2436, ext. 0), and then delete it from your system.


This electronic message transmission is a PRIVATE communication which =
contains
information which may be confidential or privileged. The information is =
intended=20
to be for the use of the individual or entity named above. If you are =
not the=20
intended recipient, please be aware that any disclosure, copying, =
distribution=20
or use of the contents of this information is prohibited. Please notify =
the
sender of the delivery error by replying to this message, or notify us =
by
telephone (877-633-2436, ext. 0), and then delete it from your system.