http://onlineAppsDBA.com

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?

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

hi atul
what is migration on db.

 

Abhi ,
Can you elaborate your question/doubt ?

Regards
Atul Kumar

 

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

 

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

Regards,
Mahender.

 

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

regards,
Mahender

 

which PDF files ?

 

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

 

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 .

 

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,

 

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

 

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

 

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

 

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

 

Hi,

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

Thanks
Raj

 

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

 

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

 

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.

 

Kiran,
Check with your discoverer developer or end users.

 

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

 

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?

 

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?