APEX

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!

Getting ORA-12535: TNS:operation timed out

Anand JagtapNov 24 2023 — edited Nov 25 2023

I received 1 rest api (created by vendor system). Which should get called once per record.

So I used cursor and bulk collect to fetch and transfer the data through the apex_web_service.make_rest_request.

After every single call I'm also creating a custom log to see what has been sent.

At first few hundred records get sent ( count is not consistent ). And then I receive ORA-12535: TNS:operation timed out.

As mentioned in https://forums.oracle.com/ords/apexds/post/apex-web-service-make-rest-request-6721

There is no blocking found by the network and firewall team.

I checked the tnsping status listener . Listener is up and running.

I opened a cmd session and pinged the destination url. At the same time I executed the program. I got error after some time but on cmd I was still receiving network packets.

I also checked the tnsnames.ora and found nothing suspicious.

Can guide Where can I look?

Added on Nov 24 2023

#apex, #apex-discussions, #make-rest-request, #oracle-apex, #ords, #rest, #restful-service, #restfulservice

1 comment

715 views