Stat 6.2 - System Administration Guide

MSS SQL Server Database Tuning

MSS SQL Server is basically a self tuning system.

Be sure there is adequate space for Transaction logs based on your backup schedule

TempDB should be a minimum 50M for each database on the server, including the master, model, etc). e.g. if there are 6 databases, the tempdb should be, at minimum, 300M in size.

Run the following on a weekly basis:

Appendix: Oracle Applications File Type Directory

This appendix documents the directories Stat uses for retrieving an object list, archiving an object, and migrating an object for all the proprietary Oracle Applications file object types. Proprietary Oracle Applications file types require that the user select a product and language before Stat retrieves a list of objects. These attributes are used to determine the archive and migration locations.

Notation:

Oracle follows a precise file structure convention for locating files for specific types. Many sites do not adhere to the convention strictly for their custom object types. Stat provides flexibility where feasible and useful to accommodate common conventions used by many sites for storing custom files. For example, Oracle stores all FMB files in $AU_TOP/forms/<lang>. Many sites do not store custom FMB files in $AU_TOP, nor do they create a sub-directory for each language. Stat allows custom FMBs to be stored in $prodTop/forms directory.

An Oracle Applications environment can be partitioned across several physical servers. Logically, there are four servers: Web Server, Forms Server, Concurrent Manager, and Database. Objects for each object type are stored on one or more of these logical servers. The table also identifies the server type.

Appendix: Ports and Firewalls

This appendix provides instructions for resolving port conflicts and firewall issues that may prevent the Stat Central Agent from running. Typical port and firewall conflicts include:

Resolving port and firewall conflicts

If the Stat™ Central Agent will not run when started, the port assigned to it may already in use by a different program or there are firewalls that need to have ports opened for the Stat Central Agent to communicate with the database or with the Stat Client.

Typical port and firewall conflicts include:

If you have port conflicts, the server will display one or more error messages, such as:

The Stat Central Agent utilizes a set of ports that are already defined.

These values are defined for a default port offset of zero which is set in a variable called jboss.socket.binding.port-offset in standalone.conf.bat or standalone.conf file. If there is a conflict situation or a second or third agent is necessary, you may change the jboss.socket.binding.port-offset in standalone.conf.bat or standalone.conf file. The value for offset is added to all the default values.

For example:

NOTE: Be aware of the following: • Stat invokes the DNS server to resolve the fully qualified server name when communicating between the client and the central agent. When server hostname is not registered on the DNS server, use etc/hosts file to map hostname and its IP address. • HTTPS connector socket and Management socket — These ports are only necessary if the Stat Central Agent is configured to support HTTPS.

When other applications are using the same port as the Stat Central Agent, you need to change the port offset in your standalone.conf.bat or standalone.conf file.

The http port is the only port that needs to be opened on existing firewalls.

Other ports used by the Stat Central Agent include the following (the actual port numbers will vary according to your site specifications):

The Stat Client will need the same ports opened if there is a firewall between the client and any of the above items.

If there is a natted firewall between the Stat Central Agent and the Stat Oracle Agents, the following options must be configured in the stat.conf file for the Stat Oracle Agents. Older versions of Stat always required the fields to be filled in, but since 5.6.0, the Stat Oracle Agents query the Stat Central Agent for the secure Stat database information. You need only change the stat.db.server: value and indicate the natted ip address. For this scenario, they are not optional.

################################################################################

# Stat Repository

################################################################################

stat.db.jdbc_driver:oracle.jdbc.driver.OracleDriver

stat.db.server:<stat repository server name/ip> <-- Natted IP Address