This document describes the business problems which privileged access management systems are intended to address. It goes on to describe best practices for deﬁning and enforcing policies ...
<Insert Picture Here>Best Practices for Upgrade to Oracle Database 11g Release 2Morana Kobal ButkovićSenior Sales ConsultantOracle HrvatskaAgendaPreparationBest PracticesPerformance TestingDemos2010 Oracle Corporation2Lifetime Support PolicytodayR2January 2015January 2018August 2012August 2015R2July 2010 July 2011July 2013R2January 2009January 2012Sustaining SupportPremier SupportExtended SupportJuly 2007 July 2008July 2010R2t222222222222222220000000000000000000000000111111111234567890123456782010 Oracle Corporation3Upgrade to Oracle Database 11g≥ 7.7 3.3 4.≥ 7.39.9 2.2 0. .0 8.R2≥ 9.9 2.2 0. .0 4.≥ 9.2.0≥ 8.8 0.0 6.≥ 8.0R2≥ 8.8 1.1 7. .7 4.≥ 8.1.7101 .0 1. .1 0. .0 5.≥ 9.9 0.0 1. .1 4.≥ 9.0.1≥ 101 .0 2. .2 0. .0 2.≥ 10.2.0R2"Empty" arrows mean: no specific patch release required2010 Oracle Corporation4Different Ways To UpgradeUPGRADEExport/ImportNStay on same OS?YCTAS, COPYNDowntime >30min?SQS LQ L A ppp lp yYOracle StreamsDBUA Transportable TablespacesCLI SQL> @catupgrdTransportable DatabaseOracle Golden Gate2010 Oracle Corporation5Upgrade Length• How long will it take to upgrade?• Usually between 30 and 90 minutes• Independent of:• Size of the database• Used datatypes• Dependent mainly on:• ThT e n umbm er o f f i ni stat lllel d c ompm onentst a nd o ptit oi ns• Valid and non-stale data dictionary statistics• Number of synonyms – they'll get recompiled (upgrade from 9i)• Number of objects in XDB• To a lesser degree, if COMPATIBLE is increased:• Datafile headers are updated• Format of redo logs can change2010 Oracle Corporation6Upgrade Length• Speed up your upgrade performance by:• Truncating the auditing table SYS.AUD$SQS LQ >L > t rt ur nu cn ac ta et e S YS SY .S A. UA DU $D ;$• Creating dictionary statistics right before the upgrade• Oracle 9i:SQS LQ >L > e xe ex ce c D BD MB SM _S S_ TS AT TA ST .S G. AG TA HT EH RE _R S_ CS HC EH ME AM _A S_ TS AT TA ST('SYS', options => 'GATHER',estimate_percent =>DBMS_STATS.AUTO_SAMPLE_SIZE, method_opt => 'FORALL COLUMNS SIZE AUTO', cascade => TRUE);• Oracle 10g/11g:SQS LQ >L > e xe ex ce c D BD MB SM _S S_ TS AT TA ST .S G. AG TA HT EH RE _R D_ ID CI TC IT OI NO AN RA YR _Y S_ TS AT TA ST ;S2010 Oracle Corporation7When to Choose Command-Line• Can afford 30-90 minutes average downtime• Manual command-line interface is preferred over GUI• Existing database is at least 18.104.22.168 if upgrading to 11g and 22.214.171.124 if upgrading to 11g R2• Migrating to a new hardware platform with same OS• Consideration•Cannot upgrade to a system with a different operating system architecture•More manual steps required•Potential for errors due to typos, missed details•Upgrade scripts can be run again and again2010 Oracle Corporation8Command Line Upgrade• Step-by-step:1. Complete online backup of the database2. Install 11g Oracle software and apply patch set, PSU etc.3. Analyze the DB using utlu112i.sql and follow all requirements given by the script 4. Create a new 11g listener with NETCA5. SwS iti ct h t ot t ht e n ew e nviv ri onmem nt,t , s tat rtut p t ht e D B B ( sts at ra tr ut pu pupgrade) and create the SYSAUX tablespace (only if source db is an Oracle 9i db)6. Run upgrade script catupgrd.sql7. Recompile with utlrp.sql - compare with utluiobj.sql8. Run catuppst.sql if you are upgrading from ≥10g for AWR9. Check the post upgrade status: utlu112s.sql2010 Oracle Corporation9Upgrade ModeSQL> STARTUP UPGRADE;ALTER SYSTEM SET _system_trig_enabled=FALSE SCOPE=MEMORY;Autotune of undo retention is turned off. ALTER SYSTEM SET _undo_autotune=FALSE SCOPE=MEMORY;ALTER SYSTEM SET undo_retention=900 SCOPE=MEMORY;ALTER SYSTEM SET aq_tm_processes=0 SCOPE=MEMORY;ALA TL ET RE R S YS SY TS ET ME M S ES TE T e ne an ba lb el _e d_ dd ld _l l_ ol go gg ig ni gn =g F= AF LA SL ES E S CS OC PO EP =E M= EM ME OM RO YR ;YResource Manager disabled during database migration: plan '' not setALTER SYSTEM SET resource_manager_plan='' SCOPE=MEMORY;ALTER SYSTEM SET recyclebin=‘OFF’ DEFERRED SCOPE=MEMORY;Resource Manager disabled during database migrationTaken from an example alert.log•Supresses unnecessary error messages likeORA-00942: table or view does not exist -thus logfiles will be easier to read and check2010 Oracle Corporation10
Share Oracle technology day 19.5.2010. best practices for upgrade to 11g r2 to:
Download Oracle technology day 19.5.2010. best practices for upgrade to 11g r2