Oracle on Linux Enterprise version 5 run 24.8-day multiple to suspend (patch installation) ___ Applet

Note: oracle10g Bug 4612267 Patch is heard to be provided only to special users O (∩_∩) o haha ~

So it's recommended to upgrade to 10.2.0.4.

oracle10g Bug 4612267 Patch installation Memo 2009-01-13 14:04

a bug symptom and description Symptoms: When the host runs for 198 days or 248 days, the CPU occupancy rate suddenly reaches 100%. At this point the operating system commands can be executed, but Oracle commands like Lsnrctl, Sqlplus, DBCA, etc. will be hang live and cannot be executed. Oracle's official description of the bug: #------------------------------------------------------------------------- # interim Patch for Base bugs:4612267 #------------------------------------------------------------------------- # # date:wed OCT 5 10:17:13 2005 # ------------------------------- # Platform Patch For:linux x86 # Product Version #: 10.2.0.1 # Product Patched:oracore # # Bugs Fixed by this patch: # ------------------------- # 4612267:oci CLIENT is in a INFINITE LOOP when MACHINE UPTIME HITS 248 days #------------------------------------------------------------------------- Note: In fact, as long as the Linux x86 host is running a multiple of 24.8, it is possible to raise the bug because the time () function value is null, causing an infinite dead loop, thus exhausting the CPU. Solution Three kinds: 1 reboot the host; 2) dozen patch set, such as upgrade to 10.2.0.4; 3 The bug alone to play temporary patch 4612267. The first method does not completely solve the problem, in the future as usual; the second method, the upgrade time is long, and request to stop the library for a long time, the current production environment is not suitable; This paper adopts the third method. Reference Documentation: Doc id:338461.1 sql*plus 10.2.0.1 hangs when the System Uptime is Long Period of Doc id:4612267.8 Bug 4612267-oci client spins when machine uptime >= Second, first stop listening, dbconsole and database Copy $oracle_base/orainventory/orainst.loc to $oracle_home directory first $ lsnrctl Stop $ emctl Stop Dbconsole $ sqlplus/as SYSDBA sql> shutdown Immediate Note: The dbconsole is stopped when Oracle EM is already installed, without interference if it is not. iii. installation of patch $ mkdir $ORACLE _base/patches $ cd $ORACLE _base/patches $ RZ (securecrt upload p4612267_10201_linux.zip file, other upload mode can also) $ unzip P4612267_10201_linux.zip $ CD 4612267/ $ $ORACLE _home/opatch/opatch Apply Invoking Opatch 10.2.0.1.0 ... Please shutdown Oracle instances running out of this oracle_home in the local system. (Oracle home = '/u01/app/oracle/product/10.2.0/db_1 ') is the local system ready for patching? Do your want to proceed? [Y|n] Y (enter Y here) User responded With:y ... Applysession adding interim patch ' 4612267 ' to inventory The local system has been patched and can restarted. Opatch succeeded. iv. verification of Patch $ $ORACLE _home/opatch/opatch lsinventory Invoking Opatch 10.2.0.1.0 Oracle Interim Patch Installer version 10.2.0.1.0 Copyright (c), Oracle Corporation. All rights reserved. Oracle Home:/u01/app/oracle/product/10.2.0/db_1 Inventory:/u01/app/oracle/orainventory From:/u01/app/oracle/product/10.2.0/db_1/orainst.loc Opatch version:10.2.0.1.0 OUI version:10.2.0.1.0 OUI Location:/u01/app/oracle/product/10.2.0/db_1/oui Log File Location:/u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch-2009_jan_13_11-06-27-hkt_tue.log Lsinventory Output file Location:/u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory-2009_ Jan_13_11-06-27-hkt_tue.txt -------------------------------------------------------------------------------- Installed top-level products (2): Oracle Database 10g 10.2.0.1.0 Oracle Database 10g Products 10.2.0.1.0 There are 2 products installed at this Oracle home. Interim patches (1): Patch 4612267:applied on Tue 11:05:10 HKT 2009 Created on 5 Oct, 13:48:00 hrs us/pacific Bugs fixed: 4612267 -------------------------------------------------------------------------------- Opatch succeeded. v. Start the database, monitor and Dbconsole $ sqlplus/as SYSDBA Sql> Startup $ lsnrctl Start $ emctl Start Dbconsole VI, if necessary, you can also delete patch, the first stop before deleting the library $ cd $ORACLE _base/patches/4612267 $ $ORACLE _home/opatch/opatch Rollback-id 4612267 Invoking Opatch 10.2.0.1.0 ... Please shutdown Oracle instances running out of this oracle_home in the local system. (Oracle home = '/u01/app/oracle/product/10.2.0/db_1 ') is the local system ready for patching? Do your want to proceed? [Y|n] Y (enter Y here) User responded With:y ... Rollbacksession removing interim patch ' 4612267 ' from inventory The local system has been patched and can restarted. Opatch succeeded. The previous validation patch command will then find that the patch has been deleted. --end--