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> 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] > Sent: Monday, August 08, 2016 5:38 AM > To: Nelson, Erick; mohammed.must...@wipro.com; 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 > +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_011116] > > 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_&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> > +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=> >