警告:针对Windows Patch Bundles 11.2.0.4.8到11.2.0.4.161018 版本的db,需要进行scn 检查

警告:针对Windows Patch Bundles 11.2.0.4.8版本到11.2.0.4.161018 版本,需要进行scn 检查.
来源于:
ALERT: SCN check needed for Windows Patch Bundles 11.2.0.4.8 to 11.2.0.4.161018 (Doc ID 2198827.1)

适用于:
Oracle Database - Standard Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Microsoft Windows x64 (64-bit)
Microsoft Windows (32-bit)

描述:
Windows Bundle patches 11.2.0.4.8 to 11.2.0.4.161018 are identified to be vulnerable to very high SCN jumps. Hence we recommend you to apply the latest bundle patch 11.2.0.4.161028 (24591648) as soon as possible.

Before applying the 11.2.0.4.161028 patch (or above) , execute the following checks. 

1. Check current_scn from v$database. If its greater than 15169738620928, contact Oracle Support before proceeding. If its less than 15169738620928, please proceed to next step.

2. Execute SCN Healthcheck.sql script from Patch 13498243.

[html]  view plain  copy

 

1. ------------------------------------------------------------  
2. ScnHealthCheck  
3. ------------------------------------------------------------  
4. Current Date: 2016/10/17 01:01:09  
5. Current SCN: 384089  
6. Version: 11.2.0.4.0  
7. ------------------------------------------------------------  
8. Result: A - SCN Headroom is good  
9. Apply the latest recommended patches  
10. based on your maintenance schedule  
11. AND set _external_scn_rejection_threshold_hours=24 after apply.  
12. For further information review MOS document id 1393363.1  
13. ------------------------------------------------------------  

If the Result is C in your case, then contact Oracle Support immediately. Else, you can apply Patch 11.2.0.4.161028 safely.

Please do not proceed with the patch application if either of the above checks are negative.

[html]  view plain  copy

 

1. The above checks are mandatory before upgrade or patch application,   
2. if and only if you had applied any of the problematic Bundle Patches mentioned here (ie, 11.2.0.4.8 to 11.2.0.4.161018).   
3. In other words, if you had never applied the Bundle Patches 11.2.0.4.8 to 11.2.0.4.161018,   
4. the above checks are not required before applying the BP 11.2.0.4.161028 or later.  

OCCURRENCE

 Applicable to all who have applied the Windows Bundle patches 11.2.0.4.8 to 11.2.0.4.161018

SYMPTOMS

 Applicable to all who have applied the Windows Bundle patches 11.2.0.4.8 to 11.2.0.4.161018. Affected patches are:

PATCHES

 Patch 11.2.0.4.161028 or above

HISTORY

Updated: 7 November 2016 

Created: 31 October 2016