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 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 being used in order to leverage the latest capabilities of the JDBC driver.

*Interoperability Matrix*       *Database 12.1.0.x*     *Database 11.2.0.x*     
*Database 11.1.0.x*
*JDBC 12.1.0.x*         
/Yes/
        
/Yes/
        
/Yes/
*JDBC 11.2.0.x*         
/Yes/
        
/Yes/
        
/Yes/
*JDBC 11.1.0.x*         
/Yes/
        
/Yes/
        
/Yes/


------------------------------------------------------------------------------------------------------------------------------------------------------
*What are the various supported Oracle database version vs JDBC compliant 
versions vs JDK version supported?

*The table below mentions the supported Oracle database versions, equivalent supported JDK versions, JDBC version compliant to in each of the releases and also mentions the JDBC jar file names which need to be used for specific releases.
*Oracle Database version
*       *JDK Version supported
*       *JDBC specification compliance
*       *JDBC Jar files specific to the release*
12.1 or 12cR1   JDK8, JDK 7 & JDK 6         JDBC 4.1 in the JDK 8 & JDK 7 
drivers
JDBC 4.0 in the JDK 6 drivers   ojdbc7.jar for JDK 8 and JDK 7
ojdbc6.jar for JDK 6
11.2 or 11gR2   JDK 6 & JDK 5
JDK 7 & JDK 8 supported in 11.2.0.3 and 11.2.0.4    JDBC 4.0 in the JDK 6 
drivers
JDBC 3.0 in the JDK 5 drivers   ojdbc6.jar for JDK 8, JDK 7 and JDK 6.
ojdbc5.jar for JDK 5
11.1 or 11gR1   JDK 6 & JDK 5       JDBC 4.0 in the JDK 6 drivers       JDBC 
3.0 in the JDK 5 drivers       ojdbc6.jar for JDK 6
ojdbc5.jar for JDK 5



Reference: http://www.oracle.com/technetwork/topics/jdbc-faq-090281.html



------------------------------------------------------------------------------------------------------------------------------------------------------

On Mon, Aug 8, 2016 at 9:40 AM, Mike Towery <mtow...@gmail.com 
<mailto:mtow...@gmail.com>> 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

Reply via email to