Home > database >  Pl/SQL, oracle can access mysql database
Pl/SQL, oracle can access mysql database

Time:09-24

As title,
The client (win10) : pl/SQL + oracle 11 gr2
The server (centos7) : mysql (version: 5.7),
The client to monitor configured, as follows;
Test=
(the DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(TCP) PROTOCOL=(HOST=192.168.168.112) (3306) PORT=)
)
(CONNECT_DATA=
https://bbs.csdn.net/topics/(SERVICE_NAME=test)
)
)
But in the pl/SQL connection times wrong: ORA - 12569: TNS: package checksum failure,
Excuse me, this configuration can access mysql?
If can, how to configure? Thank you very much!

CodePudding user response:

Study the building Lord "transparent gateway", configure a should not be too long, there is a problem to ask again,

CodePudding user response:

If just want to simple life data with navicat

CodePudding user response:

With a transparent gateway, to build an odbc gateways select odbc that then use dblink can access