VU Blog

OCT 2009 MAR

julie.catellier — Fri, 30 Oct 2009 14:05:35 +0000

Gathered Help Desk data for Law School and assisted with data associations so the Law School could set up their own help desk application.
The ITS DOA helpdesk web site was not compatible with IE8. I got the Vandy templates and upgraded the site to work with IE8.
RE-wrote a nagios check for the DNS database tablespace.
Refreshed test DIP database for the DNS server.
Cruise Director for App Hosting Fall Festival.
Wrote auto maintained query for Cardiology.

Sept 2009 MAR

julie.catellier — Thu, 01 Oct 2009 13:34:34 +0000

Researched and wrote scripts to purge logs and history from incontrol database. These scripts are written and scheduled within the oracle database to purge these tables nightly up to a given number of days.
Updated the code on the IP Request web site by NDE's request.
Modified Service Desk Report for NOC Manager, Scott.
Purged mysql log tables on Spectrum One-Click. This was needed becasue of space issues.
Added tablespace and flash recovery space to INCONTROL primary and standby databases.
Upgrading BMC Service Desk on the test servers. Testing still continues. BMC is currently looking into upgrade bugs that we found.

Aug 2009 MAR

julie.catellier — Mon, 31 Aug 2009 13:03:34 +0000

Corrected Service Desk Business Rule code to eliminate monitoring errors. Also fixed code to allow IPAM clients to get notification on ticket creation.
Worked with DNS admins on database issues to include creating export dmps, adding tablespace, adding flash recovery space and changing backup scripts.
Researched and downloaded BMC Service Desk upgrade application. Rebuilding test environment.
Wrote SQL queries.
Organized desk.

March 2009 MAR

julie.catellier — Tue, 24 Mar 2009 13:48:30 +0000

Database Maintenance: Increased processes for RHN's database.
Created auto_maintance list query for faculty.
Corrected BMC Service Desk notifications that went to a list. Lists have a limit to the number of emails that may be sent. This limit stopped notifications from BMC Service Desk. I worked with the List Admin and List owner too modifiy the limit.

Feb 2009 Mar

julie.catellier — Mon, 23 Feb 2009 20:34:18 +0000

Wrote Database queries for ITS Management to include vuspace, vumail, vsa data.
DNS/DHCP IP Request Web Page modification. Added and modified business rules in BMC Service Desk to fill in client ID if vanity addresses are used for IPAM requests. Assisted Mark with verifying viewable data for Web Page. Modified BMC Business Rules for DNS requests from IP Request web page.
Worked with the DNS/DHCP project group to refresh test database, run scripts, check and compare data that was in question from DiamondIP support. I worked with this group quite a bit this month.
Assisted Windows team with BMC Service Desk queries to validate or dispute server outages for the past year.
Worked with MIS staff to update them on my oracle duties. Provided web sites that include documentation and outstanding tasks.
Assisted ITS management and University DAR with approx 30 auto maintain queries. This included research of validity and modification of approx 30 auto maintain queries for the list serv.
Created new BMC Business Rules for the IDEV group. These rules will be used for OSIS notifications.
Restored corrupted MySQL databases.
Assisted with accessing and transferring a Spectrum mysql db backup to Spectrum's tech support for ND&E.
Many BMC Service Desk duties: A. Provided Law with spreadsheet of subjects and modified/added/deleted subjects. B. Monitored logs after list server cleanup. Updated BMC staff notifications that were left orphaned after list server cleanup.

Jan 2009 MAR

julie.catellier — Wed, 21 Jan 2009 19:31:36 +0000

Applied Oracle's security patch CPUJAN2009 to RHN database.
Moved system and datafiles to larger drive for VCMS database.
Wrote draft App Hosting Oracle Database User Account Policy.
Checked, Confirmed and sometimes locked db accounts and passwords on all of our oracle databases.
Created User account speadsheet that lists who or what has access to each account and the difficulty level to change the passwords.
Worked with Mark and DiamondIP tech support to run and check SQL code and upload dmp files to tech support.
Documented how to upload files to DiamondIP.
Verified that Oracle database backups are going to tape again this month.
Created VMWARE Update Manager Database on the oracle test server.
Completed the FEMA Information Security for Everyone and received a certificate.
Applied Oracle's security patch CPUJAN2009 to Nettracker database.
Added new functionality to the DHCP Viewable Subnets web page. NDE is now able to update the subnet database from the Diamondip subnets at any time. A cron job updates the subnet database once a day otherwise.

December 2008 MAR

julie.catellier — Wed, 17 Dec 2008 20:55:45 +0000

Completed and tested web page development for NDE to view and change subnets that are viewable by DiamondIP IP Request web page.
Modified IP Request web page to fix a bug with the network request type field.
The tape backup has not been backing up the Netid oracle backups directory. While we are still working to find the problem, I add a cron script to backup the database to a 2nd location. This export is going to tape nightly.
Wrote init.d scripts to automatically stop and start the many databases and listeners on the DiamondIP database server. Dan will put these scripts in place as time allows.
Ran queries for list server audits as requested by Gary.
Wrote script for the ITSBAR, backup database to clean the database. Also updated documentation for ITSBAR. Kenon put these scripts in his code. These scripts have saved him at least 6 hours in cleanup time for each time that he gathers new backup data.
Cleaned up the NETID Oracle backup directories. This stopped the SNMP disk space at 80% Nagios alerts.
Tested and documented a dataguard failover process where the primary db server was unavailable. The failover was quick and easy.

NOV 2008 MAR

julie.catellier — Tue, 11 Nov 2008 14:37:47 +0000

1. Created query for DiamondIP to find inconsistant IP addresses between IPAM and DNS. This query will be run before and after Mark imports IPAM data to make sure the data is consistant.

2. Created query for Kenon to disable constraints, truncate tables and reenable everything on the ITSBAR backup database. Kenon will run this procedure monthly.

3. Cleaned up VCMS database. The clean up included the purge scripts from VCMS and Oracle DDL to shrink tables and indexes.

Number of Task data is purged : 14963

VPX_EVENT_ARG: 3768335 rows deleted

VPX_EVENT: 1505999 rows deleted

Number of Stats data is purged : 2726089

6274.922 secs to index VPXI_HIST_STAT: allocated 5GB of free space

8519.012 secs to index VPXII_HIST_STAT: allocated 4GB of free space

3949.399 secs to table VPX_HIST_STAT

12 tables and indexes where altered to shrink space altogether.

4. BMC Service Desk had a problem. Users would receive a fetch error. The forms folder was corrupted. Deleted the forms folder, IISRESET to fix the problem.

5. Created standby database for VCMS.

6. Upgraded VCMS database and application to 2.5. I worked with Kendra on this. This was the process:

1. Export production

2. Move export to test server

3. Import into test server

4. Upgrade test database

5. Export test database6. Export backup copy of production database

7. Move export to production

8. Import database into production – SERVICE DOWNTIME

9. Upgrade application to point to upgraded database –SERVICE DOWNTIME

10. Backup new database – no downtime

The whole process took about 17 hours. The database upgrade alone took 11 hours.

7. Upgraded RHN-db from 9.2.0.5 to 9.2.0.8. RHN now allows for any 9i version. RHN is not compatabile with 10G yet.

8. Patched RHN-db with the CPUOCT2008 security patch.

Oct 2008 MAR

julie.catellier — Fri, 24 Oct 2008 16:21:19 +0000

1. Database support activities for Diamondip IPAM implementation

a. Run NETID scripts for Mark

b. Refresh DIP test database on a weekly basis

c. Provided documentation for our DIP database environment

d. Ran reports

2. Moved VCMS database files, increased tablespace and flash recovery area

3. Worked with IDEV DBA to help diagnose and report oracle bug – Alert_QT

4. Collected data and ran script to find majordomo list owners that were no longer at Vanderbilt. Cleaned up the non-existent owners.

5. Worked with Scott H. on the Unified Communication video.

6. Worked through VCMS upgrade issues.

a. Upgrade failed, restored database.

b. Found scripts to truncate EVENTS, TASKS, HISTORY data. Ran these on test server.

c. Cleaned VCMS test database by reindexing and shrinking tables.

d. Wrote plan to try the upgrade again. This next plan will allow for more VCMS uptime.

7. Dan patched the OS for DIP Primary database. I shutdown the databases, relinked and restarted the oracle services.

8. Audited backup services for the database servers. RHN 5 is considered production and has been put on backup list.

Sept 2008 MAR

julie.catellier — Tue, 23 Sep 2008 15:41:42 +0000

Set up new DNS IP request web page to send notifications to BMC Service Desk and Create Tickets for DNS and IP.
Set up Business Rules in BMC Service Desk to manage DNS, IP tickets.
Worked on DNS Project. Refreshed test database, executed SQL scripts on NETID database for Mark.
Re-wrote DNS Policy.
Added datafile to Nettracker database.
Dan patched the OS for db-2 and jprod2. I shutdown the services and database, relinked database, started and tested the services.
An oracle bug was discovered on the diamondip test database that caused the SYSAUX table to fill up by way of the alert_qt table. I worked with oracle tech support to get the patch and update a parameter. The production database was updated with a parameter change. I am currently testing the patch on the test server which will be complete by Sept 27. I will know at that time if we should patch the production server.
Dan applied OS patches to NETID's Oracle databases. I switched the databases as needed, shut them down, relinked and started the services.