MGW.ORA

  • A Messaging Gateway administrator can specify the initialization file to be used for a Messaging Gateway agent via DBMS_MGWADM.CREATE_AGENT and DBMS_MGWADM.ALTER_AGENT.
(You can see this in the INITFILE column of MGW_GATEWAY)
  • If an initialization file is not specified then a default initialization file will be used.
  • The default initialization file for the default agent is ORACLE_HOME/mgw/admin/mgw.ora.
  • The default initialization file for a named agent is $ORACLE_HOME/mgw/admin/mgw_AGENTNAME.ora where AGENTNAME is the name in uppercase of the Messaging Gateway agent. For example, if the agent name is my_agent then the name of the agent's default initialization file is ORACLE_HOME/mgw/admin/mgw_MY_AGENT.ora.
  • If the default initialization file for a named agent is not found then ORACLE_HOME/mgw/admin/mgw.ora will be used.

Example Confguration Files

Oracle 12.2 Example mgw.ora

log_directory=
log_level = 0
set CLASSPATH=/u01/app/oracle/product/122010/jdbc/lib/ojdbc8.jar:/u01/app/oracle/product/122010/jdk/jre/lib/i18n.jar:/u01/app/oracle/product/122010/jdk/jre/lib/rt.jar:/u01/app/oracle/product/122010/sqlj/lib/runtime12.jar:/u01/app/oracle/product/122010/jlib/orai18n.jar:/u01/app/oracle/product/122010/jlib/jta.jar:/u01/app/oracle/product/122010/rdbms/jlib/jmscommon.jar:/u01/app/oracle/product/122010/rdbms/jlib/aqapi.jar:/usr/mqm/java/lib/com.ibm.mqjms.jar:/usr/mqm/java/lib/com.ibm.mq.jar:/usr/mqm/java/lib:/usr/mqm/java/lib/connector.jar:/usr/mqm/java/lib/com.ibm.mq.jmqi.jar

Oracle 12.1 Example mgw.ora

log_directory=
log_level = 0
set CLASSPATH=/u01/app/oracle/product/12.1.0.2/jdbc/lib/ojdbc6.jar:/u01/app/oracle/product/12.1.0.2/jdk/jre/lib/i18n.jar:/u01/app/oracle/product/12.1.0.2/jdk/jre/lib/rt.jar:/u01/app/oracle/product/12.1.0.2/sqlj/lib/runtime12.jar:/u01/app/oracle/product/12.1.0.2/jlib/orai18n.jar:/u01/app/oracle/product/12.1.0.2/jlib/jta.jar:/u01/app/oracle/product/12.1.0.2/rdbms/jlib/jmscommon.jar:/u01/app/oracle/product/12.1.0.2/rdbms/jlib/aqapi.jar:/usr/mqm/java/lib/com.ibm.mqjms.jar:/usr/mqm/java/lib/com.ibm.mq.jar:/usr/mqm/java/lib:/usr/mqm/java/lib/connector.jar:/usr/mqm/java/lib/com.ibm.mq.jmqi.jar

Oracle 11.2.0.3 Example mgw.ora

log_directory=
log_level = 0
set CLASSPATH=/u01/app/oracle/product/11.2.0.3/jdbc/lib/ojdbc5.jar:/u01/app/oracle/product/11.2.0.3/jdk/jre/lib/i18n.jar:/u01/app/oracle/product/11.2.0.3/jdk/jre/lib/rt.jar:/u01/app/oracle/product/11.2.0.3/sqlj/lib/runtime12.jar:/u01/app/oracle/product/11.2.0.3/jlib/orai18n.jar:/u01/app/oracle/product/11.2.0.3/jlib/jta.jar:/u01/app/oracle/product/11.2.0.3/rdbms/jlib/jmscommon.jar:/u01/app/oracle/product/11.2.0.3/rdbms/jlib/aqapi.jar:/usr/mqm/java/lib/com.ibm.mqjms.jar:/usr/mqm/java/lib/com.ibm.mq.jar:/usr/mqm/java/lib:/usr/mqm/java/lib/connector.jar:/usr/mqm/java/lib/com.ibm.mq.jmqi.jar

Notes from 11.2.0.3 Sample file


# Sample Message Gateway configuration file## Note: Most of the examples in this file use a UNIX type file system syntax.# For a system with a different syntax (e.g. Windows) the examples must be# adjusted accordingly.## The Messaging Gateway initialization file contains lines for setting# initialization parameters, environment variables, and Java properties.# Each entity must be specified on one line; it is not possible, for example,# for an initialization parameter specification to span multiple lines.# Leading whitespace is trimmed in all cases.
################################################################################ The initialization parameters are typically specified by lines having# a "<name>=<value><NL>" format where <name> represents the parameter name,# <value> represents its value and <NL> represents a new line.## Initialization parameters include log_directory and log_level.## log_directory The directory in which to create the log file# DEFAULT $ORACLE_HOME/mgw/log## log level Indicates the level of logging detail recorded by# the Message Gateway Agent.# VALUES: 0 Logging only (default)# 1 trace lite# 2 trace high# 3 trace debug# DEFAULT logging only.
# If a value is not specified, the default will be used# log_directory=
# Set logging level to logging only.# log_level = 0
################################################################################ Environment variables such as CLASSPATH and MGW_PREPATH are set so the# Messaging Gateway agent can find the required Java classes, libraries, etc.# Environment variables are specified by lines having a# "set <env var>= <value><NL>" or "setenv <env var>=<value><NL>" format# where <env var> represents the name of the environment variable to set,# <value> represents the value of the environment variable, and <NL># represents a new line.## CLASSPATH: used by the Java Virtual Machine to find Java classes needed# by the MGW agent.# CLASSPATH: Two separate classpaths are set below. The first applies to# WebSphere MQ propagation, the second to Tibco/Rendezvous.## Note that the JRE references in the CLASSPATHs below may be in different# locations depending on installation options and the platform used. These# examples assume that the JRE to be used is located at: ORACLE_HOME/jdk/jre## Set the CLASSPATH we need for the MGW Agent.# The following are examples of CLASSPATH settings for use with WebSphere MQ# (both Base Java and JMS) and Tibco/Rendezvous respectively. In these# examples "myOracleHome" should be replaced by the path of your ORACLE_HOME.#
# This classpath includes classes needed for both WebSphere MQ Base Java# and WebSphere MQ JMS propagation.# set CLASSPATH=/myOracleHome/jdbc/lib/ojdbc5.jar:/myOracleHome/jdk/jre/lib/i18n.jar:/myOracleHome/jdk/jre/lib/rt.jar:/myOracleHome/sqlj/lib/runtime12.jar:/myOracleHome/jlib/orai18n.jar:/myOracleHome/jlib/jta.jar:/myOracleHome/rdbms/jlib/jmscommon.jar:/myOracleHome/rdbms/jlib/aqapi.jar:/opt/mqm/java/lib/com.ibm.mqjms.jar:/opt/mqm/java/lib/com.ibm.mq.jar:/opt/mqm/java/lib:/opt/mqm/java/lib/connector.jar:/opt/mqm/java/lib/com.ibm.mq.jmqi.jar
# Set the CLASSPATH we need for the MGW Agent. This classpath includes classes# needed for Tibco/Rendezvous propagation.# In this example "TibRvHome" should be replaced by the home directory of your# Tibco/Rendezvous installation.# set CLASSPATH=/myOracleHome/jdbc/lib/ojdbc5.jar:/myOracleHome/jdk/jre/lib/i18n.jar:/myOracleHome/jdk/jre/lib/rt.jar:/myOracleHome/sqlj/lib/runtime12.jar:/myOracleHome/jlib/orai18n.jar:/myOracleHome/jlib/jta.jar:/myOracleHome/rdbms/jlib/jmscommon.jar:/myOracleHome/rdbms/jlib/aqapi.jar:/opt/mqm/java/lib/com.ibm.mqjms.jar:/opt/mqm/java/lib/com.ibm.mq.jmqi.jar:/TibRvHome/lib/tibrvj.jar
# MGW_PRE_PATH: will be appended to the front of the PATH inherited by the# Messaging Gateway process. For WINDOWS NT, this variable must be set to# indicate where the library jvm.dll may be found. For example:# set MGW_PRE_PATH=\myOracleHome\jdk\jre\bin\client
# When propagating to/from the Tibco/Rendezvous messaging system the bin# directory of the installation should be included. For example:# set MGW_PRE_PATH=/TibRvHome/bin
################################################################################ Java properties. Java properties can be set when creating the JVM of the# Messaging Gateway agent. Java properties are specified by lines having a# "setJavaProp <prop name>=<value><NL>" format where <prop name> represents# the name of the Java property to set, <value> represents the value of the# Java property, and <NL> represents a new line character.# Example:# setJavaProp oracle.mgw.batch_size = 10