As you all know oracle has de-supported oracle discoverer 4i on apps 11i, therefore all DBA's will have at some point to upgrade their discoverer from 4i to 10g. Below are the steps I used to do that.
Kindly note that you have to refer to note 313418.1 in order to do that upgrade and not to my posts, my post will just give you a direct hint on what to do.
Steps are as follow based on note 313418.1:
-Install Oracle Business Intelligence Server 10g Release 2 (10.1.2.0.2). This installation type does not require installation and association to Oracle Application Server 10g Release 2 (10.1.2.0.2) Infrastructure. (You can choose this option if you are not planning to use features Discoverer Connection Management, Discoverer Portlet Provider, and Oracle SSO).
- Create secure directory under $Disco_ORACLE_HOME/discoverer
cd /u07/discoverer_home/discoverer
(mkdir secure)
-cp the $FND_SECURE/
-Update tnsnames.ora file in $Disco_ORACLE_HOME to include connect to your Oracle E-Business database Use the same entry as exists in the tnsnames.ora file on your Oracle E-Business application tier server node.
-Migrate your existing Discoverer End User Layers to Discoverer 10.1.2.
$Disco_ORACLE_HOME/bin/eulapi -CONNECT
-Set Applications Profile Options for Discoverer using AutoConfig
-open your xml file and specify variables as listed in the table below:
s_disco_standalone=true
s_disco_machine=
s_disco_port=
s_disco_protocol=http https
s_disco_ver_comma=10,1,2
s_disco_eul_prefix=EUL
After that you have to run autoconfig
-Verify Applications profile options in Oracle Applications
Log into Release 11i with the System Administrator responsibility
Navigate to the Profile > System form
Query the %Discoverer% profile options.
Verify the following ICX profile options in Oracle Applications
ICX_DISCOVERER_LAUNCHER=http://
ICX_DISCOVERER_VIEWER_LAUNCHER=http://
ICX_DISCOVERER_RELEASE=10
ICX_DISCOVERER_USE_VIEWR=Y N
ICX_DEFAULT_EUL=EUL
ICX_DISCOVERER_EUL_LANGUAGE=US
ICX_DISCOVERER_PARAMETERS=exitURL=http://
Note:
When you open the discoverer EUL using the Discoverer 10g Desktop/Admin it will ask you if you want to upgrade your EUL and you have to choose yes.
To start/stop the new discoverer do the following:
$Disco_ORACLE_HOME/opmn/bin/opmnctl stopall (to stop).
$Disco_ORACLE_HOME/opmn/bin/opmnctl startall (to start).
If you have any question please leave at comments part
14 comments:
Fadi,
Good luck to your Blog , I am happy to see you posting & your first post itself is good one .
I would like to see more from you & will introduce you in my blog .
Good luck with your posting , Keep rocking .
thanks my friend, watch my coming post soon, you will like it.
fadi
Hi Fadi,
Good Blog and All the best..
With Best Reagrds,
Srawan
wht abt cloning after integrating the 10g with 11i.
thank you Srawan,
I hope to see more comments for you.
For the cloning part, i already have the discoverer installed at my clone server so after cloning all i have to do is to update all the profiles related to %DISCOVERER% to point to the discoverer on the clone server. Same steps as in the post.
Thank you all
fadi
Your post is straight forward, yet very informative. Thank you for your post. I can use this as a quick refence for all the steps I follow for 10g migration.
However, I have a question in setting up the System profiles for the discoverer.
At present the profile is set like below, in my system
ICX_DISCOVERER_PARAMETERS=_po=10011011111111111110000
What is this profile meant for..?
Is this no more required once we upgrade to 10g ??
If we change the above one to
ICX_DISCOVERER_PARAMETERS=exitURL=http://:/OA_HTML/OA.jsp?
HI Fadi,
I have a some questions on the timelines of the activity. I want to know how much it takes for the following activities :-
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
My EUL tablespace is around 850 M.
Thanks in advance,
Regards, VVS
hi VVS, i would like to tell you that whole upgrade process took around 8 hours with the installation of the new application server for discoverer.
good luck
fadi
Hi Fadi,
We are in the process of upgrading Disco 4i to 10g. I found your blog very useful.
Refresh the Discoverer 10.1.2 End User Layer step is hanging after processing 81 folders. Any tips will be appreciated.
Here is the log:
sh adrfseul.sh \
connect=sysadmin/****@DEV \
resp="System Administrator" \
gwyuid=APPLSYSPUB/PUB \
fndnam=APPS \
secgroup="Standard" \
eulschema=EUL5_US \
eulpassword=EUL \
twotask=DEV \
iashome=/oracle/bi10g \
logfile=~/EUL5_DEV_Refesh2.log
...
...
79 of 5457 : Refreshing folder: Account Description 8 ...
-connect <**********>
-refresh_folder Account Description 8
-log /oracle/prdappl/au/11.5.0/discover/logfile2537.log
-apps_user
-eul EUL5_US
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
Command completed.
80 of 5457 : Refreshing folder: Account Description 8 1 ...
-connect <**********>
-refresh_folder Account Description 8 1
-log /oracle/prdappl/au/11.5.0/discover/logfile2537.log
-apps_user
-eul EUL5_US
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
Command completed.
81 of 5457 : Refreshing folder: Budget Account Description ...
-connect <**********>
-refresh_folder Budget Account Description
-log /oracle/prdappl/au/11.5.0/discover/logfile2537.log
-apps_user
-eul EUL5_US
-apps_responsibility System Administrator
-apps_gwuid APPLSYSPUB/PUB
-apps_fndnam APPS
-apps_security_group Standard
Command completed with errors - see log file for details.
In Dev instance also it is stopping at exactly same point.
Thanks,
Siva
hi siva,
can you plz check the log /oracle/prdappl/au/11.5.0/discover/logfile2537.log i think it should go somthily on this step just give it time and let me know incase there is error on the log.
for me i never faced an issue with that step
fadi
Fadi,
Thanks for your response.
I don;t see anything in that log file.
[devap@odevap tmp]$ cat /oracle/devappl/au/11.5.0/discover/logfile8785.log
java EulCommandLine -connect <**********> -EUL EUL5_US -apps_user -apps_responsibility System Administrator -apps_gwuid APPLSYSPUB/PUB -apps_fndnam APPS -apps_security_group Standard -refresh_folder Budget Account Description -log /oracle/devappl/au/11.5.0/discover/logfile8785.log
Started Sun Jul 22 00:09:39 CDT 2007 ...
Failed to find folder Budget Account Description...
Refresh complete. No differences found.
Completed Sun Jul 22 00:09:42 CDT 2007.
Thanks,
Siva
sorry Siva,
been busy and could not reply before any luck with your issue.
fadi
Hi Fadi,
We have about 1000 disco reports, developed on release 4.
Can you advise what is the best way to verify that all reports/ functions etc... works correctly after the 10g migration?
Regards,
Nahum
sorry for beging late nahum, i was out of my conuntry(actuly still) if you tried the upgrade you will see that all the report will work fine. if they used to work on 4i then they will work on 10g
good luck
fadi
Post a Comment