Wednesday, November 29, 2006

Upgrading discoverer 4i to 10g on Apps 11.5.10

Upgrading discoverer 4i to 10g on Apps 11.5.10.1

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/.dbc , $FND_SECURE/_.dbc TO your $Disco_ORACLE_HOME/discoverer/secure directory.

-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 /@ -AUTO_UPGRADE

-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=for example: ap6162rt.us.oracle.com
s_disco_port=for example: 7778
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://:/discoverer/plus?Connect=[APPS_SECURE]
ICX_DISCOVERER_VIEWER_LAUNCHER=http://:/discoverer/viewer?Connect=[APPS_SECURE]
ICX_DISCOVERER_RELEASE=10
ICX_DISCOVERER_USE_VIEWR=Y N
ICX_DEFAULT_EUL=EUL
ICX_DISCOVERER_EUL_LANGUAGE=US
ICX_DISCOVERER_PARAMETERS=exitURL=http://:/OA_HTML/OA.jsp?OAFunc=OAHOMEPAGE

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:

Atul Kumar said...

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 .

fhasweh said...

thanks my friend, watch my coming post soon, you will like it.


fadi

Anonymous said...

Hi Fadi,

Good Blog and All the best..

With Best Reagrds,
Srawan

Anonymous said...

wht abt cloning after integrating the 10g with 11i.

fhasweh said...

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

Anonymous said...

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?

Anonymous said...

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

fhasweh said...

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

Siva said...

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

fhasweh said...

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

Siva said...

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

fhasweh said...

sorry Siva,
been busy and could not reply before any luck with your issue.

fadi

Anonymous said...

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

fhasweh said...

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