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

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
>>
>> [email protected] <mailto:[email protected]>
>> +91 80 338 59305  Office
>> +91 74062 71026  Mobile
>>
>> Bangalore, Karnataka/India
>> *hpe.com*
>>
>> hpesm_pri_grn_pos_email_011116
>>
>> *From:* Mani, Arunkumar (BMS - India GDC)
>> *Sent:* Tuesday, August 9, 2016 1:54 PM
>> *To:* 'Howard, Chris' <[email protected]>; Nelson, Erick
>> <[email protected]>; [email protected];
>> [email protected]
>> *Subject:* RE: ORA-12154 - (DBD: login failed)
>>
>> Yes.
>>
>> *Arunkumar Mani
>> *ITO Service Delivery Consultant
>> Database Engineering, BMS Account
>>
>> [email protected] <mailto:[email protected]>
>> +91 80 338 59305  Office
>> +91 74062 71026  Mobile
>>
>> Bangalore, Karnataka/India
>> *hpe.com*
>>
>> hpesm_pri_grn_pos_email_011116
>>
>> *From:* Howard, Chris [mailto:[email protected]]
>> *Sent:* Monday, August 8, 2016 9:29 PM
>> *To:* Mani, Arunkumar (BMS - India GDC) <[email protected]
>> <mailto:[email protected]>>; Nelson, Erick
>> <[email protected] <mailto:[email protected]>>;
>> [email protected] <mailto:[email protected]>;
>> [email protected] <mailto:[email protected]>
>> *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:[email protected]]
>> *Sent:* Monday, August 08, 2016 9:37 AM
>> *To:* Howard, Chris; Nelson, Erick; [email protected]
>> <mailto:[email protected]>; [email protected]
>> <mailto:[email protected]>
>> *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
>>
>> [email protected] <mailto:[email protected]>
>>
>> +91 80 338 59305  Office
>>
>> +91 74062 71026  Mobile
>>
>> Bangalore, Karnataka/India
>>
>> hpe.com
>>
>> -----Original Message-----
>> From: Howard, Chris [mailto:[email protected]]
>> Sent: Monday, August 8, 2016 7:55 PM
>> To: Mani, Arunkumar (BMS - India GDC) <[email protected]
>> <mailto:[email protected]>>; Nelson, Erick
>> <[email protected] <mailto:[email protected]>>;
>> [email protected] <mailto:[email protected]>;
>> [email protected] <mailto:[email protected]>
>> 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:[email protected]]
>>
>> Sent: Monday, August 08, 2016 5:38 AM
>>
>> To: Nelson, Erick; [email protected]
>> <mailto:[email protected]>; [email protected]
>> <mailto:[email protected]>
>>
>> Subject: RE: ORA-12154 - (DBD: login failed)
>>
>> Instead of @<tns_string>, 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
>>
>> [email protected] <mailto:[email protected]>
>>
>> +91 80 338 59305  Office
>>
>> +91 74062 71026  Mobile
>>
>> Bangalore, Karnataka/India
>>
>> hpe.com
>>
>> -----Original Message-----
>>
>> From: Nelson, Erick [mailto:[email protected]]
>>
>> Sent: Monday, August 8, 2016 5:01 PM
>>
>> To: Mani, Arunkumar (BMS - India GDC) <[email protected]
>> <mailto:[email protected]>>; [email protected]
>> <mailto:[email protected]>; [email protected]
>> <mailto:[email protected]>
>>
>> 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&d=AwMFAg&c=J-N4xUQ7Pu4HLlwo2BifHA&r=7-NQstA5IqogNkXFIxVbHg&m=TfLVDxjcfuPnX0RcZg_ZNMw7NhNJLEbXfv1L7Ps2EgA&s=LmP3xCjCbYAJUU34ahUes_MUBhkRqsHFQdRdWsng2ZA&e=>>
>>
>>
>> <http://www.orafaq.com/wiki/TWO_TASK[orafaq.com]
>> <https://urldefense.proofpoint.com/v2/url?u=http-3A__www.orafaq.com_wiki_TWO-5FTASK&d=AwMFAg&c=J-N4xUQ7Pu4HLlwo2BifHA&r=7-NQstA5IqogNkXFIxVbHg&m=TfLVDxjcfuPnX0RcZg_ZNMw7NhNJLEbXfv1L7Ps2EgA&s=LmP3xCjCbYAJUU34ahUes_MUBhkRqsHFQdRdWsng2ZA&e=>>
>>
>>
>> Erick Nelson
>>
>> Cell 858-740-6523
>>
>> Home 760-930-0461
>>
>> From: "Mani, Arunkumar (BMS - India GDC)"
>> <[email protected]<mailto:[email protected]
>> <mailto:[email protected]%3cmailto:[email protected]>>>
>>
>> Date: Monday, August 8, 2016 at 1:14 AM
>>
>> To: "[email protected]<mailto:[email protected]>
>> <mailto:[email protected]%3cmailto:[email protected]%3e>"
>>
>> <[email protected]<mailto:[email protected]
>> <mailto:[email protected]%3cmailto:[email protected]>>>,
>>
>> "[email protected]<mailto:[email protected]>
>> <mailto:[email protected]%3cmailto:[email protected]%3e>"
>> <[email protected]<mailto:[email protected]
>> <mailto:[email protected]%3cmailto:[email protected]>>>
>>
>> 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
>>
>> [email protected]<mailto:[email protected]
>> <mailto:[email protected]%3cmailto:[email protected]>>
>>
>> +91 80 338 59305  Office
>>
>> +91 74062 71026  Mobile
>>
>> Bangalore, Karnataka/India
>>
>> hpe.com
>>
>> [hpesm_pri_grn_pos_email_011116]
>>
>> From: [email protected]<mailto:[email protected]
>> <mailto:[email protected]%3cmailto:[email protected]>>
>> [mailto:[email protected]]
>>
>> Sent: Thursday, August 4, 2016 8:53 PM
>>
>> To: Mani, Arunkumar (BMS - India GDC)
>> <[email protected]<mailto:[email protected]
>> <mailto:[email protected]%3cmailto:[email protected]>>>;
>> [email protected]<mailto:[email protected]
>> <mailto:[email protected]%3cmailto:[email protected]>>
>>
>> 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)
>> <[email protected]<mailto:[email protected]
>> <mailto:[email protected]%3cmailto:[email protected]>>>
>>
>> Sent: Thursday, August 4, 2016 8:41 PM
>>
>> To: [email protected]<mailto:[email protected]
>> <mailto:[email protected]%3cmailto:[email protected]>>
>>
>> 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_&d=DQMFAg&c=G6gE9wZC434W5IaU4ofEKQ&r=dNrS-0eOrjqS9LI6Io5GnPqWzmfgaVqofJ4wYWYOmSA&m=XVdbSsalndF6Pso7F3PaPinBlO0uj660yZz1dCC7f50&s=4T41gcmdGOE5ioZTOKH4mMqv5ld3DywufUS-mMAEJJ0&e[perl.com]
>>
>> <https://urldefense.proofpoint.com/v2/url?u=http-3A__www.perl.com_-253chttps-3A_urldefense.proofpoint.com_v2_url-3Fu-3Dhttp-2D3A-5F-5Fwww.perl.com-5F-26d-3DDQMFAg-26c-3DG6gE9wZC434W5IaU4ofEKQ-26r-3DdNrS-2D0eOrjqS9LI6Io5GnPqWzmfgaVqofJ4wYWYOmSA-26m-3DXVdbSsalndF6Pso7F3PaPinBlO0uj660yZz1dCC7f50-26s-3D4T41gcmdGOE5ioZTOKH4mMqv5ld3DywufUS-2DmMAEJJ0-26e&d=AwMFAg&c=J-N4xUQ7Pu4HLlwo2BifHA&r=7-NQstA5IqogNkXFIxVbHg&m=TfLVDxjcfuPnX0RcZg_ZNMw7NhNJLEbXfv1L7Ps2EgA&s=jjwMN-K1_-A7MhUBcuHfn5WOYCLbDY0HVSpmmZgjDX0&e=>=>,
>>
>> the Perl Home Page.
>>
>> bash-2.03$
>>
>> Arunkumar Mani
>>
>> ITO Service Delivery Consultant
>>
>> Database Engineering, BMS Account
>>
>> [email protected]<mailto:[email protected]
>> <mailto:[email protected]%3cmailto:[email protected]>>
>>
>> +91 80 338 59305  Office
>>
>> +91 74062 71026  Mobile
>>
>> Bangalore, Karnataka/India
>>
>> hpe.com
>>
>> [hpesm_pri_grn_pos_email_011116]
>>
>> 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&d=DQMFAg&c=G6gE9wZC434W5IaU4ofEKQ&r=dNrS-0eOrjqS9LI6Io5GnPqWzmfgaVqofJ4wYWYOmSA&m=XVdbSsalndF6Pso7F3PaPinBlO0uj660yZz1dCC7f50&s=dUH-HRnqB7yNm3kH29c3AMMoVTecSxAnMRCMHKVwLG0&e[wipro.com%3chttps]
>>
>> <https://urldefense.proofpoint.com/v2/url?u=http-3A__www.wipro.com-253chttps-3A_urldefense.proofpoint.com_v2_url-3Fu-3Dhttp-2D3A-5F-5Fwww.wipro.com-26d-3DDQMFAg-26c-3DG6gE9wZC434W5IaU4ofEKQ-26r-3DdNrS-2D0eOrjqS9LI6Io5GnPqWzmfgaVqofJ4wYWYOmSA-26m-3DXVdbSsalndF6Pso7F3PaPinBlO0uj660yZz1dCC7f50-26s-3DdUH-2DHRnqB7yNm3kH29c3AMMoVTecSxAnMRCMHKVwLG0-26e&d=AwMFAg&c=J-N4xUQ7Pu4HLlwo2BifHA&r=7-NQstA5IqogNkXFIxVbHg&m=TfLVDxjcfuPnX0RcZg_ZNMw7NhNJLEbXfv1L7Ps2EgA&s=bbSNOyx1TckZKAu8_PZxCcuztOsGq0b3nmwdoo45b4I&e=>=>
>>
>>