User Group Training Days 2023 March 8, 2023 Sean Scott Oracle ACE Director Managing Principal Consultant @oraclesean linkedin.com/in/soscott/ [email protected] @ViscosityNA www.viscosityna.com
Oracle ACE Program recognizes and rewards individuals for their contributions to the Oracle community. Charles Kim CEO | Co-Founder W @racdba W ACE Director Craig Shallahamer Applied AI Scientist W @orapub W ACE Director Rich Niemiec Chief Innovation Officer W @richniemiec W ACE Director Sean Scott Principal Consultant W @oraclesean W ACE Director Gary Gordhamer Principal Consultant W @ggordham W ACE Pro
of Concepts Training Turnkey Projects Managed Services Oracle • SQL Server • Postgres Performance Tuning Data Replication Data Warehousing Analytics Data Integration ERP Blue Prints Database Upgrades APEX EBS Web/Mobile Apps .Net and C# E-Business Suite SAAS/PAAS Azure Gold Partner Cloud Migrations Engineered Systems Oracle Cloud Partner Google Partner AWS Partner Hybrid Cloud
your Oracle investment ZERO DOWNTIME Migrations Performance Health Checks How’s it running? On-Call Support Managed Services Professional Services Where you need it most DBA Services Remote and On-site Apps Oracle APEX SaaS/Paas Custom Development Staff Aug Workforce Capacity on Demand
Program recognizes and rewards individuals for their contributions to the Oracle community. Charles Kim CEO | Co-Founder W @racdba W ACE Director Craig Shallahamer Applied AI Scientist W @orapub W ACE Director Rich Niemiec Chief Innovation Officer W @richniemiec W ACE Director Sean Scott Principal Consultant W @oraclesean W ACE Director Gary Gordhamer Principal Consultant W @ggordham W ACE Pro @ViscosityNA www.viscosityna.com
Training Turnkey Projects Managed Services Oracle & SQL Server PostGres Performance Tuning Data Replication Data Warehousing Analytics Data Integration ERP Blue Prints Database Upgrades APEX EBS Web/Mobile Apps .Net and C# E-Business Suite SAAS/PAAS Azure Gold Partner Cloud Migrations Engineered Systems Oracle Cloud Partner Google Partner AWS Partner Hybrid Cloud @ViscosityNA www.viscosityna.com
investment ZERO DOWNTIME Migrations Performance Health Checks How’s it running? On-Call Support Managed Services Professional Services Where you need it most DBA Services Remote and On-site Apps Oracle APEX SaaS/Paas Custom Development Staff Aug Workforce Capacity on Demand @ViscosityNA www.viscosityna.com
• Library of conditions/responses • Transparent • Manual intervention • Check logs • Repair • Simple restart • Revert at any time using GRP (N/A in Standard Edition)
-mode deploy Location of the Java binary. A compatible version is included in newer ORACLE_HOMEs Location of the AutoUpgrade jar Location of the configuration file AutoUpgrade mode (analyze, fixup, upgrade, deploy)
automatic fixups Does not create a restore point Some fixes are manual only: • Fixes requiring restarts • Changes impacting the host env • Component deinstall • Feature deactivation
global.autoupg_log_dir=/opt/oracle/autoupgrade # Database parameters upg1.sid=PROD upg1.run_utlrp=yes upg1.start_time=now upg1.timezone_upg=yes upg1.upgrade_node=localhost upg1.target_version=19.11 upg1.target_home=/opt/oracle/product/19c/dbhome_1 upg1.source_home=/opt/oracle/product/12.1.0.2/dbhome_1 • Global • Prefix = global • Parameters used for all upgrades • e.g. AutoUpgrade log directory • Provides consistent values for all systems • Local parameters can override
global.autoupg_log_dir=/opt/oracle/autoupgrade # Database parameters upg1.sid=PROD upg1.run_utlrp=yes upg1.start_time=now upg1.timezone_upg=yes upg1.upgrade_node=localhost upg1.target_version=19.11 upg1.target_home=/opt/oracle/product/19c/dbhome_1 upg1.source_home=/opt/oracle/product/12.1.0.2/dbhome_1 • Local • User defined prefix • Apply to individual databases • Overrides global settings on a per-database basis
global.target_version=19.11 global.target_home=/opt/oracle/product/19c/dbhome_1 ... # Database X upgx.sid=APPDB upgx.target_version=19.8 upgx.target_home=/opt/oracle/product/19c/dbhome_2 All databases use these values
-mode analyze AutoUpgrade 23.1.230224 launched with default internal options Processing config file ... +--------------------------------+ | Starting AutoUpgrade execution | +--------------------------------+ 1 CDB(s) plus 2 PDB(s) will be analyzed Type 'help' to list console commands upg>
help // Displays help lsj [<option>] [-a <number>] // list jobs by status up to n elements. -f Filter by finished jobs. -r Filter by running jobs. -e Filter by jobs with errors. -p Filter by jobs being prepared. -n <number> Display up to n jobs. -a <number> Repeats the command (in <number> seconds). lsr // Displays the restoration queue lsa // Displays the abort queue tasks // Displays the tasks running clear // Clears the terminal
a job with option to ignore errors status [<option>] [-a <number>] // Summary of current execution -config Show Config Information -job <number> Summary of a given job -job <number> -c <dbname> Show details of container -a [<number>] Repeats the command (in <number> seconds). restore -job <number> // Restores the database to its state prior to the upgrade restore all_failed // Restores all failed jobs to their previous states prior to the upgrade logs // Displays all the log locations abort -job <number> // Aborts the specified job h[ist] // Displays the command line history /[<number>] // Executes the command specified from the history. // The default is the last command meta // Displays Internal latch count hwinfo // Displays additional information fxlist -job <number> [<option>] // FixUps summary -c <dbname> Container specific FixUps -c <dbname> alter <check> run <yes|no|skip> Update Run Configuration
web server on the upgrade host: cd <AUTOUPGRADE BASE DIR> cd autoupgrade/cfgtoollogs/upgrade/auto python -m SimpleHTTPServer 8080 • View the upgrade status page: http://upgradehost:8080/status.html
upgrade durations—fix as much as possible ahead of time • Run ultrp.sql • Collect dictionary, fixed object status • Empty recycle bin Re-run analyze; repeat Practice, practice, practice!
Opatch - Patch 6880880 • Latest version of AutoUpgrade - MOS 2485457.1 • Latest version of Pre-Upgrade JAR - MOS 884522.1 • Latest version of AHF/TFA (includes OraChk) - MOS 2550798.1
variables/paths • ORACLE_BASE_CONFIG • ORACLE_BASE_HOME • New in $ORACLE_HOME/bin: orabaseconfig, orabasehome • New file: $ORACLE_HOME/install/orabasetab • Separates configuration from software • ROOH is the default for Oracle Database 21c and beyond Read-Only Oracle Home (ROOH)
deviation from norm or rationality in judgment. Individuals create their own "subjective reality" from their perception of the input. An individual's construction of reality, not the objective input, may dictate their behavior in the world.
it works in pre-prod it will work in production We have documentation Stress Urgency Confusion Multitasking Coordination Phone calls Messaging Alerts Research Management Doubt, Panic Conflict Documentation doesn't cover:
SiteGround - Reliable hosting with speed, security, and support you can count on.
oraclesean
rymiyamoto
lycorptech_jp
minorun365
line_developers_tw
brainpadpr
masaruogura
hssh2_bin
ebiken
sonic
_awache
tosho
sarafernandez
lauravandoore
skipperchong
addyosmani
honzajavorek
jacobtomlinson
ks91
morganepeng
jonoalderson
soudai
![@ViscosityNA www.viscosityna.com AutoUpgrade Console ========================================== Autoupgrade Summary Report ========================================== [Date]](https://files.speakerdeck.com/presentations/e7834ceaa7b84f0f893ec19e2d68657a/slide_45.jpg){kind=link}
![@ViscosityNA www.viscosityna.com AutoUpgrade Commands resume -job <number> [-ignore_errors=<ORA-#####,ORA-#####>] // Restarts](https://files.speakerdeck.com/presentations/e7834ceaa7b84f0f893ec19e2d68657a/slide_47.jpg){kind=link}
