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)     - 5 interesting Linux command line tips (Linux)

- ActiveMQ-based shared file system HA solutions (Server)

- Android Custom View step (Programming)

- How to improve the performance of Ruby On Rails (Linux)

- Shorewall firewall settings under Ubuntu (Linux)

- Introduces Linux kernel compilation system and compiler installation (Linux)

- Two alert log ORA Errors (Database)

- Installed FFmpeg 2.6.3 on Ubuntu / Debian / Fedora system (Linux)

- OpenSSL: implementation creates a private CA, certificate signing request Explanation (Server)

- Ubuntu Slingscold (Linux)

- The principle Httpclient4.4 (HttpClient Interface) (Programming)

- Linux / Unix: chroot command examples to explain (Linux)

- Source code is installed MySQL 5.6.28 (Database)

- How to make Linux a non-root user uses less than 1024 ports (Linux)

- Reason C ++ program running under Linux a segmentation fault core dumped in (Programming)

- GAMIT10.5 install and update failed Solution (Linux)

- Oracle Execute to Parse perform analytical Ratio Analysis (Database)

- Puppet 3.5 Source package Installation and Configuration (Server)

- Linux security concerns again (Linux)

- Linux Tutorial Share: How to sudo command to define the PATH environment variable (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:      
 
- The Zabbix2.4.5 source compiler installation under Ubuntu 14.04 (Server)
- Proxmox VE implement KVM OpenVZ virtualization cloud computing (Server)
- To achieve Linux Security (Linux)
- Oracle background processes daemons (Database)
- Linux kernel modules related to the management Comments (Linux)
- RedHat Performance Tuning (Server)
- Java data structures - the single linked list LinkedList linear table (Programming)
- To explore the Android ListView caching mechanism again (Programming)
- Install Oracle JDK 8 and JVM class loading mechanism in Linux (Linux)
- Static member variable modified (Programming)
- ORA-30926 and MERGE tables empty the temporary occupation problem (Database)
- Restore Oracle Database Cold backup and database reconstruction emca (Database)
- installation and configuration of the PHP environment (Apache2) under Linux (Server)
- Repair Chrome for Linux is (Linux)
- A well-known but rarely used skills: object pool (Programming)
- Security measures under Unix multi-user operating system (Linux)
- httpd-2.4 feature (Server)
- Getting Started with Linux system to learn: how to check the version of SSH on Linux (Linux)
- Install Apache streaming media services on CentOS 6.4 (Server)
- Introduction and MongoDB CRUD (Database)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.