Link to home
Start Free TrialLog in
Avatar of sventhan
sventhanFlag for United States of America

asked on

ORA-28500: connection from ORACLE to a non-Oracle system returned this message

Experts -

I'm getting the error when I tried to connect from oracle to mysql via DBLINK.

I guess this is something to do with the User/privileges.

Need some help.

ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC]DRV_InitTdp: errors.h (2112): ;
[unixODBC][TCX][MyODBC]Access denied for user 'oracle'@'localhost' (using
password: YES) (SQL State: S1000; SQL Code: 1045)
ORA-02063: preceding 2 lines from MYSQL

tnsping mysql is ok

here is the dblink creation staement..

create database link mysql connect to "username" identified by "passwd"
using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = tcp)(HOST = testhost)(PORT = 1523))) (CONNECT_DATA = (SID = mysql)) (HS=OK))' ;
ASKER CERTIFIED SOLUTION
Avatar of Wasim Akram Shaik
Wasim Akram Shaik
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sventhan

ASKER

Thanks experts. I created an MySQL account and I used that to solve this issue.

It seems to be an account/privilege issue.