What ports need to be opened at firewall to communicate ArcGIS Desktop with oracle
Port # 1521 is usually the default. If listener is bound to a different port, you need to pass that too through the firewall.
Thank you very much Jayanta