Internship with Contemporary Technologies (Remote DBA Experts) Jenna Lutton February 1, 2007
Roadmap n n n n About Contemporary Technologies (CTi) Life outside CTi Project Overview Project Details Internship Experience Acknowledgements and Thanks Questions
Contemporary Technologies n n Located in Downtown Pittsburgh in 4 Gateway Center Two subdivisions: q q Enviroware – Software designed specifically for companies who treat, store, and dispose special case materials Remote DBA
Remote DBA Experts n n Offer remote database administration services for over 50 companies Support q q q n Oracle Microsoft SQL Server Legacy Systems Sell a “Team approach” to database administration q q Instead of buying one DBA, you buy a team of DBA’s who all help support your system Teams grouped by database type
n Mission: To provide expert service to their customers and to provide the best work environment for their employees q “Like No One Else!”
Software/Systems n n n Windows Red Hat Linux Unix q q q n Sun Solaris AIX HP-UX Oracle and SQL Server clients
Life Outside CTi n Home Life q q I’m a pseudo-aunt! New puppy!
Aiden Matthew Connelly
Sophie
Project Overview n Page Audit Project q n Documentation Project q n Keep a record of all alerts we receive and stop invalid alerts Standardize documentation DBA for Customers with Stable Systems q Perform common “DBA” tasks
Total Hours Spent by Project
Total Hours Spent By Role
Old Paging System Alert Message Generated CTI Exchange Server Customer Database Servers DBA Cell Phones
Page Example
Paging System n Issue: Primary DBA’s were on call of the time for their customers q q Had to find a way to reduce unnecessary pages Goal: Reduce stress
New Paging System Alert Message Generated Oracle Pages Folder CTI Exchange Server Customer Database Servers On-Call Phone
Page Audit Project n Issues after new paging system: q q Didn’t stop invalid pages from occurring Page Audit Project created to reduce invalid pages
n n Documentation Invalid page – Example: q q Monitoring script fixed the problem Issue with the server and had to comment out the job or had to install a different monitor n Worked with UNIX job scheduler, cron and the vi Editor
Documentation Project n n Documentation key to team approach of database administration There were little to no standards q q q Documents hard to find, not in the same place Document for one customer contained information that the same document for the next wouldn’t Very difficult for DBA’s to find information about other customers
n Created a standard template for: q q n n VPN Setup documents Database details documents Created/revised all customer documents to fit a standard format First introduction to Microsoft’s SQL Server
DBA For Customers With Stable Systems n n Crucial project for my Oracle DBA training Tasks: q q q n Check filesystem space Check listener log size/database alert log Check for any space issues in the database Goal: Catch common issues before they occur
Challenges n n n Had very little experience in an Oracle database Knew next to nothing about Unix/Linux commands Paranoid about causing production problems
Filesystem Space n n Unix command: $df –k First indication of space issues
Listener Log n n Listener: process that constantly “listens” for incoming database connections Logs all activity to a log q n Log is always in $ORACLE_HOME/network/log If log too big, you will need to resize it q Use Oracle provided command line utility: $lsnrctl
Oracle Alert Log n Every Oracle database has one q q n Logs all oracle errors (ORA- errors) and other activity (when a log switch occurs, or when a redo log is archived) File name always: alert_[dbname]. log First place to look if a serious problem occurs
Database Space Issues n Two ways of administering database: q q Command Line Oracle supplied GUI Tools n n Oracle Enterprise Manager Oracle Grid Control
Database Space Issues (Command Line) n n To check, I would run the space check monitor and note down any output Find the locations of the datafiles and their sizes that contain the object. q Use the Data Dictionary views
n n Check filesystem space where the datafiles are located Two options: q Resize datafile to add space
q Add a datafile
Database Space Issues (OEM) n n n OEM (Oracle Enterprise Manager) is a GUI tool that makes common database tasks less time consuming Adding datafiles or resizing them is just a point and click operation Available with recent versions of Oracle
Internship Experience n n Thoughts on overall experience Classes taken at IUP that have helped: q q q n COSC 341 – Database course COSC 210 and 310 – Java courses COSC 316 – First introduction to Linux Classes I wish I had taken: q q COSC 362 – Unix COSC 423 – Intro to Operating Systems
Recommendations n COSC 341 – Database course q Include more SQL Plus Tips and Tricks n Have SQL*Plus prompt for a value:
SQL used to Generate SQL
ORDER BY Clause Shortcut
Acknowledgements and Thanks n I would like to thank q CTi – For giving me the opportunity to work with the company n n n q q Chris Foot – For showing me that I don’t have to code programs for the rest of my life and for being such a great teacher Jayme Puza – Bus buddy! Brian Hays – For putting up with me Friends and Family Dr. Shubra
n Questions?
Скачать презентацию Internship with Contemporary Technologies Remote DBA Experts Jenna
d291049ccbe4af38808474e8fd4a4471.ppt