1.Firewall Exceptions for Oracle Database
For basic database operation and connectivity from remote clients, such as Sql*plus, Oracle call Interface (OCI), Open Dat Abase Connectivity (ODBC), Object Linking and Embedding database (OLE DB) applications, and so on, the following EXECUTABL Es must is added to the Windows Firewall exception list:
IF you use remote monitoring capabilities for your database, the following executables must is added to the Windows Firewa LL exception list:
2.Firewall Exceptions for Oracle Database Examples (or the Companion CD)
After installing the Oracle Database Companion CD, the following executables must is added to the Windows Firewall Excepti On list:
3,Firewall Exceptions for Oracle Gateways
If your Oracle database interacts with non-oracle software through a gateway and then we must add the gateway executable to The Windows Firewall exception list. Table 5-1table lists the gateway executables used to access non-oracle software.
Table 5-1 Oracle executables used to Access non-oracle software
executable Name |
Description |
omtsreco.exe
|
Oracle Services for Microsoft Transaction Server |
dg4sybs.exe
|
Oracle Database Gateway for Sybase |
dg4tera.exe
|
Oracle Database Gateway for Teradata |
dg4msql.exe
|
Oracle Database Gateway for SQL Server |
dg4db2.exe
|
Oracle database Gateway for Distributed relational database Architecture (DRDA) |
pg4arv.exe
|
Oracle Database Gateway for communication (APPC) |
pg4t4ic.exe
|
Oracle Database Gateway for APPC |
dg4mqs.exe
|
Oracle Database Gateway for WebSphere MQ |
dg4mqc.exe
|
Oracle Database Gateway for WebSphere MQ |
dg4odbc.exe
|
Oracle Database Gateway for ODBC |
4,Firewall Exceptions for Oracle Clusterware and Oracle ASM
If you installed the Oracle Grid Infrastructure software on the nodes in your cluster and then you can enable the Windows Fir ewall only after adding the following executables and ports to the Firewall exception list. The Firewall Exception list must is updated on each node.
Grid_home
\bin\gpnpd.exe
-Grid Plug and Play daemon
Grid_home
\bin\oracle.exe
-Oracle Automatic Storage Management (Oracle ASM) executable (if using Oracle ASM for Storage)
Grid_home
\bin\racgvip.exe
-Virtual Internet Protocol Configuration Assistant
Grid_home
\bin\evmd.exe
-Oracleevmservice
Grid_home
\bin\crsd.exe
-Oraclecrservice
Grid_home
\bin\ocssd.exe
-Oraclecsservice
Grid_home
\bin\octssd.exe
-Cluster time synchronization Service Daemon
Grid_home
\bin\mDNSResponder.exe
-Multicast-domain Name System (DNS) Responder Daemon
Grid_home
\bin\gipcd.exe
-Grid inter-process communication (IPC) daemon
Grid_home
\bin\gnsd.exe
-Grid naming Service (GNS) daemon
Grid_home
\bin\ohasd.exe
-Oracleohservice
Grid_home
\bin\TNSLSNR.EXE
-Single Client Access name (SCAN) listener and local listener for Oracle RAC database and Oracle ASM
Grid_home
\opmn\bin\ons.exe
-Oracle Notification Service (ONS)
Grid_home
\jdk\jre\bin\java.exe
-JVM
5 , Firewall Exceptions for Oracle RAC Database
For the Oracle RAC database, the executables that require exceptions is:
-
oracle_home
\bin\oracle.exe
-Oracle RAC database instance
-
oracle_home
\bin\emagent.exe
-Oracle Enterprise Manager agent
-
oracle_home
\jdk\bin\java.exe
-for the Oracle Enterprise Manager Database Console
In addition, the following ports should is added to the Windows Firewall exception list:
6,Firewall Exceptions for Oracle Cluster File System for Windows
IF You use Oracle Cluster File System for Windows (OCFS for Windows) to store the Oracle Clusterware files, or Oracle RAC Database files, then you must add the following exceptions to the Windows Firewall:
7,Firewall Exceptions for other Oracle products
In addition to all the previously listed exceptions, if you use any of the Oracle software listed in, then you must create An exception for Windows Firewall for the associated executable.
Table 5-2 other Oracle software products requiring Windows Firewall Exceptions
Oracle Software Product |
executable Name |
Data Guard Manager |
dgmgrl.exe
|
Oracle Internet Directory Lightweight Directory Access Protocol (LDAP) Server |
oidldapd.exe
|
External Procedural Calls |
extproc.exe
|
Windows Environment installation ORACLE11G DB or RAC firewall must be through the process, port