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_011116

*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_011116

*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 @<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

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&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)"
<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: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%3cmailto: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%3cmailto:arunkumar.m...@hpe.com>>>;
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)

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
<mailto:arunkumar.m...@hpe.com%3cmailto: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%3cmailto: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_&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

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

+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=>=>


Reply via email to