Overview on How to Configure Discoverer 10g with Oracle Apps

Hi Atul,

Please also devote some articles on Workflow Mailer.

Thanks
Nagarajan

Naga,
I’ll surely put this week after discoverer configuration post .

Atul

Hi Atul,
My client is currently on discoverer 4i and soon be migrating to Discoverer 10g (which will be configured with Oracle e-business suite 11.5.10).Can you please let me know the pre-requisites for discoverer 10g installation and does it required to be have oracle application server 10g?
I will appreciate if you can also let me know how to configure disco 10g with oracle e-biz.
Thanks in advance.

For any apps quesries/questions / doubts raise them in forum at http://teachMeOracle.com/forum

or use metalink note #

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

Hi Atul,
Dear Senthil,

We are trying to evaluate the Discoverer 10g, by importing the Oracle EBS Standard EUL and Worksheet. All the steps are successful and we are stuck with running adupdeul.sh on the standalone server.

It would be of great help, if you can sort out this. I cannot open the TAR as we don’t have license now. I have done all the steps as mentioned in the note : 313418.1

Now, I am in the line 7 of the above note, running adupdeul.sh, which gives error

adupdeul: cannot find executable ‘dis4adm.exe’ in
notgiven directory.
Please use iashome for Dicoverer 10G and above.

Our EBS is in Unix and 10g Admin and Disco is in WIN 2003

We have mounted the Unix $AU_TOP/discover directory as U:\ in WIN 2003

Given below the script being run from WIN 2003 server

I am not using MKS Toolkit.
sh adupdeul.sh connect=sysadmin/sysadmin@test resp=”System Administrator” gwyuid=APPLSYSPUB/PUB fndnam=APPS secgroup=”Standard” topdir=. language=US eulprefix=apps_disco eultype=OLTP mode=complete iashome=F:\ORACLE\BIToolsHome_1\BIN logfile=import_complete_eul_us_cust115.log

Regards,
Ram

Can some one answer this.I am facing the same problem.

Can some one answer this. I am facing the same problem. Any suggestion.

Ram & XYZ,
Check metalink note # 444372.1 Adupdeul: Cannot Find Executable ‘Dis4adm.Exe’

Recently we upgraded Oracle Discoverer 4i to Oracle Discoverer 10g.

Earlier Oracle Dicoverer 4i reports used to run very fast (response time less than 20 secs), but now Discoverer 10g is taking around 4-5 minutes to retrieve the data.

Could you please advice, how this performance issue can be resolved?

thanks,

Hi Atul,

I could see you are doing a good job. I have a simple question about migrating the End User Layers. My client currently has the Standard EUL in Discoverer. They use database username to access the Discoverer EUL and some sort of Roles to restrict access to the EUL. They wanted to go with the APPS mode EUL from now onwards. Is there any way to migrate the Database mode EUL to Apps mode EUL? I know we can do upgrades of EUL from one version to another but is this possible? Or, do i need to install the Apps Mode EUL and create all the Business Areas/Workbooks from scratch?

Any help will be highly appreciated.

Regards
Raghu

Hi Atul

Though I am new to this Application Servers, Can you please explain me how to connect Oracle10gAS to the remote system production database(10g) on RHEL4 platform.

Looking forward to your reply

Naveen K. SR

@ Naveen,
I am not clear with your doubt regarding

How to connect Oracle10gAS to the remote system production database(10g) ?

Do you wish to connect from discoverer middle tier on Oracle10gAS to remote database (10g) ?
or
Do you wish to use remote database (10g) to host metadata of Oracle application server (Portal/Wireless/Disco/Forms type of installation) ?

Hi Atul

Actually I want to implement Discoverer, I want to know how to connect from discoverer middle tier on O10gAS to remote O10g database. And at the same time I want to know how the client systems should access from AS.

If you help me, that would be the great pleasure

Thanks
Naveen

@ Naveen,
Create tns entry in tnsnames.ora in Discoverer Middle Tier $TNS_ADMIN location and then use that TNS alias from dicoverer middle tier to connect to remote database

use URL like

http:// servername : port /discoverer/viewer
http:// servername : port /discoverer/plus

Single Sign-On configuration is optional

Hi all,

Please help i have urgent requirement, I need to migrate Dicoverer all components from 4 to 10G.

Please help on this , If you any document Please share with me my gmail:

raghavendraprasad37@gmail.com

Advance thanks to all

thanks
prasad

@ Prasad,
Check metalink note 312234.1 How to Migrate or Upgrade from Discoverer 3.1 or 4.1 to Discoverer 10.1.2

This doc has link to other docs which you would need to upgrade.

Hi Atul,

We are going to upgrade Oracle database 10g to 11g R2 and for that very reason we want to migrade our oracle discovere 10g to oracle discoverer 11g.

Here I did google and found out the installation procedure of FMW 11g but I still have one question.Once we create new schema using RCU for oracle discovere 11g , then how can we migrate our old schema of oracle discovere 10g in to new oracle discovere 11g schema created by RCU.?

Your help would eb much appreciated.

Thanks,
Ashwani

@ Ashwani Gupta ,
There are two parts of discoverer DB objects a) Metatadata which in 11g you configure using config.sh and then EUL which has end user layer which sits in EBS database of EBS-DISCO integration

sir, please provide me DBA interview questions on Archiecture & installation, i am learning appsdba from techbricks