ORA-12154 - (DBD: login failed)

[Mani, Arunkumar (BMS - India GDC)]

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]

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

[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)

[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)

[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)

[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)

[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

Migrating Perl from Solaris to Linux

[Mani, Arunkumar (BMS - India GDC)]

Friends,

We have some perl scripts used to connect to remote oracle databases to reset 
the password. There will be a front end Web console where the customers reset 
the password, and the backend perl script does this job. Unfortunately its 
running on very old hardware and we are planning to see if we can host these 
scripts on advanced hardware with RHEL 6 or 7.  It uses iplanet as a web 
platform currently.
If we want to migrate it to Apache based web platform and RHEL 6 or 7 - what 
all we need to consider?
Anyone have done such migration already? Looking for a guidance to setup a new 
system to support the perl script to run in the same way as it does now.

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]