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

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 <[email protected]> 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:[email protected]]
> Sent: Monday, August 08, 2016 5:38 AM
> To: Nelson, Erick; [email protected]; [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]
> +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]>;
> [email protected]; [email protected]
> 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)" <[email protected]<mailto:
> [email protected]>>
> Date: Monday, August 8, 2016 at 1:14 AM
> To: "[email protected]<mailto:[email protected]>" <
> [email protected]<mailto:[email protected]>>, "
> [email protected]<mailto:[email protected]>" <[email protected]<mailto:
> [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]>
> +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]]
> Sent: Thursday, August 4, 2016 8:53 PM
> To: Mani, Arunkumar (BMS - India GDC) <[email protected]<mailto:
> [email protected]>>; [email protected]<mailto:[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]>>
> Sent: Thursday, August 4, 2016 8:41 PM
> To: [email protected]<mailto:[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=>, the Perl Home Page.
>
>
>
> 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
>
>
>
> [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=XVdbSsalndF6Pso7F3PaPinBlO0uj6
> 60yZz1dCC7f50&s=dUH-HRnqB7yNm3kH29c3AMMoVTecSxAnMRCMHKVwLG0&e=>
>