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.