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

Upgrade the Oracle database from 10.1.0.2.0 to 10.1.0.5.0

This article describes the process of upgrading the Oracle Database Server 10g Release 10.1.0.2 to Oracle Database 10g Release 10.1.0.5 on Windows XP SP2.

1. Patch Set Overview
You can apply the Oracle Database 10g release 10.1.0.5 patch set to the following Oracle Database 10g release 1 (10.1.0.2, 10.1.0.3, or 10.1.0.4) installations.

2. Oracle Universal Installer Version Requirements
This patch set includes Oracle Universal Installer release 10.1.0.5, which is also installed when you install this patch set.

3. System Requirements
Hardware requirement : Intel Pentium
OS requirement : Windows XP Prof
Oracle DB : 10gr1(10.1.0.2) or later

4. Pre-installation Tasks
I. Identify the Oracle Database Installation
This is not a complete software distribution. You must install it in an existing Oracle Database 10g Oracle home.

II. Download and Extract the Installation Software
Download and extract the p4505133_10105_WINNT.zip patch set.

III. Shut Down Oracle Databases
C:\>sqlplus sys@ORCL/pwd as sysdba
SQL>shutdown immediate;
C:\>sqlplus sys@CATDB/pwd as sysdba
SQL>shutdown immediate;

IV. Stop All Services
C:\>net stop OracleOraDb10g_home1iSQL*Plus
..
The OracleOraDb10g_home1iSQL*Plus service was stopped successfully.
C:\>net stop OracleServiceORCL
The following services are dependent on the OracleServiceORCL service.
Stopping the OracleServiceORCL service will also stop these services.
OracleDBConsoleorcl
Do you want to continue this operation? (Y/N) [N]: Y
The OracleDBConsoleorcl service is stopping....
The OracleDBConsoleorcl service was stopped successfully.
The OracleServiceORCL service is stopping.
The OracleServiceORCL service was stopped successfully.
C:\>net stop OracleServiceCATDB
The OracleServiceCATDB service is stopping.......
The OracleServiceCATDB service was stopped successfully.

V. Stop the listener:
C:\>LSNRCTL stop
LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 13-JUN-2007 16:30
:58
Copyright (c) 1991, 2004, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
The command completed successfully
C:\>net stop OracleCSService
The OracleCSService service was stopped successfully.

VI. Back up the SYSTEM.

5.Installation Tasks
I. Run SETUP.EXE from where you download/extract your patch.
In the Name field in the Destination section, select the 10.1.0.x Oracle home that you want to update from the drop down list, then click Next.

On the Summary screen, click Install.

Upgrading Release 10.1 to Oracle Database 10g Release 1 (10.1.0.5)

1.Check SYSTEM TBS should have 10mb Free Space.
2.SHARED_POOL_SIZE or JAVA_POOL_SIZE at least 150 MB.

SQL> alter tablespace SYSTEM
2 add datafile 'c:\oracle\product\10.1.0\oradata\orcl\system02.dbf' size 20m;
Tablespace altered.

SQL> alter system set SHARED_POOL_SIZE = 150M SCOPE=spfile;
System altered.

SQL> alter system set JAVA_POOL_SIZE = 150M SCOPE=spfile;
System altered.

SQL> SHUTDOWN
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> STARTUP UPGRADE
ORACLE instance started.
Total System Global Area 356515840 bytes
Fixed Size 789400 bytes
Variable Size 330036328 bytes
Database Buffers 25165824 bytes
Redo Buffers 524288 bytes
Database mounted.
Database opened.

SQL> SPOOL patch.log

SQL> @C:\oracle\product\10.1.0\db_1\rdbms\admin\catpatch.sql
DOC>######################################################################
DOC>######################################################################
DOC> The following PL/SQL block will cause an ORA-20000 error and
DOC> terminate the current SQLPLUS session if the user is not SYS.
DOC> Disconnect and reconnect with AS SYSDBA.
DOC>######################################################################DOC>######################################################################DOC>#PL/SQL procedure successfully completed
.....
[OUTPUT CUT]

SQL> SPOOL OFF

Restart the database
SQL>SHUTDOWN
SQL>STARTUP

Run the utlrp.sql script to recompile all invalid PL/SQL packages
SQL> @C:\oracle\product\10.1.0\db_1\rdbms\admin\utlrp.sql
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - Prod
PL/SQL Release 10.1.0.5.0 - Production
CORE 10.1.0.5.0 Production
TNS for 32-bit Windows: Version 10.1.0.5.0 - Production
NLSRTL Version 10.1.0.5.0 - Production

Known Issues
select dbms_java.full_ncomp_enabled from dual
*
ERROR at line 1:
ORA-29558: JAccelerator (NCOMP) not installed. Refer to Install Guide for
instructions.
ORA-06512: at "SYS.DBMS_JAVA", line 236

IGNORE
---> If you do not use Java in the database, then ignore this error message.

Don't Ignore
--->If you use Java in the database, then install the NCOMP libraries by selecting the Oracle Database 10g Products installation type from the Oracle Database Companion CD.

If RMAN CATALOG is also configure then upgrade RMAN CATALOG
C:\>rman CATALOG=rman/cat@CATDB
Recovery Manager: Release 10.1.0.5.0 - Production
Copyright (c) 1995, 2004, Oracle. All rights reserved.
connected to recovery catalog database
RMAN> UPGRADE CATALOG;
recovery catalog owner is RMAN
enter UPGRADE CATALOG command again to confirm catalog upgrade
RMAN> UPGRADE CATALOG;
recovery catalog upgraded to version 10.01.00
DBMS_RCVMAN package upgraded to version 10.01.00
DBMS_RCVCAT package upgraded to version 10.01.00