Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle 11g RAC manually playing GI PSU patch (11.2.0.4.8)     - Gitblit adopted Ticket collaborative development model (Linux)

- 10 tips daily Docker (Server)

- AFNetworking + Nginx HTTPS communication server + (Server)

- Linux password file security issues detailed usage (Linux)

- Linux Security (Linux)

- To obtain installation package (RPM) under RHEL6 (Linux)

- Linux /var/spool/ insufficient clientmqueue space solutions (Linux)

- Generic mechanism C11 standard (Programming)

- Linux system security audit tools scan nessus installation tutorial (Linux)

- CentOS and RHEL to install IPython 0.11 (Linux)

- Automated Password Generator: Linux under a special password generator (Linux)

- Linux compiler installation Redis (Database)

- Hadoop configuration ssh automation of automation (Server)

- Cryptography development environment to build under Ubuntu (Linux)

- Linux 10 useful examples of command-line completion (Linux)

- To install CentOS 6.5 on your hard drive under Windows 7 (Linux)

- The direct insertion sort algorithm (Programming)

- Ubuntu 15.10 under Python + Apache + CGI fully configured (Server)

- The Gitlab migrated to Docker container (Server)

- About phpwind 5.01-5.3 0day analysis of the article (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 10g in the unique and index problems (Database)
- Linux PXE unattended installation PXE-E32: TFTP OPen timeout the solution (Linux)
- MySQL Error Code Complete (Database)
- Linux Getting Started tutorial: 3D effects and beautify your desktop (Linux)
- Java rewrite the hashcode method (Programming)
- Docker: Mirroring and container operations (Server)
- Offline (local) Yum source structures (Linux)
- Linux Samba server-side structures and the use of the client (Server)
- PyCharm new Python file name and the name of the module will import the same problem might arise (Programming)
- MySQL optimization tabs (Database)
- Spring use Cache (Programming)
- MongoDB3.0.6 wiredtiger MMAPv1 (Database)
- Two strokes to improve development productivity Struts2 (Programming)
- Memcached distributed caching (Server)
- Observation network performance tools for Linux (Linux)
- How to set up FTP server on Linux (Server)
- Linux 0.12 kernel and modern kernels difference in memory management (Linux)
- Oracle PL / SQL based cursor (Database)
- Spring Data JPA call a stored procedure examples (Programming)
- To install the Oracle 10.2.0.1.0 process notes on Oracle Linux 4u4 (Database)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.