ITEC Newsletter
Volume 15, No. 1
February 2, 2007

Table of Contents

  1. 2007 Daylight Savings Time Change
  2. Oracle and Daylight Savings Time Change
  3. Lotus Notes / Domino and Daylight Savings Time
  4. New Security Approach from Oracle
  5. CPU’s and 9.2 RDBMS Desupport Date
  6. Banner Performance at University of Illinois
  7. Spring 2007 Wizard

 

 

1. 2007 Daylight Saving Time Change

The Energy Policy Act of 2005 (Public Law 109-58) was passed by the United States Congress on July 29, 2005 and signed into law on August 8, 2005. This law changes the time-change dates for Daylight Saving Time in the United States. Beginning in 2007, DST will begin on the second Sunday in March and end on the first Sunday in November.

Below are links to the various Operating System's patches to address the DST time change for 2007:

Java Runtime Environment:  http://java.sun.com/developer/technicalArticles/Intl/USDST/

Redhat Linux: http://kbase.redhat.com/faq/FAQ_80_7909.shtm
(At the time this newsletter was distributed, this URL / link is currently not working but we have verified it is correct.  We believe the respective sites may be having an issue or may be redeploying the documentation.  We will keep you advised.)  Feb 3, 2007 Follow-up:  The link, http://kbase.redhat.com/faq/FAQ_80_7909.shtm, is still the top hit when searching for DST on Redhat's kbase site. 

Some other references that might be of some help from RedHat:
FAQ specific to RHEL4 and DST: http://kbase.redhat.com/faq/FAQ_85_9951.shtm
FAQ on testing your system's time after DST: http://kbase.redhat.com/faq/FAQ_85_9714.shtm
 

Microsoft Operating Systems (including Exchange Server): http://www.microsoft.com/windows/timezone/dst2007.mspx

IBM AIX: http://www-03.ibm.com/servers/eserver/support/unixservers/news/2006/10/DSTupdate.html

SUN Solaris: http://sunsolve.sun.com/search/document.do?assetkey=1-26-102775-1

HP HP-UX: http://www2.itrc.hp.com/service/cki/docDisplay.do?docLocale=en_US&docId=200000084528322

HP OpenVMS: http://h71000.www7.hp.com/dst.html

The time may be updated "MANUALLY" on any system with the following procedure on March-11

$ @sys$manager:UTC$TIME_SETUP.COM

OR

*********************************************************************************************

For "AUTOMATIC" updates and users running VMS 7.3-2--(the system will require an immediate reboot for the Update-9 patch) (No update is available for VMS 7.3-1 must use manual)

1.VMS732_PCSI-V0300 (installer patch-no reboot)

2.VMS732_UPDATE-V0900 (update bundle-reboot required)

3.DEC-AXPVMS-VMS732_TZ-V0300 (new daylight time patch-no reboot)

ALTERNATE-BATCH QUEUE METHOD

**********************************************************************************************

IF the sysgen parameter "AUTO_DLIGHT_SAV" is set to 1 you must set it to 0 and reboot-(the parameter is NOT dynamic)

Example-

$ MC SYSGEN

SYSGEN> SHO AUTO

Parameter Name Current Default Min. Max. Unit Dynamic

-------------- ------- ------- ------- ------- ---- -------

AUTO_DLIGHT_SAV 1 0 0 1 Boolean

SYSGEN> SET AUTO_DLIGHT_SAV 0

SYSGEN> WRITE CURRENT

SYSGEN> EXIT

(REBOOT THE SYSTEM AT YOUR CONVIENIENCE BEFORE SETTING THE QUEUE)

$ @SYS$EXAMPLES:DAYLIGHT_SAVINGS.COM

Are you changing to DAYLIGHT or to STANDARD time? (DAYLIGHT/STANDARD): DAY

Will the sysman be on this NODE only or CLUSTER wide? (NODE/CLUSTER): NODE

If you choose to SAVE the procedures, you can modify

the SYSMAN environment, or make other changess before executing.

Do you wish to EXECUTE the change now, QUEUE it for future execution,

or SAVE the created procedures without executing?

(EXECUTE/QUEUE/SAVE): QUEUE

Created file WAYNE$DKA0:[VMS$COMMON.SYSMGR]DST$CHANGE.COM

Enter the time at which the queued procedure will execute.

(Default is 2:00 AM tomorrow.)

(DD-MMM-YYYY HH:MM): 11-MAR-2007 02:00

Job DST$CHANGE (queue SYS$BATCH, entry 10) holding until 11-MAR-2007 02:00

$


Submitted by Mike Radomski (Mike.Radomski@itec.suny.edu)

 

2. Oracle and Daylight Saving Time

The change in the daylight savings time start/stop dates as passed into law by Congress in 2005 takes effect this spring and will probably necessitate patches to your Oracle database, application servers and other database clients. These patches must be installed prior to the March 11, 2007.

Attached Note:359145.1 is a good starting point in helping you assess the situation as it pertains to your installation and understand the patch application process. 

For campuses that receive database management services from ITEC you can expect us to be requesting downtime to apply the applicable patches in the near future.

Two important FYI's:

a) We have an open issue with Oracle support regarding Application Server 9.4.0.2 and the lack of an available patch. We will pass on information as it pertains to this as well once we have a more firm answer from Oracle support.

b) Should you determine that your database (or clients) require the DST patch and it appears that the patch is not available for your specific version, do not despair. YOU DO NOT need to upgrade in order to apply the patch. Quoting from the aforementioned note:

"If a patch is not available for your specific patchset version, then you can manually install the time zone files from a patch for the same platform and release (but a different patchset version).  For details on about this please see: Note 396387.1"

Submitted by Dan Brint (Dan.Brint@itec.suny.edu)

Note: 359145.1
Note: 396387.1

 

3.  Lotus Notes / Domino and Daylight Savings Time

Title:        Executive Summary and End User Guide: Daylight Saving Time (DST) 2007
URL:        http://www.ibm.com/support/docview.wss?rs=463&uid=swg21254625 <http://www.ibm.com/support/docview.wss?rs=463&uid=swg21254625>
Content:  Information to help IT System Administrators and Help Desk personnel communicate the changes for DST within you organization.

Title:        Deployment Guide: Daylight Saving Time (DST) 2007
URL:        http://www.ibm.com/support/docview.wss?rs=463&uid=swg21254624 <http://www.ibm.com/support/docview.wss?rs=463&uid=swg21254624>
Content:  Step-by-step instructions to implement the changes needed to prepare your Lotus Notes and Domino systems for the DST 2007 changes, along with Frequently Asked Questions.

Title:        Agents for updating Calendaring and Scheduling entries and Resource Reservation entries for Daylight Saving Time (DST) 2007
URL:        http://www.ibm.com/support/docview.wss?rs=463&uid=swg21254639 <http://www.ibm.com/support/docview.wss?rs=463&uid=swg21254639>
Content:  The released agents, instructions for applying the agents, and a detailed description of how the agents work.  

Complete information about addressing Changes to Daylight Saving Time (DST) in 2007 for Lotus Notes and Domino can be found on  http://www.ibm.com/support/docview.wss?rs=463&uid=swg21247972 <http://www.ibm.com/support/docview.wss?rs=463&uid=swg21247972> .  Additional notifications will be sent when new information is available.

Submitted by Chris Bordeleau (Chris.Bordeleau@itec.suny.edu)

 

4. New Security Approach from Oracle

The January 2007 CPU (Critical Patch Update) has been available from Oracle for a short while (for most platforms) and you may not have noticed a slight change in Oracle's approach. I'm assuming that by now you have all received this notice from Oracle. 

In addition to the normal stuff Oracle is now giving us more advance notice of what is IN the CPU and is also putting a numeric threat assessment value (CVSS =Common Vulnerablity Scoring System) against each issue being addressed by the CPU. Of particular alarm is that we see a few App Server and EM Agent threats rated at 7!

The CPU advisory note (403335.1) is attached for your convenience.

In addition to that, below are a couple of good links regarding the CPU in particular and Oracles change in how it approaches them:

http://www.securityfocus.com/news/10541

http://ct.enews.eweek.com/rd/cts?d=186-5292-4-84-90095-603681-0-0-0-1

http://www.eweek.com/article2/0,1895,2028804,00.asp

Note: 403335.1

Submitted by Dan Brint (Dan.Brint@itec.suny.edu)

 

5. CPU's and 9.2 RDBMS Desupport date

With the impending desupport of 9.x databases Oracle DBA's are wondering about the availability of CPUs (Critical Patch Updates) after July of 2007. Oracle support has indicated to ITEC that they will "continue to provide CPU's into the foreseeable future at the terminal release version" of a given product. You are encouraged to at least get to the terminal release if you cannot move to the current release by mid summer. 

For platforms other than VMS the terminal release is 9.2.0.8 and should be available now. For VMS 9.2.0.8 is projected to be available Q1 2007.

Submitted by Dan Brint (Dan.Brint@itec.suny.edu)



6. Banner Performance at University of Illinois.

We received a most excellent document from the University of Illinois (by way of Don Erwin and BOracle) regarding their performance tuning efforts and results therein. Their installed base is considerably larger than most of us in SUNY but useful gems of information are contained throughout the documents.

Footnote: If you take the time to look at the Oracleknow-xxxx.pdf document you can catch a glimpse of some of the work going on here at ITEC ramping up to our being able to serve up a more robust knowledge base to our membership. I would encourage you to attend the Wizard session being given by ITEC pertaining to our adoption of Confluence and AtTask for more details.


SETA Midwest 2006 – Taming Banner 7 on Oracle 10g
Prod Parms
PIN Objects
Oracleknow-xxx.pdf  

Submitted by Dan Brint (Dan.Brint@itec.suny.edu)



7.    Spring 2007 Wizard

Mark the Date:  The Spring 2007 Wizard will be held March 14-16 at the Double Tree Hotel (formerly the Wyndham) in Syracuse.  Registration and an agenda will be available on the SUNY Training Center's website:  http://www.suny.edu/sunytrainingcenter/wizardS07Welcome.cfm!

Submitted by Barbara Boquard (Barb@itec.suny.edu)

 

Editor:  Barbara A. Boquard

Barb.Boquard@itec.suny.edu

ITEC's General Office

716/878-ITEC (4832)

Operations

716/878-5122

FAX

716/878-3485

Web Page

http://www.itec.suny.edu


ITEC Home