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