Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle 11g RAC manually playing GI PSU patch (11.2.0.4.8)     - Java Set and List in the relationship and difference (Programming)

- Modify Linux SSH default port 22 in several ways (Linux)

- Linux gprof oprofiling and performance testing tools (Linux)

- SQL Beginner Guide (Database)

- Linux file system management partition, format, mount - label mount (Linux)

- Java NIO2: Buffer (Programming)

- Ubuntu install driver manager Mint Driver Manager and Device Driver Manager (Linux)

- MySQL binary packages install for RedHat Linux Enterprise 6.4 (Database)

- PostgreSQL using the system cache to improve operational efficiency (Database)

- Django Web dynamic three linkage (Programming)

- CentOS 6.4 under PXE + Kickstart unattended operating system installation (Programming)

- CentOS 7 virt-manager can not connect a local hypervisor (Linux)

- Sublime Text - Opens the current file in a browser (Linux)

- Oracle can not change the tablespace to backup mode in non-archive mode (Database)

- Linux shared libraries .so file name and Dynamic Link (Linux)

- Red Hat Linux security settings document (Linux)

- LVM management parameters commonly used commands explained in detail (Linux)

- Upgrade to Linux Mint 16 petra Mint 17 Qiana (Linux)

- Linux in order to make NMAP hide and seek with the firewall (Linux)

- Lambda expressions of evolution (Programming)

 
         
  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:      
 
- 17 How to install the Ubuntu 14.04 and Linux Mint Kodi14 (XBMC) (Linux)
- cat command uses the Linux redirection merge files (Linux)
- Build and verify MongoDB3.0.7 version (shard + replica) Cluster (Database)
- How to add a new resolution VirtualBox (Linux)
- Actual custom yum repository ---- gem commands commonly used parameters (Linux)
- GO five stages of language learning (Programming)
- Zabbix installation and configuration process (Server)
- Linux operating system security management skills (Linux)
- Java NIO1: I / O model overview (Programming)
- Management DB2 logs (Database)
- Python data types summary (Programming)
- Linux common commands ll namely ls -l --color = auto (Linux)
- OpenSUSE 13.1 OpenSUSE 12.3 and how to install Cinnamon 2.2 Desktop (Linux)
- Grep, Ack, Ag searches Efficiency Comparison (Linux)
- Teach you self-built Linux firewall free (Linux)
- Experts teach you safety precautions Linux Sniffer (Linux)
- SecureCRT use the configuration detailed tutorial (Linux)
- Android Studio and Git Git configuration file status (Linux)
- JDK comes with tools jinfo (Linux)
- LAMP and LNMP automated installation scripts (Server)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.