Oracle Business Intelligence Applications

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Integration Service port

Received Response
12
Views
5
Comments

Hi,

We are not able to identify the port used by the Integration services in the Informatica workflow in BIApps 7.9.6.4.

We have tried making firewall exception for the integration service port 4006 as mentioned in the DAC setup parameters. Without the firewall, we are able to access the service.

But when the firewall is on, we are unable to connect to the Integration service.

We have made exception for all the ports mentioned in the Informatica Admin console because of which we are now able to access all the services in the Powercenter Designer and Workflow Manager. But the Issue with the Monitor still exist.

Thanks and Regards:

Chinmay Kale,

BIAPPS Developer,

Evosys Global

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    Have you run

    Run netstat -a -n

    from a command prompt to see what port the Service is actually listening on? 

  • Chinmay Kale
    Chinmay Kale Rank 2 - Community Beginner

    Hi Thomas,

    Yes, I have tried the command:

    netstat -a -n | grep 4006

    But I am not able to get any output.

  • I guess the idea behind netstat is to look for other ports than 4006, so don't add the grep, do your netstat and look at which port is there and what process is related to which port and you will find out what other port you need.

  • Chinmay Kale
    Chinmay Kale Rank 2 - Community Beginner

    Thanks Thomas and Gianni.

    I have analysed with netstat that the request is sent from the port 6014.

    The state of the request is SYN-SENT and after some attempts this entry in the netstat disappears and the connection fail message appears.

  • Chinmay Kale
    Chinmay Kale Rank 2 - Community Beginner

    I was able to sort out the issue by forwarding the above results to the network team. Thanks all