topic Re: Qlik Replicate -Oracle source connection - TNS:protocol adapter not loadable in Qlik Replicate

Qlik Replicate -Oracle source connection - TNS:protocol adapter not loadable

Shruthik — Mon, 18 Apr 2022 11:58:43 GMT

Hi,

I'm trying to create a source Oracle connection. I'm not able to proceed as I'm facing below issue.

'SYS-E-HTTPFAIL, ORA-12557: TNS:protocol adapter not loadable.

SYS,GENERAL_EXCEPTION,ORA-12557: TNS:protocol adapter not loadable'

I've tried all possible ways to fix this( Adding environmental variables, checking .ora files etc) . But nothing is helping me solving this issue. It would really help if I could get some help on this 🙂

Thanks,

Shruthi

Re: Qlik Replicate -Oracle source connection - TNS:protocol adapter not loadable

SwathiPulagam — Mon, 18 Apr 2022 12:52:19 GMT

Hi @Shruthik ,

ORA-12557: TNS:protocol adapter not loadable

Cause
Controller application server's Oracle client environment has not been configured correctly.

Resolving The Problem
Make sure that all the Oracle-client-related configuration (on the Controller application server) is correct.

This is an Oracle client environment issue please try to ping the TNS.

Thanks,
Swathi

Re: Qlik Replicate -Oracle source connection - TNS:protocol adapter not loadable

Heinvandenheuvel — Tue, 19 Apr 2022 14:39:31 GMT

This is an Oracle client configuration issue, not a Replicate issue. If you just provided the Oracle client _after_ starting Replicate, then you may need to re-start the replicate service.

It is very possible you provided an incorrect connection string, but you covered up the details for that.

Please be sure to test the connection(string), on the Replicate server, with Oracle tools like SQLplus and/or TNSping before even trying Replicate.

If those work, but the connection through Replicate does not you may want to show the connection string IN TEXT, NOT IN A PICTURE and perhaps replace what you believe to be sensitive parts and things like <ipaddress> or <SID>.

hth,

Hein.

Re: Qlik Replicate -Oracle source connection - TNS:protocol adapter not loadable

lyka — Wed, 20 Apr 2022 18:49:51 GMT

Hello,

Please let us know if any of the suggested solution worked.

Thanks

Lyka

Re: Qlik Replicate -Oracle source connection - TNS:protocol adapter not loadable

Shruthik — Thu, 21 Apr 2022 06:03:15 GMT

Thanks for the reply Swathi. Checked the suggested points. Everything seems fine but it's not working. Will try to uninstall and reinstall Oracle 19c and check it again.

Thanks,

Shruthi

Re: Qlik Replicate -Oracle source connection - TNS:protocol adapter not loadable

Shruthik — Thu, 21 Apr 2022 06:02:51 GMT

Thanks Hein. It seems like Oracle configuration is fine because I followed the same steps to connect in another server, it worked fine.

Connection string I mentioned was 'localhost:1521/SID' .

Thanks,

Shruthi

Re: Qlik Replicate -Oracle source connection - TNS:protocol adapter not loadable

Heinvandenheuvel — Thu, 21 Apr 2022 11:50:17 GMT

>> It seems like Oracle configuration is fine because I followed the same steps to connect in another server, it worked fine.

That's a very convincing argument that your Oracle 'code' is fine. ! :-).

At the same time it is a very convincing argument that Replicate does the right thing if a valid connection string is provided. Agreed?

>> Connection string I mentioned was 'localhost:1521/SID' .

That's the same string format I use

For me though, where you indicate SID, I am using a 'service' name.

Did you do the SQLplus test?

Check the names with Oracle's LSNRCTL STATUS?

Check for rogue TNSNAMES.ORA entries?