We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
Discoverer in Oracle Applications |
Sunday, November 05, 2006 |
|
One of my readers reminded me that I have not covered on discoverer for Apps DBA yet so thought of putting some bits and pieces for you on Discoverer and later on How to Integrate Discoverer 10g with Oracle Apps 11i. So lets start this discussion about overview & things you should know about Discoverer as Apps DBA.
Whats is Discoverer Server ? Discoverer is and ad hoc query, reporting, analysis and publishing tool which help business users to get quick access to information from datawarehouse or OLTP systems. In Apps, Discoverer version 4i used to be installed & configured out of the box which is desupported now. You should configure Apps with Discoverer 10g (I am going to cover about how to configure discoverer 10g with E-Business Suite)
What should I know about Discoverer as an Apps DBA ? Though each component in Apps like forms, reports, web server including Discoverer in itself are quite big and more you know about them better it is for you . Few Important things you should know about Discoverer in Apps is like how to start/stop & how to access it. In case of any issues you should be able to troubleshoot discoverer.
What is EUL ? You will hear lot about EUL from business analyst which means End User Layer, which is the key to provide ease of use to underlying data in Oracle Apps Database.
Technical things about discoverer in Apps .. --In Apps default discoverer version 4i, is installed under $ORACLE_HOME/discwb4 --Script to start discoverer server is addisctl.sh under $OAD_TOP/admin/scripts/$CONTEXT_NAME -- This script in turn start discoverer processes which can be start by startall.sh under $ORACLE_HOME/discwb4/util (This script is different from adstrtal.sh) -- startall.sh calls scripts like startgatekeeper.sh, startlocator.sh , startoad.sh, startosagent.sh to start gatekeeper, locator, oad & osagent resp. -- In Apps two major way to access EUL is via Discoverer view & Discoverer Plus edition (You can use Discoverer Administration Edition as well)
Quiz to reader : A. How will you find discoverer version in Apps ? B. What URL you use to access Disco viewer & Disco plus .
Post your answers via comments
Stay tuned to check How to install 10g Discoverer & configure with Oracle Applications 11i Coming Soon .....
*************Important Note************* Now you can subscribe Email Notification For New Post on this Site --Check on right Menu Bar of Page under E-mail Subscription enter your email ID --click on "subscribe". --It will open new window to verify (If pop up blocker is enabled , allow for this session) --You have to type text message displayed on pop up window --"click on complete subscription". Final step is to Verify in your mail box that you only asked for Subscription. Go to your inbox , you should see a mail with Subject "Activate your Email Subscription to:.. "Open that mail & click on link in mail If you don't see this mail in your inbox then check your Junk eMail Folder Click on this link Relax & you will get notification in your mail box as soon I post new Topic here .Labels: 11i, basics, discoverer |
We have moved to kindly check onLineAppsDBA.com in future
|
|
del.icio.us
¦
Digg This
¦
My Yahoo
¦
Reddit
¦
BlinkList
¦
Furl It
¦
Email This
¦
Leave Your Comments
|
posted by Atul Kumar @ 2:00 AM
  |
|
38 Comments: |
-
for viewer it is
http://hostname.domainname:port/dicswb4/viewer
-
Hi,
Plus--http://hostname.domain:port/discwb4/html/english/welcome.htm
Viewer-- http://hostname.domain/discoverer4i/viewer
Version $ORACLE_HOME/Discwb4
$ string –a dis4pr | grep –i ‘discoverer version’
-
Hi,
Viewer-- http://hostname.domain:port/discoverer4i/viewer
Plus---- http://hostname.domain/discwb4/html/english/welcome.htm
Version:
Goto $ORACLE_HOME/Discwb4
$ string –a dis4pr | grep –i ‘discoverer version’
Thanks
-
Thanks a lot for comments,
Second answer is correct one .
i.e.
Plus--http://hostname.domain:port/discwb4/html/english/welcome.htm
Viewer-- http://hostname.domain/discoverer4i/viewer
Version $ORACLE_HOME/Discwb4
$ string –a dis4pr | grep –i ‘discoverer version’
Please mention your name if possible for your feedback & answers
-
hi atul I want to use the discoverer4i in my existing apps. So after starting the discoverer server does it have a default user and password provided by oracle to access for the first time.
-
Hi Santosh, You can use sysadmin or apps user to access dscoverer .
Ask Discoverre Functioanl analyst to grant EUL access to any other Application users which you created later .
Atul
-
Please tell me what is the URL if i have to access Oracle 10g.
-
Hi Anonymous, We are going to cover this in my coming post on how to configure Apps with Discoverer 10g
Atul
-
Mudasir, Its now available at
http://becomeappsdba.blogspot.com/2006/11/discoverer-10g-oracle-11i.html
Atul
-
Just wanted to share the below
The location for looking for dis4pr is $ORACLE_HOME/diswb4/bin
where ORACLE_HOME -> 8.0.6. Oracle Home
-
Thanks for information. I would like to ask that we have oracle discoverer 4.1.37 version, so how to upgrade to 4.1.48.06? I heard that there is a patch for this, would you elaborate more on this.
Arizuddin arizudding@rcjubail.gov.sa
-
hi atul how to configure workflow and Discoverer,
i mean , my discoverer reports to schebuled based on events
-
You mean you want to configure Disco & workflow with apps or any other thing ?
If this is 11.5.9 and higher disco & WF are already integrated with Apps
-
Arizuddin Do you wish to upgrade it to 4.1.37 (This is obsolete & desupported now) I would suggest you to configure 10g Disco with Apps which I am going to cover in a day or two by 18 Feb 07 in this blog
-
Hi Atul, I have created EUL using Discoverer 10g Administrator, but my server side is running 9i AS can I still use Discoverer Plus/Viewer to show reports based on 10g EUL?
Thanks Anand
-
Anand, Your Discoverer Desktop Admin version is 10g and EUL on server is 9i. As soon as you try to connect to 9i Server it will display message that You are using old version of EUL kindly upgrade & it will upgrade EUL on server to 10g
-
.HI Atul
Can you tell me about the Single Sign on facility with Orale Discoverer 4i and Oracle APPS release 11i (11.5.10)
How I am gonna setup SSO (Single Sign on to Discoverer Plus From ORacle APPS 11i)
-
Hi anonymous, for configuring sso with any oracle apps component only certified way is to use sso server which comes with 10g AS . so Install 10g AS & use 10g AS for & sso with 10g AS in apps .
Another option is to use 10g Disco itself (install 10g AS with disco option) follow metalink note # 313418.1 Using Discoverer 10.1.2 with Oracle E-Business Suite 11i when you install 10g disco install infra first (sso & oid) and then install disco middle tier & configure disco 10g with apps
-
could you please explain more about discoverer like why do we use it? if its for reporting, we have CM and reports server for such functionality...why use disco then???also what do you mean by analysis??
-
Hi Anonymous, Discoverer is for Business Intelligence reporting .
These are more complex reports & mainly targeted for OLAP kind of reports . Soon you might see discoverer being replaced by BIEE (Business Intelligence Enterprise Edition) build on siebel analytics
-
Hi Atul, Thanks for the great info. I have a query. Iam using Disc 10 on Apps 10 and access Disc Viewer via a URL call from Custom form. I have created Disc reports using LOGIN_A and granted access to some users. But if there is a any session issue in Viewer it is still asking the LOGIN_A's pwd even though I logged in using one of the granted user name. Please help; Thanks!!
-
Hi Kriz, Are you talking about application server 10g or applications 11i ?
Raise any questions/issues at http://teachmeoracle.com/forum
-
Hi,
how to integrate OLAP Report with Oracle application in 11.5.10.2
-
Hi,
How to integrate OLAP report with Oracle applications 11.5.10.2
-
Hi This is Krishna, will you please tell me how we register the discoverer reports. i have followed the process but it is giving some errors.
Krishna
-
How to connect to discoverer viewer in Release 12?
-
-
Use http://hostname.domainname:http_port/discoverer/viewer
-
How i will configure oracle discoverer 1og with oracle apps 12i. how oracle user will be permitted to access the responsibility
-
I everyone,
I would like to know how to get à paper shema of the table relation created by the sysadmin in Discoverer.
Is there a tool that do it ?
-
good see a lot of info exchanging between u guys on discoverer which i wasnt even aware of
-
Hi,
First of all thanks for sharing the such a useful information across the blog. I would like to know the Whether we can install on linux x86 that is 11i instaces server, is yes where i will get the Discoverer 10g on linux Software.
Thanks in advance Krishna Kumari
-
-
hi, client is using discoverer viewer to access reports and most of the users use the same id to login to viewer edition to access the reports.
I do know that in Viewer we’ll need to turn off anything that allows the user to save changes/preferences as what they are saving is not only for themselves, but everyone else using that ID to access the reports.
can you tell me what attibuites we need to change in discoverer viewer Configuration file for this.
Anuj malhotra
-
Dear expert; I'm new to both Oracle Apps and Discover 10g; I've installed oracle application server on a linux box(as_linux_x86_bi_101202); I try to access to discoverer by browsing http://charon.cd.celtel.com:7777/ but i can go far. could some one help me with the basic alka
-
Hi all; When I try to logon logon a DB, I recieve following error message: ================================= Attempt 1. CORBA protocol : 0 of 1 processes started. Hint: An administrator can further diagnose connection problems by running the "checkdiscoverer" script under ORACLE_HOME/discoverer/util. ================================== and when I run the checkdiscoverer.sh ; I get following message: =============================== /home/oracle/Home/jdk/bin/java: error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file or directory =============================
thanks for the help
-
Does anyone know about a solution for the CORBA-error described by Alka?
-
HI,
When i am trying to login the Discoverer..its throwing following error..
Error Authentication Failed. (You do not have access to any End User Layer tables)
HOw i can give acess ??
|
|
<< Home |
|
|
|
for viewer it is
http://hostname.domainname:port/dicswb4/viewer