1 / 25

Oracle APEX Developer - Expert in Doc Engineering

Experienced Oracle APEX developer with 23 years at Oracle, specializing in document engineering. Presenting at ApexWorld 2019 on powerful SQL functions and the future of web development.

staples
Download Presentation

Oracle APEX Developer - Expert in Doc Engineering

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. @koenlostrie Developer in Doc Engineering @oracle Been at Oracle since 1996 Apex Developer since 2006 koen.lostrie@oracle.com

  2. Oracle Speakers @ ApexWorld 2019 Connor McDonald Joel Kallman Pattern Matching - the most powerful SQL functions you've ever seen Oracle APEX: The Prognostication Tuesday, 10:40 - Theatre Monday, 09:15 - Theatre Colm Divilly Koen Lostrie The Next Ten Years of the Web The “Create App Wizard”: Here is the magic Tuesday, 13:30 - Grand Ballroom Monday, 11:40 - Odyssee Room Hilary Farrell Chris Saxon 18(ish) Things Developers Will Love about Oracle Database 18c Extend your APEX Application with Oracle JET Tuesday, 14:30 - Theatre Monday, 13:30 - La Fontaine Room Shakeeb Rahman Jason Straub Mastering Mobile UI with Universal Theme APEX and Multitenant: What you need to know Tuesday, 16:00 - Theatre Tuesday, 09:15 - Theatre

  3. Program Agenda • OLL overview/architecture • Environments • Dev Process • Patch Process Confidential – Oracle Internal/Restricted/Highly Restricted

  4. Why this presentation Previous talks by Alan Arentsen en Rob Van Wijck Confidential – Oracle Internal/Restricted/Highly Restricted

  5. No walk in the park ? 😎 Well… Confidential – Oracle Internal/Restricted/Highly Restricted

  6. oracle.com/oll - Oracle Learning Library • Library • Learning Paths • Events • Since 2010 • Activity in 2 weeks: 4mln page events, 3000 users Confidential – Oracle Internal/Restricted/Highly Restricted

  7. Team • Geografically spread • 3 Sustaining Engineering, 3/4 Developers (varies over time) • Not only apex and pl/sql (node, java, digital assistant,…) • Part of larger group - 45 developers Confidential – Oracle Internal/Restricted/Highly Restricted

  8. External Apps • OLL • Quiz Manager • Content Hub Confidential – Oracle Internal/Restricted/Highly Restricted

  9. Internal and Supporting Apps • OLL Admin • Event Admin • Ad Hoc Query (3 x) • Job Manager • Report Scheduler • Mail Manager • Logger Reporting • Security Management (users/roles/responsibilities/params) • Restful Services feeding to multiple internal systems Confidential – Oracle Internal/Restricted/Highly Restricted

  10. Development Environments • Dev • Dev2 • Build • Stage Confidential – Oracle Internal/Restricted/Highly Restricted

  11. Hosted Environments • Pre-prod • Prod Confidential – Oracle Internal/Restricted/Highly Restricted

  12. Development Cycle • Monthly sprints • Agile • Jira/Confluence • Daily Scrum • Poker Planning • Git (alm) Confidential – Oracle Internal/Restricted/Highly Restricted

  13. Patch naming • Yearly number (now is 9) • Monthly patch is point release (9.1) • Emergency (not in sprint) patch is 9.1.1 Confidential – Oracle Internal/Restricted/Highly Restricted

  14. Patch Process - developer • Create patch scripts • dml/ddl • Apex app or page • Patch header • (re)Check in Confidential – Oracle Internal/Restricted/Highly Restricted

  15. Patch Process - header Confidential – Oracle Internal/Restricted/Highly Restricted

  16. Patch Process - file order 1 first First phase, runs before all others 2 con Disable constraints, foreign keys 3 seq Create Sequences 4 tab Create Tables and Indexes 5 tbm Alter table in ways not supported by ODF 6 os Odd Synonyms 7 pls Create Package Specifications 8 invoker Invoker's Rights Processing 9 vw Create Views 10 compile Compile code objects 11 plb Create Package Bodies … 19 en Enable constraints, create triggers 20 last Last phase, runs after all others Confidential – Oracle Internal/Restricted/Highly Restricted

  17. Patch Process - default scripts • validate_patch_user.sql (phase=first) • set_patch_version.sql (phase=last+98) • compile_invalid_objects.sql (phase=last+99) Confidential – Oracle Internal/Restricted/Highly Restricted

  18. Patch Process - jenkins • Polling jobs to flashback to prevent flashback too old • Plugins: git, log parser, mailer • One project per patch/environment Confidential – Oracle Internal/Restricted/Highly Restricted

  19. Patch Process - build • Check out git code (manual or polling) • One patch process per schema • Consolidate all files • Generate zip file • Flashback to restore point • Apply Patch w sqlplus • Email if failed Confidential – Oracle Internal/Restricted/Highly Restricted

  20. Patch Process - build • Failed ? • Fix code. • Build again. Confidential – Oracle Internal/Restricted/Highly Restricted

  21. Patch Process - stage • Testers give feedback. • Minor errors are fixed in next release • Major errors are fixed in current release Confidential – Oracle Internal/Restricted/Highly Restricted

  22. Patch Process - prod • App written by apex dev team • Zip file: max 2 files • First pre-prod then prod • No flashback on pre-prod (2nd patch if needed) • If fails, then fix w followup patch Confidential – Oracle Internal/Restricted/Highly Restricted

  23. Patch Process - post patch • Disable jenkins processes • New restore point on stage/build • Create patch report • Delete old zip files Confidential – Oracle Internal/Restricted/Highly Restricted

  24. Questions ? Confidential – Oracle Internal/Restricted/Highly Restricted

More Related