Custom Search . . .

Sunday, November 18, 2007

Upgrade Oracle 10.2.0.2 to 10.2.0.3


1. Patch Set Overview

Patch set release 10.2.0.3. Before installing this patch set you must be need 10.2.0.1 version.

2. Requirements

Oracle DB : Oracle 10.2.0.1 (later)
Operating System: Windows 2000 (Service Pack 2 or higher)

3. Pre - Installation Tasks

1. Identify prior installation

Before installing this patch you must install oracle 10.2.0.1 (or later version)

2. Download Patch set

Download and extract the p5337014_10203_WINNT.zip patch set installation archive to a directory that is not the Oracle home directory or under the Oracle home directory.

3. Shutdown oracle database.

C:\>set oracle_sid=DEVDB

C:\>sqlplus /nolog

SQL*Plus: Release 10.2.0.2.0 - Production on Tue Nov 13 10:49:26 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> connect sys@DEVDB as sysdba
Enter password:
Connected.

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

4. Stop all services

C:\>set oracle_sid=DEVDB

C:\>net stop OracleDBConsoleDEVDB
The OracleDBConsoleDEVDB service is stopping................
The OracleDBConsoleDEVDB service was stopped successfully.


C:\>net stop OracleServiceDEVDB
The OracleServiceDEVDB service is stopping.
The OracleServiceDEVDB service was stopped successfully.


C:\>net stop OracleOraDB10g_Home1iSQL*Plus..
The OracleOraDb10g_home1iSQL*Plus service was stopped successfully.

C:\>net stop OracleOraDB10g_Home1TNSListener
The OracleOraDb10g_home1TNSListener service is stopping.
The OracleOraDb10g_home1TNSListener service was stopped successfully.

Note: while patch installation time If you face Distributed Transaction Coordinator still running. You should be stop this service

C:\>net stop msdtc
The Distributed Transaction Coordinator service is stopping.
The Distributed Transaction Coordinator service was stopped successfully.

4. Backup your database.

Oracle recommends that you create a backup of the Oracle 10g installation before you install the patch set.

5. Check Tablespace Sizes and Set Parameter Values

Review the following sections before upgrading a database.

7. Check SYSTEM Tablespace Size

If JServer is part of the installation ensure that there is at least 50 MB of free space allocated to the SYSTEM tablespace.

6. Set the SHARED_POOL_SIZE and JAVA_POOL_SIZE Initialization Parameters

Users who have JVM (Java enabled) or JVM and XDB installed on their 10.2.0.1 databases should make sure that the init.ora parameters SHARED_POOL_SIZE and JAVA_POOL_SIZE are each 150 MB or more before running the catpatch.sql upgrade script. Failure to do so could result in an unrecoverable memory failure while running of the script. Please note that JVM and XML DB was shipped as part of the default 10.2.0.1 seed database, and will be present unless the user explicitly installed a 10.2.0.1 instance without them.
Set the value of the SHARED_POOL_SIZE and the JAVA_POOL_SIZE initialization parameters as follows:

C:\>set oracle_sid=DEVDB


C:\>sqlplus /nolog
SQL*Plus: Release 10.2.0.2.0 - Production on Tue Nov 13 10:49:26 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> connect sys@DEVDB as sysdba
Enter password:
Connected.

SQL> STARTUP NOMOUNT
ORACLE instance started.
Total System Global Area 437329148 bytes
Fixed Size 453884 bytes
Variable Size 369098752 bytes
Database Buffers 67108864 bytes
Redo Buffers 667648 bytes
Database mounted.

Note:

If the system uses an initialization parameter file, if necessary change the values of the SHARED_POOL_SIZE and the JAVA_POOL_SIZE initialization parameters to at least 150 MB in the initialization parameter file (initsid.ora).

SQL> ALTER SYSTEM SET JAVA_POOL_SIZE=150M SCOPE=SPFILE;

System altered.

SQL> ALTER SYSTEM SET SHARED_POOL_SIZE=150M SCOPE=SPFILE;
System altered.

SQL> STARTUP FORCE
ORACLE instance started.
Total System Global Area 437329148 bytes
Fixed Size 453884 bytes
Variable Size 369098752 bytes
Database Buffers 67108864 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.

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

8. Upgrade the Database

Install patch set, you must perform the following steps on every database associated with the upgraded Oracle home:

1. Start all services

2. Connect sys user

C:\> sqlplus /NOLOG

SQL> CONNECT SYS/SYS_password AS SYSDBA

3. Enter the following SQL*Plus commands:

SQL> STARTUP UPGRADE

SQL> SPOOL patch.log

SQL> @ORACLE_BASE\ORACLE_HOME\rdbms\admin\catupgrd.sql

SQL> SPOOL OFF

Review the patch.log file for errors and inspect the list of components that is displayed at the end of catupgrd.sql script.

This list provides the version and status of each SERVER component in the database.

If necessary, rerun the catupgrd.sql script after correcting any problems.

4. Restart the database:

SQL> SHUTDOWN
SQL> STARTUP

5. Compile Invalid Objects

Run the utlrp.sql script to recompile all invalid PL/SQL packages now instead of when the packages are accessed for the first time. This step is optional but recommended.

SQL> @ORACLE_BASE\ORACLE_HOME\rdbms\admin\utlrp.sql

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Release 10.2.0.3.0 - Production
PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for 32-bit Windows: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production

Please post your comments..

14 comments:

DreamzZ said...

Nice Work!!!!

Anonymous said...

I see there is a recommendation on teh Oracle site to apply an additonal patch after this upgrade...If your operating system is Microsoft Windows, then download and apply patch 6038241... However that is not mention above. Any thoughts??

Babu B said...

Hi,

Thanks for your comments. Actually once you install patch set 10.2.0.3. You need to install 16 patches (CPU) in your database.

Not only patch 7 (6038241).

Babu B

kaunain said...

but u forgot to write the step of starting OUI and installing the patchset in the 10.2.0.1 oracle home???

Babu B said...

Hello,

You want help from my end to install 10.2.0.1 to 10.2.0.2 or 10.2.0.3 patchset installation?

Babu

satya said...

Hi,

In this whole document no where is mentioned when we have to run the patchset..
Can you please suggest in, at what step number i need to run the patch??

Babu B said...

Hi,

Thanks for your comments.

>>Install patch set, you must perform the following steps on every database associated with the upgraded Oracle home:
<<

Thank you in advance.

Babu

Anonymous said...

better not to have any knowledge than giving having half knowledge.
if possible try to post complete cycle of upgrade.

Babu B said...

Hello,

What's your problem ??

Where did you find incomplete steps??

Babu

Anonymous said...

Hi, Babu B
I need to upgrade 10.2.02 to 10.2.03 patchset 17. I can not find on Metalink website the correspondence between short patch name (17) and long one(e.g.6038241). Win x64. Can you advise where i can get it plz?
Roman

Anonymous said...

Hi, Babu B
I need to upgrade 10.2.02 to 10.2.03 patchset 17. I can not find on Metalink website the correspondence between short patch name (17) and long one(e.g.6038241). Win x64. Can you advise where i can get it plz?
Roman

Babu B said...

Hello,

Try this patch number "5337014"

Thanks

Babu

Anonymous said...

Please can any one provide me the link to download oracle 10.2.0.3 patch as well as links to download rest all patches with 10.2.0.3

Babu said...

check here

metalink.oracle.com