Upgrading OracleAS 10g Portal from 10.1.2.0.2 to 10.1.4.2 on Windows

Introduction
Upgrading Portal can be a puzzle and a challenge, and it's not always fun.

This guide assumes that:
you have a fresh installation of Oracle Application Server 10g Release 2 (10.1.2.0.2)

Important:
Throughout these instructions, you need to replace example paths (e.g. "D:\ora101202mt") with your paths, example instance names (e.g. "ora101202mt") with your instance names, and example server names (e.g. "donald.disney.com") with your server names, unless you actually use similar values as the ones showed here (which makes things much easierWhy?). To be on the safe side, avoid using spaces or periods in your permanent and temporary paths!

You should always read the documentation and notes that come with all the products and patches so that you may be prepared for some of the expected and unexpected situations!

Before you begin
1. If you have not rebooted since you started installing Application Server, then reboot now.

2. Ensure that the database, TNS and Infrastructure processes are running:
net start OracleServiceORCL
net start Oracleora102dbTNSListener
cd /d D:\ora101202infra\opmn\binopmnctl startall

3. Ensure that all Middle-Tier processes are stopped:
cd /d D:\ora101202mt\opmn\bin
opmnctl stopall

Download software
Portal Upgrade (10.1.4) - 176 MB
Patch 5983622 (OracleAS 10.1.2.3) - 1.7 GB

Upgrading Portal to 10.1.4
1. If your metadata repository database is version 10.2.0.2 or higher, you need to edit C:\stage\mrua_051020\mrua\mrua.xml, adding the following entry (using version 10.2.0.2 as an example):
<Version ReleaseNumber="10.2.0.2"
DisplayName="OracleAS supported database">
</Version>
For more information, see Note 361176.1 on MetaLink.

2. Run the upgrade script (check the parameter values by inspecting the ias.properties file in the D:\ora101202infra\config folder):
cd /d C:\stage\mrua_051020\mrua
mrua.bat -oracle_home D:\ora101202infra -oid_host donald.disney.com -oid_ssl_port 636

3. When prompted, enter the password for the database SYS user account, e.g. welcome1

4. When prompted, enter the Oracle Internet Directory administrator password, e.g. welcome1

5. When the script finishes (after approximately 30 minutes), check the upgrade.log file in the D:\ora101202infra\upgrade\temp\portal folder

6. Review the Post-Upgrade Tasks in the online documentation.

7. If you would like to configure Oracle Text Indexes to Synchronize on Commit:
cd /d D:\ora101202mt\portal\admin\plsql\wws

sqlplusw portal@orclexec

wwv_context.commit_sync('WWSBR_CORNER_CTX_INDX', true);exec wwv_context.commit_sync('WWSBR_DOC_CTX_INDX', true);exec wwv_context.commit_sync('WWSBR_PERSP_CTX_INDX', true);exec wwv_context.commit_sync('WWSBR_THING_CTX_INDX', true);exec wwv_context.commit_sync('WWSBR_TOPIC_CTX_INDX', true);exec wwv_context.commit_sync('WWSBR_URL_CTX_INDX', true);

@textstat.sql

8. If you need to add text elements, please see "Configuring OracleAS 10g (10.1.2.0.2)".

Upgrading OracleAS to 10.1.2.3
1. Download Patch 5983622 (1.7 GB)
2. Unzip patch to C:\stage\ias\p5983622

Middle-Tier
1. Start Installer, e.g. C:\stage\ias\p5983622\Disk1\setup.exe
2. Click Next
3. As Destination, select ora101202mt (folder D:\ora101202mt)
4. Click Next
5. Select Oracle Application Server and Developer Suite 10g Rel 2 Software Update 10.1.2.3.0 (already selected)
6. Click Next
7. Enter ias_admin password
8. Click Next
9. Enter password for cn=orcladmin
10. Click Next
11. Click OK to accept that processes will be shut down
12. If Windows Security Alert pops up, click Unblock
13. Click Install
14. When update is finished, click Exit and then Yes

Infrastructure
1. Stop Middle-Tier processes and all other clients
2. Start Installer, e.g. C:\stage\ias\p5983622\Disk1\setup.exe
3. Click Next
4. As Destination, select ora101202infra (folder D:\ora101202infra)
5. Click Next
6. Select Oracle Application Server and Developer Suite 10g Rel 2 Software Update 10.1.2.3.0 (already selected)
7. Click Next
8. Enter ias_admin password
9. Click Next
10. Enter password for cn=orcladmin
11. Click Next
12. Enter password for Oracle Certificate Authority Administrator
13. Click Next
14. Enter password for the SYS schema in the Metadata Repository database
15. Click Next
16. Click OK to accept that processes will be shut down
17. If Windows Security Alert pops up, click Unblock
18. Click Install
19. When update is finished, click Exit and then Yes

Upgrading Portal Metadata Repository to 10.1.4.2
1. Verify that component PORTAL is found in app_registry:
connect sys@orcl as sysdba
select version, status from app_registry where comp_id = 'PORTAL';
2. Stop Middle-Tier processes and clients, but leave Infrastructure and Database processes running
3. Start Installer, e.g. C:\stage\ias\p5983622\Disk1\setup.exe
4. Click Next
5. As Destination, select ora101202mt (folder D:\ora101202mt)
6. Click Next
7. Select Oracle Application Server 10g Portal Metadata Repository Update
8. Click Next
9. Click OK to verify that the database version is correct and that the software update has been performed on the Middle-Tier and the Infrastructure
10. Select Immediately install the update (already selected)
11. Click Next
12. Enter ias_admin password
13. Click Next
14. Enter password for cn=orcladmin
15. Click Next
16. Click Next to accept the Database Connection String (e.g. donald.disney.com:1521:orcl.disney.com:ORCL.DISNEY.COM)
17. Click Next
18. Enter password for the SYS schema in the Metadata Repository database
19. Click Next
20. Select OracleAS 10g Portal (schema PORTAL) and OracleAS 10g Wireless (schema WIRELESS)
21. Click Next
22. Click OK to verify that processes have been stopped
23. Click Install
24. When update is finished, click Exit and then Yes

More Information
Staging a Test Environment from a Production Environment
Oracle Application Server Portal Installation and Upgrade Guide
OracleAS Portal Upgrade
Readme for Patch 4960210
Note 260554.1: Master Note for OracleAS Portal Install Issues
Note 262623.1: Master Note for OracleAS Portal Upgrade Issues
Note 281400.1: Troubleshooting Portal Errors when applying MR Updates from Oracle AS Patchsets 9.0.4.x / 10.1.2.x
Note 361176.1: Database Version 10.2.0.2.0 or 10.2.0.3.0 Is Not Supported When Upgrading Portal to 10.1.4
Note 276620.1: How to "clone" a Portal Repository
Note 249212.1: Support Position for Oracle Products Running on VMWare Virtualized Environments