Discoverer 10g Migration Plan - PowerPoint PPT Presentation

Albert_Lan
discoverer 10g migration plan l.
Skip this Video
Loading SlideShow in 5 Seconds..
Discoverer 10g Migration Plan PowerPoint Presentation
Download Presentation
Discoverer 10g Migration Plan

play fullscreen
1 / 13
Download Presentation
Discoverer 10g Migration Plan
301 Views
Download Presentation

Discoverer 10g Migration Plan

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Discoverer 10g Migration Plan Contributed by Chandra [Oracle Apps Tech Specialist] - oracle.anilpassi.com

  2. Index • Feasible Architectures • Installation • Configuration • Connectivity to Apps DB • Post Installation Tasks • EUL Migration • Discoverer clients on Windows PC • JInitiator upgradation Contributed by Chandra [Oracle Apps Tech Specialist] - oracle.anilpassi.com

  3. Oracle 9iAS Apps 11i DB Forms HTTP Discoverer 4i Oracle 10gAS Reports Discoverer 10g Conc MGR Application Tier Database Tier Standalone Installation • Pros: • -No Additional servers required • No Database, less maintenance • Quick Installation and configuration • Cons: • No Portal services • No Oracle SSO Contributed by Chandra [Oracle Apps Tech Specialist] - oracle.anilpassi.com

  4. Oracle 9iAS Apps 11i DB Forms HTTP Discoverer 4i Oracle 10gAS Reports Discoverer 10g ConcMGR Oracle 10g AS with Infrastructure Infrastructure • Cons: • Additional server required • More maintenance with Infra database • Complex installation. • Pros: • Discoverer reports can be accessed as Prortlets Contributed by Chandra [Oracle Apps Tech Specialist] - oracle.anilpassi.com

  5. Installation Steps • Application Unix Account • Oracle Unix account • 10gAS Server Installation with Discoverer Component on separate ORACLE_HOME on existing 11i environment, on application tier. • Installation of Infra metadata database (If required) on separate server • Configuration of Portal setup (If required) Contributed by Chandra [Oracle Apps Tech Specialist] - oracle.anilpassi.com

  6. Configuration • Establish Connectivity between Discoverer 10g and Apps Database • Discoverer integration with 11i through changes in XML. • Discoverer Profile changes in 11i to point new Discoverer 10g Contributed by Chandra [Oracle Apps Tech Specialist] - oracle.anilpassi.com

  7. Index • Feasible Architectures • Installation • Configuration • Connectivity to Apps DB • Post Installation Tasks • EUL Migration • Discoverer clients on Windows PC • JInitiator upgradation Contributed by Chandra [Oracle Apps Tech Specialist] - oracle.anilpassi.com

  8. Connectivity to Apps DB • Update tnsnames.ora file to connect Oracle Apps 11i • Enable sqlnet access • Connectivity check through Discoverer Home Contributed by Chandra [Oracle Apps Tech Specialist] - oracle.anilpassi.com

  9. Post Installation Tasks • Configuring Oracle 11i to use Discoverer 10g and to load Application specific content and workbooks into discoverer 10g EUL • Latest AutoConfig patch • AD Patch application • ICX Patch application Contributed by Chandra [Oracle Apps Tech Specialist] - oracle.anilpassi.com

  10. EUL Migration • Schema creation for EUL • EUL Creation • Database Parameter setting (Rollback segment) • DBA setup to migrate $AU_TOP to 10gAS server • Import Discoverer Content for release 11i • Refresh Discoverer 10g EUL • Check grant privileges (Responsibility, Users, Workbooks ) Contributed by Chandra [Oracle Apps Tech Specialist] - oracle.anilpassi.com

  11. Discoverer clients on Windows PC Install Internet Developer Suit 10g, this will install Admin edition • Edit Microsoft windows registry • FTP DBC file from 11i to D:\secure on Windows PC • TNS Connectivity to 11i Database • Install Discoverer Desktop Contributed by Chandra [Oracle Apps Tech Specialist] - oracle.anilpassi.com

  12. JInitiator Upgradation • Change in config.xml on 10gAS env. • JVM setting for JInitiator 1.3.1.24 • JInitiator upgrade on 11i env. • Application JInitiator patches Contributed by Chandra [Oracle Apps Tech Specialist] - oracle.anilpassi.com

  13. Thank You Contributed by Chandra [Oracle Apps Tech Specialist] - oracle.anilpassi.com