Windows Environment installation ORACLE11G DB or RAC firewall must be through the process, port

Source: Internet
Author: User

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:

    • Oracle_home\bin\oracle.exe -Oracle Database Executable

    • Oracle_home\bin\tnslsnr.exe -Oracle Listener

IF you use remote monitoring capabilities for your database, the following executables must is added to the Windows Firewa LL exception list:

    • Oracle_home\bin\emagent.exe -Oracle Database Control

    • Oracle_home\jdk\bin\java.exe -Java Virtual Machine (JVM) for Enterprise Manager Database Control

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:

    • Oracle_home\opmn\bin\opmn.exe -Oracle Process Manager

    • Oracle_home\jdk\bin\java.exe -JVM

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:

    • Microsoft file sharing System Management bus (SMB)

      • User Datagram Protocol (UDP) ports from 135 through 139

      • TCP ports from 135 through 139

    • direct-hosted SMB traffic without a network basic I/O system (NetBIOS)

      • Port 445 (TCP and UPD)

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:

    • Grid_home\cfs\Ocfsfindvol.exe -OCFS for Windows Volume Service

    • %WINDOWS_HOME%\system32\drivers\Ocfs.sys -System file for OCFS (if using OCFS for Windows for Oracle clusterware storage)

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.