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

[Shruthik]

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

[SwathiPulagam · Accepted solution]

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

[Heinvandenheuvel · Accepted solution]

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.

[lyka]

Hello,

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

Thanks

Lyka

[Shruthik]

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

[Shruthik]

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 

[Heinvandenheuvel · Accepted solution]

>> 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?