About Firewall Exceptions for Oracle Database
For a basic database operation and connectivity from remote clients (SQL*Plus, OCI, ODBC, OLE DB applications, and so on), add the following executables to the Windows Firewall exception list:
- 
                     
Oracle_home\bin\oracle.exe- Oracle Database executable - 
                     
Oracle_home\bin\tnslsnr.exe- Oracle Listener 
For remote monitoring capabilities to be available for a database running on Windows, the following executables must be added to the Windows Firewall exception list:
- 
                     
Oracle_home\bin\emagent.exe- Oracle Database Control - 
                     
Oracle_home\jdk\bin\java.exe-Java Virtual Machine