Re: ORA-12154 - (DBD: login failed)
Christopher Jones <[email protected]>
| Newsgroups | gmane.comp.lang.perl.modules.dbi.general |
|---|---|
| Message-ID | <[email protected]> |
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 <[email protected] <mailto:[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] <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 <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:[email protected] <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 <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)" <[email protected] <mailto:[email protected]><mailto:[email protected] > <mailto:[email protected]>>> > Date: Monday, August 8, 2016 at 1:14 AM > To: "[email protected] <mailto:[email protected]><mailto:[email protected] <mailto:[email protected]>>" > <[email protected] <mailto:[email protected]><mailto:[email protected] <mailto:[email protected]>>>, > "[email protected] <mailto:[email protected]><mailto:[email protected] <mailto:[email protected]>>" <[email protected] > <mailto:[email protected]><mailto:[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]><mailto:[email protected] <mailto:[email protected]>> > +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: [email protected] <mailto:[email protected]><mailto:[email protected] <mailto:[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]><mailto:[email protected] > <mailto:[email protected]>>>; [email protected] <mailto:[email protected]><mailto:[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 <tel:%2B44-7440%2056%2012%2032> > > ________________________________ > From: Mani, Arunkumar (BMS - India GDC) <[email protected] <mailto:[email protected]><mailto:[email protected] > <mailto:[email protected]>>> > Sent: Thursday, August 4, 2016 8:41 PM > To: [email protected] <mailto:[email protected]><mailto:[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= > <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]><mailto:[email protected] <mailto:[email protected]>> > +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