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 wrote: > > > ORACLE_HOME not defined correctly? > > (I would test by printing out all ENV from within script) > > > > -Original

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

*Which version of JDBC drivers support which version of Oracle database?* Please refer to the table below for the Oracle database versions supported by JDBC drivers. Best Practice that we recommend is, JDBC driver version should always be either same as or higher than the Oracle database version

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:

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

In message , "Mani, Arunkumar (BMS - India GDC)" writes: >I'll probably explain it with a piece of code and output, so everybody can = >explain the problem I face clearly. Assuming that you've confirmed Oracle's

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; dbi-users@perl.org Subject: RE:

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

DBD::Oracle uses Oracle's OCI not JDBC. The official OCI Support matrix is Document #207303.1 (for those with MOS access). Chris On 9/08/2016 1:07 AM, Mike Towery wrote: *Which version of JDBC drivers support which version of Oracle database?* Please refer to the table below for the Oracle

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

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

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

You possibly need to bring your 10g client up to date with patches so authentication succeeds; I've seen similar things in the past. But, in general, why use 10g client if you are connecting to 12c? You may as well use the 12c client. I forget whether 8i used service names or only the old

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 > wrote:

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

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

Did you try TWO_TASK env var ? Erick Nelson Cell 858-740-6523 Home 760-930-0461 From: "Mani, Arunkumar (BMS - India GDC)" > Date: Monday, August 8, 2016 at 1:14 AM

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

Instead of @, 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

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;