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!

Oracle 12C DB Link to Hive

Vlad MelnychenkoMay 19 2017 — edited Oct 5 2017

Hi All,

I created a db link to Hive following to the article

isql wokrs fine, but in sql plus I got an error

select count(*) from customers@HIVEDSN;

ERROR at line 1:

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

[

Here is trace log:

--------------------------------------------

Entered hgopoer at 2017/05/19-03:08:29

hgopoer, line 240: got native error 10210 and sqlstate H; message follows...

[

Exiting hgopoer, rc=0 at 2017/05/19-03:08:29

hgolgon, line 202: calling SQLSetConnectAttr got sqlstate H

Exiting hgolgon, rc=28500 at 2017/05/19-03:08:29 with error ptr FILE:hgolgon.c LINE:202 ID:Connection Attribute: TRACE

hostmstr:          0: HOA After hoalgon

RPC Calling nscontrol(0), rc=0

Does anyone have experience of this matter?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 2 2017
Added on May 19 2017
9 comments
3,477 views