Chat now with support
Chat with Support

Stat 6.0 - System Administration Guide

Overview of Stat Administration Administrative Utilities Stat Security General Maintenance Tables
System Maintenance Service Domain Maintenance Department Maintenance Country Maintenance Customer Maintenance Object Type Maintenance PeopleSoft Environment Connection Maintenance Pre/Post Migration Steps Parameters Oracle Applications Configuration Oracle Applications Connection Maintenance Generic Application Connection Maintenance Schema Object Parameters Maintenance Data Object Maintenance PeopleSoft Search Configurations Stat Report Definition Maintenance Version Control Management Connection Maintenance
Service Domain-Specific Maintenance Configuring the Stat Central Agent Email Configuration Object Security Appendix: Sample Service Domain Configuration Appendix: User Class Rights Appendix: Creating a Staging Database Appendix: Database Tuning Appendix: Oracle Applications File Type Directory Appendix: Ports and Firewalls Appendix: Stat Web Services Appendix: Troubleshooting Chart Appendix: stat.conf Configuration Appendix: Custom Report Files

Appendix: stat.conf Configuration

The stat_ora.zip file includes a default stat.conf file, which after installation is located in the user’s home directory under <STAT_HOME>/conf. All the mandatory parameters and most commonly used parameters are included in this default configuration file. The value for some of these parameters will need to be updated. Additional parameters listed in this section may not be included in the default stat.conf file and, if applicable, will need to be defined by the user. The syntax for all parameters is name:value pair. Comments begin with a “#” character and end with the end of the line.

The following table lists all valid parameters. Some parameters apply to all instances of an agent (e.g. parameters to identify the Stat Repository), while others apply to each instances of an agent (e.g. parameters specific for an Oracle E-Business Suite environment).

Parameters prefixed with “stat” apply to all instances of an agent and should only be defined once in the configuration file. Parameters prefixed with <ENV> refer to an instance of the Stat Oracle Agent for a particular Oracle E-Business Suite environment. The <ENV> must be replaced with the environment code used to define that Oracle E-Business Suite environment in Stat.

When the Stat Oracle Agent is started, the stat.conf configuration parameters are cached in memory. You need to restart the agent before a parameter change can take effect.

<ENV>.adadmin_timeout

<ENV>.admin_port

<ENV>.autopatch_timeout

<ENV>.command_timeout

<ENV>.db_init_sql

<ENV>.DB_ORACLE_HOME

<env>.env.ADOP_LOG_PATTERN

<ENV>.env.APPLFENV

<ENV>.env.APPLREP

<ENV>.env.APPLTMP

<ENV>.env.APPL_TOP

<ENV>.env.<BaseDirCode>

<ENV>.env.CONTEXT_FILE

<ENV>.env.CONTEXT_NAME:<sid_hostname>

<ENV>.env.CONTEXT_FILE

<ENV>.env.CUSTOM_OAF_ROOT_PATH

<env>.env.CUSTOM_PRODUCTS

<ENV>.env.JAVA_TOP

<ENV>.env.NLS_LANG

<ENV>.env.ORACLE_HOME

<ENV>.env.<parameter>

<ENV>.env.PLSQL_ERROR_EXPRESSION

<ENV>.env.<ProductCode>

<ENV>.env.set_escape_processing

<ENV>.env.SHARED_PRODUCTS

<env>.env.ssh_disabled

<ENV>.env.SQLPLUS_PREPROCESSORS

<ENV>.env.TWO_TASK

<ENV>.env.USE_DATABASE_CHARACTERSET

<ENV>.env.XMLEXPORTER_OPTIONAL_PARMS

<ENV>.env.XMLIMPORTER_OPTIONAL_PARMS

<ENV>.event_timeout

<ENV>.event_processors

<ENV>. java.naming.factory.initial

<ENV>.log.directory

<ENV>.log.file

<ENV>.log.level

<ENV>.log.pattern

<ENV>.log.rolling.frequency

<ENV>.log.rolling.size

<ENV>.log.rolling.type

<ENV>.maintmode_script

<ENV>.maintmode_timeout

<ENV>.migration_order_timeout

<ENV>.servername

<ENV>.shutdown_services_timeout

<ENV>.skip_show_errors

<ENV>._skip_object_generation

<ENV>.env.TWO_TASK

<ENV>._sqlplus_timeout

<ENV>.WFLOAD.upload_mode

stat.central_agent.disconnect_action

stat.central_agent.name_port

stat.central_agent.server

stat.db.jdbc_driver

stat.db.name

stat.db.password

stat.db.port

stat.db.server

stat.db.username

<ENV>.adadmin_timeout

Minutes the Stat Oracle Agent will wait for an adadmin command to produce an output. The Stat Oracle Agent will fail the Adadmin session if the inactivity (i.e., no output) exceeds this parameter. Default is 5 minutes.

<ENV>.admin_port

Port on local server for administering the Stat Oracle Agent processes for <ENV> Oracle E-Business Suite environment. Any unused port greater than 1024 can be used (e.g., 5501, 5502). The parameter for each environment on the server must be unique.

<ENV>.autopatch_timeout

Minutes the Stat Oracle Agent will wait while monitoring AutoPatch activity. The Stat Oracle Agent will fail the AutoPatch session if the inactivity (i.e., no output) exceeds this parameter. Default is 5 minutes. Larger patches may require up to 15 minutes.

Related Documents