Oracle Patch p18841764 Related

Database version:11.2.0.4.0

Patch Requirements Environment:linux64(This version is the example here)

Patch Considerations: You can scroll the upgrade. You need to close the node database and close the node's Cluster service and related processes.

Patch Flow:

1. Unzip Patch Pack (recommended path is /u01)

2. Close node database and related database resources

3. Replace Opatch

4, into the patch path,Opatch apply

Common error Handling:

Q1: There is an active lib package that cannot be patched.

A1: A handle to the associated Lib is held by the program. lsof Lib, find the handle program to hold the Lib , close the program can be changed.

Q2: After the patch is finished, cannot identify Controlfile

A2: The patch must be turned off in a RAC environment if the cluster-related service is not turned off, causing asm registration issues. Execute under all nodes

[Email protected]:/u01/app/grid/product/11.2.0/db_1/bin$./setasmgidwrap-o/u01/app/oracle/product/11.2.0/db_1/ Bin/oracle

Re-register ASM to Oracle .

Q3:opatch version is too low

A3: Download p6880880 patch Pack, unzip the patch, replace the oracle_home/opacth

Supplemental: ASM is not turned off, the key section of the database startup log is as follows

note:loaded Library:system
Ora-15025:could not open Disk "/DEV/MAPPER/ASMDATA01"
Ora-27041:unable to open File
Linux-x86_64 Error:13:permission denied
Additional Information:9
Ora-15025:could not open Disk "/DEV/MAPPER/ASMDATA02"
Ora-27041:unable to open File
Linux-x86_64 Error:13:permission denied
Additional Information:9
Ora-15025:could not open Disk "/dev/mapper/asmdata03"
Ora-27041:unable to open File
Linux-x86_64 Error:13:permission denied
Additional Information:9
Success:diskgroup DATADG was dismounted
Error:diskgroup DATADG is not mounted
Ora-00210:cannot Open the specified control file
Ora-00202:control file: ' +datadg/pmsgs/controlfile/current.256.875718133 '
Ora-17503:ksfdopn:2 Failed to open file +datadg/pmsgs/controlfile/current.256.875718133
Ora-15001:diskgroup "DATADG" does not exist or was not mounted
Ora-15040:diskgroup is incomplete
Ora-15040:diskgroup is incomplete
Ora-15040:diskgroup is incomplete
ORA-205 signalled During:alter DATABASE MOUNT ...
Sat APR 23 04:28:03 2016
ALTER SYSTEM SET local_listener= ' (address= (PROTOCOL=TCP) (host=10.212.242.199) (port=1521)) ' Scope=memory SID= ' pmsgs1 ‘;
Sat APR 23 04:28:29 2016
Reconfiguration started (Old Inc 2, New Inc 4)
List of instances:
1 2 (myinst:1)
Global Resource Directory Frozen
Communication channels reestablished
Master broadcasted resource hash value bitmaps
Non-local Process blocks cleaned out
Sat APR 23 04:28:30 2016
LMS 1:0 GCS Shadows cancelled, 0 closed, 0 Xw survived
Sat APR 23 04:28:30 2016
LMS 3:0 GCS Shadows cancelled, 0 closed, 0 Xw survived
Sat APR 23 04:28:30 2016
LMS 0:0 GCS Shadows cancelled, 0 closed, 0 Xw survived
Sat APR 23 04:28:30 2016
LMS 2:0 GCS Shadows cancelled, 0 closed, 0 Xw survived
Set Master Node Info
Submitted all Remote-enqueue requests
Dwn-cvts replayed, Valblks dubious
All grantable Enqueues granted
Post Smon to start 1st pass IR
Submitted all GCS Remote-cache requests
Post Smon to start 1st pass IR
Fix write in GCs resources
Reconfiguration complete
Sat APR 23 04:28:32 2016
Starting ORACLE instance (normal)
Sat APR 23 04:29:28 2016
Warning:vktm detected a time drift.
Time drifts can result in an unexpected behavior such as time-outs. Please check the trace file for more details.
Sat APR 23 04:33:25 2016
Shutting down instance (immediate)

Oracle Patch p18841764 Related