5 Ответы Последний ответ: 23.09.2019 9:43, автор: fmz

    no ocijdbc18 in java.library.path

    fmz

      Hi,

       

      I am trying to connect from sqlcl to my Cloud ATP DB (SQLdeveloper & SQLmodeler works well) on Windows 10,

      - installed instant client 19

      - set ORACLE_HOME=<instant client 19-path>

      - set PATH=.. <instant client 19-path>

       

      and getting 'no ocijdbc18 in java.library.path'

       

      used doc: https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/connect-sqlcl.html#GUID-AC24404D-8D0B-4716-83F6-F0F501318011

       

      No idea.

       

      Friedhold

        • 1. Re: no ocijdbc18 in java.library.path
          Glen Conway

          Install Oracle Instant Client 18.3.0.0 and set your ORACLE_HOME to that (and also make it the first home in your PATH variable).  As far as I can tell, SQLcl always attempts to use an OCI/Thick JDBC  driver connection (even without specifying the -oci option), and if that fails it will fall through to using a Thin connection.  In your case, an ocijdbc19 is found instead of the ocijdbc18 and it never even tries to use Thin.  That seems like a bug to me, but the SQL Developer PM and developers are the judge of that.

           

          You could set these variables in your Windows System properties, but many/most will create a custom setup script for each Oracle environment.

           

          Cheers

           

          Edit:  And actually, in my environment (with my various setup scripts), SQLcl starts up fine whether I use the 19.3 or the 18.3 instant client - 

           

                     1) With 18.3 I get an OCI/Thick connection

                     2) With 19.3 I get a Thin connection.

           

                     Make sure your path reference is correct, say...

                     C:\app\<yourUserID>\product\19.3.0.0\instantclient_19_3

           

                     If I mix 19.3 and 18_3 in the path, like C:\app\<yourUserID>\product\18.3.0.0\instantclient_19_3, then I also get the 'no ocijdbc18 in java.library.path' message.

          1 пользователь считает эту информацию полезной
          • 2. Re: no ocijdbc18 in java.library.path
            fmz

            Hi Glen,

             

            many thanks, I will try it.

             

            Can you send me a download link of 18.3 , please ?

             

            Only found the 19.3 ..

             

            Friedhold

            • 3. Re: no ocijdbc18 in java.library.path
              Glen Conway

              If you scroll down in this (https://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.html ) link's page, you will find 18.5 (the page seems to contain the last / terminal release for each NN.N historical release).

               

              Specifically for Oracle Instant Client 18.3 on Windows, you are correct, seems like it no longer comes up on web searches.  Try 18.5.

              1 пользователь считает эту информацию полезной
              • 4. Re: no ocijdbc18 in java.library.path
                fmz

                Thanks again Glen, 18.5 was the magic.

                I will try it after the weekend.

                 

                Friedhold

                • 5. Re: no ocijdbc18 in java.library.path
                  fmz

                  Hi Glen,

                   

                  the 18.5 helps here.

                   

                  Friedhold