Shulou(Shulou.com)06/01 Report--

I. current environment

Platform

Version

Pattern

Linux 32bit

Oracle 10.2.0.3

Single instance

2. Objective to repair CPU bug

Namely Patch 7369190:

Download the patch and log on to metalink website

Find the corresponding patch

Install the patch and upload the downloaded patch p7369190_10203_LINUX.zip to the database server

Follow the instructions included in the patch to upgrade

4.1 check patch oracle@linux-o154:~ > / opt/oracle/product/10.2.0/db_1/OPatch/opatch lsinventory

Invoking OPatch 10.2.0.3.0

Oracle interim Patch Installer version 10.2.0.3.0

Copyright (c) 2005, Oracle Corporation. All rights reserved..

Oracle Home: / opt/oracle/product/10.2.0/db_1

Central Inventory: / opt/oracle/oraInventory

From: / etc/oraInst.loc

OPatch version: 10.2.0.3.0

OUI version: 10.2.0.3.0

OUI location: / opt/oracle/product/10.2.0/db_1/oui

Log file location: / opt/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch3011-04-20 21-21-24PM.log

Lsinventory Output file location: / opt/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2011-04-20 21-21-24PM.txt

Installed Top-level Products (2):

Oracle Database 10g 10.2.0.1.0

Oracle Database 10g Release 2 Patch Set 2 10.2.0.3.0

There are 2 products installed in this Oracle Home.

Interim patches (2):

Patch 5556081: applied on Sat Oct 30 10:48:31 EDT 2010

Created on 9 Nov 2006, 22:20:50 hrs PST8PDT

Bugs fixed:

5556081

Patch 5557962: applied on Sat Oct 30 10:48:22 EDT 2010

Created on 9 Nov 2006, 23:23:06 hrs PST8PDT

Bugs fixed:

4269423, 5557962, 5528974

4.2 install patches? Extract the patch

$unzip p7369190_10203_LINUX.zip

? Close the database instance

SQL > shutdown immediate

? Install the patch

Follow the patch's own instructions.

$cd 7369190

$opatch napply-skip_subset-skip_duplicate

Note: Oracle 10.2.0.3 opath does not have the napply parameter. You need to download the p6741493_10203_GENERIC.zip patch, decompress the p6741493 patch, use the p6741493 patch to decompress the opatch command of the path, and execute the following command to install patch 7369190:

Oracle@linux-o154:~/7369190/7369190 > / opt/oracle/OPatch/opatch napply-skip_subset-skip_duplicate

? Execute sql

Execute sql as described in the documentation

Sqlplus / nolog

SQL > CONNECT / AS SYSDBA

SQL > STARTUP

SQL > @ / opt/oracle/7369190/7369190/files/cpu/CPUOct2008/catcpu.sql

If catcpu.sql reports any Invalid Objects, run the following commands:

SQL > @ $ORACLE_HOME/rdbms/admin/utlrp.sql

SQL > SELECT OBJECT_NAME FROM DBA_OBJECTS WHERE STATUS= 'INVALID'

No rows selected

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.