Oracle and v1.1.14 : cannot connect in bulk mode

[fabrice-etanchaud]

Hi !
I cannot connect v1.1.14 to oracle,
Is there something to add/update in the configuration ?
Thank you !

[flarco]

Hi, did you take a look at https://docs.slingdata.io/connections/database-connections/oracle? What error message are you seeing?

…

On Thu, Mar 21, 2024, 5:30 AM Fabrice ETANCHAUD ***@***.***> wrote: Hi ! I cannot connect v1.1.14 to oracle, Is there something to add/update in the configuration ? Thank you ! — Reply to this email directly, view it on GitHub <#234>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AB2QZYQKI2CCIMSMLIRXZJDYZKLDBAVCNFSM6AAAAABFA7CSBKVHI2DSMVQWIX3LMV43ERDJONRXK43TNFXW4OZWGQYDGMBVGQ> . You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

[fabrice-etanchaud]

Sorry, It only breaks when I try to use the bulk mode, with the following debug information :

Oracle Import Error:SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]
ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA


SQL*Loader: Release 19.0.0.0.0 - Production on Thu Mar 21 10:46:07 2024
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]
ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA


SQL*Loader: Release 19.0.0.0.0 - Production on Thu Mar 21 10:46:07 2024
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.


--- database_oracle.go:305 SQLLoad ---
exit status 1

[flarco]

Thanks, and bulk_mode used to work for you with 1.1.13?
1.1.14 uses a new Oracle Driver (which doesn't require the Oracle client to be installed).