Configure Server Time Zone Settings

For File Watcher to load the data files it detects in a timely manner, the date and time settings on your servers—database server, the middle tier server where the WebLogic Server is installed, and the middle tier server(s) where the Oracle LSH Distributed Processing (DP) Server is installed—must all have the same date and time setting.

If your servers are located in different time zones, set the time zone manually or automatically. Then verify the setting used by the Java Virtual Machine (JVM). See the following topics for details:

• Set the TZ Environment Variable Manually
  
• Set the TZ Environment Variable Automatically
  
• Use the tzselect Utility
  
• Verify the Time Zone Setting Used by Java Virtual Machine (JVM)
  

Set the TZ Environment Variable Manually

You can set the TZ environment variable as follows:

TZ='<correct timezone>'export TZ

For example, to set the time zone to the US Pacific time zone:

TZ='America/Los_Angeles'export TZ

To determine a valid TZ value, see Use the tzselect Utility.

Set the TZ Environment Variable Automatically

You can set the TZ environment variable automatically by one of the following methods:

• Set the TZ variable in the startup configuration file (.profile or .cshrc file) for the operating system user that runs the DP Server process or the Web Logic Server process on the respective middle tier.
• Set the TZ variable in the shell script that starts the process:
  • For the DP Server, set the TZ variable in the DP Server Home/cdr_apps_dpserver.sh shell script, or in a shell script that invokes cdr_apps_dpserver.sh; see the Oracle Life Sciences Data Hub Installation Guide for information
  • For the Web Logic Server, set the TZ variable in the setDomainEnv.sh script from your Web Logic installation in a full path similar to middleware_home/user_projects/domains/base_domain/bin/setDomainEnv.sh.

To determine a valid TZ value, see Use the tzselect Utility.

Use the tzselect Utility

Many UNIX systems provide the tzselect utility to aid in selecting a Posix standard time zone format. You enter this command at the UNIX command prompt with no arguments and it prompts you to select a continent or ocean and then a time zone region. It returns the string to use in the TZ command.

See your operating system documentation for more information about this command in your specific environment.

Verify the Time Zone Setting Used by Java Virtual Machine (JVM)

On the middle tier servers DMW is implemented using Java, and you must confirm that the Java Virtual Machine (JVM) is using the correct time zone

Note that a correct return from the UNIX date command does NOT mean that the Java Virtual Machine (JVM) is using the correct time zone. The JVM looks for the time zone settings as follows. This can vary in different implementations of UNIX/Linux, so check your operating system documentation for further information:

1. JVM uses the environment variable TZ if it is set.
2. If TZ is not set, then JVM looks for the file /etc/sysconfig/clock and finds the ZONE entry.
3. If neither TZ nor ZONE is set, JVM compares the contents of /etc/localtime to the files in /usr/share/zoneinfo looking for a match. The matching path and filename under /usr/share/zoneinfo provides the time zone.

Check the time zone that the DP Server and Web Logic Server are actually using by reading the time zone information displayed at the beginning of most lines in their log files:

• DP Server: The log file is located in the directory: DP Server Home/log.
• Web Logic Server: The log file is located in a full path similar to: /app/product/middleware/user_projects/domains/base_domain/servers/DMWServer/logs.