Mil9ip Instance Performance Tuning

Performed Mil9ip tuning on 4/7/2008, based the test on mildemo instance with Sean Vincent.  According to Sean, this tuning improved the performance of Millennium dramatically.  The tuning includes the follwing changes in the parameter file.

·         optimizer_mode=FIRST_ROWS from CHOOSE

·         increased shared_pool_size, pga_aggregate_target size, and sga_max_size

mail attribute no longer synced from OID to AD

AD must have sole control of its “mail” attribute to properly provision e-mail accounts. OID –> AD synchronization had included this, and the provisioning system (privcmd) had been filling this with any known e-mail address. This prevented new pugetsound domain accounts from being enabled when the e-mail address was not in the ups.edu domain, as is the case for most new students.

The mapping file was changed to no longer update the “mail” attribute when synchronizing from OID to AD.

[resolved] Application Servers Dev and Test not responding

The Oracle listener on Albert stopped functioning 3/26/2009 around 9:15 or 9:30am, which caused all Oracle databases on the machine to stop responding.

This affected development and test application servers. Specifically Registrar staff testing was interrupted. No production services were affected.

The listener was bounced and service restored after about 20-30 minutes.

Cascade Web minor improvements installed

The following minor changes were installed 3/25/2009 10:30am, with no disruption:

  • Cascade Home page now includes “Technical Problems” link
  • Password Change page now includes buttons when using tab key to navigate
  • Typo in error message was fixed
  • Format of initial password was changed so it includes mixed case instead of symbol

Firefox can now access Discoverer and ViewsFlash

3/19/2009
The value of mod_osso_url in the production application server was changed from “https://cascade.ups.edu:443” to “https://cascade.ups.edu”.

This fixes the problem where ViewsFlash or Discoverer could not be accessed via Firefox. (A space appeared at the end of the url.)

We tested the new configuration, using Firefox to directly access ViewsFlash, Discoverer, Portal, Cascade Web, and oiddas.

[Completed] ResNet Bandwidth Upgrade 3/24/09

[Update 3/24/09 6:00 AM] The bandwidth upgrade on the ResNet Internet connection is complete. ResNet now has a 100 Mbps connection to the Internet. Enjoy!

On Tuesday morning, 3/24/09, from 5:30 AM to 6:00 AM the Internet connection for the college’s residential network will be upgraded from 45 Mbps to 100 Mbps (a two-fold increase). The Resnet Internet connection will be unavailable during this time.

The upgraded connection will feature not only a 100 Mbps bandwidth, but also a new traffic shaping model, based on bandwidth, rather than type of traffic. This should reduce many of the application problems we have seen over the past few years.

[Complete] Multiple Services affected by emergency electrical work 3/21/09

[Update 3/21/09 10:13 AM] The emergency power repairs have been completed, and all systems have been restored to normal.

Due to emergency electrical work in the server room, the following services will be unavailable from 8:00 AM to 1:00 PM Saturday, 3/21/09:

• Moodle
• itech.ups.edu Web site
• ASUPS Web server and file server
• Sophos PureMessage quarantine Web site (mail delivery will be unaffected)
• Kronos server (electronic time cards)