Skip to Main Content

Oracle Database Discussions

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!

Unable read SQLite table contents from Oracle database 19c

Marcelo PSep 17 2022

Hi everyone
Please, any tips about next situation:

I have installed oracle 19c 64 on windows 10 64.
I have installed SQLite driver 32 bits and i have created new ODBC 32 DNS using SQLite driver and I have poin to SQLite database
I have modified listener.ora and tnsnames.ora and added entries required. Executing lsnrctl stop / start response is succesfull
Executing tnsping o SQLite tnsnames entry also is succesfull.
I have created dblink pointing to tnsnames.ora SQLite entry
But executing Oracle sql query throw next error:
ORA-28513:internal error in heterogeneous remote agent
ORA-02063: preceding line from dblink...

Thanks in advance

This post has been answered by L. Fernigrini on Sep 21 2022
Jump to Answer
Comments
Post Details
Added on Sep 17 2022
4 comments
668 views