Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle 11g RAC manually playing GI PSU patch (11.2.0.4.8)     - Install minimize RHEL / CentOS 7 things to do (Linux)

- CentOS 6.x and CentOS7 install MPlayer (Linux)

- Linux and Unix systems really do network more secure (Linux)

- Linux foreground to background process switch (Linux)

- Atlassian Linux Shell Scripting the confluence remote backup methods (Linux)

- Java, hashcode, equals and == (Programming)

- Java data structures - the linear form of the single-chain applications (Programming)

- Nginx + uWSGI + Django + Python Application Architecture Deployment (Server)

- Tmux Getting Start (Linux)

- The difference between free command displays the buffers and cache (Linux)

- CentOS 7 source code to compile and install PHP5.6 Nginx1.7.9 and MySQL (LNMP build environment) (Server)

- Linux / BSD firewall M0n0wall Profile (Linux)

- Source MongoDB 3.2.1 installed on CentOS6.5 (Database)

- Between the two to achieve the main MySQL database synchronization from (Database)

- S5PV210 development board for embedded development environment to build under Ubuntu (Linux)

- Oracle PL / SQL based cursor (Database)

- About Git (Linux)

- Heartbeat (v1, v2, pacemaker) cluster components Overview (Server)

- MySQL partition summary (Database)

- Ubuntu How to install Pacman (Linux)

 
         
  Oracle 11g RAC manually playing GI PSU patch (11.2.0.4.8)
     
  Add Date : 2018-11-21      
         
       
         
  First, the preparatory work

1, the database environment

Operating system version: RedHat 6.5 x64
Database version: Oracle 11.2.0.4 x64 RAC
Grid: 11.2.0.4
Oracle database: 11.2.0.4

2, ready to content

GI PSU: p21523375_112040_Linux-x86-64.zip
OPatch: p6880880_112000_Linux-x86-64.zip
DB PSU: p21352635_112040_Linux-x86-64.zip only a single instance.

OPatch Download:
https://updates.oracle.com/download/6880880.html

Description: GI PSU include DB PSU, CPU.

Second, update OPatch version must be updated

Description: OPatch version were updated two nodes.

1. Update OPatch version needs to be updated to 11.2.0.3.11, OPatch direct compression replace it.

(1) Upload p6880880_112000_Linux-x86-64.zip to / u01 / software directory, / u01 / software to 777 can also be used the / tmp directory.
(2) root user directory under the original OPatch renamed.

mv /u01/app/11.2.0/grid/OPatch /u01/app/11.2.0/grid/OPatchbk
mv /u01/app/oracle/product/11.2.0/db_1/OPatch /u01/app/oracle/product/11.2.0/db_1/OPatchBK

2. grid replacement OPatch directory

(1) root user
cd / u01 / software /; chown grid: oinstall p6880880_112000_Linux-x86-64.zip

(2) grid users

su - grid
cd / u01 / software /
unzip p6880880_112000_Linux-x86-64.zip

(3) root user

cd / u01 / software /
mv OPatch /u01/app/11.2.0/grid/

(4) grid user testing

su - grid
/u01/app/11.2.0/grid/OPatch/opatch version

OPatch Version: 11.2.0.3.11
OPatch succeeded.

3. oracle directory OPatch replacement

(1) root user

cd / u01 / software /; chown oracle: oinstall p6880880_112000_Linux-x86-64.zip

(2) oracle user

su - oracle
cd / u01 / software /
unzip p6880880_112000_Linux-x86-64.zip

(3) root user

cd / u01 / software /
mv OPatch /u01/app/oracle/product/11.2.0/db_1/

(4) oracle user testing

su - oracle

/u01/app/oracle/product/11.2.0/db_1/OPatch/opatch version

OPatch Version: 11.2.0.3.11
OPatch succeeded.

 

Third, start the upgrade package GI PSU

1. premise

(1) to play the next grid root user needs to close grid (two nodes perform)

cd /u01/app/11.2.0/grid/bin
./crsctl stop has

Resolve GI PSU patch 2. grid user under

(1) root user operation

cd / u01 / software /; chown grid: oinstall p21523375_112040_Linux-x86-64.zip

(2) grid user operation

su - grid
cd / u01 / software /; unzip p21523375_112040_Linux-x86-64.zip

3. grid user under test compatibility for playing multiple CPU environment.

$ ORACLE_HOME / OPatch / opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir / u01 / software / 21523375/21352649 -oh $ ORACLE_HOME
$ ORACLE_HOME / OPatch / opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir / u01 / software / 21523375/21352642 -oh $ ORACLE_HOME
$ ORACLE_HOME / OPatch / opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir / u01 / software / 21523375/21352635 -oh $ ORACLE_HOME

-------------------------------------------------- -
Example of the following:
Oracle Interim Patch Installer version 11.2.0.3.11
Copyright (c) 2015, Oracle Corporation. All rights reserved.

PREREQ session

Oracle Home: /u01/app/11.2.0/grid
Central Inventory: / u01 / app / oraInventory
  from: /u01/app/11.2.0/grid/oraInst.loc
OPatch version: 11.2.0.3.11
OUI version: 11.2.0.4.0
Log file location: /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2015-12-18_16-21-46PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

Fourth, start the upgrade GRID

1. successively Node 1, Node 2 Master Executive.

Step 1: Execute the script must be executed, or can not succeed, ensure CRS is turned off.

Alternatively, you can view the patch README file.

[Root @ db1 bin] # /u01/app/11.2.0/grid/crs/install/rootcrs.pl -unlock

Using configuration parameter file: / grid / grid_home / crs / install / crsconfig_params
CRS-4544: Unable to connect to OHAS
CRS-4000: Command Stop failed, or completed with errors.
Successfully unlock / grid / grid_home

[Root @ db1 bin] #

Step 2: Download the patch (currently 11.2.0.4.8 PSU), prepare for upgrade

su - grid

/u01/app/11.2.0/grid/OPatch/opatch napply -oh $ ORACLE_HOME -local / u01 / software / 21523375/21352649
/u01/app/11.2.0/grid/OPatch/opatch napply -oh $ ORACLE_HOME -local / u01 / software / 21523375/21352642
/u01/app/11.2.0/grid/OPatch/opatch napply -oh $ ORACLE_HOME -local / u01 / software / 21523375/21352635

Press Y during three

 

2. Check upgrades

$ /u01/app/11.2.0/grid/OPatch/opatch Lsinv
                                                    
Patch 21352635: applied on Fri Dec 18 17:38:24 CST 2015
Unique Patch ID: 19227862
Patch description: "Database Patch Set Update: 11.2.0.4.8 (21352635)"
  Created on 1 Sep 2015, 07:49:44 hrs
Sub-patch 20760982; "Database Patch Set Update: 11.2.0.4.7 (20760982)"
Sub-patch 20299013; "Database Patch Set Update: 11.2.0.4.6 (20299013)"
Sub-patch 19769489; "Database Patch Set Update: 11.2.0.4.5 (19769489)"
Sub-patch 19121551; "Database Patch Set Update: 11.2.0.4.4 (19121551)"
Sub-patch 18522509; "Database Patch Set Update: 11.2.0.4.3 (18522509)"
Sub-patch 18031668; "Database Patch Set Update: 11.2.0.4.2 (18031668)"
Sub-patch 17478514; "Database Patch Set Update: 11.2.0.4.1 (17478514)"
  Bugs fixed:
...

$ /u01/app/11.2.0/grid/OPatch/opatch Lspatches

21352635; Database Patch Set Update: 11.2.0.4.8 (21352635)
21352642; ACFS Patch Set Update: 11.2.0.4.8 (21352642)
21352649; OCW Patch Set Update: 11.2.0.4.8 (21352649)

OPatch succeeded.

3. The two nodes start crs

Note: Because it is hand to play PSU, the need to manually shut down and restart operation.
# Cd /u01/app/11.2.0/grid/bin
# ./crsctl Start has
CRS-4123: Oracle High Availability Services has been started.

Five, playing patch database PSU

1. Preparations

(1) Root user, the re-patch to give permission to PSU

cd / u01 / software /
rm -rf 21523375
chown oracle: oinstall p21523375_112040_Linux-x86-64.zip

(2) oracle user

su - oracle
cd / u01 / software /; unzip p21523375_112040_Linux-x86-64.zip

(3) Oracle user under check compatibility for playing multiple CPU environment.

$ ORACLE_HOME / OPatch / opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir / u01 / software / 21523375/21352635 -oh $ ORACLE_HOME
-------------------------------------------------- -
Oracle Interim Patch Installer version 11.2.0.3.11
Copyright (c) 2015, Oracle Corporation. All rights reserved.

PREREQ session

Oracle Home: /u01/app/oracle/product/11.2.0/db_1
Central Inventory: / u01 / app / oraInventory
  from: /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version: 11.2.0.3.11
OUI version: 11.2.0.4.0
Log file location: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2015-12-21_09-25-57AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
-------------------------------------------------- -

2. oracle database patch or a patch with the same

su - oracle
/u01/app/oracle/product/11.2.0/db_1/OPatch/opatch napply -oh $ ORACLE_HOME -local / u01 / software / 21523375/21352635

See patch situation:

/u01/app/oracle/product/11.2.0/db_1/OPatch/opatch lsinv
/u01/app/oracle/product/11.2.0/db_1/OPatch/opatch lspatches

 

Sixth, upgrade the database data dictionary

1. Start Database

(1) to play the next grid root user needs to close grid (two nodes perform)

cd /u01/app/11.2.0/grid/bin
./crsctl start has

Or directly execute the following command, while closing two nodes.
./crs_start -all


$ Sqlplus / as sysdba
  
SQL * Plus: Release 11.2.0.4.0 Production on Fri Mar 15 13:40:39 2013
  
Copyright (c) 1982, 2011, Oracle. All rights reserved.
  
Connected to an idle instance.
  
SQL> startup

ORA-01565: error in identifying file '+ DATA / orcl / spfileorcl.ora'
ORA-17503: ksfdopn: 2 Failed to open file + DATA / orcl / spfileorcl.ora
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-15040: diskgroup is incomplete
ORA-15040: diskgroup is incomplete
ORA-15040: diskgroup is incomplete

Description: Unable to start the database through queries because oracle permissions are changed to oracle: oinstall. Resolved in the following way.
Run the following command on all nodes in the cluster Review:
# Chown oracle: asmadmin /u01/app/oracle/product/11.2.0/db_1/bin/oracle
# Chmod 6751 /u01/app/oracle/product/11.2.0/db_1/bin/oracle

SQL> startup
ORACLE instance started.

Total System Global Area 2505338880 bytes
Fixed Size 2255832 bytes
Variable Size 687866920 bytes
Database Buffers 1795162112 bytes
Redo Buffers 20054016 bytes
Database mounted.
Database opened.

SQL> @? / Rdbms / admin / catbundle.sql psu apply
Wait intermediate process.

After the implementation of our updated information can be found PSU:
SQL>

set line 150
col ACTION_TIME for a30
col ACTION for a8
col NAMESPACE for a8
col VERSION for a10
col BUNDLE_SERIES for a5
col COMMENTS for a20
select * from dba_registry_history;
 

ACTION_TIME ACTION NAMESPAC VERSION ID BUNDL COMMENTS
------------------------------ -------- -------- ---- ------ ---------- ----- --------------------
24-AUG-13 12.03.45.119862 PM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0
22-DEC-15 03.53.27.330912 PM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0
24-DEC-15 04.58.29.381100 PM APPLY SERVER 11.2.0.4 8 PSU PSU 11.2.0.4.8

3 rows selected.

SQL>
SQL>
     
         
       
         
  More:      
 
- Oracle 11g RMAN cross-platform transfer table space (Database)
- Oracle 11g partition maintenance (Nice) - Truncating And Partitions (Database)
- extundelete: the Linux-based open source data recovery tools (Linux)
- Linux file compression and file system packaged with instructions (Linux)
- Vim configuration instructions (Linux)
- Ubuntu 64-bit installation Adobe Reader 9.5.5 (Linux)
- Android 5.1 OTA package compilation error (Programming)
- Security: Unix operating system intrusion tracking Strikes Back (Linux)
- Snort build a secure Linux server (Linux)
- The several technical presentation Raid under Linux (Linux)
- Safety testing Unix and Linux server entry succinctly (Linux)
- The SVN installation, configuration and start - up under Linux (CentOS 6.5) (Server)
- CentOS 6 Install Xen4.2 Virtualization Practice (Linux)
- Use window.name + iframe cross-domain access to data Detailed (Programming)
- ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], [] (Database)
- Restore Oracle Database Cold backup and database reconstruction emca (Database)
- Netcat Example (Linux)
- MySQL Statistics (Database)
- Ubuntu 14.10 Install Ubuntu Touch Music App 2.0 (Linux)
- Using C ++ Container Templates in Shared Memory (Programming)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.