The Installation of the new storage array and SAN to support upgrades of the database and email systems was completed with the reboots of all database servers from 5:30 to 6:30 AM this morning. CRM was restored at 7:45 AM. The extended timeframe was necessary to ensure that all existing and new LUNs had redundant paths to their hosts in the SAN.
Category Archives: Cascade
Database/Email Systems Unavailable 10/25
Saturday, October 25, Technology Services will be performing important updates on our database systems and storage area network. This will impact our database and email systems. In order to minimize service disruption, there will be two groups of outages:
- 7 AM until 5 PM – Cascade Web, Banner, Famis, Basis, and the CRM will be unavailable.
- 7:30 AM until 9:00 AM – Email will be unavailable.
Network files and shares, and other network services will not be impacted.
Database Systems Restored – 09.09.08
Service has been restored to all central database systems (Cascade, Cascade Web, Banner, Famis, Millennium, Basis and CRM) as of 3pm. Please contact the Help Desk, 253.879.8585 or helpdesk@ups.edu, if you continue to experience problems.
All Database Systems Unavailable – 09.09.08
All central database systems are unavailable. This service disruption began at 11AM today and services impacted include: Cascade, Cascade Web, Banner, Famis, Basis, CRM and Millennium. Technology Services has determined the source of the disruption to be a power outage and is working with Facilities Services to resolve as quickly as possible.
UPDATE AS OF 2PM:
Stable power has been restored and Technology Services is now focused on restarting and verifying the database systems. Every effort is being made to restore services as quickly as possible. Our earliest continuation of service is estimated at 3pm today.
Cascade Unscheduled Downtime
At 6 AM this morning, a reload of the core switch caused a failure of the network interfaces on the Cascade Web server. This in turn caused the Cascade web interface to be unavailable from 6 to 8:15 this morning. The server was rebooted and recovered, restoring service at approximately 8:15.
Other affected servers were grace, camano, and crystal, all of which were rebooted to restore service at 7:30 AM. Batch job processing was affected between 6 and 7:30 AM.
Cascade Schema Owners Passwords Change
Changed Passwords for Schema Owners and modified related database links from As1012p, Crm11ip, Banner. Aslo, modified BJP’s parameter file.
Internet ISP Service DOWN!
A major fiber feed for Integra has been broken. A pole damaged along route 167 has broken the fiber feed for the state of Washington. This feed cannot be repaired until later this afternoon when 167 can be shutdown to restring the fiber across the highway. There is no estimated time of repair.
Cascade DB Parameter Update 4.17.08
Updated Cascade DB global parameters to help performance:
db_cache_size
sga_size
pga_size
large_pool_size
Database Server Reboot 4.17.2008
Email sent to liaisons:
Thursday April 17, Information Services will be performing critical changes on our database systems to improve recent performance concerns.
Access to all database systems including Cascade, Cascade Web, Banner, Famis, Basis and Millennium will be unavailable from 5:30 AM until 6 AM Thursday.
If you have questions or concerns regarding this outage, please contact Jenifer Brauen by telephone at ext. 2725, 253.879.2725, or via email at jbrauen@ups.edu. Thank you for understanding our need to conduct critical systems work.
Thank you.
– Jenifer Brauen
1/12/2008 Applied Oracle Critical Database Patch
Applied Crital Patch CPUJOct07 to Cascade, Banner, Ban9it, Famis9i, Mil9it, and Crm11ip on Rainier Server.
1/10/2008 Applied the same patch to the databases on Crystal as well.
1/27/2007 DB upgrade on Crystal
Upgraded DB 9.2.0.6 to DB 9.2.0.8
3/3/2007 Applied Oracle Critical Patch
Crital Patch cpuJan07
3/3/2007 DB Upgrade on Rainier
upgraded 9.2.0.6 db to 9.2.0.8 db
8/2/2007 Applied Oracle CPUJuly2007 & 5671676 Patches
Applied Oracle CPUJuly2007 & 5671676 Patches to 9.2.0.9 Database and its Instances ( Ridge, Summit, Ban9id, Ban9it, Crm11id, Fam9id, Fam9it, Mildemo, Rcat, Tools9i) on Crystal server.
8/24 Securing Database on Crystal
Limited sysdba login , Secured Other Oracle Executables, Configured Oracle binary permissions.