Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

Franck PachotNov 10 2016 — edited Nov 10 2016

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.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 8 2016
Added on Nov 10 2016
0 comments
849 views