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 Nov 10, 2016 7:55 AM

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

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

Connected to:

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

Berst regards,

Franck.

Regards,

Franck.