Introduction
Steps to upgrade Discoverer from 41 to 10g Applicatioins
Posted by Narasimha Rao
Upgradation of Discoverer from 4i to 10g for Applications 11i CU2 (11.5.10.2)
Environment Details : Operating system : Solaris Sparc 64 Bit (5.10)
Applications : 11i CU2 (11.5.10.2)
Database : 10.2.0.2.0
Oracle AS (Infra and Disc) Installation in TEST Applications
Infra Structure installation in TEST:
1. login to root
2. xhost +
3. echo set semsys:seminfo_semmni=300 >>/etc/system
4. echo set semsys:seminfo_semmns=1024 >>/etc/system
5. echo set semsys:seminfo_semmsl=256 >>/etc/system
6. echo set shmsys:shminfo_shmmax=4294967295 >>/etc/system
7. echo set shmsys:shminfo_shmmin=1 >>/etc/system
8. echo set shmsys:shminfo_shmmni=512 >>/etc/system
9. echo set shmsys:shminfo_shmseg=150 >>/etc/system
10. cd /testapps01/
11. mkdir –p testdisc
12. mkdir –p testdisc/testinfra
13. mkdir –p testdisc/testdis
14. chown –R apptstmgr:dba ./testdisc
15. Login to OS application owner (apptstmgr).
16. cd /Disk1/
17. DISPLAY=192.168.73.168:0.0;export DISPLAY
18. ./runInstaller
19. click next on welcome screen
20. set ORACLE_HOME as /testapps01/testdisc/testinfra and click next in “Specify file
location” screen.
21. Select “Oracle Application Server Infrastructure 10g” and click next in “Select a product
to Install” Screen.
22. Select “Identity Management and Metadata Repository” and click next in “Select
Application Type” Screen.
23. Select “Root Privileges” and click next in “Confirm Pre-Installation Requirements” Screen.
24. Select “Oracle Internet Directory, Oracle Application Single Sign-on, Oracle Application
Server Delegated Administrator” and click next in “Select configuration Options” screen.
25. select “Suggested Namespace” with default values (dc=dummy,dc=co,dc=in) and click
next in “Specify Namespace in Internet Directory” Screen
26. select “Automatic” and click next in “Specify Port Configuration Options” screen
27. Provide Global Database Name = “testinfr.dummy.co.in” , SID=testinfr , select database
character set as English US7ASCII , specify Database File Location
/testapps01/testdisc/oradata/ and click next in “Specify Database Configuration Options”
Screen
28. Select “Use the same password for all the accounts” and enter the password as tester1
And click next in “specify Database Schema Passwords” Screen.
29. Enter the Instance Name as “testinfr”, ias_admin password as tester1, confirm password
as tester1 and click next on “Specify Instance Name and ias_admin Password” screen.
30. click Install on “Summary Screen”
31. After Setup Completion, Installer request to run /testapps01/testdisc/testinfra/root.sh
from root.
32. login to root through another terminal
33. sh /testapps01/testdisc/testinfra/root.sh
34. Accept all the default values prompted by root.sh scripts
35. click ok on installer screen prompted to run /testapps01/testdisc/testinfra/root.sh script
36. Installer will proceed for configuration of database and As Components.
37. After Installation is completed click exit & yes to exit installer.
Details of TEST AS Infrastructure after completion of Installation and configuration of
AS Components
The following information is available in:
/testapps01/testdisc/testinfra/install/setupinfo.txt
Oracle Application Server 10g (10.1.2.0.2) Usernames and Default password information:
Please refer to Oracle Application Server 10g Administrator Guide for more information.
Install Type: Identity Management and Metadata Repository
Configured Components: Oracle Application Server Metadata Repository Oracle HTTP Server
Oracle Application Server Containers for J2EE Oracle Internet Directory Oracle Application
Server Single Sign-On Oracle Application Server Delegated Administration Service Oracle
Application Server Directory Integration and Provisioning
New Database created with these properties:
Database File Location: /testapps01/testdisc/oradata/
Database Global Name: testinfr.dummy.co.in
Database SID:testinfr
Database Name:testinfr
Character Set: -characterset US7ASCII
Use the following URL to access the Oracle HTTP Server and the Welcome Page:
http://ebstest01.dummy.co.in:7778
—————————————–
Use the following URL to access the Oracle Enterprise Manager Application Server Control:
http://ebstest01.dummy.co.in:1156
Instance Name: testinfr.ebstest01.dummy.co.in
Discoverer Structure installation in TEST:
1. login to root
2. xhost +
3. echo set rlim_fd_max=65536 >>/etc/system
4. Login to OS application owner (apptstmgr).
5. cd /Disk1/
6. DISPLAY=192.168.73.168:0.0;export DISPLAY
7. ./runInstaller
8. click next on welcome screen
9. set ORACLE_HOME as /testapps01/testdisc/testdis and click next in “Specify file location”
screen.
10. Select “Oracle Application Server 10g” and click next in “Select a product to Install”
Screen.
11. Select “Business Intelligence and Forms” and click next in “Select Application Type”
Screen.
12. Select “Root Privileges” and click next in “Confirm Pre-Installation Requirements” Screen.
13. Select “Oracle Application Server 10g Discoverer” and click next in “Select configuration
Options” screen.
14. select “Automatic” and click next in “Specify Port Configuration Options” screen
15. Provide password as tester1 for username: cn=orcladmin in “Specify OID Login” Screen.
16. Click next on “Select Oracle Application Server 10g Metadata Repository” Screen.
17. Click next on “Provide Outgoing Mail Server Information” screen (SMTP can be null).
18. Enter the Instance Name as “testdis”, ias_admin password as tester1, confirm password
as tester1 and click next on “Specify Instance Name and ias_admin Password” screen.
19. click Install on “Summary Screen”
20. After Setup Completion, Installer request to run /testapps01/testdisc/testdis/root.sh from
root.
21. login to root through another terminal
22. sh /testapps01/testdisc/testdis/root.sh
23. Accept all the default values prompted by root.sh scripts
24. click ok on installer screen prompted to run /testapps01/testdisc/testdis/root.sh script
25. Installer will proceed for configuration of database and As Components.
26. After Installation is completed click exit & yes to exit installer.
Details of TEST Discoverer after completion of Installation and Configuration of AS
Components
The following information is available in:
/testapps01/testdisc/testdis/install/setupinfo.txt
Oracle Application Server 10g 10.1.2.0.2 Usernames and Default password information: Please
refer to the Oracle Application Server 10g Administrator Guide for more information.
Install Type: All Services
Configured Components: Oracle HTTP Server, Oracle Application Server 10g Containers for J2EE,
Oracle Application Server 10g Web Cache, Oracle Application Server 10g Discoverer,
Registered with Oracle Internet Directory: ebstest01.dummy.co.in:389
Use only SSL connections with this Oracle Internet Directory:No
Database Connection String:
ebstest01.dummy.co.in:1521:testinfr.dummy.co.in:testinfr.dummy.co.in
Use the following URL to access the Oracle HTTP Server and the Welcome Page:
http://ebstest01.dummy.co.in:7779
—————————————–
Use the following URL to access the Oracle Enterprise Manager Application Server Control:
http://ebstest01.dummy.co.in:1810
Instance Name: testdis.ebstest01.dummy.co.in
/testapps01/testdisc/testdis/discoverer/util/pref.txt
Configuration of TEST Discoverer and integrating Oracle Application 11i with 10g
Discoverer
1. login to apptstmgr ( applications manager )
2. scp –rp /testapps01/testappl/fnd/11.5.0/secure/TEST_ebstest01/test.dbc
/testapps01/testdisc/testdis/discoverer/secure/
3. cd /testapps01/testdisc/testdis/network/admin
4. vi tnsnames.ora
5. add the following tns entry in tnsnames.ora
a. TEST=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=ebstest01.dummy.co.in)(PORT=1572))
(CONNECT_DATA=
(SERVICE_NAME=test)
(INSTANCE_NAME=test)
)
)
16. login to apptstmgr in another terminal to ebstest01
17. source applications 11i environment file
18. cd $APPL_TOP/admin
19. backup the xml file : scp –rp TEST_ebstest01.xml
TEST_ebstest01_bkp__.xml
20. vi TEST_ebstest01.xml
21. change the following parameters as below:
a. s_disco_standalone = true
b. s_disco_machine = ebstest01.dummy.co.in
c. s_disco_port = 7779
d. s_disco_protocol = http
e. s_disco_ver_comma = 10,1,2
f. s_disco_eul_prefix = EUL
g. s_discostatus = disabled
22. cd $COMMON_TOP/admin/scripts/$CONTEXT_NAME
23. stop application services : sh adstpall.sh apps/apps
24. ensure concurrent managers stop completely : ps –efgrep FNDLIBRgrep –v grepwc –l
25. execute autoconfig : sh adautocfg.sh
26. provide the apps schema password : apps
27. After Autoconfig completed successfully, Startup application services :
sh adstrtal.sh apps/apps
28. Login to sysadmin through front end applications
29. Navigate to system administrator responsibility.
30. In System administrator, Navigate profiles à system form. Query the %Discoverer%
profile options. verify the following ICX profile options in Oracle Applications:
a. ICX_DISCOVERER_LAUNCHER =
http://ebstest01.dummy.co.in:7779/discoverer/plus?Connect=[APPS_SECURE]
b. ICX_DISCOVERER_VIEWER_LAUNCHER =
http://ebstest01.dummy.co.in:7779/discoverer/viewer?Connect=[APPS_SECURE]
c. ICX_DISCOVERER_RELEASE = 10
d. ICX_DISCOVERER_USE_VIEWER = Yes
e. ICX_DEFAULT_EUL = EUL
f. ICX_DISCOVERER_EUL_LANGUAGE = American English
g. ICX_DISCOVERER_PARAMETERS =
exitURL=http://ebstest01.dummy.co.in:8051/OA_HTML/OA.jsp?OAFunc=OAHOMEPAGE.
