130 likes | 479 Views
Discoverer 10g Migration Plan. Index. Feasible Architectures Installation Configuration Connectivity to Apps DB Post Installation Tasks EUL Migration Discoverer clients on Windows PC JInitiator upgradation. Oracle 9iAS. Apps 11i DB. Forms. HTTP. Discoverer 4i. Oracle 10gAS. Reports.
E N D
Discoverer 10g Migration Plan Contributed by Chandra [Oracle Apps Tech Specialist] - oracle.anilpassi.com
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
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
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
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
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
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
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
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
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
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
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
Thank You Contributed by Chandra [Oracle Apps Tech Specialist] - oracle.anilpassi.com