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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

"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

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.

Frank Kulash

HI,

This question isn't about the SQL or PL/SQL languages, so the SQL and PL/SQL forum isn't a good place for it.

Ill move the thread to the General Database forum.

John Thorton

3696948 wrote:

Hello,

I created database link in oracle for My SQL Database. When I tried to test the database link it throw an error shown in the screen shot below. I was successfully created db links, synonyms for various databases in oracle in the past. However, when i execute below SQL Query it throws error.

CREATE DATABASE LINK "MYDATABASE.MYSQL.xyzxyz.COM"

CONNECT TO ABC_EFG_USER IDENTIFIED BY "******";

My question is does oracle support creation of database link for MY SQL.

Thanks,

Nawaz

unwilling or incapable to use GOOGLE yourself.

Let me assist

LMGTFY

How does Oracle DB know that the target of this DBLink is NOT an Oracle DB & is a MYSQL database?

>CREATE DATABASE LINK "MYDATABASE.MYSQL.xyzxyz.COM"

3011615

Hi,

The simple answer for your simple questions is: Yes, oracle supports database links to MySql.

The point is: You cannot do it just that way by creating a database link with the creation command. There are some configurations you should do to accomplish this task which depends on your oracle installation and environment you have.

Regards,

Sunny kichloo

This will help:

How to connect Oracle DB to Mysql DB

https://oracle-base.com/articles/mysql/mysql-connections-in-sql-developer

1 - 4