5 Replies Latest reply on Aug 22, 2019 4:39 PM by thatJeffSmith-Oracle

    ORDS using oci

    SJenkins

      I've been getting random errors using Driver Type thin.. so I wanted to try OCI

       

      I've seen references to jdbc.DriverType=oci8 in the documentation

      taking a working connection with jdbc.DriverType=thin and changing it to oci or oci8 does not work..

       

      I've tried the oci8 option with several parameter options for the connection

       

      WORKS:

      <entry key="db.hostname">servername</entry>

      <entry key="db.port">1521</entry>

      <entry key="db.servicename">ORCL</entry>

      <entry key="jdbc.DriverType">thin</entry>

       

      tried:

      <entry key="db.hostname">servername</entry>

      <entry key="db.port">1521</entry>

      <entry key="db.servicename">ORCL</entry>

      <entry key="jdbc.DriverType">oci8</entry>

       

      <entry key="db.hostname">servername</entry>

      <entry key="db.port">1521</entry>

      <entry key="db.servicename">ORCL</entry>

      <entry key="jdbc.DriverType">oci</entry>

       

      <entry key="db.connectionType">customURL</entry>

      <entry key="db.customURL">jdbc:oracle:oci8:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=servername)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCL)))</entry>

       

       

      no matter what I try, everything gives error

      404 not found:

      Could not find a WLSUser in the subject

      Could not find any dispatcher to handle request:

       

      ORDS 3.0.2

        • 1. Re: ORDS using oci
          thatJeffSmith-Oracle

          Couple of things:

           

          >>I've been getting random errors using Driver Type thin.. so I wanted to try OCI

          Like, what exactly?

           

          >>ORDS 3.0.2

          That's not a good release to be using. The terminal version of 3 was 3.0.12 (as in twelve)..and even that is very old. Better to get a copy of version 19.1/19.2 and try that with a THIN connection before proceeding with anything else.

          • 2. Re: ORDS using oci
            SJenkins

            users get random 500 internal server errors..

            logs show ORA-01460: unimplemented or unreasonable conversion requested

            but at random times, sometimes even just after they click Logon

            if they refresh their page, F5, then they can continue working

             

            I am using 3.0.2 because when I tried a newer version it did not function behind our load balancer, some security change in 3.0.3 and higher..

            I am planning on trying version 19 though as soon as I get a chance to see if it works..

            • 3. Re: ORDS using oci
              thatJeffSmith-Oracle

              >>logs show ORA-01460: unimplemented or unreasonable conversion requested

              I usually see those when someone is using our stuff on an older database, like 9i or 10g

              • 4. Re: ORDS using oci
                SJenkins

                the databases are 12.1.0.2

                apex is 5.1

                weblogic hosting ORDS is 12.2.1.3

                pretty sure the java/JDBC it is using is ojdbc8.jar

                • 5. Re: ORDS using oci
                  thatJeffSmith-Oracle

                  after you upgrade, if you see the error again, there should be some SQL/PLSQL attached to it - we'll need to see that to determine what's happening

                   

                  Your APEX is also pretty old.

                   

                  Jeff