VU Blog

1. Wrote script on RHN to stop/stop/status for the oracle nagios listener.
2. Added a datafile to the nettracker database.
3. Extended VPX datafiles from 9GB to 15GB.
4. Wrote Nagios check oracle script to check Flash Recovery Area space usage for Oracle databases.
5. Upgraded the DiamondIP test database from 3.0.39 to 3.0.53. 
6. Patched the nettracker database with the July security patch.
7. Wrote Nagios check oracle script to account for the 10G autoextend space.
8. refreshed the diamondip database and currently writing documentation and testing out sql refresh scripts.

1. Updated diamondip test db with new import.  Changed dns zones.  Updated and completed documentation on how to create a test database. Created synonyms on Netid tables and worked with DiamondIP on scripts.
2. Created/refreshed standby test database for diamondip.
3. Wrote auto-maintain query for parking and created mailing list.
4. Created ITS test database on Oracle's test server
5. Created tables and helped Kenon with the Backup Reports Database and 11G client.
6. Wrote documentation for 11G client install.
7. Setup oracle_check plugin on Nagios to monitor oracle tablespace size, functionality for Oracle databases.  Peter set up the environmental variables on the OS. 5 databases are now being monitored with this plugin.  Also, updated documentation on how to configure this plugin to monitor a db.

1. Wrote script and crontab for spectrum mysql db optimize and maintenance programs.
2. Added and autoextended tablespace for RHN.  Also ran utilities to check fragmentation on tables, indexes, etc. 
3. Fixed a listener security vulnerability.
4. Refreshed the diamondip test data twice.
5. Initated and installed oracle 11G client on Nagios for the check_oracle plugin.  This plugin checks the tablespace size and db status. 
6. Installed Oracle 10GR2, upgrades and patches on the test dipdb 2 standby server for the test DIP dataguard configuration.

1. Created vcms database on production dip oracle server.  Now, admins can get more than a weeks worth of stats in seconds.  Stats collection has been tested for up to 1 year successfully.  I increased the redo log size and defragmented the indexes and tables for the stats, history and events.  Set up rman backups.  Configured database for automatic storage management (ASM). 
2. Documented DiamondIP database, install and maintenance for test and production servers..  Documented VCMS database install and maintenance for test and production servers.
3. Refreshed the DiamondIP test database with the current production data. 
4. DiamondIP application had a runaway task.  I worked with DNS admins and Tech support to stop and cleanup the mess.  I worked to find the exact tables that were effected which in turn pointed to a runaway scheduled task.
5. Presented Enterprise level Service Desk solution to the Governance Board. 

1. Added 11G datafile to Nettracker database.
2. Created Test Primary server for DiamondIP…twice.
3. Upgraded the ojdbc to version 5 and changed java parameters on the Diamondip app server  and db server to fix a jdbc error.
4. Added another oracle datafile to VCMS.
5. Upgraded Nettracker web server oracle client and Nettracker Oracle database.  Added security patches.
6. Moved datafiles on RHN to larger drive to fix diskspace warning issue.  Fixed a wait issue also.
7. Created a test database for VCMS on the dipdb test server.
8. Created a Service Desk Request to implemet ITS Collaboration requests into BMC Service Desk.  This required creating staff, groups, subjects, business rules, queries for 8 requests to include Groove, Centra, Video Conferencing and Collaboration Services Demo.

1. Worked out the details to get additional storage for db-1 and db-2.
2. installed and setup isqlplus on the dip oracle servers.
3. Created Server DeCommission Form in SharePoint
4. Worked with DNS Request Form developer on many issues.  Also tested web site.
5. Diamondip import created spiralling ORA-0600 errors in Oracle DB.  Downloaded and installed patch.
6. Diamondip DNS was implemented.  My duties included a request to restore the db from backup to a point in time and running a SQL update script on a table.

1. Configured IP database to run in dataguard's maximum availablity mode.  Set up scheduled RMAN backups.
2. Working with Kim from Infoworks to develop DNS/DHCP request web pages and the resources that we have available such as mysql, authenticate procedure.
3. BMC Service Desk changes and updates for Categories, Business Rules, Notifications, staff and other changes for Law Building Services.
4. Working on Service Desk Project.  Evaluated BMC Remedy Service Desk and CA Unicenter Service Desk.
5. Attending MS SQL 2005 database class.

1.       The tablespace for VCMS was running out of space.  I added another 2GB datafile with a max size of 3GB.

2.       BMC Service Desk 9 was patched to help correct the email conversation problem.

3.       I worked with Scott E. to set up the backup maintenance plan for a co-located print server.  The MSSQL transaction log had caused problems because of the current backup schedule.

4.       I added a field to the RUNBOOK for the NEW Nagios Status.  I also added more rows to the UNIX on-call and put Dan as permanent DNS on call.  The app host web site links were updated for New Nagios and removed VUCAL. links.

5.       I checked the database matrix and found that one of the oracle database servers was not on backup.  The server was recently modified to move the data from a disk array to the SAN.  The fstab file was not updated which caused the problem.  This was resolved immediately.

6.       I wrote some auto-maintain queries for the list server.

7.       I installed Oracle 10GR2 on the 2 new 64-bit Linux servers for IP.  They were patched up to 10.2.0.3 with the Jan critical patch.  I designed the database with flash back recovery and the Oracle Managed File system.  The first server has been configured as a primary dataguard server.  I will be finishing the standby server by the end of the month [with the next couple of days].  The install process has been documented.

•  Moved Nettracker’s Oracle database files from disk array to SAN.
•       Set up 3 tier structure.
•       Tier 1, the fastest storage contains control files, redo logs, temp and undo files.
•       Tier 2 contains control files and datafiles.
•       Tier 3, the slowest storage contains the flash recovery area, archive logs and backups.
• Configured flash recovery for Nettracker.  It will automatically manage the files in the flash recovery area directory.
• Reconfigured Nettracker’s RMAN to backup files while using the automatic db recovery features in conjunction with flash recovery.
• I completed the requested changes to the DNS Request web site.
• I worked on the new RHN Satellite database.  I re-imported the data from the old server.  Dan ran the upgrade scripts successfully.  There is not enough disk space for the backups causing backup failures.  Kenon will add storage soon.  The database needed to be restored once.  Fortunately, I have been keeping the archive logs and was able to restore to 3 days back successfully as requested by the admins.

1.       Created DNS registration request web page.