here we go again upgrading to 11 5 10 l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Here We Go Again! Upgrading to 11.5.10 PowerPoint Presentation
Download Presentation
Here We Go Again! Upgrading to 11.5.10

Loading in 2 Seconds...

play fullscreen
1 / 38

Here We Go Again! Upgrading to 11.5.10 - PowerPoint PPT Presentation


  • 178 Views
  • Uploaded on

Here We Go Again! Upgrading to 11.5.10 . Jeff Slavitz Computer Creations Inc. Jeff@OracleAppsPro.com (415) 388-3003. Agenda. Planning an upgrade Staging Rapid Install Installing the Vision database Upgrading using the Maintenance Pack Lessons learned Questions. Planning the Upgrade.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Here We Go Again! Upgrading to 11.5.10' - tudor


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
here we go again upgrading to 11 5 10

Here We Go Again!Upgrading to 11.5.10

Jeff SlavitzComputer Creations Inc.

Jeff@OracleAppsPro.com

(415) 388-3003

Jeff Slavitz, Computer Creations Inc.

agenda
Agenda
  • Planning an upgrade
  • Staging Rapid Install
  • Installing the Vision database
  • Upgrading using the Maintenance Pack
  • Lessons learned
  • Questions

Jeff Slavitz, Computer Creations Inc.

planning the upgrade
Planning the Upgrade
  • Check required operating system patches
  • Review Maintenance Pack Installation instructions, Metalink note 259484.1
  • Develop upgrade and problem blog
  • Request LOTS of disk space for intermediate backups

Jeff Slavitz, Computer Creations Inc.

plan the upgrade timetable
Plan the Upgrade Timetable
  • Plan on a minimum of three test upgrades
  • Testing
  • How long will it take?
  • Determine the best Production downtime window
  • Document customizations
  • Plan major milestone dates

Jeff Slavitz, Computer Creations Inc.

technology stack decisions
Technology Stack Decisions

Jeff Slavitz, Computer Creations Inc.

stage rapid install
Stage Rapid Install
  • Three ways to stage Rapid Install:
  • Rapid Install manual – use adautostg.pl
  • OR manually copy Rapid Install from 11.5.10 media
    • Copy Start Here – Disk 1 to stage/startCD
    • Copy APPL_TOP Disk 1 – 2 to stage/oraApps
    • Copy RDBMS – Disk 1 to stage/oraDB
    • Copy Tools – Disk 1 to stage/oraiAS
    • Copy Databases – Disk 1-3 to stage/oraAppsDB

Jeff Slavitz, Computer Creations Inc.

stage rapid install7
Stage Rapid Install
  • OR use electric download, Metalink note 287281.1
    • Download zip files
    • Unzip files as for manual copy
  • Apply latest Rapid Install patch, currently 4132885

Jeff Slavitz, Computer Creations Inc.

installing the vision database
Installing the Vision Database
  • Follow Oracle Applications Installation manual
  • Disk space requirement: 86 gig

Jeff Slavitz, Computer Creations Inc.

installing the vision database9
Installing the Vision Database
  • Enable X-windows on your PC
  • In Rapid Install stage area:

cd startCD/Disk1/rapidwiz

  • Start Rapid Install: rapidwiz

Jeff Slavitz, Computer Creations Inc.

installing the vision database10
Installing the Vision Database
  • When prompted to select database, choose Vision
  • Rapid Install does the rest!

Jeff Slavitz, Computer Creations Inc.

the 11 5 10 maintenance pack
The 11.5.10 Maintenance Pack
  • Rapid Install used to install:
    • Vision
    • New database and technology stack
    • Upgrade pre-11i database
  • 11.5.10 Maintenance Pack, patch 3140000
    • Used to upgrade an existing 11i instance
    • 11.5.10 Install media or download from Metalink
  • Maintenance Pack instructions, Metalink note 259484.1

Jeff Slavitz, Computer Creations Inc.

maintenance pack overview
Maintenance Pack Overview
  • Pre-Upgrade steps
    • AD minipack I.1
    • Latest AutoConfig template
    • Configure database for new products and tablespace requirements
    • Technology stack upgrade
    • Many smaller patches
  • Apply patch 3140000
  • Post-upgrade steps

Jeff Slavitz, Computer Creations Inc.

technology stack upgrade
Technology Stack Upgrade
  • Technology Stack Validation Utility
    • Run on database and all application tiers
    • Must pass all checks before upgrading!
  • Install new technology stack:
    • Manually
    • Rapid Install techstack option

Jeff Slavitz, Computer Creations Inc.

technology stack decisions14
Technology Stack Decisions

Jeff Slavitz, Computer Creations Inc.

rapid install tech stack
Rapid Install Tech Stack
  • Installs 9.2.0.5 Oracle Home
  • Installs 9iAS 1.0.2.2.2 Oracle Home
  • Installs 8.0.6 Oracle Home
  • You must manually do necessary product upgrade steps
  • Will not install JDK 1.4.2

Jeff Slavitz, Computer Creations Inc.

rapid install tech stack16
Rapid Install Tech Stack
  • New tech stack code installed to new path
  • To retain existing tech stack path install it twice. For example:
    • Original 8.0.6 and iAS ORACLE_HOME at /ora01/PROD/…
    • Install new tech stack to /ora01/PRODupg
    • Use new OUI to remove Oracle Home at /ora01/PROD
    • Install new tech stack again to /ora01/PROD
    • Use OUI to remove tech stack at /ora01/PRODupg

Jeff Slavitz, Computer Creations Inc.

rapid install tech stack17
Rapid Install Tech Stack
  • From stage area: rapidwiz –techstack
  • For details, Rapid Install manual chapter 5

Jeff Slavitz, Computer Creations Inc.

upgrading jdk and jinitiator
Upgrading JDK and JInitiator
  • Oracle recommends using JDK 1.4.2 with 11.5.10
  • Download JDK 1.4.2 for your operating system, Metalink note 130091.1
  • Upgrade to JInitiator 1.3.1 using Metalink note 124606.1
  • Requires users to download new JInitiator

Jeff Slavitz, Computer Creations Inc.

tips for applying maintenance pack
Tips for Applying Maintenance Pack
  • Correct errors found by pre-upgrade validation scripts
  • Turn off custom triggers and applications before applying patch 3140000
  • Save time and apply custom AutoConfig changes after upgrade is complete
  • Work in parallel with Oracle Support

Jeff Slavitz, Computer Creations Inc.

tips for applying maintenance pack20
Tips for Applying Maintenance Pack
  • Skip adpatch workers that fail for applications you are not using
  • Open a tar to confirm no cross-application issues
  • Manually re-run script that failed when problem resolved

Jeff Slavitz, Computer Creations Inc.

skipping adpatch workers
Skipping Adpatch Workers
  • Select option 8 on adctrl menu to skip adpatch workers

Jeff Slavitz, Computer Creations Inc.

hung adpatch workers
Hung Adpatch Workers
  • Most workers end in a few minutes. If one runs abnormally long it may be hung.
  • Confirm with ‘top’
  • Use adctrl option 3 to shutdown all workers
  • Hung workers will not shutdown
  • kill -9 `ps –ef | grep adwork | cut –c 9-14`
  • You may also need to kill adpatch job

Jeff Slavitz, Computer Creations Inc.

hung adpatch workers23
Hung Adpatch Workers
  • Hung workers still show status of ‘Running’
  • Use adctrl option 4 to fail all jobs
  • Then adctrl option 2 to restart all failed jobs
  • Restart adpatch

Jeff Slavitz, Computer Creations Inc.

maintenance pack problems
Maintenance Pack Problems
  • Adpatch.log:
  • FAILED: file MTL_COPY_ORG_REPORT_TEMP.xdf
  • Adworker.log:

Error in executing statement ALTER TABLE INV.MTL_COPY_ORG_REPORT_TEMP MODIFY ...

ORA-00600: internal error code, arguments: [25012], [68], [0], [], [], [], [], []

  • Work-around is to set "_disable_multiple_block_sizes" = true

in the database init.ora

Jeff Slavitz, Computer Creations Inc.

maintenance pack problems25
Maintenance Pack Problems
  • Adpatch.log:

FAILED: file aftcm049.sql

  • Adworker.log:

ORA-20000: Oracle Error Mkr4= -904

ORA-00904: "RULESET_NAME": invalid identifier

  • Problem caused by Advanced Queue corruption that occurs when upgrading to 9.2.0.x from 8.1.7.x. Follow note 231074.1 and run the three patch scripts provided.

Jeff Slavitz, Computer Creations Inc.

maintenance pack problems26
Maintenance Pack Problems
  • For errors uploading .ldt files, upload manually using adodfcmp:

adodfcmp userid=jtf/xxx touser=apps/xxx priv_schema=system/xxx changedb=yes mode=tables odffile=xxx.odf logfile=xxx

  • Specifying ‘changedb=no’ will show changes without making them

Jeff Slavitz, Computer Creations Inc.

maintenance mode
Maintenance Mode
  • New feature with 11.5.10/AD.I
  • Adpatch requires maintenance mode
  • Use adadmin option 5

Jeff Slavitz, Computer Creations Inc.

maintenance mode28
Maintenance Mode

Jeff Slavitz, Computer Creations Inc.

maintenance mode29
Maintenance Mode
  • Be sure to disable Maintenance Mode or users cannot login to Financials

Jeff Slavitz, Computer Creations Inc.

adpatch hotpatch
Adpatch Hotpatch
  • If you want to apply a patch without enabling maintenance mode and disabling user access:

adpatch options=hotpatch

  • The Maintenance Utilities manual indicates this causes severe performance degradation

Jeff Slavitz, Computer Creations Inc.

helpful tips
Helpful Tips
  • Transfer setups between instances using FNDLOAD, Metalink note 274667.1
    • Concurrent program definitions
    • Responsibilities
    • Menus
    • Profile Options
    • Value Sets
    • And more!

Jeff Slavitz, Computer Creations Inc.

pre compiling jsps
Pre-Compiling JSPs
  • Java Server Pages (JSP) compiled when user first accesses a page
  • May result in noticeable delay
  • Perceived as ‘performance’ problem
  • Pre-compile all or first used JSPs

Jeff Slavitz, Computer Creations Inc.

pre compiling jsps33
Pre-Compiling JSPs
  • Compiled JSPs normally stored on web tier at $OA_HTML/_pages/_oa__html
  • Unix command ‘ls –ltr’ shows:
    • Pages used
    • Order pages are compiled
  • Use ojspCompile.sh as explained in Metalink note 215268.1

Jeff Slavitz, Computer Creations Inc.

pre compiling jsps34
Pre-Compiling JSPs
  • Compile JSPs using a regular expression

$JTF_TOP/admin/scripts/ojspCompile.pl --compile -s \

'OA%' -log $LOGFILE --flush

$JTF_TOP/admin/scripts/ojspCompile.pl --compile -s \

'Apps%' -log $LOGFILE --flush

  • Compile an individual JSP

$JTF_TOP/admin/scripts/ojspCompile.pl --compile -s \

'jtflogin.jsp' -log $LOGFILE --flush

Jeff Slavitz, Computer Creations Inc.

managing autoconfig
Managing AutoConfig
  • AutoConfig re-writes:
    • Oracle 9i init.ora, tnsnames.ora, listener.ora, sqlnet.ora
    • Oracle 8.0.6 listener.ora, tnsnames.ora
  • Make your system AutoConfig independent using ifiles:
    • ifile last line in above files
    • ifile name defined in context file

Jeff Slavitz, Computer Creations Inc.

slide36
OATM
  • Convert database to Oracle Application Tablespace Model. See Metalink note 248857.1
    • Reduces over 300 datafiles to 12
    • Saves a lot of disk space!
    • Easier to manage
    • Migrate tablespaces incrementally
    • Large tablespaces can take a LONG time to migrate

Jeff Slavitz, Computer Creations Inc.

summary
Summary
  • Spend the time to plan your upgrade before starting it
  • Long for the days of \ Row Erase?
  • Keep careful notes of what you’ve done
  • Use the tools Oracle provides to make your system easier to upgrade and maintain

Jeff Slavitz, Computer Creations Inc.

slide38
Questions?

Other tips and techniques?

Feel free to email or call me …

Jeff Slavitz

Jeff@OracleAppsPro.com

(415) 388 - 3003

Jeff Slavitz, Computer Creations Inc.