Re: ORA-12154 - (DBD: login failed)

2016-08-16 Thread Jeff Long 
It has been so long since it happened I might be (mis)remembering that 
the periods were in the path to java being used by the installer(?).


Jeff

On 08/16/2016 05:51 PM, Jeff Long wrote:

Does your current ORACLE_HOME have periods in it?  If so the periods
could possibly cause the problem.  I have seriously been unable to do
things with certain versions of Oracle on certain operating systems when
there were periods in the directory path.  Getting rid of the periods
made everything work immediately.

Jeff Long


On 08/10/2016 10:40 PM, Mani, Arunkumar (BMS - India GDC) wrote:

Just following up to see if I can get any help on this.

*Arunkumar Mani
*ITO Service Delivery Consultant
Database Engineering, BMS Account

arunkumar.m...@hpe.com <mailto:arunkumar.m...@hpe.com>
+91 80 338 59305  Office
+91 74062 71026  Mobile

Bangalore, Karnataka/India
*hpe.com*

hpesm_pri_grn_pos_email_06

*From:* Mani, Arunkumar (BMS - India GDC)
*Sent:* Tuesday, August 9, 2016 1:54 PM
*To:* 'Howard, Chris' <howa...@prpa.org>; Nelson, Erick
<erick.nel...@hdsupply.com>; mohammed.must...@wipro.com;
dbi-users@perl.org
*Subject:* RE: ORA-12154 - (DBD: login failed)

Yes.

*Arunkumar Mani
*ITO Service Delivery Consultant
Database Engineering, BMS Account

arunkumar.m...@hpe.com <mailto:arunkumar.m...@hpe.com>
+91 80 338 59305  Office
+91 74062 71026  Mobile

Bangalore, Karnataka/India
*hpe.com*

hpesm_pri_grn_pos_email_06

*From:* Howard, Chris [mailto:howa...@prpa.org]
*Sent:* Monday, August 8, 2016 9:29 PM
*To:* Mani, Arunkumar (BMS - India GDC) <arunkumar.m...@hpe.com
<mailto:arunkumar.m...@hpe.com>>; Nelson, Erick
<erick.nel...@hdsupply.com <mailto:erick.nel...@hdsupply.com>>;
mohammed.must...@wipro.com <mailto:mohammed.must...@wipro.com>;
dbi-users@perl.org <mailto:dbi-users@perl.org>
*Subject:* RE: ORA-12154 - (DBD: login failed)

And tnsnames.ora under each ORACLE_HOME works good using sqlplus or
other tools, yes?

*From:*Mani, Arunkumar (BMS - India GDC) [mailto:arunkumar.m...@hpe.com]
*Sent:* Monday, August 08, 2016 9:37 AM
*To:* Howard, Chris; Nelson, Erick; mohammed.must...@wipro.com
<mailto:mohammed.must...@wipro.com>; dbi-users@perl.org
<mailto:dbi-users@perl.org>
*Subject:* RE: ORA-12154 - (DBD: login failed)

I'll probably explain it with a piece of code and output, so everybody
can explain the problem I face clearly.

If you look at 2 codes, the only change is I modified 8i client with 10g
client. After that it couldn’t resolve the TNS connection string.

_Perl code with 8i client - works:_

#!/usr/local/bin/perl

#use DBI

#use strict;

use strict;

use lib '/u01/home/oracle/admin/site/lib/perl';

use DBI;

$ENV{ORACLE_HOME} = '/u01/home/oracle/product/8.1.7.4';

$ENV{TNS_ADMIN} = '/home/httpd/cgi-bin/oradba';

my $sid = "ECLD.WORLD";

my $usr = "mania2";

my $pas = "blah";

my $dbh = DBI->connect("dbi:Oracle:tns:$sid", $usr, $pas) or die
$DBI::errstr;

Output:

bash-2.03$ ./perl_testing1.pl

DBI->connect(tns:ECLD.WORLD) failed: ORA-01017: invalid
username/password; logon denied (DBD: login failed) at
./perl_testing1.pl line 14

ORA-01017: invalid username/password; logon denied (DBD: login failed)
at ./perl_testing1.pl line 14.

bash-2.03$

_Perl code with 10g client - not working:_

#!/usr/local/bin/perl

#use DBI

#use strict;

use strict;

use lib '/u01/home/oracle/admin/site/lib/perl';

use DBI;

$ENV{ORACLE_HOME} = '/u01/home/oracle/product/10.2.0';

$ENV{TNS_ADMIN} = '/home/httpd/cgi-bin/oradba';

my $sid = "ECLD.WORLD";

my $usr = "mania2";

my $pas = "blah";

my $dbh = DBI->connect("dbi:Oracle:tns:$sid", $usr, $pas) or die
$DBI::errstr;

Output:

bash-2.03$ ./perl_testing1.pl

DBI->connect(tns:ECLD.WORLD) failed: ORA-12154: TNS:could not resolve
the connect identifier specified (DBD: login failed) at
./perl_testing1.pl line 14

ORA-12154: TNS:could not resolve the connect identifier specified (DBD:
login failed) at ./perl_testing1.pl line 14.

bash-2.03$

Arunkumar Mani

ITO Service Delivery Consultant

Database Engineering, BMS Account

arunkumar.m...@hpe.com <mailto:arunkumar.m...@hpe.com>

+91 80 338 59305  Office

+91 74062 71026  Mobile

Bangalore, Karnataka/India

hpe.com

-Original Message-
From: Howard, Chris [mailto:howa...@prpa.org]
Sent: Monday, August 8, 2016 7:55 PM
To: Mani, Arunkumar (BMS - India GDC) <arunkumar.m...@hpe.com
<mailto:arunkumar.m...@hpe.com>>; Nelson, Erick
<erick.nel...@hdsupply.com <mailto:erick.nel...@hdsupply.com>>;
mohammed.must...@wipro.com <mailto:mohammed.must...@wipro.com>;
dbi-users@perl.org <mailto:dbi-users@perl.org>
Subject: RE: ORA-12154 - (DBD: login failed)

ORACLE_HOME not defined correctly?

(I would test by printing out all ENV from within script)

-Original Message-

From: Mani, Arunkumar (BMS - India GDC) [mailto:arunkumar.m

Re: ORA-12154 - (DBD: login failed)

2016-08-16 Thread Jeff Long 
Does your current ORACLE_HOME have periods in it?  If so the periods 
could possibly cause the problem.  I have seriously been unable to do 
things with certain versions of Oracle on certain operating systems when 
there were periods in the directory path.  Getting rid of the periods 
made everything work immediately.


Jeff Long


On 08/10/2016 10:40 PM, Mani, Arunkumar (BMS - India GDC) wrote:

Just following up to see if I can get any help on this.

*Arunkumar Mani
*ITO Service Delivery Consultant
Database Engineering, BMS Account

arunkumar.m...@hpe.com <mailto:arunkumar.m...@hpe.com>
+91 80 338 59305  Office
+91 74062 71026  Mobile

Bangalore, Karnataka/India
*hpe.com*

hpesm_pri_grn_pos_email_06

*From:* Mani, Arunkumar (BMS - India GDC)
*Sent:* Tuesday, August 9, 2016 1:54 PM
*To:* 'Howard, Chris' <howa...@prpa.org>; Nelson, Erick
<erick.nel...@hdsupply.com>; mohammed.must...@wipro.com; dbi-users@perl.org
*Subject:* RE: ORA-12154 - (DBD: login failed)

Yes.

*Arunkumar Mani
*ITO Service Delivery Consultant
Database Engineering, BMS Account

arunkumar.m...@hpe.com <mailto:arunkumar.m...@hpe.com>
+91 80 338 59305  Office
+91 74062 71026  Mobile

Bangalore, Karnataka/India
*hpe.com*

hpesm_pri_grn_pos_email_06

*From:* Howard, Chris [mailto:howa...@prpa.org]
*Sent:* Monday, August 8, 2016 9:29 PM
*To:* Mani, Arunkumar (BMS - India GDC) <arunkumar.m...@hpe.com
<mailto:arunkumar.m...@hpe.com>>; Nelson, Erick
<erick.nel...@hdsupply.com <mailto:erick.nel...@hdsupply.com>>;
mohammed.must...@wipro.com <mailto:mohammed.must...@wipro.com>;
dbi-users@perl.org <mailto:dbi-users@perl.org>
*Subject:* RE: ORA-12154 - (DBD: login failed)

And tnsnames.ora under each ORACLE_HOME works good using sqlplus or
other tools, yes?

*From:*Mani, Arunkumar (BMS - India GDC) [mailto:arunkumar.m...@hpe.com]
*Sent:* Monday, August 08, 2016 9:37 AM
*To:* Howard, Chris; Nelson, Erick; mohammed.must...@wipro.com
<mailto:mohammed.must...@wipro.com>; dbi-users@perl.org
<mailto:dbi-users@perl.org>
*Subject:* RE: ORA-12154 - (DBD: login failed)

I'll probably explain it with a piece of code and output, so everybody
can explain the problem I face clearly.

If you look at 2 codes, the only change is I modified 8i client with 10g
client. After that it couldn’t resolve the TNS connection string.

_Perl code with 8i client - works:_

#!/usr/local/bin/perl

#use DBI

#use strict;

use strict;

use lib '/u01/home/oracle/admin/site/lib/perl';

use DBI;

$ENV{ORACLE_HOME} = '/u01/home/oracle/product/8.1.7.4';

$ENV{TNS_ADMIN} = '/home/httpd/cgi-bin/oradba';

my $sid = "ECLD.WORLD";

my $usr = "mania2";

my $pas = "blah";

my $dbh = DBI->connect("dbi:Oracle:tns:$sid", $usr, $pas) or die
$DBI::errstr;

Output:

bash-2.03$ ./perl_testing1.pl

DBI->connect(tns:ECLD.WORLD) failed: ORA-01017: invalid
username/password; logon denied (DBD: login failed) at
./perl_testing1.pl line 14

ORA-01017: invalid username/password; logon denied (DBD: login failed)
at ./perl_testing1.pl line 14.

bash-2.03$

_Perl code with 10g client - not working:_

#!/usr/local/bin/perl

#use DBI

#use strict;

use strict;

use lib '/u01/home/oracle/admin/site/lib/perl';

use DBI;

$ENV{ORACLE_HOME} = '/u01/home/oracle/product/10.2.0';

$ENV{TNS_ADMIN} = '/home/httpd/cgi-bin/oradba';

my $sid = "ECLD.WORLD";

my $usr = "mania2";

my $pas = "blah";

my $dbh = DBI->connect("dbi:Oracle:tns:$sid", $usr, $pas) or die
$DBI::errstr;

Output:

bash-2.03$ ./perl_testing1.pl

DBI->connect(tns:ECLD.WORLD) failed: ORA-12154: TNS:could not resolve
the connect identifier specified (DBD: login failed) at
./perl_testing1.pl line 14

ORA-12154: TNS:could not resolve the connect identifier specified (DBD:
login failed) at ./perl_testing1.pl line 14.

bash-2.03$

Arunkumar Mani

ITO Service Delivery Consultant

Database Engineering, BMS Account

arunkumar.m...@hpe.com <mailto:arunkumar.m...@hpe.com>

+91 80 338 59305  Office

+91 74062 71026  Mobile

Bangalore, Karnataka/India

hpe.com

-Original Message-
From: Howard, Chris [mailto:howa...@prpa.org]
Sent: Monday, August 8, 2016 7:55 PM
To: Mani, Arunkumar (BMS - India GDC) <arunkumar.m...@hpe.com
<mailto:arunkumar.m...@hpe.com>>; Nelson, Erick
<erick.nel...@hdsupply.com <mailto:erick.nel...@hdsupply.com>>;
mohammed.must...@wipro.com <mailto:mohammed.must...@wipro.com>;
dbi-users@perl.org <mailto:dbi-users@perl.org>
Subject: RE: ORA-12154 - (DBD: login failed)

ORACLE_HOME not defined correctly?

(I would test by printing out all ENV from within script)

-Original Message-

From: Mani, Arunkumar (BMS - India GDC) [mailto:arunkumar.m...@hpe.com]

Sent: Monday, August 08, 2016 5:38 AM

To: Nelson, Erick; mohammed.must...@wipro.com
<mailto:mohammed.must...@wipro.com>; dbi-users@perl.org
<mailto:dbi-users@perl.org

Re: ORA-12154 - (DBD: login failed)

2016-08-11 Thread John D Groenveld 
In message , "Mani, Arunkumar (BMS - India GDC)" writes:
>Just following up to see if I can get any help on this.

I saw where you confirmed that tnsping and sqlplus from
your new 10g ORACLE_HOME work against your listeners
and instances.
But did you confirm that you rebuilt your DBD::Oracle against
your new ORACLE_HOME?
$ find /u01/home/oracle/admin/site/lib/perl -name Oracle.so \
-exec ldd {} \;

John
groenv...@acm.org

RE: ORA-12154 - (DBD: login failed)

2016-08-10 Thread Mani, Arunkumar (BMS - India GDC) 
Just following up to see if I can get any help on this.

Arunkumar Mani
ITO Service Delivery Consultant
Database Engineering, BMS Account

arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com>
+91 80 338 59305  Office
+91 74062 71026  Mobile

Bangalore, Karnataka/India
hpe.com

[hpesm_pri_grn_pos_email_06]

From: Mani, Arunkumar (BMS - India GDC)
Sent: Tuesday, August 9, 2016 1:54 PM
To: 'Howard, Chris' <howa...@prpa.org>; Nelson, Erick 
<erick.nel...@hdsupply.com>; mohammed.must...@wipro.com; dbi-users@perl.org
Subject: RE: ORA-12154 - (DBD: login failed)

Yes.

Arunkumar Mani
ITO Service Delivery Consultant
Database Engineering, BMS Account

arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com>
+91 80 338 59305  Office
+91 74062 71026  Mobile

Bangalore, Karnataka/India
hpe.com

[hpesm_pri_grn_pos_email_06]

From: Howard, Chris [mailto:howa...@prpa.org]
Sent: Monday, August 8, 2016 9:29 PM
To: Mani, Arunkumar (BMS - India GDC) 
<arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com>>; Nelson, Erick 
<erick.nel...@hdsupply.com<mailto:erick.nel...@hdsupply.com>>; 
mohammed.must...@wipro.com<mailto:mohammed.must...@wipro.com>; 
dbi-users@perl.org<mailto:dbi-users@perl.org>
Subject: RE: ORA-12154 - (DBD: login failed)

And tnsnames.ora under each ORACLE_HOME works good using sqlplus or other 
tools, yes?



From: Mani, Arunkumar (BMS - India GDC) [mailto:arunkumar.m...@hpe.com]
Sent: Monday, August 08, 2016 9:37 AM
To: Howard, Chris; Nelson, Erick; 
mohammed.must...@wipro.com<mailto:mohammed.must...@wipro.com>; 
dbi-users@perl.org<mailto:dbi-users@perl.org>
Subject: RE: ORA-12154 - (DBD: login failed)


I'll probably explain it with a piece of code and output, so everybody can 
explain the problem I face clearly.

If you look at 2 codes, the only change is I modified 8i client with 10g 
client. After that it couldn't resolve the TNS connection string.



Perl code with 8i client - works:



#!/usr/local/bin/perl



#use DBI

#use strict;

use strict;

use lib '/u01/home/oracle/admin/site/lib/perl';

use DBI;

$ENV{ORACLE_HOME} = '/u01/home/oracle/product/8.1.7.4';

$ENV{TNS_ADMIN} = '/home/httpd/cgi-bin/oradba';

my $sid = "ECLD.WORLD";

my $usr = "mania2";

my $pas = "blah";

my $dbh = DBI->connect("dbi:Oracle:tns:$sid", $usr, $pas) or die $DBI::errstr;



Output:



bash-2.03$ ./perl_testing1.pl

DBI->connect(tns:ECLD.WORLD) failed: ORA-01017: invalid username/password; 
logon denied (DBD: login failed) at ./perl_testing1.pl line 14

ORA-01017: invalid username/password; logon denied (DBD: login failed) at 
./perl_testing1.pl line 14.

bash-2.03$



Perl code with 10g client - not working:





#!/usr/local/bin/perl



#use DBI

#use strict;

use strict;

use lib '/u01/home/oracle/admin/site/lib/perl';

use DBI;

$ENV{ORACLE_HOME} = '/u01/home/oracle/product/10.2.0';

$ENV{TNS_ADMIN} = '/home/httpd/cgi-bin/oradba';

my $sid = "ECLD.WORLD";

my $usr = "mania2";

my $pas = "blah";

my $dbh = DBI->connect("dbi:Oracle:tns:$sid", $usr, $pas) or die $DBI::errstr;





Output:



bash-2.03$ ./perl_testing1.pl

DBI->connect(tns:ECLD.WORLD) failed: ORA-12154: TNS:could not resolve the 
connect identifier specified (DBD: login failed) at ./perl_testing1.pl line 14

ORA-12154: TNS:could not resolve the connect identifier specified (DBD: login 
failed) at ./perl_testing1.pl line 14.

bash-2.03$





Arunkumar Mani

ITO Service Delivery Consultant

Database Engineering, BMS Account



arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com>

+91 80 338 59305  Office

+91 74062 71026  Mobile



Bangalore, Karnataka/India

hpe.com









-Original Message-
From: Howard, Chris [mailto:howa...@prpa.org]
Sent: Monday, August 8, 2016 7:55 PM
To: Mani, Arunkumar (BMS - India GDC) 
<arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com>>; Nelson, Erick 
<erick.nel...@hdsupply.com<mailto:erick.nel...@hdsupply.com>>; 
mohammed.must...@wipro.com<mailto:mohammed.must...@wipro.com>; 
dbi-users@perl.org<mailto:dbi-users@perl.org>
Subject: RE: ORA-12154 - (DBD: login failed)







ORACLE_HOME not defined correctly?



(I would test by printing out all ENV from within script)







-Original Message-

From: Mani, Arunkumar (BMS - India GDC) [mailto:arunkumar.m...@hpe.com]

Sent: Monday, August 08, 2016 5:38 AM

To: Nelson, Erick; 
mohammed.must...@wipro.com<mailto:mohammed.must...@wipro.com>; 
dbi-users@perl.org<mailto:dbi-users@perl.org>

Subject: RE: ORA-12154 - (DBD: login failed)



Instead of @, we define the connection string in TWO_TASK, and it 
still looks for tnsnames.ora or sqlnet.ora for resolution and it fails.



Arunkumar Mani

ITO Service Delivery Consultant

Database Engineering, BMS Account



arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com>

+91 80 338 59305  Office

RE: ORA-12154 - (DBD: login failed)

2016-08-09 Thread Mani, Arunkumar (BMS - India GDC) 
Yes.

Arunkumar Mani
ITO Service Delivery Consultant
Database Engineering, BMS Account

arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com>
+91 80 338 59305  Office
+91 74062 71026  Mobile

Bangalore, Karnataka/India
hpe.com

[hpesm_pri_grn_pos_email_06]

From: Howard, Chris [mailto:howa...@prpa.org]
Sent: Monday, August 8, 2016 9:29 PM
To: Mani, Arunkumar (BMS - India GDC) <arunkumar.m...@hpe.com>; Nelson, Erick 
<erick.nel...@hdsupply.com>; mohammed.must...@wipro.com; dbi-users@perl.org
Subject: RE: ORA-12154 - (DBD: login failed)

And tnsnames.ora under each ORACLE_HOME works good using sqlplus or other 
tools, yes?



From: Mani, Arunkumar (BMS - India GDC) [mailto:arunkumar.m...@hpe.com]
Sent: Monday, August 08, 2016 9:37 AM
To: Howard, Chris; Nelson, Erick; 
mohammed.must...@wipro.com<mailto:mohammed.must...@wipro.com>; 
dbi-users@perl.org<mailto:dbi-users@perl.org>
Subject: RE: ORA-12154 - (DBD: login failed)


I'll probably explain it with a piece of code and output, so everybody can 
explain the problem I face clearly.

If you look at 2 codes, the only change is I modified 8i client with 10g 
client. After that it couldn't resolve the TNS connection string.



Perl code with 8i client - works:



#!/usr/local/bin/perl



#use DBI

#use strict;

use strict;

use lib '/u01/home/oracle/admin/site/lib/perl';

use DBI;

$ENV{ORACLE_HOME} = '/u01/home/oracle/product/8.1.7.4';

$ENV{TNS_ADMIN} = '/home/httpd/cgi-bin/oradba';

my $sid = "ECLD.WORLD";

my $usr = "mania2";

my $pas = "blah";

my $dbh = DBI->connect("dbi:Oracle:tns:$sid", $usr, $pas) or die $DBI::errstr;



Output:



bash-2.03$ ./perl_testing1.pl

DBI->connect(tns:ECLD.WORLD) failed: ORA-01017: invalid username/password; 
logon denied (DBD: login failed) at ./perl_testing1.pl line 14

ORA-01017: invalid username/password; logon denied (DBD: login failed) at 
./perl_testing1.pl line 14.

bash-2.03$



Perl code with 10g client - not working:





#!/usr/local/bin/perl



#use DBI

#use strict;

use strict;

use lib '/u01/home/oracle/admin/site/lib/perl';

use DBI;

$ENV{ORACLE_HOME} = '/u01/home/oracle/product/10.2.0';

$ENV{TNS_ADMIN} = '/home/httpd/cgi-bin/oradba';

my $sid = "ECLD.WORLD";

my $usr = "mania2";

my $pas = "blah";

my $dbh = DBI->connect("dbi:Oracle:tns:$sid", $usr, $pas) or die $DBI::errstr;





Output:



bash-2.03$ ./perl_testing1.pl

DBI->connect(tns:ECLD.WORLD) failed: ORA-12154: TNS:could not resolve the 
connect identifier specified (DBD: login failed) at ./perl_testing1.pl line 14

ORA-12154: TNS:could not resolve the connect identifier specified (DBD: login 
failed) at ./perl_testing1.pl line 14.

bash-2.03$





Arunkumar Mani

ITO Service Delivery Consultant

Database Engineering, BMS Account



arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com>

+91 80 338 59305  Office

+91 74062 71026  Mobile



Bangalore, Karnataka/India

hpe.com









-Original Message-
From: Howard, Chris [mailto:howa...@prpa.org]
Sent: Monday, August 8, 2016 7:55 PM
To: Mani, Arunkumar (BMS - India GDC) 
<arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com>>; Nelson, Erick 
<erick.nel...@hdsupply.com<mailto:erick.nel...@hdsupply.com>>; 
mohammed.must...@wipro.com<mailto:mohammed.must...@wipro.com>; 
dbi-users@perl.org<mailto:dbi-users@perl.org>
Subject: RE: ORA-12154 - (DBD: login failed)







ORACLE_HOME not defined correctly?



(I would test by printing out all ENV from within script)







-Original Message-

From: Mani, Arunkumar (BMS - India GDC) [mailto:arunkumar.m...@hpe.com]

Sent: Monday, August 08, 2016 5:38 AM

To: Nelson, Erick; 
mohammed.must...@wipro.com<mailto:mohammed.must...@wipro.com>; 
dbi-users@perl.org<mailto:dbi-users@perl.org>

Subject: RE: ORA-12154 - (DBD: login failed)



Instead of @, we define the connection string in TWO_TASK, and it 
still looks for tnsnames.ora or sqlnet.ora for resolution and it fails.



Arunkumar Mani

ITO Service Delivery Consultant

Database Engineering, BMS Account



arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com>

+91 80 338 59305  Office

+91 74062 71026  Mobile



Bangalore, Karnataka/India

hpe.com







-Original Message-

From: Nelson, Erick [mailto:erick.nel...@hdsupply.com]

Sent: Monday, August 8, 2016 5:01 PM

To: Mani, Arunkumar (BMS - India GDC) 
<arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com>>; 
mohammed.must...@wipro.com<mailto:mohammed.must...@wipro.com>; 
dbi-users@perl.org<mailto:dbi-users@perl.org>

Subject: Re: ORA-12154 - (DBD: login failed)



Did you try TWO_TASK env var ?

<http://www.orafaq.com/wiki/TWO_TASK[orafaq.com]<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.orafaq.com_wiki_TWO-5FTASK=AwMFAg=J-N4xUQ7Pu4HLlwo2BifHA=7-NQstA5IqogNkXFIxVbHg=TfLVDxjcfuPnX0RcZg_ZNMw7NhNJLEbXfv1L7Ps2EgA

RE: ORA-12154 - (DBD: login failed)

2016-08-08 Thread Kevin Moore 
The problem I’m seeing here is you are using a "service name" when you should 
be using a SID. If the database name is ECLD, I would suggest dropping the 
.WORLD and retrying the connection where you have my $sid = "ECLD.WORLD";

Your sid setting should look like this: $sid = "ECLD";

The connect string should look something like this:

my $dbh = DBI->connect("dbi:Oracle:ecd", $usr, $pas) or die $DBI::errstr;

If you still have problems, feel free to post the tnsnames.ora file from the 
client with the host names removed and the listener.ora from the database 
server also with the hostnames removed.

For giggles, do a tnsping for ECLD.WORLD and post the results.

-Kevin

-Original Message-
From: Christopher Jones [mailto:christopher.jo...@oracle.com] 
Sent: Monday, August 08, 2016 7:07 PM
To: dbi-users@perl.org
Subject: Re: ORA-12154 - (DBD: login failed)


You can connect to 12c using 10gR2 client.

Chris

On 9/08/2016 12:40 AM, Mike Towery wrote:
> I don't think the 10G Oracle client works with Oracle 12.  Have you tried the 
> Oracle 12 client?
>
> On Mon, Aug 8, 2016 at 9:25 AM, Howard, Chris <howa...@prpa.org 
> <mailto:howa...@prpa.org>> wrote:
>
>
>
> ORACLE_HOME not defined correctly?
>
> (I would test by printing out all ENV from within script)
>
>
>
> -Original Message-
> From: Mani, Arunkumar (BMS - India GDC) [mailto:arunkumar.m...@hpe.com 
> <mailto:arunkumar.m...@hpe.com>]
> Sent: Monday, August 08, 2016 5:38 AM
> To: Nelson, Erick; mohammed.must...@wipro.com 
> <mailto:mohammed.must...@wipro.com>; dbi-users@perl.org 
> <mailto:dbi-users@perl.org>
> Subject: RE: ORA-12154 - (DBD: login failed)
>
> Instead of @, we define the connection string in TWO_TASK, 
> and it still looks for tnsnames.ora or sqlnet.ora for resolution and it fails.
>
> Arunkumar Mani
> ITO Service Delivery Consultant
> Database Engineering, BMS Account
>
> arunkumar.m...@hpe.com <mailto:arunkumar.m...@hpe.com>
> +91 80 338 59305 <tel:%2B91%2080%20338%2059305>  Office
> +91 74062 71026 <tel:%2B91%2074062%2071026>  Mobile
>
> Bangalore, Karnataka/India
> hpe.com <http://hpe.com>
>
>
>
> -Original Message-
> From: Nelson, Erick [mailto:erick.nel...@hdsupply.com 
> <mailto:erick.nel...@hdsupply.com>]
> Sent: Monday, August 8, 2016 5:01 PM
> To: Mani, Arunkumar (BMS - India GDC) <arunkumar.m...@hpe.com 
> <mailto:arunkumar.m...@hpe.com>>; mohammed.must...@wipro.com
> <mailto:mohammed.must...@wipro.com>; dbi-users@perl.org 
> <mailto:dbi-users@perl.org>
> Subject: Re: ORA-12154 - (DBD: login failed)
>
> Did you try TWO_TASK env var ?
> <http://www.orafaq.com/wiki/TWO_TASK 
> <http://www.orafaq.com/wiki/TWO_TASK>>
> <http://www.orafaq.com/wiki/TWO_TASK 
> <http://www.orafaq.com/wiki/TWO_TASK>>
>
>
> Erick Nelson
> Cell 858-740-6523 
> Home 760-930-0461 
>
>
> From: "Mani, Arunkumar (BMS - India GDC)" <arunkumar.m...@hpe.com 
> <mailto:arunkumar.m...@hpe.com><mailto:arunkumar.m...@hpe.com
> <mailto:arunkumar.m...@hpe.com>>>
> Date: Monday, August 8, 2016 at 1:14 AM
> To: "mohammed.must...@wipro.com 
> <mailto:mohammed.must...@wipro.com><mailto:mohammed.must...@wipro.com 
> <mailto:mohammed.must...@wipro.com>>"
>     <mohammed.must...@wipro.com 
> <mailto:mohammed.must...@wipro.com><mailto:mohammed.must...@wipro.com 
> <mailto:mohammed.must...@wipro.com>>>,
> "dbi-users@perl.org <mailto:dbi-users@perl.org><mailto:dbi-users@perl.org 
> <mailto:dbi-users@perl.org>>" <dbi-users@perl.org
> <mailto:dbi-users@perl.org><mailto:dbi-users@perl.org 
> <mailto:dbi-users@perl.org>>>
> Subject: RE: ORA-12154 - (DBD: login failed)
>
> All were done earlier. The problem is perl doesn't recognize my 
> sqlnet.ora or tnsnames.ora, though I define TNS_ADMIN correctly in the script.
> Note: This was working when we used Oracle 8 client.
>
> Arunkumar Mani
> ITO Service Delivery Consultant
> Database Engineering, BMS Account
>
> arunkumar.m...@hpe.com 
> <mailto:arunkumar.m...@hpe.com><mailto:arunkumar.m...@hpe.com 
> <mailto:arunkumar.m...@hpe.com>>
> +91 80 338 59305 <tel:%2B91%2080%20338%2059305>  Office
> +91 74062 71026 <tel:%2B91%2074062%2071026>  Mobile
>
> Bangalore, Karnataka/India
> hpe.com <http://hpe.com>
>
>     [hpesm_pri_grn_pos_email

Re: ORA-12154 - (DBD: login failed)

2016-08-08 Thread Christopher Jones 
You possibly need to bring your 10g client up to date with patches so authentication succeeds; I've seen similar things in the past.  But, in general, 
why use 10g client if you are connecting to 12c?  You may as well use the 12c client.


I forget whether 8i used service names or only the old "SID" names, but check you are using the correct tnsnames.ora syntax if you have upgraded the 
oracle client.


Chris

On 9/08/2016 1:36 AM, Mani, Arunkumar (BMS - India GDC) wrote:


I'll probably explain it with a piece of code and output, so everybody can 
explain the problem I face clearly.

If you look at 2 codes, the only change is I modified 8i client with 10g 
client. After that it couldn’t resolve the TNS connection string.

_Perl code with 8i client - works:_

#!/usr/local/bin/perl

#use DBI

#use strict;

use strict;

use lib '/u01/home/oracle/admin/site/lib/perl';

use DBI;

$ENV{ORACLE_HOME} = '/u01/home/oracle/product/8.1.7.4';

$ENV{TNS_ADMIN} = '/home/httpd/cgi-bin/oradba';

my $sid = "ECLD.WORLD";

my $usr = "mania2";

my $pas = "blah";

my $dbh = DBI->connect("dbi:Oracle:tns:$sid", $usr, $pas) or die $DBI::errstr;

Output:

bash-2.03$ ./perl_testing1.pl

DBI->connect(tns:ECLD.WORLD) failed: ORA-01017: invalid username/password; 
logon denied (DBD: login failed) at ./perl_testing1.pl line 14

ORA-01017: invalid username/password; logon denied (DBD: login failed) at 
./perl_testing1.pl line 14.

bash-2.03$

_Perl code with 10g client - not working:_

#!/usr/local/bin/perl

#use DBI

#use strict;

use strict;

use lib '/u01/home/oracle/admin/site/lib/perl';

use DBI;

$ENV{ORACLE_HOME} = '/u01/home/oracle/product/10.2.0';

$ENV{TNS_ADMIN} = '/home/httpd/cgi-bin/oradba';

my $sid = "ECLD.WORLD";

my $usr = "mania2";

my $pas = "blah";

my $dbh = DBI->connect("dbi:Oracle:tns:$sid", $usr, $pas) or die $DBI::errstr;

Output:

bash-2.03$ ./perl_testing1.pl

DBI->connect(tns:ECLD.WORLD) failed: ORA-12154: TNS:could not resolve the 
connect identifier specified (DBD: login failed) at ./perl_testing1.pl line 14

ORA-12154: TNS:could not resolve the connect identifier specified (DBD: login 
failed) at ./perl_testing1.pl line 14.

bash-2.03$

Arunkumar Mani

ITO Service Delivery Consultant

Database Engineering, BMS Account

arunkumar.m...@hpe.com

+91 80 338 59305  Office

+91 74062 71026  Mobile

Bangalore, Karnataka/India

hpe.com

-Original Message-
From: Howard, Chris [mailto:howa...@prpa.org]
Sent: Monday, August 8, 2016 7:55 PM
To: Mani, Arunkumar (BMS - India GDC) <arunkumar.m...@hpe.com>; Nelson, Erick <erick.nel...@hdsupply.com>; mohammed.must...@wipro.com; 
dbi-users@perl.org

Subject: RE: ORA-12154 - (DBD: login failed)

ORACLE_HOME not defined correctly?

(I would test by printing out all ENV from within script)

-Original Message-

From: Mani, Arunkumar (BMS - India GDC) [mailto:arunkumar.m...@hpe.com]

Sent: Monday, August 08, 2016 5:38 AM

To: Nelson, Erick; mohammed.must...@wipro.com <mailto:mohammed.must...@wipro.com>; 
dbi-users@perl.org <mailto:dbi-users@perl.org>

Subject: RE: ORA-12154 - (DBD: login failed)

Instead of @, we define the connection string in TWO_TASK, and it 
still looks for tnsnames.ora or sqlnet.ora for resolution and it fails.

Arunkumar Mani

ITO Service Delivery Consultant

Database Engineering, BMS Account

arunkumar.m...@hpe.com <mailto:arunkumar.m...@hpe.com>

+91 80 338 59305  Office

+91 74062 71026  Mobile

Bangalore, Karnataka/India

hpe.com

-Original Message-

From: Nelson, Erick [mailto:erick.nel...@hdsupply.com]

Sent: Monday, August 8, 2016 5:01 PM

To: Mani, Arunkumar (BMS - India GDC) <arunkumar.m...@hpe.com <mailto:arunkumar.m...@hpe.com>>; mohammed.must...@wipro.com 
<mailto:mohammed.must...@wipro.com>; dbi-users@perl.org <mailto:dbi-users@perl.org>


Subject: Re: ORA-12154 - (DBD: login failed)

Did you try TWO_TASK env var ?

<http://www.orafaq.com/wiki/TWO_TASK>

<http://www.orafaq.com/wiki/TWO_TASK>

Erick Nelson

Cell 858-740-6523

Home 760-930-0461

From: "Mani, Arunkumar (BMS - India GDC)" <arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com 
<mailto:arunkumar.m...@hpe.com%3cmailto:arunkumar.m...@hpe.com>>>


Date: Monday, August 8, 2016 at 1:14 AM

To: "mohammed.must...@wipro.com<mailto:mohammed.must...@wipro.com> <mailto:mohammed.must...@wipro.com%3cmailto:mohammed.must...@wipro.com%3e>" 
<mohammed.must...@wipro.com<mailto:mohammed.must...@wipro.com <mailto:mohammed.must...@wipro.com%3cmailto:mohammed.must...@wipro.com>>>, 
"dbi-users@perl.org<mailto:dbi-users@perl.org> <mailto:dbi-users@perl.org%3cmailto:dbi-users@perl.org%3e>" 
<dbi-users@perl.org<mailto:dbi-users@perl.org <mailto:dbi-users@perl.org%3cmailto:dbi-users@perl.org>>>


Subject: RE: ORA

Re: ORA-12154 - (DBD: login failed)

2016-08-08 Thread Christopher Jones 


DBD::Oracle uses Oracle's OCI not JDBC.
The official OCI Support matrix is Document #207303.1 (for those with MOS 
access).

Chris

On 9/08/2016 1:07 AM, Mike Towery wrote:

*Which version of JDBC drivers support which version of Oracle database?*

Please refer to the table below for the Oracle database versions supported by JDBC drivers. Best Practice that we recommend is, JDBC driver version 
should always be either same as or higher than the Oracle database version being used in order to leverage the latest capabilities of the JDBC driver.


*Interoperability Matrix*   *Database 12.1.0.x* *Database 11.2.0.x* 
*Database 11.1.0.x*
*JDBC 12.1.0.x* 
/Yes/

/Yes/

/Yes/
*JDBC 11.2.0.x* 
/Yes/

/Yes/

/Yes/
*JDBC 11.1.0.x* 
/Yes/

/Yes/

/Yes/


--
*What are the various supported Oracle database version vs JDBC compliant 
versions vs JDK version supported?

*The table below mentions the supported Oracle database versions, equivalent  supported JDK versions, JDBC version compliant to in each of the 
releases and also mentions the JDBC jar file names which need to be used for specific releases.

*Oracle Database version
*   *JDK Version supported
*   *JDBC specification compliance
*   *JDBC Jar files specific to the release*
12.1 or 12cR1   JDK8, JDK 7 & JDK 6 JDBC 4.1 in the JDK 8 & JDK 7 
drivers
JDBC 4.0 in the JDK 6 drivers   ojdbc7.jar for JDK 8 and JDK 7
ojdbc6.jar for JDK 6
11.2 or 11gR2   JDK 6 & JDK 5
JDK 7 & JDK 8 supported in 11.2.0.3 and 11.2.0.4JDBC 4.0 in the JDK 6 
drivers
JDBC 3.0 in the JDK 5 drivers   ojdbc6.jar for JDK 8, JDK 7 and JDK 6.
ojdbc5.jar for JDK 5
11.1 or 11gR1   JDK 6 & JDK 5   JDBC 4.0 in the JDK 6 drivers   JDBC 
3.0 in the JDK 5 drivers   ojdbc6.jar for JDK 6
ojdbc5.jar for JDK 5



Reference: http://www.oracle.com/technetwork/topics/jdbc-faq-090281.html



--

On Mon, Aug 8, 2016 at 9:40 AM, Mike Towery <mtow...@gmail.com 
<mailto:mtow...@gmail.com>> wrote:

I don't think the 10G Oracle client works with Oracle 12.  Have you tried 
the Oracle 12 client?

On Mon, Aug 8, 2016 at 9:25 AM, Howard, Chris <howa...@prpa.org 
<mailto:howa...@prpa.org>> wrote:



ORACLE_HOME not defined correctly?

(I would test by printing out all ENV from within script)



-Original Message-
From: Mani, Arunkumar (BMS - India GDC) [mailto:arunkumar.m...@hpe.com 
<mailto:arunkumar.m...@hpe.com>]
Sent: Monday, August 08, 2016 5:38 AM
To: Nelson, Erick; mohammed.must...@wipro.com 
<mailto:mohammed.must...@wipro.com>; dbi-users@perl.org 
<mailto:dbi-users@perl.org>
Subject: RE: ORA-12154 - (DBD: login failed)

Instead of @, we define the connection string in TWO_TASK, 
and it still looks for tnsnames.ora or sqlnet.ora for resolution and
it fails.

Arunkumar Mani
ITO Service Delivery Consultant
Database Engineering, BMS Account

arunkumar.m...@hpe.com <mailto:arunkumar.m...@hpe.com>
+91 80 338 59305 <tel:%2B91%2080%20338%2059305>  Office
+91 74062 71026 <tel:%2B91%2074062%2071026>  Mobile

Bangalore, Karnataka/India
hpe.com <http://hpe.com>



-Original Message-
From: Nelson, Erick [mailto:erick.nel...@hdsupply.com 
<mailto:erick.nel...@hdsupply.com>]
Sent: Monday, August 8, 2016 5:01 PM
To: Mani, Arunkumar (BMS - India GDC) <arunkumar.m...@hpe.com 
<mailto:arunkumar.m...@hpe.com>>; mohammed.must...@wipro.com
    <mailto:mohammed.must...@wipro.com>; dbi-users@perl.org 
<mailto:dbi-users@perl.org>
Subject: Re: ORA-12154 - (DBD: login failed)

Did you try TWO_TASK env var ?
<http://www.orafaq.com/wiki/TWO_TASK 
<http://www.orafaq.com/wiki/TWO_TASK>>
<http://www.orafaq.com/wiki/TWO_TASK 
<http://www.orafaq.com/wiki/TWO_TASK>>


Erick Nelson
Cell 858-740-6523 
Home 760-930-0461 


From: "Mani, Arunkumar (BMS - India GDC)" <arunkumar.m...@hpe.com 
<mailto:arunkumar.m...@hpe.com><mailto:arunkumar.m...@hpe.com
<mailto:arunkumar.m...@hpe.com>>>
Date: Monday, August 8, 2016 at 1:14 AM
To: "mohammed.must...@wipro.com 
<mailto:mohammed.must...@wipro.com><mailto:mohammed.must...@wipro.com 
<mailto:mohammed.must...@wipro.com>>"
<mohammed.must...@wipro.com 
<mailto:mohammed.must...@wipro.com><mailto:mohammed.mu

Re: ORA-12154 - (DBD: login failed)

2016-08-08 Thread Christopher Jones 


You can connect to 12c using 10gR2 client.

Chris

On 9/08/2016 12:40 AM, Mike Towery wrote:

I don't think the 10G Oracle client works with Oracle 12.  Have you tried the 
Oracle 12 client?

On Mon, Aug 8, 2016 at 9:25 AM, Howard, Chris <howa...@prpa.org 
<mailto:howa...@prpa.org>> wrote:



ORACLE_HOME not defined correctly?

(I would test by printing out all ENV from within script)



-Original Message-
From: Mani, Arunkumar (BMS - India GDC) [mailto:arunkumar.m...@hpe.com 
<mailto:arunkumar.m...@hpe.com>]
Sent: Monday, August 08, 2016 5:38 AM
To: Nelson, Erick; mohammed.must...@wipro.com 
<mailto:mohammed.must...@wipro.com>; dbi-users@perl.org 
<mailto:dbi-users@perl.org>
    Subject: RE: ORA-12154 - (DBD: login failed)

Instead of @, we define the connection string in TWO_TASK, and 
it still looks for tnsnames.ora or sqlnet.ora for resolution and it fails.

Arunkumar Mani
ITO Service Delivery Consultant
Database Engineering, BMS Account

arunkumar.m...@hpe.com <mailto:arunkumar.m...@hpe.com>
+91 80 338 59305 <tel:%2B91%2080%20338%2059305>  Office
+91 74062 71026 <tel:%2B91%2074062%2071026>  Mobile

Bangalore, Karnataka/India
hpe.com <http://hpe.com>



-Original Message-
From: Nelson, Erick [mailto:erick.nel...@hdsupply.com 
<mailto:erick.nel...@hdsupply.com>]
Sent: Monday, August 8, 2016 5:01 PM
To: Mani, Arunkumar (BMS - India GDC) <arunkumar.m...@hpe.com 
<mailto:arunkumar.m...@hpe.com>>; mohammed.must...@wipro.com
<mailto:mohammed.must...@wipro.com>; dbi-users@perl.org 
<mailto:dbi-users@perl.org>
Subject: Re: ORA-12154 - (DBD: login failed)

Did you try TWO_TASK env var ?
<http://www.orafaq.com/wiki/TWO_TASK <http://www.orafaq.com/wiki/TWO_TASK>>
<http://www.orafaq.com/wiki/TWO_TASK <http://www.orafaq.com/wiki/TWO_TASK>>


Erick Nelson
Cell 858-740-6523 
Home 760-930-0461 


From: "Mani, Arunkumar (BMS - India GDC)" <arunkumar.m...@hpe.com 
<mailto:arunkumar.m...@hpe.com><mailto:arunkumar.m...@hpe.com
<mailto:arunkumar.m...@hpe.com>>>
Date: Monday, August 8, 2016 at 1:14 AM
To: "mohammed.must...@wipro.com 
<mailto:mohammed.must...@wipro.com><mailto:mohammed.must...@wipro.com 
<mailto:mohammed.must...@wipro.com>>"
<mohammed.must...@wipro.com 
<mailto:mohammed.must...@wipro.com><mailto:mohammed.must...@wipro.com 
<mailto:mohammed.must...@wipro.com>>>,
"dbi-users@perl.org <mailto:dbi-users@perl.org><mailto:dbi-users@perl.org 
<mailto:dbi-users@perl.org>>" <dbi-users@perl.org
<mailto:dbi-users@perl.org><mailto:dbi-users@perl.org 
<mailto:dbi-users@perl.org>>>
Subject: RE: ORA-12154 - (DBD: login failed)

All were done earlier. The problem is perl doesn't recognize my sqlnet.ora 
or tnsnames.ora, though I define TNS_ADMIN correctly in the script.
Note: This was working when we used Oracle 8 client.

Arunkumar Mani
ITO Service Delivery Consultant
Database Engineering, BMS Account

arunkumar.m...@hpe.com <mailto:arunkumar.m...@hpe.com><mailto:arunkumar.m...@hpe.com 
<mailto:arunkumar.m...@hpe.com>>
+91 80 338 59305 <tel:%2B91%2080%20338%2059305>  Office
+91 74062 71026 <tel:%2B91%2074062%2071026>  Mobile

Bangalore, Karnataka/India
hpe.com <http://hpe.com>

[hpesm_pri_grn_pos_email_06]

From: mohammed.must...@wipro.com 
<mailto:mohammed.must...@wipro.com><mailto:mohammed.must...@wipro.com 
<mailto:mohammed.must...@wipro.com>>
[mailto:mohammed.must...@wipro.com <mailto:mohammed.must...@wipro.com>]
Sent: Thursday, August 4, 2016 8:53 PM
To: Mani, Arunkumar (BMS - India GDC) <arunkumar.m...@hpe.com 
<mailto:arunkumar.m...@hpe.com><mailto:arunkumar.m...@hpe.com
<mailto:arunkumar.m...@hpe.com>>>; dbi-users@perl.org 
<mailto:dbi-users@perl.org><mailto:dbi-users@perl.org <mailto:dbi-users@perl.org>>
Subject: Re: ORA-12154 - (DBD: login failed)




Testing: Manually, try connecting to DB using current .ora file content.





Solution:  update .ora file with right
Ip:
Port:
Sid/service name:




Regards,
Mustafa
+44-7440 56 12 32 <tel:%2B44-7440%2056%2012%2032>


From: Mani, Arunkumar (BMS - India GDC) <arunkumar.m...@hpe.com 
<mailto:arunkumar.m...@hpe.com><mailto:arunkumar.m...@hpe.com
<mailto:arunkumar.m...@hpe.com>>>
Sent: Thursday, August 4, 2016 8:41 PM
To: dbi-users@perl.org <mailto:dbi-users@perl.org><mailto:dbi-users@perl.org 
<mailto:dbi-users@perl.org>>
Subject: ORA-12154 - (DBD: login failed)

RE: ORA-12154 - (DBD: login failed)

2016-08-08 Thread Howard, Chris 
And tnsnames.ora under each ORACLE_HOME works good using sqlplus or other 
tools, yes?



From: Mani, Arunkumar (BMS - India GDC) [mailto:arunkumar.m...@hpe.com]
Sent: Monday, August 08, 2016 9:37 AM
To: Howard, Chris; Nelson, Erick; mohammed.must...@wipro.com; dbi-users@perl.org
Subject: RE: ORA-12154 - (DBD: login failed)


I'll probably explain it with a piece of code and output, so everybody can 
explain the problem I face clearly.

If you look at 2 codes, the only change is I modified 8i client with 10g 
client. After that it couldn't resolve the TNS connection string.



Perl code with 8i client - works:



#!/usr/local/bin/perl



#use DBI

#use strict;

use strict;

use lib '/u01/home/oracle/admin/site/lib/perl';

use DBI;

$ENV{ORACLE_HOME} = '/u01/home/oracle/product/8.1.7.4';

$ENV{TNS_ADMIN} = '/home/httpd/cgi-bin/oradba';

my $sid = "ECLD.WORLD";

my $usr = "mania2";

my $pas = "blah";

my $dbh = DBI->connect("dbi:Oracle:tns:$sid", $usr, $pas) or die $DBI::errstr;



Output:



bash-2.03$ ./perl_testing1.pl

DBI->connect(tns:ECLD.WORLD) failed: ORA-01017: invalid username/password; 
logon denied (DBD: login failed) at ./perl_testing1.pl line 14

ORA-01017: invalid username/password; logon denied (DBD: login failed) at 
./perl_testing1.pl line 14.

bash-2.03$



Perl code with 10g client - not working:





#!/usr/local/bin/perl



#use DBI

#use strict;

use strict;

use lib '/u01/home/oracle/admin/site/lib/perl';

use DBI;

$ENV{ORACLE_HOME} = '/u01/home/oracle/product/10.2.0';

$ENV{TNS_ADMIN} = '/home/httpd/cgi-bin/oradba';

my $sid = "ECLD.WORLD";

my $usr = "mania2";

my $pas = "blah";

my $dbh = DBI->connect("dbi:Oracle:tns:$sid", $usr, $pas) or die $DBI::errstr;





Output:



bash-2.03$ ./perl_testing1.pl

DBI->connect(tns:ECLD.WORLD) failed: ORA-12154: TNS:could not resolve the 
connect identifier specified (DBD: login failed) at ./perl_testing1.pl line 14

ORA-12154: TNS:could not resolve the connect identifier specified (DBD: login 
failed) at ./perl_testing1.pl line 14.

bash-2.03$





Arunkumar Mani

ITO Service Delivery Consultant

Database Engineering, BMS Account



arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com>

+91 80 338 59305  Office

+91 74062 71026  Mobile



Bangalore, Karnataka/India

hpe.com









-Original Message-
From: Howard, Chris [mailto:howa...@prpa.org]
Sent: Monday, August 8, 2016 7:55 PM
To: Mani, Arunkumar (BMS - India GDC) 
<arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com>>; Nelson, Erick 
<erick.nel...@hdsupply.com<mailto:erick.nel...@hdsupply.com>>; 
mohammed.must...@wipro.com<mailto:mohammed.must...@wipro.com>; 
dbi-users@perl.org<mailto:dbi-users@perl.org>
Subject: RE: ORA-12154 - (DBD: login failed)







ORACLE_HOME not defined correctly?



(I would test by printing out all ENV from within script)







-Original Message-

From: Mani, Arunkumar (BMS - India GDC) [mailto:arunkumar.m...@hpe.com]

Sent: Monday, August 08, 2016 5:38 AM

To: Nelson, Erick; 
mohammed.must...@wipro.com<mailto:mohammed.must...@wipro.com>; 
dbi-users@perl.org<mailto:dbi-users@perl.org>

Subject: RE: ORA-12154 - (DBD: login failed)



Instead of @, we define the connection string in TWO_TASK, and it 
still looks for tnsnames.ora or sqlnet.ora for resolution and it fails.



Arunkumar Mani

ITO Service Delivery Consultant

Database Engineering, BMS Account



arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com>

+91 80 338 59305  Office

+91 74062 71026  Mobile



Bangalore, Karnataka/India

hpe.com







-Original Message-

From: Nelson, Erick [mailto:erick.nel...@hdsupply.com]

Sent: Monday, August 8, 2016 5:01 PM

To: Mani, Arunkumar (BMS - India GDC) 
<arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com>>; 
mohammed.must...@wipro.com<mailto:mohammed.must...@wipro.com>; 
dbi-users@perl.org<mailto:dbi-users@perl.org>

Subject: Re: ORA-12154 - (DBD: login failed)



Did you try TWO_TASK env var ?

<http://www.orafaq.com/wiki/TWO_TASK[orafaq.com]<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.orafaq.com_wiki_TWO-5FTASK=AwMFAg=J-N4xUQ7Pu4HLlwo2BifHA=7-NQstA5IqogNkXFIxVbHg=TfLVDxjcfuPnX0RcZg_ZNMw7NhNJLEbXfv1L7Ps2EgA=LmP3xCjCbYAJUU34ahUes_MUBhkRqsHFQdRdWsng2ZA=>>

<http://www.orafaq.com/wiki/TWO_TASK[orafaq.com]<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.orafaq.com_wiki_TWO-5FTASK=AwMFAg=J-N4xUQ7Pu4HLlwo2BifHA=7-NQstA5IqogNkXFIxVbHg=TfLVDxjcfuPnX0RcZg_ZNMw7NhNJLEbXfv1L7Ps2EgA=LmP3xCjCbYAJUU34ahUes_MUBhkRqsHFQdRdWsng2ZA=>>





Erick Nelson

Cell 858-740-6523

Home 760-930-0461





From: "Mani, Arunkumar (BMS - India GDC)" 
<arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com%3cmailto:arunkumar.m...@hpe.com>>>

Date: Monday, August 8, 2016 at 1:14 AM

Re: ORA-12154 - (DBD: login failed)

2016-08-08 Thread John D Groenveld 
In message , "Mani, Arunkumar (BMS - India GDC)" writes:
>I'll probably explain it with a piece of code and output, so everybody can =
>explain the problem I face clearly.

Assuming that you've confirmed Oracle's tools in your new ORACLE_HOME
can connect to your instances, I doubt you rebuilt DBD::Oracle
when you changed ORACLE_HOME.

John
groenv...@acm.org

RE: ORA-12154 - (DBD: login failed)

2016-08-08 Thread Mani, Arunkumar (BMS - India GDC) 
I'll probably explain it with a piece of code and output, so everybody can 
explain the problem I face clearly.

If you look at 2 codes, the only change is I modified 8i client with 10g 
client. After that it couldn't resolve the TNS connection string.



Perl code with 8i client - works:



#!/usr/local/bin/perl



#use DBI

#use strict;

use strict;

use lib '/u01/home/oracle/admin/site/lib/perl';

use DBI;

$ENV{ORACLE_HOME} = '/u01/home/oracle/product/8.1.7.4';

$ENV{TNS_ADMIN} = '/home/httpd/cgi-bin/oradba';

my $sid = "ECLD.WORLD";

my $usr = "mania2";

my $pas = "blah";

my $dbh = DBI->connect("dbi:Oracle:tns:$sid", $usr, $pas) or die $DBI::errstr;



Output:



bash-2.03$ ./perl_testing1.pl

DBI->connect(tns:ECLD.WORLD) failed: ORA-01017: invalid username/password; 
logon denied (DBD: login failed) at ./perl_testing1.pl line 14

ORA-01017: invalid username/password; logon denied (DBD: login failed) at 
./perl_testing1.pl line 14.

bash-2.03$



Perl code with 10g client - not working:





#!/usr/local/bin/perl



#use DBI

#use strict;

use strict;

use lib '/u01/home/oracle/admin/site/lib/perl';

use DBI;

$ENV{ORACLE_HOME} = '/u01/home/oracle/product/10.2.0';

$ENV{TNS_ADMIN} = '/home/httpd/cgi-bin/oradba';

my $sid = "ECLD.WORLD";

my $usr = "mania2";

my $pas = "blah";

my $dbh = DBI->connect("dbi:Oracle:tns:$sid", $usr, $pas) or die $DBI::errstr;





Output:



bash-2.03$ ./perl_testing1.pl

DBI->connect(tns:ECLD.WORLD) failed: ORA-12154: TNS:could not resolve the 
connect identifier specified (DBD: login failed) at ./perl_testing1.pl line 14

ORA-12154: TNS:could not resolve the connect identifier specified (DBD: login 
failed) at ./perl_testing1.pl line 14.

bash-2.03$





Arunkumar Mani

ITO Service Delivery Consultant

Database Engineering, BMS Account



arunkumar.m...@hpe.com

+91 80 338 59305  Office

+91 74062 71026  Mobile



Bangalore, Karnataka/India

hpe.com









-Original Message-
From: Howard, Chris [mailto:howa...@prpa.org]
Sent: Monday, August 8, 2016 7:55 PM
To: Mani, Arunkumar (BMS - India GDC) <arunkumar.m...@hpe.com>; Nelson, Erick 
<erick.nel...@hdsupply.com>; mohammed.must...@wipro.com; dbi-users@perl.org
Subject: RE: ORA-12154 - (DBD: login failed)







ORACLE_HOME not defined correctly?



(I would test by printing out all ENV from within script)







-Original Message-

From: Mani, Arunkumar (BMS - India GDC) [mailto:arunkumar.m...@hpe.com]

Sent: Monday, August 08, 2016 5:38 AM

To: Nelson, Erick; 
mohammed.must...@wipro.com<mailto:mohammed.must...@wipro.com>; 
dbi-users@perl.org<mailto:dbi-users@perl.org>

Subject: RE: ORA-12154 - (DBD: login failed)



Instead of @, we define the connection string in TWO_TASK, and it 
still looks for tnsnames.ora or sqlnet.ora for resolution and it fails.



Arunkumar Mani

ITO Service Delivery Consultant

Database Engineering, BMS Account



arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com>

+91 80 338 59305  Office

+91 74062 71026  Mobile



Bangalore, Karnataka/India

hpe.com







-Original Message-

From: Nelson, Erick [mailto:erick.nel...@hdsupply.com]

Sent: Monday, August 8, 2016 5:01 PM

To: Mani, Arunkumar (BMS - India GDC) 
<arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com>>; 
mohammed.must...@wipro.com<mailto:mohammed.must...@wipro.com>; 
dbi-users@perl.org<mailto:dbi-users@perl.org>

Subject: Re: ORA-12154 - (DBD: login failed)



Did you try TWO_TASK env var ?

<http://www.orafaq.com/wiki/TWO_TASK>

<http://www.orafaq.com/wiki/TWO_TASK>





Erick Nelson

Cell 858-740-6523

Home 760-930-0461





From: "Mani, Arunkumar (BMS - India GDC)" 
<arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com%3cmailto:arunkumar.m...@hpe.com>>>

Date: Monday, August 8, 2016 at 1:14 AM

To: 
"mohammed.must...@wipro.com<mailto:mohammed.must...@wipro.com><mailto:mohammed.must...@wipro.com%3cmailto:mohammed.must...@wipro.com%3e>"
 
<mohammed.must...@wipro.com<mailto:mohammed.must...@wipro.com<mailto:mohammed.must...@wipro.com%3cmailto:mohammed.must...@wipro.com>>>,
 
"dbi-users@perl.org<mailto:dbi-users@perl.org><mailto:dbi-users@perl.org%3cmailto:dbi-users@perl.org%3e>"
 
<dbi-users@perl.org<mailto:dbi-users@perl.org<mailto:dbi-users@perl.org%3cmailto:dbi-users@perl.org>>>

Subject: RE: ORA-12154 - (DBD: login failed)



All were done earlier. The problem is perl doesn't recognize my sqlnet.ora or 
tnsnames.ora, though I define TNS_ADMIN correctly in the script.

Note: This was working when we used Oracle 8 client.



Arunkumar Mani

ITO Service Delivery Consultant

Database Engineering, BMS Account



arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com%3cmailto:arunku

Re: ORA-12154 - (DBD: login failed)

2016-08-08 Thread Mike Towery 
*Which version of JDBC drivers support which version of Oracle database?*

Please refer to the table below for the Oracle database versions supported
by JDBC drivers.  Best Practice that we recommend is, JDBC driver version
should always be either same as or higher than the Oracle database version
being used in order to leverage the latest capabilities of the JDBC driver.

*Interoperability Matrix* *Database 12.1.0.x* *Database 11.2.0.x* *Database
11.1.0.x*
*JDBC 12.1.0.x*
*Yes*
*Yes*
*Yes*
*JDBC 11.2.0.x*
*Yes*
*Yes*
*Yes*
*JDBC 11.1.0.x*
*Yes*
*Yes*
*Yes*



--


*What are the various supported Oracle database version vs JDBC compliant
versions vs JDK version supported? *The table below mentions the supported
Oracle database versions, equivalent  supported JDK versions, JDBC version
compliant to in each of the releases and also mentions the JDBC jar file
names which need to be used for specific releases.


*Oracle Database version*
*JDK Version supported*
*JDBC specification compliance* *JDBC Jar files specific to the release*
12.1 or 12cR1 JDK8, JDK 7 & JDK 6 JDBC 4.1 in the JDK 8 & JDK 7 drivers
JDBC 4.0 in the JDK 6 drivers ojdbc7.jar for JDK 8 and JDK 7
ojdbc6.jar for JDK 6
11.2 or 11gR2 JDK 6 & JDK 5
JDK 7 & JDK 8 supported in 11.2.0.3 and 11.2.0.4 JDBC 4.0 in the JDK 6
drivers
JDBC 3.0 in the JDK 5 drivers ojdbc6.jar for JDK 8, JDK 7 and JDK 6.
ojdbc5.jar for JDK 5
11.1 or 11gR1 JDK 6 & JDK 5 JDBC 4.0 in the JDK 6 drivers   JDBC 3.0 in
the JDK 5 drivers ojdbc6.jar for JDK 6
ojdbc5.jar for JDK 5



Reference:  http://www.oracle.com/technetwork/topics/jdbc-faq-090281.html



--

On Mon, Aug 8, 2016 at 9:40 AM, Mike Towery <mtow...@gmail.com> wrote:

> I don't think the 10G Oracle client works with Oracle 12.  Have you tried
> the Oracle 12 client?
>
> On Mon, Aug 8, 2016 at 9:25 AM, Howard, Chris <howa...@prpa.org> wrote:
>
>>
>>
>> ORACLE_HOME not defined correctly?
>>
>> (I would test by printing out all ENV from within script)
>>
>>
>>
>> -Original Message-
>> From: Mani, Arunkumar (BMS - India GDC) [mailto:arunkumar.m...@hpe.com]
>> Sent: Monday, August 08, 2016 5:38 AM
>> To: Nelson, Erick; mohammed.must...@wipro.com; dbi-users@perl.org
>> Subject: RE: ORA-12154 - (DBD: login failed)
>>
>> Instead of @, we define the connection string in TWO_TASK,
>> and it still looks for tnsnames.ora or sqlnet.ora for resolution and it
>> fails.
>>
>> Arunkumar Mani
>> ITO Service Delivery Consultant
>> Database Engineering, BMS Account
>>
>> arunkumar.m...@hpe.com
>> +91 80 338 59305  Office
>> +91 74062 71026  Mobile
>>
>> Bangalore, Karnataka/India
>> hpe.com
>>
>>
>>
>> -Original Message-----
>> From: Nelson, Erick [mailto:erick.nel...@hdsupply.com]
>> Sent: Monday, August 8, 2016 5:01 PM
>> To: Mani, Arunkumar (BMS - India GDC) <arunkumar.m...@hpe.com>;
>> mohammed.must...@wipro.com; dbi-users@perl.org
>> Subject: Re: ORA-12154 - (DBD: login failed)
>>
>> Did you try TWO_TASK env var ?
>> <http://www.orafaq.com/wiki/TWO_TASK>
>> <http://www.orafaq.com/wiki/TWO_TASK>
>>
>>
>> Erick Nelson
>> Cell 858-740-6523
>> Home 760-930-0461
>>
>>
>> From: "Mani, Arunkumar (BMS - India GDC)" <arunkumar.m...@hpe.com> arunkumar.m...@hpe.com>>
>> Date: Monday, August 8, 2016 at 1:14 AM
>> To: "mohammed.must...@wipro.com<mailto:mohammed.must...@wipro.com>" <
>> mohammed.must...@wipro.com<mailto:mohammed.must...@wipro.com>>, "
>> dbi-users@perl.org<mailto:dbi-users@perl.org>" <dbi-users@perl.org
>> <mailto:dbi-users@perl.org>>
>> Subject: RE: ORA-12154 - (DBD: login failed)
>>
>> All were done earlier. The problem is perl doesn't recognize my
>> sqlnet.ora or tnsnames.ora, though I define TNS_ADMIN correctly in the
>> script.
>> Note: This was working when we used Oracle 8 client.
>>
>> Arunkumar Mani
>> ITO Service Delivery Consultant
>> Database Engineering, BMS Account
>>
>> arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com>
>> +91 80 338 59305  Office
>> +91 74062 71026  Mobile
>>
>> Bangalore, Karnataka/India
>> hpe.com
>>
>> [hpesm_pri_grn_pos_email_06]
>>
>> From: mohammed.must...@wipro.com<mailto:mohammed.must...@wipro.com>
>> [mailto:mohammed.must...@wipro.com]
>> Sent: Thursday, August 4, 2016 8:53 PM
>> To: Mani, Arunkumar (BMS - India GDC) <arunkumar.m...@hpe.com> arunkumar.m...@hpe.com>>; dbi-users@perl.org&l

Re: ORA-12154 - (DBD: login failed)

2016-08-08 Thread Mike Towery 
I don't think the 10G Oracle client works with Oracle 12.  Have you tried
the Oracle 12 client?

On Mon, Aug 8, 2016 at 9:25 AM, Howard, Chris <howa...@prpa.org> wrote:

>
>
> ORACLE_HOME not defined correctly?
>
> (I would test by printing out all ENV from within script)
>
>
>
> -Original Message-
> From: Mani, Arunkumar (BMS - India GDC) [mailto:arunkumar.m...@hpe.com]
> Sent: Monday, August 08, 2016 5:38 AM
> To: Nelson, Erick; mohammed.must...@wipro.com; dbi-users@perl.org
> Subject: RE: ORA-12154 - (DBD: login failed)
>
> Instead of @, we define the connection string in TWO_TASK, and
> it still looks for tnsnames.ora or sqlnet.ora for resolution and it fails.
>
> Arunkumar Mani
> ITO Service Delivery Consultant
> Database Engineering, BMS Account
>
> arunkumar.m...@hpe.com
> +91 80 338 59305  Office
> +91 74062 71026  Mobile
>
> Bangalore, Karnataka/India
> hpe.com
>
>
>
> -Original Message-
> From: Nelson, Erick [mailto:erick.nel...@hdsupply.com]
> Sent: Monday, August 8, 2016 5:01 PM
> To: Mani, Arunkumar (BMS - India GDC) <arunkumar.m...@hpe.com>;
> mohammed.must...@wipro.com; dbi-users@perl.org
> Subject: Re: ORA-12154 - (DBD: login failed)
>
> Did you try TWO_TASK env var ?
> <http://www.orafaq.com/wiki/TWO_TASK>
> <http://www.orafaq.com/wiki/TWO_TASK>
>
>
> Erick Nelson
> Cell 858-740-6523
> Home 760-930-0461
>
>
> From: "Mani, Arunkumar (BMS - India GDC)" <arunkumar.m...@hpe.com arunkumar.m...@hpe.com>>
> Date: Monday, August 8, 2016 at 1:14 AM
> To: "mohammed.must...@wipro.com<mailto:mohammed.must...@wipro.com>" <
> mohammed.must...@wipro.com<mailto:mohammed.must...@wipro.com>>, "
> dbi-users@perl.org<mailto:dbi-users@perl.org>" <dbi-users@perl.org dbi-users@perl.org>>
> Subject: RE: ORA-12154 - (DBD: login failed)
>
> All were done earlier. The problem is perl doesn't recognize my sqlnet.ora
> or tnsnames.ora, though I define TNS_ADMIN correctly in the script.
> Note: This was working when we used Oracle 8 client.
>
> Arunkumar Mani
> ITO Service Delivery Consultant
> Database Engineering, BMS Account
>
> arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com>
> +91 80 338 59305  Office
> +91 74062 71026  Mobile
>
> Bangalore, Karnataka/India
> hpe.com
>
> [hpesm_pri_grn_pos_email_011116]
>
> From: mohammed.must...@wipro.com<mailto:mohammed.must...@wipro.com>
> [mailto:mohammed.must...@wipro.com]
> Sent: Thursday, August 4, 2016 8:53 PM
> To: Mani, Arunkumar (BMS - India GDC) <arunkumar.m...@hpe.com arunkumar.m...@hpe.com>>; dbi-users@perl.org<mailto:dbi-users@perl.org>
> Subject: Re: ORA-12154 - (DBD: login failed)
>
>
>
>
> Testing: Manually, try connecting to DB using current .ora file content.
>
>
>
>
>
> Solution:  update .ora file with right
> Ip:
> Port:
> Sid/service name:
>
>
>
>
> Regards,
> Mustafa
> +44-7440 56 12 32
>
> 
> From: Mani, Arunkumar (BMS - India GDC) <arunkumar.m...@hpe.com arunkumar.m...@hpe.com>>
> Sent: Thursday, August 4, 2016 8:41 PM
> To: dbi-users@perl.org<mailto:dbi-users@perl.org>
> Subject: ORA-12154 - (DBD: login failed)
>
>
> ** This mail has been sent from an external source **
>
> Hi,
>
>
>
> We have a perl script which is used to connect to all our target databases
> ( close to 1000) and fetch the user related information and inturn compare
> it with our enterprise directory which is used to clear the inactive users
> periodically. This was a very old script and it was using Oracle 8i client.
> Since most of our systems were upgraded to 12c, 8i client is not compatible
> with 12c - so we had to update the perl script to use 10g client instead.
> After we did that, we are not able to connect to any databases and getting
> below errors. The script exclusively sets TNS_ADMIN to point to right
> sqlnet.ora.
>
>
>
> Need your help to fix this.
>
>
>
> ORA-12154: TNS:could not resolve the connect identifier specified (DBD:
> login failed)
>
>
>
> Perl Version:
>
>
>
> bash-2.03$ /usr/local/bin/perl -v
>
>
>
> This is perl, version 5.005_03 built for sun4-solaris
>
>
>
> Copyright 1987-1999, Larry Wall
>
>
>
> Perl may be copied only under the terms of either the Artistic License or
> the
>
> GNU General Public License, which may be found in the Perl 5.0 source kit.
>
>
>
> Complete documentation for Perl, including FAQ lists, should be found on
>
> this system using `man perl' or `perldoc perl'.  I

RE: ORA-12154 - (DBD: login failed)

2016-08-08 Thread Howard, Chris 


ORACLE_HOME not defined correctly?

(I would test by printing out all ENV from within script)



-Original Message-
From: Mani, Arunkumar (BMS - India GDC) [mailto:arunkumar.m...@hpe.com] 
Sent: Monday, August 08, 2016 5:38 AM
To: Nelson, Erick; mohammed.must...@wipro.com; dbi-users@perl.org
Subject: RE: ORA-12154 - (DBD: login failed)

Instead of @, we define the connection string in TWO_TASK, and it 
still looks for tnsnames.ora or sqlnet.ora for resolution and it fails.

Arunkumar Mani
ITO Service Delivery Consultant
Database Engineering, BMS Account

arunkumar.m...@hpe.com
+91 80 338 59305  Office
+91 74062 71026  Mobile

Bangalore, Karnataka/India
hpe.com



-Original Message-
From: Nelson, Erick [mailto:erick.nel...@hdsupply.com] 
Sent: Monday, August 8, 2016 5:01 PM
To: Mani, Arunkumar (BMS - India GDC) <arunkumar.m...@hpe.com>; 
mohammed.must...@wipro.com; dbi-users@perl.org
Subject: Re: ORA-12154 - (DBD: login failed)

Did you try TWO_TASK env var ?
<http://www.orafaq.com/wiki/TWO_TASK>
<http://www.orafaq.com/wiki/TWO_TASK>


Erick Nelson
Cell 858-740-6523
Home 760-930-0461


From: "Mani, Arunkumar (BMS - India GDC)" 
<arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com>>
Date: Monday, August 8, 2016 at 1:14 AM
To: "mohammed.must...@wipro.com<mailto:mohammed.must...@wipro.com>" 
<mohammed.must...@wipro.com<mailto:mohammed.must...@wipro.com>>, 
"dbi-users@perl.org<mailto:dbi-users@perl.org>" 
<dbi-users@perl.org<mailto:dbi-users@perl.org>>
Subject: RE: ORA-12154 - (DBD: login failed)

All were done earlier. The problem is perl doesn't recognize my sqlnet.ora or 
tnsnames.ora, though I define TNS_ADMIN correctly in the script.
Note: This was working when we used Oracle 8 client.

Arunkumar Mani
ITO Service Delivery Consultant
Database Engineering, BMS Account

arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com>
+91 80 338 59305  Office
+91 74062 71026  Mobile

Bangalore, Karnataka/India
hpe.com

[hpesm_pri_grn_pos_email_06]

From: mohammed.must...@wipro.com<mailto:mohammed.must...@wipro.com> 
[mailto:mohammed.must...@wipro.com]
Sent: Thursday, August 4, 2016 8:53 PM
To: Mani, Arunkumar (BMS - India GDC) 
<arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com>>; 
dbi-users@perl.org<mailto:dbi-users@perl.org>
Subject: Re: ORA-12154 - (DBD: login failed)




Testing: Manually, try connecting to DB using current .ora file content.





Solution:  update .ora file with right
Ip:
Port:
Sid/service name:




Regards,
Mustafa
+44-7440 56 12 32


From: Mani, Arunkumar (BMS - India GDC) 
<arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com>>
Sent: Thursday, August 4, 2016 8:41 PM
To: dbi-users@perl.org<mailto:dbi-users@perl.org>
Subject: ORA-12154 - (DBD: login failed)


** This mail has been sent from an external source **

Hi,



We have a perl script which is used to connect to all our target databases ( 
close to 1000) and fetch the user related information and inturn compare it 
with our enterprise directory which is used to clear the inactive users 
periodically. This was a very old script and it was using Oracle 8i client. 
Since most of our systems were upgraded to 12c, 8i client is not compatible 
with 12c - so we had to update the perl script to use 10g client instead. After 
we did that, we are not able to connect to any databases and getting below 
errors. The script exclusively sets TNS_ADMIN to point to right sqlnet.ora.



Need your help to fix this.



ORA-12154: TNS:could not resolve the connect identifier specified (DBD: login 
failed)



Perl Version:



bash-2.03$ /usr/local/bin/perl -v



This is perl, version 5.005_03 built for sun4-solaris



Copyright 1987-1999, Larry Wall



Perl may be copied only under the terms of either the Artistic License or the

GNU General Public License, which may be found in the Perl 5.0 source kit.



Complete documentation for Perl, including FAQ lists, should be found on

this system using `man perl' or `perldoc perl'.  If you have access to the

Internet, point your browser at 
http://www.perl.com/<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.perl.com_=DQMFAg=G6gE9wZC434W5IaU4ofEKQ=dNrS-0eOrjqS9LI6Io5GnPqWzmfgaVqofJ4wYWYOmSA=XVdbSsalndF6Pso7F3PaPinBlO0uj660yZz1dCC7f50=4T41gcmdGOE5ioZTOKH4mMqv5ld3DywufUS-mMAEJJ0=>,
 the Perl Home Page.



bash-2.03$





Arunkumar Mani
ITO Service Delivery Consultant
Database Engineering, BMS Account

arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com>
+91 80 338 59305  Office
+91 74062 71026  Mobile

Bangalore, Karnataka/India
hpe.com



[hpesm_pri_grn_pos_email_06]


The information contained in this electronic message and any attachments to 
this message are intended for the exclusive use of the addressee(s) and may 
contain proprietary, confidential or privileged information. If y

Re: ORA-12154 - (DBD: login failed)

2016-08-08 Thread Nelson, Erick 
Did you try TWO_TASK env var ?
<http://www.orafaq.com/wiki/TWO_TASK>
<http://www.orafaq.com/wiki/TWO_TASK>


Erick Nelson
Cell 858-740-6523
Home 760-930-0461


From: "Mani, Arunkumar (BMS - India GDC)" 
<arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com>>
Date: Monday, August 8, 2016 at 1:14 AM
To: "mohammed.must...@wipro.com<mailto:mohammed.must...@wipro.com>" 
<mohammed.must...@wipro.com<mailto:mohammed.must...@wipro.com>>, 
"dbi-users@perl.org<mailto:dbi-users@perl.org>" 
<dbi-users@perl.org<mailto:dbi-users@perl.org>>
Subject: RE: ORA-12154 - (DBD: login failed)

All were done earlier. The problem is perl doesn't recognize my sqlnet.ora or 
tnsnames.ora, though I define TNS_ADMIN correctly in the script.
Note: This was working when we used Oracle 8 client.

Arunkumar Mani
ITO Service Delivery Consultant
Database Engineering, BMS Account

arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com>
+91 80 338 59305  Office
+91 74062 71026  Mobile

Bangalore, Karnataka/India
hpe.com

[hpesm_pri_grn_pos_email_06]

From: mohammed.must...@wipro.com<mailto:mohammed.must...@wipro.com> 
[mailto:mohammed.must...@wipro.com]
Sent: Thursday, August 4, 2016 8:53 PM
To: Mani, Arunkumar (BMS - India GDC) 
<arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com>>; 
dbi-users@perl.org<mailto:dbi-users@perl.org>
Subject: Re: ORA-12154 - (DBD: login failed)




Testing: Manually, try connecting to DB using current .ora file content.





Solution:  update .ora file with right
Ip:
Port:
Sid/service name:




Regards,
Mustafa
+44-7440 56 12 32


From: Mani, Arunkumar (BMS - India GDC) 
<arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com>>
Sent: Thursday, August 4, 2016 8:41 PM
To: dbi-users@perl.org<mailto:dbi-users@perl.org>
Subject: ORA-12154 - (DBD: login failed)


** This mail has been sent from an external source **

Hi,



We have a perl script which is used to connect to all our target databases ( 
close to 1000) and fetch the user related information and inturn compare it 
with our enterprise directory which is used to clear the inactive users 
periodically. This was a very old script and it was using Oracle 8i client. 
Since most of our systems were upgraded to 12c, 8i client is not compatible 
with 12c - so we had to update the perl script to use 10g client instead. After 
we did that, we are not able to connect to any databases and getting below 
errors. The script exclusively sets TNS_ADMIN to point to right sqlnet.ora.



Need your help to fix this.



ORA-12154: TNS:could not resolve the connect identifier specified (DBD: login 
failed)



Perl Version:



bash-2.03$ /usr/local/bin/perl -v



This is perl, version 5.005_03 built for sun4-solaris



Copyright 1987-1999, Larry Wall



Perl may be copied only under the terms of either the Artistic License or the

GNU General Public License, which may be found in the Perl 5.0 source kit.



Complete documentation for Perl, including FAQ lists, should be found on

this system using `man perl' or `perldoc perl'.  If you have access to the

Internet, point your browser at 
http://www.perl.com/<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.perl.com_=DQMFAg=G6gE9wZC434W5IaU4ofEKQ=dNrS-0eOrjqS9LI6Io5GnPqWzmfgaVqofJ4wYWYOmSA=XVdbSsalndF6Pso7F3PaPinBlO0uj660yZz1dCC7f50=4T41gcmdGOE5ioZTOKH4mMqv5ld3DywufUS-mMAEJJ0=>,
 the Perl Home Page.



bash-2.03$





Arunkumar Mani
ITO Service Delivery Consultant
Database Engineering, BMS Account

arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com>
+91 80 338 59305  Office
+91 74062 71026  Mobile

Bangalore, Karnataka/India
hpe.com



[hpesm_pri_grn_pos_email_06]


The information contained in this electronic message and any attachments to 
this message are intended for the exclusive use of the addressee(s) and may 
contain proprietary, confidential or privileged information. If you are not the 
intended recipient, you should not disseminate, distribute or copy this e-mail. 
Please notify the sender immediately and destroy all copies of this message and 
any attachments. WARNING: Computer viruses can be transmitted via email. The 
recipient should check this email and any attachments for the presence of 
viruses. The company accepts no liability for any damage caused by any virus 
transmitted by this email. 
www.wipro.com<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.wipro.com=DQMFAg=G6gE9wZC434W5IaU4ofEKQ=dNrS-0eOrjqS9LI6Io5GnPqWzmfgaVqofJ4wYWYOmSA=XVdbSsalndF6Pso7F3PaPinBlO0uj660yZz1dCC7f50=dUH-HRnqB7yNm3kH29c3AMMoVTecSxAnMRCMHKVwLG0=>

RE: ORA-12154 - (DBD: login failed)

2016-08-08 Thread Mani, Arunkumar (BMS - India GDC) 
Instead of @, we define the connection string in TWO_TASK, and it 
still looks for tnsnames.ora or sqlnet.ora for resolution and it fails.

Arunkumar Mani
ITO Service Delivery Consultant
Database Engineering, BMS Account

arunkumar.m...@hpe.com
+91 80 338 59305  Office
+91 74062 71026  Mobile

Bangalore, Karnataka/India
hpe.com



-Original Message-
From: Nelson, Erick [mailto:erick.nel...@hdsupply.com] 
Sent: Monday, August 8, 2016 5:01 PM
To: Mani, Arunkumar (BMS - India GDC) <arunkumar.m...@hpe.com>; 
mohammed.must...@wipro.com; dbi-users@perl.org
Subject: Re: ORA-12154 - (DBD: login failed)

Did you try TWO_TASK env var ?
<http://www.orafaq.com/wiki/TWO_TASK>
<http://www.orafaq.com/wiki/TWO_TASK>


Erick Nelson
Cell 858-740-6523
Home 760-930-0461


From: "Mani, Arunkumar (BMS - India GDC)" 
<arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com>>
Date: Monday, August 8, 2016 at 1:14 AM
To: "mohammed.must...@wipro.com<mailto:mohammed.must...@wipro.com>" 
<mohammed.must...@wipro.com<mailto:mohammed.must...@wipro.com>>, 
"dbi-users@perl.org<mailto:dbi-users@perl.org>" 
<dbi-users@perl.org<mailto:dbi-users@perl.org>>
Subject: RE: ORA-12154 - (DBD: login failed)

All were done earlier. The problem is perl doesn't recognize my sqlnet.ora or 
tnsnames.ora, though I define TNS_ADMIN correctly in the script.
Note: This was working when we used Oracle 8 client.

Arunkumar Mani
ITO Service Delivery Consultant
Database Engineering, BMS Account

arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com>
+91 80 338 59305  Office
+91 74062 71026  Mobile

Bangalore, Karnataka/India
hpe.com

[hpesm_pri_grn_pos_email_06]

From: mohammed.must...@wipro.com<mailto:mohammed.must...@wipro.com> 
[mailto:mohammed.must...@wipro.com]
Sent: Thursday, August 4, 2016 8:53 PM
To: Mani, Arunkumar (BMS - India GDC) 
<arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com>>; 
dbi-users@perl.org<mailto:dbi-users@perl.org>
Subject: Re: ORA-12154 - (DBD: login failed)




Testing: Manually, try connecting to DB using current .ora file content.





Solution:  update .ora file with right
Ip:
Port:
Sid/service name:




Regards,
Mustafa
+44-7440 56 12 32


From: Mani, Arunkumar (BMS - India GDC) 
<arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com>>
Sent: Thursday, August 4, 2016 8:41 PM
To: dbi-users@perl.org<mailto:dbi-users@perl.org>
Subject: ORA-12154 - (DBD: login failed)


** This mail has been sent from an external source **

Hi,



We have a perl script which is used to connect to all our target databases ( 
close to 1000) and fetch the user related information and inturn compare it 
with our enterprise directory which is used to clear the inactive users 
periodically. This was a very old script and it was using Oracle 8i client. 
Since most of our systems were upgraded to 12c, 8i client is not compatible 
with 12c - so we had to update the perl script to use 10g client instead. After 
we did that, we are not able to connect to any databases and getting below 
errors. The script exclusively sets TNS_ADMIN to point to right sqlnet.ora.



Need your help to fix this.



ORA-12154: TNS:could not resolve the connect identifier specified (DBD: login 
failed)



Perl Version:



bash-2.03$ /usr/local/bin/perl -v



This is perl, version 5.005_03 built for sun4-solaris



Copyright 1987-1999, Larry Wall



Perl may be copied only under the terms of either the Artistic License or the

GNU General Public License, which may be found in the Perl 5.0 source kit.



Complete documentation for Perl, including FAQ lists, should be found on

this system using `man perl' or `perldoc perl'.  If you have access to the

Internet, point your browser at 
http://www.perl.com/<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.perl.com_=DQMFAg=G6gE9wZC434W5IaU4ofEKQ=dNrS-0eOrjqS9LI6Io5GnPqWzmfgaVqofJ4wYWYOmSA=XVdbSsalndF6Pso7F3PaPinBlO0uj660yZz1dCC7f50=4T41gcmdGOE5ioZTOKH4mMqv5ld3DywufUS-mMAEJJ0=>,
 the Perl Home Page.



bash-2.03$





Arunkumar Mani
ITO Service Delivery Consultant
Database Engineering, BMS Account

arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com>
+91 80 338 59305  Office
+91 74062 71026  Mobile

Bangalore, Karnataka/India
hpe.com



[hpesm_pri_grn_pos_email_06]


The information contained in this electronic message and any attachments to 
this message are intended for the exclusive use of the addressee(s) and may 
contain proprietary, confidential or privileged information. If you are not the 
intended recipient, you should not disseminate, distribute or copy this e-mail. 
Please notify the sender immediately and destroy all copies of this message and 
any attachments. WARNING: Computer viruses can be transmitted via email. The 
recipient should check this email and any attachments for the presence of 
viruses. The company accepts

RE: ORA-12154 - (DBD: login failed)

2016-08-08 Thread Mani, Arunkumar (BMS - India GDC) 
All were done earlier. The problem is perl doesn't recognize my sqlnet.ora or 
tnsnames.ora, though I define TNS_ADMIN correctly in the script.
Note: This was working when we used Oracle 8 client.

Arunkumar Mani
ITO Service Delivery Consultant
Database Engineering, BMS Account

arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com>
+91 80 338 59305  Office
+91 74062 71026  Mobile

Bangalore, Karnataka/India
hpe.com

[hpesm_pri_grn_pos_email_06]

From: mohammed.must...@wipro.com [mailto:mohammed.must...@wipro.com]
Sent: Thursday, August 4, 2016 8:53 PM
To: Mani, Arunkumar (BMS - India GDC) <arunkumar.m...@hpe.com>; 
dbi-users@perl.org
Subject: Re: ORA-12154 - (DBD: login failed)




Testing: Manually, try connecting to DB using current .ora file content.





Solution:  update .ora file with right
Ip:
Port:
Sid/service name:




Regards,
Mustafa
+44-7440 56 12 32


From: Mani, Arunkumar (BMS - India GDC) 
<arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com>>
Sent: Thursday, August 4, 2016 8:41 PM
To: dbi-users@perl.org<mailto:dbi-users@perl.org>
Subject: ORA-12154 - (DBD: login failed)


** This mail has been sent from an external source **

Hi,



We have a perl script which is used to connect to all our target databases ( 
close to 1000) and fetch the user related information and inturn compare it 
with our enterprise directory which is used to clear the inactive users 
periodically. This was a very old script and it was using Oracle 8i client. 
Since most of our systems were upgraded to 12c, 8i client is not compatible 
with 12c - so we had to update the perl script to use 10g client instead. After 
we did that, we are not able to connect to any databases and getting below 
errors. The script exclusively sets TNS_ADMIN to point to right sqlnet.ora.



Need your help to fix this.



ORA-12154: TNS:could not resolve the connect identifier specified (DBD: login 
failed)



Perl Version:



bash-2.03$ /usr/local/bin/perl -v



This is perl, version 5.005_03 built for sun4-solaris



Copyright 1987-1999, Larry Wall



Perl may be copied only under the terms of either the Artistic License or the

GNU General Public License, which may be found in the Perl 5.0 source kit.



Complete documentation for Perl, including FAQ lists, should be found on

this system using `man perl' or `perldoc perl'.  If you have access to the

Internet, point your browser at http://www.perl.com/, the Perl Home Page.



bash-2.03$





Arunkumar Mani
ITO Service Delivery Consultant
Database Engineering, BMS Account

arunkumar.m...@hpe.com<mailto:arunkumar.m...@hpe.com>
+91 80 338 59305  Office
+91 74062 71026  Mobile

Bangalore, Karnataka/India
hpe.com



[hpesm_pri_grn_pos_email_06]


The information contained in this electronic message and any attachments to 
this message are intended for the exclusive use of the addressee(s) and may 
contain proprietary, confidential or privileged information. If you are not the 
intended recipient, you should not disseminate, distribute or copy this e-mail. 
Please notify the sender immediately and destroy all copies of this message and 
any attachments. WARNING: Computer viruses can be transmitted via email. The 
recipient should check this email and any attachments for the presence of 
viruses. The company accepts no liability for any damage caused by any virus 
transmitted by this email. www.wipro.com<http://www.wipro.com>

Re: ORA-12154 - (DBD: login failed)

2016-08-04 Thread mohammed.mustafa 

Testing: Manually, try connecting to DB using current .ora file content.



Solution:  update .ora file with right
Ip:
Port:
Sid/service name:



Regards,
Mustafa
+44-7440 56 12 32



From: Mani, Arunkumar (BMS - India GDC) 
Sent: Thursday, August 4, 2016 8:41 PM
To: dbi-users@perl.org
Subject: ORA-12154 - (DBD: login failed)


** This mail has been sent from an external source **

Hi,



We have a perl script which is used to connect to all our target databases ( 
close to 1000) and fetch the user related information and inturn compare it 
with our enterprise directory which is used to clear the inactive users 
periodically. This was a very old script and it was using Oracle 8i client. 
Since most of our systems were upgraded to 12c, 8i client is not compatible 
with 12c - so we had to update the perl script to use 10g client instead. After 
we did that, we are not able to connect to any databases and getting below 
errors. The script exclusively sets TNS_ADMIN to point to right sqlnet.ora.



Need your help to fix this.



ORA-12154: TNS:could not resolve the connect identifier specified (DBD: login 
failed)



Perl Version:



bash-2.03$ /usr/local/bin/perl -v



This is perl, version 5.005_03 built for sun4-solaris



Copyright 1987-1999, Larry Wall



Perl may be copied only under the terms of either the Artistic License or the

GNU General Public License, which may be found in the Perl 5.0 source kit.



Complete documentation for Perl, including FAQ lists, should be found on

this system using `man perl' or `perldoc perl'.  If you have access to the

Internet, point your browser at http://www.perl.com/, the Perl Home Page.



bash-2.03$





Arunkumar Mani
ITO Service Delivery Consultant
Database Engineering, BMS Account

arunkumar.m...@hpe.com
+91 80 338 59305  Office
+91 74062 71026  Mobile

Bangalore, Karnataka/India
hpe.com



[hpesm_pri_grn_pos_email_06]



The information contained in this electronic message and any attachments to 
this message are intended for the exclusive use of the addressee(s) and may 
contain proprietary, confidential or privileged information. If you are not the 
intended recipient, you should not disseminate, distribute or copy this e-mail. 
Please notify the sender immediately and destroy all copies of this message and 
any attachments. WARNING: Computer viruses can be transmitted via email. The 
recipient should check this email and any attachments for the presence of 
viruses. The company accepts no liability for any damage caused by any virus 
transmitted by this email. www.wipro.com