Oracle Database Problem Solving and Troubleshooting Handbook

About Guy HarrisonJim CzuprynskiMike AultMohamed HouriPaulo PortugalSyed HussainTariq Farooq

Tariq Farooq is an Oracle technologist architect and problem-solver and has been working with various Oracle Technologies for more than twenty-four years in very complex environments at some of the worlds largest organizations. Having presented at almost every major Oracle conference/event all over the world Tariq is an award-winning speaker community leader/organizer author forum contributor and tech blogger. He is the founding president of the IOUG Virtualization & Cloud Computing Special Interest Group and the BrainSurface social network for the various Oracle communities. Tariq founded organized and chaired various Oracle conferences including among others the OTN Middle East and North Africa (MENA) Tour VirtaThonthe largest online-only conference for the various Oracle domains the CloudaThon & RACaThon series of conferences and the first-ever Oracle-centric conference at the Massachusetts Institute of Technology (MIT) in 2011. He was the founder and anchor/show host of the VirtaThon Internet Radio series program. Tariq is an Oracle RAC Certified Expert and holds a total of 14 professional Oracle certifications. Having authored more than one-hundred articles whitepapers and other publications Tariq is the coauthor of the Expert Oracle RAC 12c (Apress 2013) Oracle Exadata Experts Handbook (Addison-Wesley 2015) and Building Database Clouds in Oracle 12c (Addison-Wesley 2016) Oracle books. Tariq has been awarded the Oracle ACE and ACE Director awards. Mike Ault began working with computers in 1980following a six-year Navy enlistment in the Nuclear Navy riding submarinesprogramming in Basic and Fortran IV on the PDP-11 architecture in the nuclear industry. During Mikes nuclear years he worked with PDP IBM-PC Osborne and later VAX-VMS and HP architectures as well as with the Informix and Ingres databases. Following the downturn in the nuclear industry Mike began working with Oracle as the only DBA at the Luka Mississippibased Advanced Solid Rocket Motor (ASRM) project for NASA in 1990. Since 1990 Mike has worked with a variety of industries using Oracle both in-house and as a consulting talent. Mike got extensive Flash experience as the Oracle Guru for Texas Memory Systems. Mike transitioned to IBM as the Oracle Guru for the STG Flash group when IBM purchased TMS in 2012. Mike has published over two dozen Oracle-related books including the 7.0 8.0 8i and 9i versions of his Oracle Administration and Management with Wiley the Oracle8 Black Book and Oracle DBA OCP Exam Cram series (for versions 8 and 8i) with Coriolis and multiple titles including Oracle9i RAC and Oracle10g Grid & Real ApplicationClusters with Rampant Technical Press. Mike has written articles for Oracle Select DBMS Oracle Internals and several other database-related magazines. Mike is also a highly sought-after keynote speaker and expert instructor for local regional and international Oracle conferences such as GOUSERS SEOUG RMOUG NYOUG NCOUG IOUG OOW ODTUG UKOUG and EOUG. Paulo Portugal has more than fifteen years of IT experience as an Oracle DBA. He is an Oracle Certified Master 11g; an Oracle Certified Professional (9i 10g 11g and 12c); an Oracle RAC 10g and 11g Certified Specialist; an Oracle DBA 10g Certified Linux Administrator; Oracle Exadata Implementation Certified; IBM DB2 Certified (8 and 9 Viper); an Oracle GoldenGate 10 Certified Implementation Specialist; an Oracle Enterprise Manager Certified Implementation Specialist; and an Oracle 11i Applications Database Administrator Certified Professional. Paulo is the author of the Rampant Advanced DBMS Packages and many articles in blogs and some magazines and websites. Paulo has maintained a regular presence on the Oracle conference and speaking circuit: Oracle Open WorldSan Francisco (2005 2006 2011 and 2013); IBM Information on DemandLos Angeles (2006); Burleson Oracle RAC Cruise (2009); and Oracle Training in ReadingUnited Kingdom (2011). Currently Paulo works as an Oracle sales consultant for Oracle Brazil. Paulo has participated in the Oracle Beta Test 11i project using Data Guard and is a specialist in high Availability tools such as Oracle Data Guard Oracle Streams Oracle GoldenGate and Oracle RAC. Mohamed Houri has a Ph.D. in fluid mechanics (scientific computing) from the University of AixMarseille II preceded by an engineer diploma in aeronautics. He has been working around the Oracle database for more than fourteen years for different European customers as an independent Oracle consultant specializing in tuning and troubleshooting Oracle performance problems. Mohamed has also worked with the Naval Architect Society of Japan on the analysis of tsunamis and breaking waves using a powerful signal analysis called Wavelet Transform. He maintains an Oracle blog and is active in the Oracle Worldwide forum and in the French equivalent. He tweets about Oracle topics at @MohamedHouri. Syed Jaffar Hussain is an Oracle Database expert with more than twenty years of IT experience. For more than a year he has been involved with several local and large-scale international banks where he implements and manages highly complex cluster and Exadata environments with hundreds of business-critical databases. Oracle awarded him the prestigious Best DBA of the Year and Oracle ACE Director status in 2011. He also acquired industry-best Oracle credentials Oracle Certified Master (OCM) Oracle RAC Expert OCP DBA 8i 9i 10g and 11g in addition to ITIL expertise. Syed is an active Oracle speaker who regularly presents technical sessions and webinars at many Oracle events. You can visit his technical blog at http://jaffardba.blogspot.com. In addition to being part of the core technical review committee for Oracle technologyoriented books he coauthored Oracle 11g R1/R2 Real Application Clusters Essentials (Packt Publishing 2011) Expert Oracle RAC 12c (Apress 2013) and Oracle Exadata Experts Handbook (Addison-Wesley 2015). Jim Czuprynski is an Oracle ACE Director with more than thirty-five years of experience in information technology serving diverse roles at several Fortune 1000 companies in those three-plus decadesmainframe programmer applications developer business analyst and project managerbefore becoming an Oracle DBA in 2001.      In his current role as a strategic solutions consultant for OnX Enterprise Solutions he focuses on providing his expertise to help customers understand how to best leverage Oracle technology to solve their most difficult IT challenges. As a senior Oracle University instructor Jim has taught Oracle core technologies Exadata and GoldenGate to more than two-thousand Oracle DBAs since 2005. He was selected as Oracle Education Partner Instructor of the Year in 2009.      Jims most recent book Oracle Database Upgrade Migration & Transformation Tips & Techniques (McGraw-Hill Education 2015) takes a nitty-gritty approach to tackling the best ways to migrate transform and upgrade Oracle databases to 12c Exadata and beyond. Jim continues to write a steady stream of articles that focus on the myriad facets of Oracle database administration with more than one-hundred articles to his credit since 2003 at databasejournal.com and ioug.org. Jims blog Generally . . . It Depends contains his regular observations on all things Oracle. Jim is also a sought-after public speaker on Oracle Database technology features. Since 2008 he has presented topics at Oracle OpenWorld IOUGs COLLABORATE Hotsos Symposium Oracle Technology Network ACE Tours and Oracle User Group conferences around the world. Guy Harrison is an executive director of research and development at Dell Software where he oversees the development of database tools such as Toad and Shareplex. Guy is the author of six books on database technology including Next Generation Databases (Apress 2015) O racle Performance Survival Guide (Prentice Hall 2010) and MySQL Stored Procedure Programming (OReilly 2006). He also writes the Big Data notes column for Database Trends and Applications (dbta.com). Guy can be found on the Internet at www.guyharrison.net and at @guyharrison on Twitter.