Skip to main content

Qlik Replicate

Discussion board for collaboration on Qlik Replicate.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Shruthik
Partner - Contributor II
Partner - Contributor II

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

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

 

 

Labels (1)
3 Solutions

Accepted Solutions
SwathiPulagam
Support
Support

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

View solution in original post

Heinvandenheuvel
Creator III
Creator III

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.

View solution in original post

Heinvandenheuvel
Creator III
Creator III

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

View solution in original post

6 Replies
SwathiPulagam
Support
Support

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
Creator III
Creator III

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

Hello,

 

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

 

Thanks

Lyka

Shruthik
Partner - Contributor II
Partner - Contributor II
Author

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
Partner - Contributor II
Partner - Contributor II
Author

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
Creator III
Creator III

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