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 @<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 <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 <tel:858-740-6523>
> Home 760-930-0461 <tel: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_011116]
>
> 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)
>
>
> ** 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=
>
> <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=>>,
> 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
> <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_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
>
> <http://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=
>
> <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=>>
>
>
--
http://twitter.com/ghrd
