Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle 11g upgrade PSU detailed steps     - Linux compression and decompression command (Linux)

- Mount NFS network file system (Linux)

- Ubuntu Eclipse configuration Gtk + 2.0 libraries (Linux)

- Oracle physical storage structure outline (Database)

- MySQLbinlog combat on using data recovery (Database)

- Linux system package manager (rpm, yum, source packages installation) (Linux)

- Subquery Oracle study notes (Database)

- C ++ casts New Standard Comments (Programming)

- A custom implementation of the Android sidebar (Programming)

- Analysis examples: Intrusion Response Linux platform Case (Linux)

- HBase cluster installation and deployment (Server)

- To create someone else can not afford to delete the administrator user (Linux)

- Mhddfs: multiple smaller partitions into one large virtual storage (Linux)

- MySQL bulk insert data script (Database)

- Linux Learning --- disk partition / relational representation + mount (Linux)

- CentOS card fails to start at boot progress bar certmonger solve (Linux)

- To setup a ftp server under Linux (Server)

- MySQL service failed to start thinking of settlement under CentOS7 (Database)

- Thinking in Java study notes - initialization and cleanup (Programming)

- Java implementation chain store binary tree (Programming)

 
         
  Oracle 11g upgrade PSU detailed steps
     
  Add Date : 2017-08-31      
         
       
         
  Oracle releases the latest patches every quarter. For the production operation and maintenance personnel, regularly upgrade the system, patching is an integral part of daily work.

 Compared with the previous version, Oracle patch approach has become relatively simple, the method of dealing with PSU has also undergone some changes. In 11g, for some small bug fixes, we can use the OPatch tool for patch repair. For a large version of the upgrade, Oracle's PSU is actually a series of new installation files, downloaded from the MOS can be installed directly after.

1, close the database

Oracle's PSU upgrade does not update the data dictionary, the risk is small, but still need to stop the library for the upgrade operation.

SQL> shutdown immediate

Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Stop the listening service.
[Oracle @ bntjftest 20299015] $ lsnrctl stop
Check the service process
[Oracle @ bntjftest 20299015] $ ps aux | grep ora_
Oracle 6922 0.0 0.0 5700 796 pts / 3 S + 17:48 0:00 grep ora_
[Oracle @ bntjftest 20299015] $ ps aux | grep tns
Oracle 6924 0.0 0.0 5704 796 pts / 3 S + 17:48 0:00 grep tns

2, check opatch version information, if necessary, to upgrade

[Oracle @ bntjftest OPatch] $ ./opatch version
OPatch Version: 11.2.0.1.7
OPatch succeeded.

Check the opatch version is low, the default version, so need to upgrade opatch. Upgrade method is very simple, direct mv swap the original opatch directory, and then extract the latest version of the opatch software to ORACLE_HOME below

[Oracle @ bntjftest OPatch] $ unzip p6880880_112000_Linux-x86-64-opatch .zip -d $ ORACLE_HOME

Check the version again and found that the upgrade has been successful.
[Oracle @ bntjftest OPatch] $ ./opatch version
OPatch Version: 11.2.0.3.6
OPatch succeeded.

3, the application PSU patch

1) episode one, the installation program error

[Oracle @ bntjftest OPatch] $ ./opatch apply ./20299015/
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation. All rights reserved.

Oracle Home: /app/oracle/product/11.2.0/dbhome_1
Central Inventory: / app / oraInventory
  From: /app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version: 11.2.0.3.6
OUI version: 11.2.0.4.0
Log file location: /app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2015-05-14_10-45-03AM_1.log


Verifying environment and performing prerequisite checks ...
Prerequisite check "CheckPatchApplicableOnCurrentPlatform" failed.
The details are:
Patch (20299015) is not applicable> UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.
Log file location: /app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2015-05-14_10-45-03AM_1.log
OPatch failed with error code 73


Do not use the automatic mode, manual operation, the same error:

[Oracle @ bntjftest 20299015] $ /app/oracle/product/11.2.0/dbhome_1/OPatch/opatch napply -skip_subset -skip_duplicate
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation. All rights reserved.

Oracle Home: /app/oracle/product/11.2.0/dbhome_1
Central Inventory: / app / oraInventory
  From: /app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version: 11.2.0.3.6
OUI version: 11.2.0.4.0
Log file location: /app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2015-05-14_10-45-03AM_1.log


Verifying environment and performing prerequisite checks ...
Prerequisite check "CheckPatchApplicableOnCurrentPlatform" failed.
The details are:
Patch (20299015) is not applicable> UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.
Log file location: /app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2015-05-14_10-45-03AM_1.log
OPatch failed with error code 73

Internet baidu, "UtilSession failed: Prerequisite check" CheckActiveFilesAndExecutables "failed", quickly found a solution that is in fact because of a user process occupied by the file libclntsh.so.11

[Oracle @ bntjftest 20299015] $ / sbin / fuser /app/oracle/product/11.2.0/dbhome_1/lib/libclntsh.so.11 .1
/app/oracle/product/11.2.0/dbhome_1/lib/libclntsh.so.11.1:16470m
[Oracle @ bntjftest 20299015] $ ps -ef | grep 16470
Oracle 16470 5399 0 14:45 pts / 2 00:00:00 sqlplus as sysdba
Oracle 7780 6617 0 18:47 pts / 3 00:00:00 grep 16470
[Oracle @ bntjftest 20299015] $ kill -9 16470
[Oracle @ bntjftest 20299015] $ / sbin / fuser /app/oracle/product/11.2.0/dbhome_1/lib/libclntsh.so.11.1


3) re-apply PSU patch again, success


[Oracle @ bntjftest 20299015] $ /app/oracle/product/11.2.0/dbhome_1/OPatch/opatch napply -skip_subset -skip_duplicate
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation. All rights reserved.

Oracle Home: /app/oracle/product/11.2.0/dbhome_1
Central Inventory: / app / oraInventory
  From: /app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version: 11.2.0.3.6
OUI version: 11.2.0.4.0
Log file location: /app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2015-05-14_10-45-03AM_1.log


Verifying environment and performing prerequisite checks ...
OPatch continues with these patches: [17811429 17811438 17811447 18203835 18203838 19463893 19544839 19584068 19972564 19972566 19972568 19972569 20142975 20299015 20506699 20506715 20631274]


Do you want to proceed? [Y | n]
Y
User Responded with: Y
All checks passed.
Provide your email address to be informed of security issues, install and
Initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address / User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address / User Name:


You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y] es, [N] o) [N]: y

OPatch Session completed with warnings.
 Log file location: /app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2015-05-14_10-45-03AM_1.log

OPatch completed with warnings.

4, check the results after the application

[Oracle @ bntjftest 20299015] $ ../opatch lspatches
 20631274;
 20506715;
 20506699;
 20299015;
 20142975;
 19972569;
 19972568;
 19972566;
 19972564;
 19584068;
 19544839;
 19463893;
 18203838;
 18203837;
 18203835; & lt;
 17811447;
 17811438;
 17811429;

[Oracle @ bntjftest 20299015] $ ../opatch lsinventory
 Oracle Interim Patch Installer version 11.2.0.3.6
 Copyright (c) 2013, Oracle Corporation. All rights reserved.


 Oracle Home: /app/oracle/product/11.2.0/dbhome_1
 Central Inventory: / app / oraInventory
    From: /app/oracle/product/11.2.0/dbhome_1/oraInst.loc
 OPatch version: 11.2.0.3.6
 OUI version: 11.2.0.4.0
 Log file location: /app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2015-05-14_11-04-15AM_1.log

Lsinventory Output file location: /app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2015-05-14_11-04-15AM.txt

-------------------------------------------------- ------------------------------
 Installed Top-level Products (1):

Oracle Database 11g 11.2.0.4.0
 There are 1 product (s) installed in this Oracle Home.


 Interim patches (18):

Patch 20631274: applied on Wed May 13 17:11:06 CST 2015
 Unique Patch ID: 18695736
    Created on 13 Mar 2015, 10:25:35 hrs PST8PDT
    Bugs fixed:
      20296213, 17600719, 19458377, 19554106, 20631274, 16524926, 19466309

Patch 20506715: applied on Wed May 13 17:11:02 CST 2015
 Unique Patch ID: 18695736
    Created on 13 Mar 2015, 10:23:10 hrs PST8PDT
    Bugs fixed:
      19049453, 19915271, 16450169, 17006570, 17811456, 18554871, 17786278
      18096714, 18744139, 20506715, 18061914

Patch 20506699: applied on Wed May 13 17:10:57 CST 2015
 Unique Patch ID: 18695736
    Created on 13 Mar 2015, 11:23:48 hrs PST8PDT
    Bugs fixed:
      20506699, 19358317, 19197175, 19972570, 17762296

Patch 20299015: applied on Wed May 13 17:10:54 CST 2015
 Unique Patch ID: 18695736
    Created on 13 Mar 2015, 10:28:05 hrs PST8PDT
    Bugs fixed:
      20299015, 18139690, 18681862, 17343514, 19727057, 19271443, 19854503, 17551709

Patch 20142975: applied on Wed May 13 17:10:53 CST 2015
 Unique Patch ID: 18406185
    Created on 22 Dec 2014, 00:47:05 hrs PST8PDT
    Bugs fixed:
      19827973, 19463897, 19289642, 20142975

Patch 19972569: applied on Wed May 13 17:10:51 CST 2015
 Unique Patch ID: 18406185
    Created on 22 Dec 2014, 00:21:09 hrs PST8PDT
    Bugs fixed:
      19972569, 19006849

Patch 19972568: applied on Wed May 13 17:10:50 CST 2015
 Unique Patch ID: 18406185
    Created on 22 Dec 2014, 00:13:36 hrs PST8PDT
    Bugs fixed:
      19972568, 19309466

Patch 19972566: applied on Wed May 13 17:10:48 CST 2015
 Unique Patch ID: 18406185
    Created on 22 Dec 2014, 00:03:20 hrs PST8PDT
    Bugs fixed:
      19972566, 18641461, 18641451

Patch 19972564: applied on Wed May 13 17:10:45 CST 2015
 Unique Patch ID: 18406185
    Created on 21 Dec 2014, 23:54:58 hrs PST8PDT
    Bugs fixed:
      19972564, 18436647

Patch 19584068: applied on Wed May 13 17:10:43 CST 2015
 Unique Patch ID: 18084194
    Created on 24 Sep 2014, 07:43:52 hrs PST8PDT
    Bugs fixed:
      18262334, 19584068

Patch 19544839: applied on Wed May 13 17:10:40 CST 2015
 Unique Patch ID: 18084194
    Created on 11 Oct 2014, 01:43:34 hrs PST8PDT
    Bugs fixed:
      18673325, 19544839, 19211724, 18673304

Patch 19463893: applied on Wed May 13 17:10:26 CST 2015
 Unique Patch ID: 18084194
    Created on 24 Sep 2014, 06:28:06 hrs PST8PDT
    Bugs fixed:
      19463893, 18641419

Patch 18203838: applied on Wed May 13 17:10:24 CST 2015
 Unique Patch ID: 17351342
    Created on 26 Feb 2014, 23:57:58 hrs PST8PDT
    Bugs fixed:
      17865671, 18203838

Patch 18203837: applied on Wed May 13 17:10:21 CST 2015
 Unique Patch ID: 17351342
    Created on 26 Feb 2014, 23:48:38 hrs PST8PDT
    Bugs fixed:
      17716305, 18203837

Patch 18203835: applied on Wed May 13 17:10:19 CST 2015
 Unique Patch ID: 17351342
    Created on 26 Feb 2014, 23:43:04 hrs PST8PDT
    Bugs fixed:
      17721717, 18203835

Patch 17811447: applied on Wed May 13 17:10:17 CST 2015
 Unique Patch ID: 17066906
    Created on 11 Dec 2013, 02:20:51 hrs PST8PDT
    Bugs fixed:
      17811447, 17088068

Patch 17811438: applied on Wed May 13 17:10:15 CST 2015
 Unique Patch ID: 17066906
    Created on 11 Dec 2013, 02:37:11 hrs PST8PDT
    Bugs fixed:
      17811438, 16721594

Patch 17811429: applied on Wed May 13 17:10:13 CST 2015
 Unique Patch ID: 17066906
    Created on 11 Dec 2013, 02:36:54 hrs PST8PDT
    Bugs fixed:
      17811429, 13944971


-------------------------------------------------- ------------------------------

OPatch succeeded.


SQL> select * from dba_registry_history;


ACTION_TIME ACTION NAMESPAC VERSION ID BUNDL COMMENTS
 ------------------------------ -------- -------- ---- ---------------- ----- --------------------
 05-MAY-15 09.24.08.184589 AM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0
 13-MAY-15 05.17.48.578053 PM APPLY SERVER 11.2.0.4 6 CPU CPUApr2015


2 rows selected.
     
         
       
         
  More:      
 
- Hibernate Performance Optimization of EHCache cache (Programming)
- Linux crontab use (Linux)
- Linux environment to build next Cocos2dx-3.3.1 (Linux)
- xCAT error Unable to dispatch hierarchical sub-command to NORESOLUTION: 3001 (Linux)
- Server Security Analysis attack on Linux (Linux)
- Android Get App version number and version name (Programming)
- Linux SVN account password to save your settings (Linux)
- Composition and dynamic memory allocation C program (Programming)
- dmidecode command Detailed (Hardware information) (Linux)
- Use py2exe to generate exe files Python script (Programming)
- Can not empty the Recycle Bin to repair problems in Ubuntu 14.04 (Linux)
- Android custom title bar (Programming)
- Ubuntu15 core CLR (Server)
- Five strokes to find out the IP address you want to know (Linux)
- CentOS7 set boot directly into the command line interface (Linux)
- Oracle database with test data insertion speed (Database)
- Linux environment has been running Tomcat how to deploy the new Tomcat (Server)
- Linux Network Programming - raw socket instance: MAC header message analysis (Programming)
- C ++ virtual functions Classic Insights (Programming)
- Ubuntu update bug fixes Daquan (Linux)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.