Open port on Oracle Form & DB

Unanswered Question
Aug 21st, 2008


I configured remote access VPN to access Oracle DB server (I have two group ADMIN and CLIENT, this access for Client group only).A client application has be installed on VPN client's laptop and I have allowed port 1521 (sqlnet) on the firewall. But though users were able to connect VPN they cant access this oracle form and DB in it.

However when I open all the ports on the same server (IP level) it was able to access the applicaiton.

Here is please find attached configuraiton.

Are there any other ports to be open other than sqlnet (port 1521)?.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
pemasirid Thu, 08/21/2008 - 06:12

Hi Andrew,

Many thanks for your reply. the clients wants to open only sqnet port.since it didnt work I allowed all the ports then it worked. However as you suggested I will capture the packets for this vpn client & find out what are the ports it required to access and update you soon.


pemasirid Fri, 08/22/2008 - 03:18

Hi Andrew,

Could you please confirm that the following command syntax (using capture ACL) will OK to get TCP/UDP port details used by Oracle application.

access-list capturethis permit ip host client subnet) host (Oracle Appli.server)

access-list capturethis permit ip host host

capture cap1 access-list capturethis interface outside

show capture cap1



This Discussion