Register for Apps DBA Training
For Apps DBA Beginner's
  • Start From Here
  • Order of Apps Study
  • 11i Software
  • Apps Architecture
  • Install Apps 11i
  • Install Apps 11i Part II
  • Startup/Shutdown
  • Request Flow in Apps
  • Various TOP's
  • Cloning Basics
  • Cloning I
  • Cloning II
  • Autoconfig Basics
  • Autoconfig Config File
  • Template Files in Autoconfig
  • Discoverer Overview
  • Workflow Mailer in Apps
  • Printing Overview
  • Configuring Printers
  • Pasta Printing
  • Performance Overview
  • Install 10g Application Server
  • Apps DBA Certification
  • Common DBA Topics
  • Scared of RAC ?
  • Install RAC on your laptop part I
  • Step by Step build RAC part II
  • Step by Step install RAC using VMWare part III
  • Install Oracle RAC Database part IV
  • oraInventory Basics
  • Install Database 10.2.0.1
  • Upgarde DB to 10.2.0.2
  • Fusion
  • Is Fusion a conFusion ?
  • Fusion Middleware Overview I
  • Fusion Middleware Overview II
  • Application Integration Architecture
  • SOA Install Part I
  • SOA Install Part II
  • SOA Install Part III
  • Install BPEL Process Manager
  • Apps Integration OID/SSO
  • Management Qs for Apps Integration with SSO/OID
  • 25 things your DBA should know for Apps/SSO integration
  • Identity Management
  • COREid Overview
  • Oracle COREid or Idm & Access Mgmt overview
  • Installing Access Manager 10.1.4
  • WebGate request flow
  • Identity Manager Architecture
  • Installing Identity Manager
  • OAS-SSO Overview
  • OID Overview
  • OID Basics II
  • OID Cluster
  • OID Integration with Other LDAP Servers overview
  • Integrate OID with AD I
  • OID Replication Overview
  • Multi Master OID Replication
  • Migrate OID/SSO to new Host
  • Apps R 12
  • Socket or Servlet in R12
  • Startup/Shutdown Scripts in R12
  • Unified APPL_TOP
  • Apps R 12.0.1
  • Difference between 11i & R12 Technical
  • Prepare for R12 Installation
  • Install VMWare on Windows for Linux Install
  • Install Linux for Apps R12 Install
  • Install Apps R12 on Linux Virtual Machine
  • R12 Upgrade & database
  • R12 Fils System Changes
  • R12 Release Date
  • 10g Application Server
  • 10g AS Overview
  • Installing 10g AS
  • Start/Stop 10g AS
  • Web Cache Basics
  • Single Sign-On Overview
  • OID Overview
  • Cloning 10g AS
  • 10g AS Middle tier Cloning & Overview
  • OID Cluster Imp. Points
  • CPU Patch, Infra Tier
  • CPU Patch, Middle Tier
  • AS Guard / DR Overview
  • Oracle Apps 11i
  • My Site
  • Apps DBA Scripts
  • Apps DBA Interview Q's
  • 11i JVM's
  • Apps Training in India
  • 11i Health Check
  • Good Metalink Notes
  • About Me  
  • For Advanced Apps DBA
  • URL Firewall in DMZ Setup
  • Upgrade Apps to 11.5.10.2
  • Load Balancer Overview
  • Load Balancer Config
  • HTTP layer Load balancing in Apps 11i
  • Dataguard Overview
  • Configure Dataguard / Standby database
  • Standby Site for Apps 11i
  • How to change Hostname on Apps Instance
  • SSL Overview in Apps
  • Configure SSL to Web Server
  • Key Points for SSL in Apps
  • Reduce Patch Timing
  • Reduce Patch Timing II
  • Shared APPL_TOP Overview
  • Configure Shared APPL_TOP
  • 11i Database Upgrade I
  • 11i Database Upgrade II
  • Change Session TimeOut
  • Patching
  • Apps Patch Basics
  • Apps Patch Basics II
  • Apply Apps Patch
  • CPU Overview
  • Steps to Apply CPU Patch
  • CPU Patch on Infra Tier
  • CPU Patch on AS Middle Tier
  • Troubleshooting
  • Web Server TS Part I
  • Web Server TS Part II
  • CM Troubleshooting
  • 10g Discoverer with Apps
  • Discoverer Bascis in Apps
  • Discoverer 10g Upgarde Basics
  • Discoverer 10g Configuration Steps with 11i
  • Collaboration Suite
  • Collaboration Suite
  • Calendar Overview
  • Sync Calendar from Mobile I
  • Sync Calendar from Mobile II
  • OCS Mail Architecture
  • Apex / HTMLDB
  • Install Apex 2.2
  • Apex with SSO part I
  • Apex with SSO part II
  • SSO Authentication Schemes
  • Certification
  • Possible Certifications for DBA
  • Apps DBA Certification
  • 1Z0-311-OCA-10g OAS Overview
  • 1z0-312-OCP-10g OAS Overview
  • 1z0-312 - Managing Customization and Topology
  • 1z0-312 - Cloning and Staging OAS
  • Apps DBA Jobs
  • Working / Apps DBA in UK
  • Oracle Recruiting Apps DBA's
  • Apps DBA Jobs Updated Regularly
  • Apps Job at Satyam
  • Useful Links
  • Good Metalink Notes
  • petefinnigan's Oracle Security
  • Linux Basics
  • Atul Mehta's Oracle Links
  • Others
  • Apps DBA Training Institute
  • 1 Year Journey of this Blog
  • How To ?
  • Change APPS Password
  • Preserve Customizations
  • Blog Roll
    Apps / E-Business Suite
  • Steven Chan Apps
  • Anil Passi Technical
  • Fadi Apps DBA
  • Senthil Apps DBA
  • Bas Klaassen EBS DBA
  • Sam Apps DBA
  • Black Geek Apps DBA
  • Bandari Apps
  • Vikram ERP Architect
  • OraBiz
  • Eric Core DBA
  • SOA
  • Navdeep Saini Apps DBA
  • tugdualgrall Web Services
  • Mohan Dutt's Apps Certification
    IdM
  • Nishant Kaushik's IdM
  • Nulli Blog, OAM
  • Identity Musing
  • Identity nd Access Management
    Core DBA
  • Vidya Bala DBA
  • Sabdar DBA
    Data Management
  • Ivan Pellegrin Data Management


  • We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Discoverer 10g & Oracle 11i Configuration Steps
    Wednesday, November 08, 2006
    Register for R12 upgrade
    If you are reading this post directly then visit my previous posts on discoverer basics & overview with Apps at

    http://becomeappsdba.blogspot.com/2006/11/discoverer-in-oracle-applications.html
    http://becomeappsdba.blogspot.com/2006/11/overview-on-how-to-configure.html

    Lets start today with broad level Steps to Install & configure 10g Discoverer with Apps 11i , in end you can see metalink note & other references.
    Please Note that Steps mentioned here are specifically from version 10.1.2.0.2

    1.Install 10g Oracle Application Server Release 2 i.e. 10.1.2.0.2
    2.Copy DBC file from $FND_SECURE(E-Business Suite Tier) to $ORACLE_HOME/discoverer/secure(Discoverer Home Installed in Step1)
    3. Update tnsnames.ora in DISCO ORACLE_HOME installed in Step1 to point to E-Business Suite 11i Database
    4. Migrate your EUL (End User Layer) from 4i to 10g EUL (Please Note upgrade from EUL3i to direct 10g is not supported , you have to first upgrade eul to4i & then to 10g)
    5. Select JVM for Disco Plus (you can Oracle's Jinitiator or Sun Java Plug-in)
    6. Apply Necessary Apps Patch for compatibility Issues (For list of patches check Metalink Note mentioned below)
    7. Change Profile options to point to 10g Discoverer from 4i

    All these Steps above are compulsory steps , I have not mentioned Optional Steps like Single Sign On Server configuration and generating Business Layers. Also steps mentioned here are configurations related to Apps DBA's perspective for functional steps refer to document mentioned below.

    Related Links

    Metalink Note # 313418.1 Using Discoverer 10.1.2 with Oracle E-Business Suite 11i

    1og Application Server Installation Overview
    http://becomeappsdba.blogspot.com/2006/10/installing-10g-application-server.html

    10g Discoverer Installation Guide
    http://download-uk.oracle.com/docs/cd/B14099_19/getstart.htm

    discoverer Documentation
    http://download-uk.oracle.com/docs/cd/B14099_19/bi.htm


    Stay Tuned to Understand Application Server Concepts like Oracle Internet Directory, Oracle Single Sign-On Server, OPMN & lot more . For 10g Application Server overview check in Left Menu Bar under section "10g Application Server"

    Now you can get email notification with Update on this blog , check "E-mail Subscription" on right Menu Bar.

    Labels: ,


    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  digg thisDigg This  ¦  My Yahoo!My Yahoo  ¦  RedditReddit  ¦  add to BlinkListBlinkList   ¦  Furl ItFurl It  ¦  Email This Email This  ¦     Leave Your Comments
    posted by Atul Kumar @ 8:14 PM  
    32 Comments:
    • At 7:40 PM, Anonymous Anonymous said…

      does installing 10g Oracle Application Server Release 2 i.e. 10.1.2.0.2 itself is installing discoverer? what would be the URL to access discoverer then?

       
    • At 9:00 PM, Blogger Atul Kumar said…

      Yes Santosh,
      when you install Application Sever 10.1.2.0.2 (With Middle Tier Option as BI & Forms) this will install Discoverer & rest other steps are configuring it with E-Business Suite . That's why I mentioned in my previous post that Upgarding Discoverer is not supported but its New Install & Upgarde only EUL

       
    • At 9:07 PM, Blogger Atul Kumar said…

      Sorry I forgot to mention URL

      its

      http://hostname.domainname:port/discoverer/viewer

      http://hostname.domainname:port/discoverer/plus

      where hostname & domainnanme are machine name & domain name on which you installed 10g AS & port number is port you selected at install time defualt 7777

      though you can change these hostname & port number to your desired value

      Atul

       
    • At 10:43 AM, Anonymous Anonymous said…

      Hi Atul,
      Well done on the website!

      I have installed 10.1.2.0.2 on the same physical server as my current 4i install. For the purpose of testing and parallel runs etc this was the only course of action I had open to me. Oracle recommend not to do this. Both are functioning fine at the moment with the 4i and 10g tables located in the same schema. I can't fine out why Oracle warn against this (from Metalink etc).

      Do you have any ideas?

      Many thanks,
      Derek

       
    • At 10:48 AM, Blogger Atul Kumar said…

      Derek,
      first of all congarts for configuration.

      I dobn't see any document where Oarcle mention not to install discoverer 10g on same machine as discoverer 4i but they say you can't share Oarcle_Home.

      Could you please point me oarcle doc which say not to (or not recommended) to install 10g Discoverer on same host as on 4i discoverer .

      Once again thanks for sharing this info with readers , It will really inspire them to go for Disco 10g R2 wiith Apps

       
    • At 12:31 PM, Anonymous Anonymous said…

      Atul,

      From
      "Installing Oracle Application Server 10g with Oracle E-Business Suite Release 11i. Note:233436.1’

      ‘Existing Discoverer 4i content, including workbooks and End User Layers, can be easily upgraded to Discoverer 10g. It is strongly recommended that Discoverer 4i and 10g be installed on separate physical servers; see the Oracle Application Server 10g Release Notes for your operating system platform for more details.’

      Also

      http://download-east.oracle.com/docs/cd/B10467_16/relnotes.904/relnotes/install.htm#sthref24

      lists the Application Server 10g coexistence restrictions.

      I have yet to see an explanation why they cannot coexist. There is a suggestion that this may have something to do with the visibroker but I am not sure.

      Derek

       
    • At 1:00 PM, Blogger Atul Kumar said…

      Derek,
      Thanks for pointing that out & docs for that.

      I will also try to find reasoning behind Oracle's recommendadtion that "Discoverer 4i and 10g be installed on separate physical servers"

      Atul

       
    • At 5:42 PM, Anonymous Anonymous said…

      Hi Atul,
      Thanks for publishing a blog on Discoverer. DO you have any estimate on the activities performed during upgrade like:-
      1. Migration of existing EUL to 10g

      2. Regenration of business views

      3. Import of Discoverer content using adupdeul.sh

      4. Refresh Discoverer EUl

      ...etc

      the size of my EUL Tbs is around 850 M.

      Regards, VVS

       
    • At 6:43 PM, Blogger Atul Kumar said…

      Hi VVS ,
      Is this from 3i or 4i ?

       
    • At 11:26 AM, Anonymous Anonymous said…

      Hi Atul,
      This is from 4i to 10g.
      Also, I want to know how it is possible to maintain different URL's for 4i and 10g, if we want to put two discoveres's for one database, as I did not see anything in the xml file, which will facilitate the same.

      Thanks in advance,
      Regards, V V S

       
    • At 12:46 PM, Blogger Atul Kumar said…

      VVS ,
      EUL upgrade should be around 1 hour or so (Depends on your server configuration as well).

      You can have two different URL's via Profile Options.

      You have to set one URL at site level & other one at server level .

      Raise your issues / doubts at forum http://teachMeOracle.com/forum dedicated to Apps DBA's

       
    • At 5:35 AM, Blogger Unknown said…

      hi atul
      what is migration on db.

       
    • At 11:40 AM, Blogger Atul Kumar said…

      Abhi ,
      Can you elaborate your question/doubt ?

      Regards
      Atul Kumar

       
    • At 11:08 AM, Blogger leenus said…

      HI Atul,
      small doubt,I am upgading disco 4i to 10g with doc 313418.1.
      i had done all the steps mentioned above up to changing profile options and all.
      I am confused how to grant access on business areas to the users in Apps.
      bcoz when i trying to access discoverer work books from apps itz telling invalid ID/PWD like..

      what is the way to grant responsibilities on work books to application users...

      Regards
      Leenus

       
    • At 4:22 PM, Blogger Unknown said…

      Hi,
      PLEASE ANYONE TELL ME THE LOCATION OF "PDF FILES LOCATION ON MIDDLE TIER"

      Regards,
      Mahender.

       
    • At 4:23 PM, Anonymous Anonymous said…

      Hi,
      Please any one tell me the location of PDF FILES ON MIDDLE TIER

      regards,
      Mahender

       
    • At 4:28 PM, Blogger Atul Kumar said…

      which PDF files ?

       
    • At 10:57 AM, Blogger Anand said…

      Hi Atul,
      You directed me from Application Server section to this discoverer section.
      As shared in my previous post (AS section),
      I am on 11.5.10 (9iAS)
      I have created my EUL using Discoverer 10g.
      But because of compatibility issue I am not able to use Discoverer Plus/Viewer with 10g EUL
      Can you suggest what would be the steps?
      I understand from your post that AS cannot be upgraded from 9iAS to 10g in Apps environment. Can you please elaborate?

      Thanks again
      Anand

       
    • At 11:09 AM, Blogger Atul Kumar said…

      11.5.10 by default comes with eul4 so install standalone 10g Discoverer on seprate oracle home and chnage tns in this oracle home pointing to your 11i database. and use disco URL using new 10g AS ORACLE_HOME . Check 10g Disco configurtaion with 11i metalink note for more information on how to do this .

       
    • At 6:43 PM, Anonymous Anonymous said…

      Hi Atul,
      I have installed 10g application servers in standalone.
      1) I have created the .dbc file in Discoverer/Secure
      2)updated tnsnames in discoverer
      3) I have created the EUL using eulapi

      Refering 313418.1
      ------------------------
      I am into step 7 of Note, configuring the jvm for disco plus?? should I ?

      Section 6 : Postinstallation Tasks?

      I want to enable the workbook(standard) in the Discoverer viewer/Plus

      There seems so many steps, which I can exclude?? Please guide...
      Thanks,

       
    • At 10:30 AM, Anonymous Anonymous said…

      Dear Atul,

      E-Business suite 11i (11.5.10.1 special edition. I want to upgrade 9iR2 (9.2.0.5) database to 10gR1 (10.1.0.4). Is it possible ?

      I also want to freshly install Discoverer, can you guide me which version will be compatible with the 10gR1 (11.5.10.1 special edtion). Do I need to install first Discoverer 4i and then upgrade to 10gR1 ? or first upgrade and then install discoverer ?

      Please help me, bcoz i have to submit today the scope.

      Many Thanks,
      Ravi Purbia

       
    • At 2:28 PM, Blogger Unknown said…

      Dear Atul,

      E-Business suite 11i (11.5.10.1 special edition. I want to upgrade 9iR2 (9.2.0.5) database to 10gR1 (10.1.0.4). Is it possible ?

      I also want to freshly install Discoverer, can you guide me which version will be compatible with the 10gR1 (11.5.10.1 special edtion). Do I need to install first Discoverer 4i and then upgrade to 10gR1 ? or first upgrade and then install discoverer ?

      Please help me, bcoz i have to submit today the scope.

      Many Thanks,
      Ravi Purbia

       
    • At 8:35 PM, Blogger Atul Kumar said…

      Disco 10.1.2.0.2 works fine which you can later upgrade to 10.1.2.2

      4i is not required it comes by default

       
    • At 11:33 AM, Blogger Unknown said…

      Hi Atul,

      I did not get you about

      "Disco 10.1.2.0.2 works fine which you can later upgrade to 10.1.2.2"

      Currently, 11.5.10.1 special edition dose not have installed the Discoverer and the database version is 9.2.0.5.

      My question is.
      1) Do i need to install Discoverer BEFORE UPGRADE the database from 9.2.0.5 to 10.1.0.4 (Not upgrading E-Business suits)

      2) If AFTER UPGRADS to 10.1.0.4 database, which version of Discoverer we should install ? (document id ?)

      3) Can i follow the CORE database upgrade (DBUA) mathod into E-Business suits to upgrade the DB ?

      Looking for instant reply.

      Many Thanks,
      Ravi Purbia

       
    • At 9:17 AM, Anonymous Anonymous said…

      Hi,

      Is it possible in discoverer10g to change parameters RowFetchLimit, RowFetchLimitDisabled in pref.txt file globally for all users.

      Thanks
      Raj

       
    • At 9:32 AM, Anonymous Anonymous said…

      Hi Atul,

      Thanks for doing this great work. I have a doubt about discoverer10g. Is it possible to change parameter RowFetchLimit, RowFetchLimitDisabled for all users in file pref.txt file. We want to disable these parameters for all.

      Thanks
      Raj

       
    • At 11:58 AM, Blogger Anuj Malhotra said…

      Hi,

      I am working on Discoverer 10g and Now I have to work on configuration files as well. Can you tell me what all we can do with the Discoverer Configuration files and how we can access those files. I refered the Documentation and found that We can do Viewer and discoverer Plus Customizations in terms of Color font etc , Do you have any good documentation on it and can you guide me on..

      Regards,

      Anuj Malhotra

       
    • At 4:21 AM, Anonymous Anonymous said…

      Hi Atul,

      How do i know that the discoverer is used and has EUL's. In the installtion note 313418.1 under the section "Migrate your existing Discoverer End User Layers to Discoverer 10.1.2." he says ""If you do not have an existing Discoverer 4i or 9.0.4 End User Layer, skip this step ""

      Thanks,
      Kiran.

       
    • At 7:02 AM, Blogger Atul Kumar said…

      Kiran,
      Check with your discoverer developer or end users.

       
    • At 9:05 AM, Blogger jay said…

      Hi Atul,
      one user trying to copy his view output from Ebusiness suit
      but he cant the smae thing i did from other user it works will you plz send the solution as soon as possible bcause its urgent

       
    • At 5:02 AM, Blogger narashim said…

      Multiple Oracle Discoverer version on same system


      Is there a way we can have both Oracle Discoverer 10 (web-based) and Oracle Discoverer 4 (existing version) installed on the same production server to allow us to deploy new reports in the web version while still supporting the older existing reports?

       
    • At 5:02 AM, Blogger narashim said…

      Multiple Oracle Discoverer version on same system


      Is there a way we can have both Oracle Discoverer 10 (web-based) and Oracle Discoverer 4 (existing version) installed on the same production server to allow us to deploy new reports in the web version while still supporting the older existing reports?

       
    Post a Comment
    << Home
     
    About Me


    Name: Atul Kumar
    Home: London, United Kingdom

    About Me: I am Independent Oracle consultant. If you wish to hire me on Contract or to Quote on project basis contact me at
    atul @ onlineappsdba.com

    See my complete profile

    View Atul Kumar's profile on LinkedIn

    E-mail Subscription

    Enter your email address:

    Delivered by FeedBurner

    Search
    Only search this Blog
    Categories
  • Advanced Topics
  • Application Server
  • Apex / HTMLDB
  • Apps 11i
  • Apps R12
  • Autoconfig
  • Basics
  • Certification
  • Cloning
  • Discoverer
  • Fusion
  • OID
  • Patching
  • Printer
  • Single Sign-On
  • Useful Sites & Forum
  • Previous Post
    Archives
    Add On
     

    Add to Technorati Favorites

     

     

    Add to Google

     

    Add to My AOL

     

    Subscribe in Bloglines

     

    Subscribe in NewsGator Online

     
    Powered by



    Hits Since 30, Jul 06

    Blog Counter

    Technology Blogs - Blog Top Sites
    Comments
    ADs
    Copyright © 2006 teachmeoracle.com All rights reserved Presented by Atul Kumar