Database Upgrade from 10.2.0.2 to 10.2.0.3 – R12

Oracle Apps certified the 10.2.0.3 database with R12.Metalink Note 454750.1

Here I will explain my upgrade experience.

As a normal practice before doing upgrade please backup your system. Download the required patches.

Operating system	Unix Users	Windows users
Patch set	5337014	5337014
Patch	6319846	6344567

1. Before Upgrade , check the invalid count in the database

2. Unzip the patch 5337014 .

3. Invoke the run installer for unix and setup.exe for windows users.

4. As a part of post install step

· Start the database in upgrade mode

· @?/rdbms/admin/catupgrd.sql

· After completed upgrade ,Shutdown the database and startup in normal mode.

· @?/rdbms/admin/utlrp.sql

· Apply the additional patches(6319846 and 6344567)

How to find Release version of Oracle Apps?

Table name called FND_PRODUCT_GROUPS. Login to sqlplus as apps/apps

SQL> select release_name from fnd_product_groups;

RELEASE_NAME
————————————————–
12.0.0

How to start the mobile web application in R12.

Starting the Mobile Web Application (mwa)

Go to $INST_TOP/admin/scripts . Check mwactl its instantiated by Autoconfig.

Windows -mwactl.cmd start
UNIX -mwactl.sh start

In windows ,Once you fired the above command .It will open two or three command prompt with below message.

Message
———
“MWA Telnet server Release: 1.0.8.4 [December 12th 2002]”
E:\oracle\VIS\apps\tech_st\10.1.3\appsutil\jdk\bin\java.exe -Doracle.apps.mwa=E:
\oracle\VIS\inst\apps\VIS_ap703app -Doracle.apps.inst=E:\oracle\VIS\inst\apps\VI
S_ap703app -mx256m -ms128m -cp “E:\oracle\VIS\apps\tech_st\10.1.3\appsutil\jdk\
lib\dt.jar;E:\oracle\VIS\apps\tech_st\10.1.3\appsutil\jdk\lib\tools.jar;E:\oracl
e\VIS\apps\tech_st\10.1.3\appsutil\jdk\jre\lib\rt.jar;E:\oracle\VIS\apps\
apps_st\comn\java\lib\appsborg2.zip;E:\oracle\VIS\apps\apps_st\comn\java
\classes”

oracl
e.apps.mwa.presentation.telnet.Listener 10202
Created server socket : listening on port 10202
Server startup is successful.

Two ways to check what are the ports are available for mobile application:

1. From the above message you can find what are the ports are open for the mobile application .. here 10202 in this port is listening .
2. Login to sysadmin/sysadmin.
   system administrator–>Oracle Applications Manager–>Hosts—->view configuration .

you can find the “MSCA Server Port Number 10200-10205”

To test whether MWA is started . Type
“telnet hostname.domainname 10200”