0 Replies Latest reply on Nov 10, 2016 7:55 AM by Franck Pachot

    "No suitable driver found" for sqlcl on Oracle Public Cloud 12.2

    Franck Pachot

      On the DBaaS 12.2, I get:

       

      [oracle@OPC122 ~]$ $ORACLE_HOME/sqldeveloper/sqlcl/bin/sql / as sysdba

      -bash: /u01/app/oracle/product/12.2.0/dbhome_1/sqldeveloper/sqlcl/bin/sql: Permission denied

       

      and

       

      [oracle@OPC122 ~]$ bash $ORACLE_HOME/sqldeveloper/sqlcl/bin/sql / as sysdba

       

      SQLcl: Release 12.2.0.1.0 RC on Thu Nov 10 07:39:36 2016

       

      Copyright (c) 1982, 2016, Oracle.  All rights reserved.

       

        USER          =

        URL           = jdbc:oracle:oci8:@

        Error Message = No suitable driver found for jdbc:oracle:oci8:@

        USER          =

        URL           = jdbc:oracle:thin:@127.0.0.1:1521:CDB1

        Error Message = No suitable driver found for jdbc:oracle:thin:@127.0.0.1:1521:CDB1

        USER          =

        URL           = jdbc:oracle:thin:@localhost:1521/orcl

        Error Message = No suitable driver found for jdbc:oracle:thin:@localhost:1521/orcl

      Username? (RETRYING) ('/ as sysdba'?)

       

      It works when I set JAVA_HOME the the oracle one:

       

      [oracle@OPC122 ~]$ JAVA_HOME=$ORACLE_HOME/jdk bash $ORACLE_HOME/sqldeveloper/sqlcl/bin/sql / as sysdba

       

      SQLcl: Release 12.2.0.1.0 RC on Thu Nov 10 07:46:01 2016

       

      Copyright (c) 1982, 2016, Oracle.  All rights reserved.

       

      Connected to:

      Oracle Database 12c EE Extreme Perf Release 12.2.0.1.0 - 64bit Production

       

       

      Berst regards,

      Franck.

       

       

      Regards,

      Franck.