OPMN.xml is the main configuration file for OPMN that is used to launch each system component (such as Oracle Business Intelligence).
It specifies environment variable (path, …)
The opmn.xml file contains specific configuration for:
The opmn.xml file is divided into three main sections:
The opmn.xml is located in the following directory: ORACLE_INSTANCE/config/OPMN/opmn/opmn.xml
Log
The log files configuration by default fully enables the standard log but disables the debug log
Notification
The notification-server configuration includes the OPMN listener ports as well as secure connection definition.
Process manager
The process-manager configuration includes all information required for each managed component.
Property meaning
Example
<?xml version = '1.0' encoding = 'UTF-8'?> <opmn xmlns="http://www.oracle.com/ias-instance"> <log comp="internal;ons;pm" rotation-size="1500000"/> <debug comp="" rotation-size="1500000"/> <notification-server interface="any"> <port local="6700" remote="6701"/> <ssl enabled="true" wallet-file="/u01/app/oracle/product/fmw/instances/instance1/config/OPMN/opmn/wallet"/> </notification-server> <process-manager> <process-modules> <module path="$ORACLE_HOME/opmn/lib/libopmnohs"> <module-id id="OHS2"/> </module> <module path="$ORACLE_HOME/opmn/lib/libopmncustom"> <module-id id="CUSTOM"/> </module> <module path="$ORACLE_HOME/opmn/lib/libopmnoid"> <module-id id="OID"/> </module> <module path="$ORACLE_HOME/opmn/lib/libopmnbi"> <module-id id="BIServer"/> <module-id id="BIScheduler"/> <module-id id="BIPresentationServices"/> <module-id id="BIClusterController"/> <module-id id="BIJavaHost"/> </module> <module path="$ORACLE_HOME/opmn/lib/libopmnovd"> <module-id id="OVD"/> </module> <module path="$ORACLE_HOME/opmn/lib/libopmnwc"> <module-id id="WebCache"/> <module-id id="WebCache-admin"/> </module> <module path="$ORACLE_HOME/opmn/lib/libopmnreports"> <module-id id="ReportsServices"/> <module-id id="ReportsBridgeServices"/> </module> <module path="$ORACLE_HOME/opmn/lib/libopmndisco"> <module-id id="Disco_ServicesStatus"/> <module-id id="Disco_SessionServer"/> <module-id id="Disco_PreferenceServer"/> </module> <module path="$ORACLE_HOME/opmn/lib/libopmnemagent"> <module-id id="EMAGENT"/> </module> <module path="$ORACLE_HOME/products/Essbase/EssbaseServer/bin/libopmness"> <module-id id="ESS"/> </module> </process-modules> <ias-instance id="instance1" name="instance1"> <environment> <variable id="TEMP" value="/tmp"/> <variable id="TMP" value="/tmp"/> </environment> <ias-component id="coreapplication_obis1" inherit-environment="true"> <environment> <variable id="ORACLE_BI_OPMNMANAGED" value="true"/> <variable id="ORACLE_BI_APPLICATION" value="coreapplication"/> <variable id="ORA_NLS10" value="$ORACLE_HOME/nls/data"/> <variable id="UNIXPERFDIR" value="$ORACLE_INSTANCE/tmp/$COMPONENT_TYPE/$COMPONENT_NAME"/> <variable id="LD_LIBRARY_PATH" value="$ORACLE_HOME/common/ODBC/Merant/5.3/lib$:$ORACLE_HOME/bifoundation/server/bin$:$ORACLE_HOME/bifoundation/web/bin$:$ORACLE_HOME/clients/epm/Essbase/EssbaseRTC/bin$:$ORACLE_HOME/bifoundation/odbc/lib$:$ORACLE_INSTANCE$:$ORACLE_HOME/lib:/u01/app/oracle/product/TimesTen/tt1122/lib" append="true"/> <variable id="ODBCINI" value="$ORACLE_INSTANCE/bifoundation/OracleBIApplication/$ORACLE_BI_APPLICATION/setup/odbc.ini"/> <variable id="PATH" value="$ORACLE_HOME/common/ODBC/Merant/5.3/lib$:$ORACLE_HOME/bifoundation/server/bin$:$ORACLE_HOME/bifoundation/web/bin$:$ORACLE_HOME/clients/epm/Essbase/EssbaseRTC/bin$:$ORACLE_HOME/bifoundation/odbc/lib$:$ORACLE_INSTANCE$:$ORACLE_HOME/lib$:$PATH$:$/bin" append="true"/> <variable id="ESSBASEPATH" value="$ORACLE_HOME/clients/epm/Essbase/EssbaseRTC"/> <variable id="TIMESTEN_DLL" value="/u01/app/oracle/product/TimesTen/tt1122/lib/libttclient.so"/> </environment> <process-type id="OracleBIServerComponent" module-id="CUSTOM"> <module-data> <category id="start-parameters"> <data id="start-executable" value="$ORACLE_HOME/bifoundation/server/bin/biserver.sh"/> <data id="start-args" value="-quiet"/> <data id="no-stdio" value="false"/> </category> <category id="stop-parameters"> <data id="stop-executable" value="integrator"/> </category> <category id="ping-parameters"> <data id="ping-type" value="integrator"/> </category> <category id="ready-parameters"> <data id="use-ping-for-ready" value="true"/> </category> </module-data> <start timeout="600" retry="1"/> <stop timeout="120"/> <restart timeout="720" retry="1"/> </process-type> </ias-component> <ias-component id="coreapplication_obips1"> <!-- Environment variables for the process --> <!-- Note that COMPONENT_NAME (=ias-component id) and COMPONENT_TYPE(=process-type id) are automatically passed by OPMN --> <environment> <variable id="ORACLE_BI_OPMNMANAGED" value="true"/> <variable id="ORACLE_BI_APPLICATION" value="coreapplication"/> <!-- Temporarily required to pass ORACLE_BIPS_INSTANCE_CONFIGDIR since the COMPONENT_CONFIGDIR passed automatically from OPMN is incorrect --> <variable id="ORA_NLS10" value="$ORACLE_HOME/nls/data"/> <variable id="ORACLE_BIPS_INSTANCE_CONFIGDIR" value="$ORACLE_INSTANCE/config/$COMPONENT_TYPE/$COMPONENT_NAME"/> <!-- Location of Perf dump files --> <variable id="UNIXPERFDIR" value="$ORACLE_INSTANCE/tmp/$COMPONENT_TYPE/$COMPONENT_NAME"/> <variable id="ODBCINI" value="$ORACLE_INSTANCE/bifoundation/OracleBIApplication/$ORACLE_BI_APPLICATION/setup/odbc.ini"/> <variable id="LD_LIBRARY_PATH" value="$ORACLE_HOME/common/ODBC/Merant/5.3/lib$:$ORACLE_HOME/bifoundation/server/bin$:$ORACLE_HOME/bifoundation/web/bin$:$ORACLE_HOME/bifoundation/odbc/lib$:$ORACLE_INSTANCE$:$ORACLE_HOME/lib" append="true"/> <variable id="PATH" value="$ORACLE_HOME/common/ODBC/Merant/5.3/lib$:$ORACLE_HOME/bifoundation/server/bin$:$ORACLE_HOME/bifoundation/web/bin$:$ORACLE_HOME/bifoundation/odbc/lib$:$ORACLE_INSTANCE$:$ORACLE_HOME/lib" append="true"/> </environment> <process-type id="OracleBIPresentationServicesComponent" module-id="CUSTOM"> <module-data> <category id="start-parameters"> <data id="start-executable" value="$ORACLE_HOME/bifoundation/web/bin/sawserver"/> <!-- enable console log to be able to see process startup error --> <data id="no-stdio" value="false"/> </category> <category id="stop-parameters"> <data id="stop-executable" value="integrator"/> </category> <category id="ping-parameters"> <data id="ping-type" value="integrator"/> </category> <category id="ready-parameters"> <data id="use-ping-for-ready" value="true"/> </category> </module-data> <start timeout="600" retry="1"/> <stop timeout="120"/> <restart timeout="720" retry="1"/> </process-type> </ias-component> <ias-component id="coreapplication_obijh1"> <environment> <variable id="ORACLE_BI_OPMNMANAGED" value="true"/> <variable id="ORACLE_BI_APPLICATION" value="coreapplication"/> <variable id="JAVA_HOME" value="$ORACLE_HOME/jdk"/> <variable id="COMMON_COMPONENTS_HOME" value="$ORACLE_HOME/../oracle_common"/> <variable id="XDO_FONT_DIR" value="$ORACLE_HOME/common/fonts"/> <variable id="UNIXPERFDIR" value="$ORACLE_INSTANCE/tmp/$COMPONENT_TYPE/$COMPONENT_NAME"/> <variable id="LD_LIBRARY_PATH" value="$ORACLE_HOME/common/ODBC/Merant/5.3/lib$:$ORACLE_HOME/bifoundation/server/bin$:$ORACLE_HOME/bifoundation/web/bin$:$ORACLE_HOME/bifoundation/odbc/lib$:$ORACLE_INSTANCE$:$ORACLE_HOME/lib" append="true"/> <variable id="PATH" value="$ORACLE_HOME/common/ODBC/Merant/5.3/lib$:$ORACLE_HOME/bifoundation/server/bin$:$ORACLE_HOME/bifoundation/web/bin$:$ORACLE_HOME/bifoundation/odbc/lib$:$ORACLE_INSTANCE$:$ORACLE_HOME/lib" append="true"/> </environment> <process-type id="OracleBIJavaHostComponent" module-id="CUSTOM"> <module-data> <category id="start-parameters"> <data id="start-executable" value="$ORACLE_HOME/jdk/bin/java"/> <data id="start-args" value="-server -Xmx1024M -Djava.security.manager=default -DXDO_FONT_DIR=$ORACLE_HOME/common/fonts -Djava.security.policy=$ORACLE_INSTANCE/config/$COMPONENT_TYPE/$COMPONENT_NAME/java.policy -Djava.util.logging.config.class=oracle.core.ojdl.logging.LoggingConfiguration -Doracle.core.ojdl.logging.config.file=$ORACLE_INSTANCE/config/$COMPONENT_TYPE/$COMPONENT_NAME/logging-config.xml -Doracle.home=$ORACLE_HOME -Doracle.instance=$ORACLE_INSTANCE -Doracle.component.type=$COMPONENT_TYPE -Doracle.component.name=$COMPONENT_NAME -classpath $COMMON_COMPONENTS_HOME/modules/oracle.odl_11.1.1/ojdl.jar$:$ORACLE_HOME/bifoundation/javahost/lib/core/sautils.jar$:$ORACLE_HOME/bifoundation/javahost/lib/core/mad.jar$:$ORACLE_HOME/bifoundation/javahost/lib/core/sawconnect.jar$:$ORACLE_HOME/bifoundation/javahost/lib/core/javahost.jar$:$COMMON_COMPONENTS_HOME/modules/oracle.xdk_11.1.0/xmlparserv2.jar$:$ORACLE_HOME/opmn/lib/ons.jar$:$COMMON_COMPONENTS_HOME/modules/oracle.jps_11.1.1/jps-manifest.jar$:$COMMON_COMPONENTS_HOME/modules/oracle.jps_11.1.1/jps-api.jar$:$COMMON_COMPONENTS_HOME/modules/oracle.jps_11.1.1/jps-common.jar$:$COMMON_COMPONENTS_HOME/modules/oracle.jps_11.1.1/jps-internal.jar$:$COMMON_COMPONENTS_HOME/modules/oracle.nlsrtl_11.1.0/orai18n.jar$:$COMMON_COMPONENTS_HOME/modules/oracle.nlsrtl_11.1.0/orai18n-collation.jar$:$COMMON_COMPONENTS_HOME/modules/oracle.nlsrtl_11.1.0/orai18n-mapping.jar$:$COMMON_COMPONENTS_HOME/modules/oracle.dms_11.1.1/dms.jar com.siebel.analytics.javahost.standalone.Main"/> <data id="java-proc" value="true"/> <data id="no-stdio" value="true"/> </category> <category id="stop-parameters"> <data id="stop-executable" value="integrator"/> </category> <category id="ping-parameters"> <data id="ping-type" value="integrator"/> </category> <category id="ready-parameters"> <data id="use-ping-for-ready" value="true"/> </category> </module-data> <start timeout="600" retry="1"/> <stop timeout="120"/> <restart timeout="720" retry="1"/> </process-type> </ias-component> <ias-component id="coreapplication_obisch1"> <environment> <variable id="ORACLE_BI_OPMNMANAGED" value="true"/> <variable id="ORACLE_BI_APPLICATION" value="coreapplication"/> <variable id="ORA_NLS10" value="$ORACLE_HOME/nls/data"/> <variable id="UNIXPERFDIR" value="$ORACLE_INSTANCE/tmp/$COMPONENT_TYPE/$COMPONENT_NAME"/> <variable id="LD_LIBRARY_PATH" value="$ORACLE_HOME/common/ODBC/Merant/5.3/lib$:$ORACLE_HOME/bifoundation/server/bin$:$ORACLE_HOME/bifoundation/web/bin$:$ORACLE_HOME/bifoundation/odbc/lib$:$ORACLE_INSTANCE$:$ORACLE_HOME/lib" append="true"/> <variable id="PATH" value="$ORACLE_HOME/common/ODBC/Merant/5.3/lib$:$ORACLE_HOME/bifoundation/server/bin$:$ORACLE_HOME/bifoundation/web/bin$:$ORACLE_HOME/bifoundation/odbc/lib$:$ORACLE_INSTANCE$:$ORACLE_HOME/lib$:$PATH" append="true"/> <variable id="ODBCINI" value="$ORACLE_INSTANCE/bifoundation/OracleBIApplication/$ORACLE_BI_APPLICATION/setup/odbc.ini"/> </environment> <process-type id="OracleBISchedulerComponent" module-id="CUSTOM"> <module-data> <category id="start-parameters"> <data id="start-executable" value="$ORACLE_HOME/bifoundation/server/bin/bischeduler.sh"/> <!-- enable console log to be able to see process startup error --> <data id="no-stdio" value="false"/> </category> <category id="stop-parameters"> <data id="stop-executable" value="integrator"/> </category> <category id="ping-parameters"> <data id="ping-type" value="integrator"/> </category> <category id="ready-parameters"> <data id="use-ping-for-ready" value="true"/> </category> </module-data> <start timeout="600" retry="1"/> <stop timeout="120"/> <restart timeout="720" retry="1"/> </process-type> </ias-component> <ias-component id="coreapplication_obiccs1"> <environment> <variable id="ORACLE_BI_OPMNMANAGED" value="true"/> <variable id="ORACLE_BI_APPLICATION" value="coreapplication"/> <variable id="ORA_NLS10" value="$ORACLE_HOME/nls/data"/> <variable id="UNIXPERFDIR" value="$ORACLE_INSTANCE/tmp/$COMPONENT_TYPE/$COMPONENT_NAME"/> <variable id="LD_LIBRARY_PATH" value="$ORACLE_HOME/common/ODBC/Merant/5.3/lib$:$ORACLE_HOME/bifoundation/server/bin$:$ORACLE_HOME/bifoundation/web/bin$:$ORACLE_HOME/bifoundation/odbc/lib$:$ORACLE_INSTANCE$:$ORACLE_HOME/lib" append="true"/> <variable id="PATH" value="$ORACLE_HOME/common/ODBC/Merant/5.3/lib$:$ORACLE_HOME/bifoundation/server/bin$:$ORACLE_HOME/bifoundation/web/bin$:$ORACLE_HOME/bifoundation/odbc/lib$:$ORACLE_INSTANCE$:$ORACLE_HOME/lib" append="true"/> </environment> <process-type id="OracleBIClusterControllerComponent" module-id="CUSTOM"> <module-data> <category id="start-parameters"> <data id="start-executable" value="$ORACLE_HOME/bifoundation/server/bin/nqsclustercontroller"/> <data id="no-stdio" value="true"/> </category> <category id="stop-parameters"> <data id="stop-executable" value="integrator"/> </category> <category id="ping-parameters"> <data id="ping-type" value="integrator"/> </category> <category id="ready-parameters"> <data id="use-ping-for-ready" value="true"/> </category> </module-data> <start timeout="600" retry="1"/> <stop timeout="120"/> <restart timeout="720" retry="1"/> <process-set id="BIClusterController" numprocs="1"/> </process-type> </ias-component> </ias-instance> <rmd-definitions> <!-- Audit Loader Setup TODO Update the interval for Audit Loader to control how frequently the Standalone Audit Loader gets invoked (seconds). --> <rmd name="AuditLoader" interval="315360000"> <conditional> ({time}>=00:00) </conditional> <!-- Audit Loader Setup TODO Before Updating the action snippet below, please update the password in the Secret Store --> <!-- Audit Loader Setup TODO Update the jdbcString (@%host%:%port%:%sid%) Update the username (%username%) Update the password (%password%) in Secret Store by adding 2 more system properties: -Dstore.password=true -Dauditloader.password=%password% --> <action value="exec $ORACLE_HOME/jdk/bin/java -classpath $COMMON_COMPONENTS_HOME/modules/oracle.osdt_11.1.1/osdt_cert.jar$:$COMMON_COMPONENTS_HOME/modules/oracle.osdt_11.1.1/osdt_core.jar$:$ORACLE_HOME/jdbc/lib/ojdbc5.jar$:$COMMON_COMPONENTS_HOME/modules/oracle.iau_11.1.1/fmw_audit.jar$:$COMMON_COMPONENTS_HOME/modules/oracle.pki_11.1.1/oraclepki.jar -Doracle.home=$ORACLE_HOME -Doracle.instance=$ORACLE_INSTANCE -Dauditloader.jdbcString=jdbc:oracle:thin:@%host%:%port%:%sid% -Dauditloader.username=%username% oracle.security.audit.ajl.loader.StandaloneAuditLoader" timeout="60"/> <exception value="exec /bin/echo PERIODICAL CALL FOR Audit Loader FAILED"/> </rmd> </rmd-definitions> <launch-targets> <launch-target id="logquery"> <exec path="$ORACLE_HOME/jdk/bin/java"/> <argument value="-classpath"/> <argument value="$COMMON_COMPONENTS_HOME/modules/oracle.odl_11.1.1/ojdl.jar$:$COMMON_COMPONENTS_HOME/modules/oracle.odl_11.1.1/ojdl2.jar"/> <argument value="-Djava.encoding=utf-8"/> <argument value="oracle.as.management.logging.tools.LogQuery"/> <argument value="-i"/> <argument value="$ORACLE_INSTANCE"/> </launch-target> <launch-target id="createcomponent" timeout="600"> <exec path="$ORACLE_INSTANCE/bin/opmnctl$BAT_EXT"/> <argument value="createcomponent"/> </launch-target> <launch-target id="deletecomponent" timeout="600"> <exec path="$ORACLE_INSTANCE/bin/opmnctl$BAT_EXT"/> <argument value="deletecomponent"/> </launch-target> <launch-target id="reload" reload-timeout="0"> <exec path="$ORACLE_INSTANCE/bin/opmnctl$BAT_EXT"/> <argument value="reload"/> </launch-target> </launch-targets> </process-manager> </opmn>
where you can find the environment variables by system component. For instance for BI Server (ISA component, coreapplication_obis1), you can find the location of the ODBC.INI file of OB
