Posts

ORA-28086: The data redaction policy expression has an error

Image
Error:
ERROR at line 1:
ORA-28086: The data redaction policy expression has an error.
ORA-06512: at "SYS.DBMS_REDACT_INT", line 3
ORA-06512: at "SYS.DBMS_REDACT", line 42
ORA-06512: at line 1

When we try to run same as sys user it is working perfectly fine, but as a normal user it is failing with below errors.




No Privileges issue because AVO user had DBA Privilege ..

Versions confirmed as being affected12.1.0.2 (Server Patch Set)11.2.0.4
Fixed:The fix for 20693579 is first included in12.2.0.1 (Base Release)
Cause :
Bug 20693579 - DBMS_REDACT.ADD_POLICY fails with ORA-28086 when CURSOR_SHARING is force (Doc ID 20693579.8)To Bottom
Bug 20693579  DBMS_REDACT.ADD_POLICY fails with ORA-28086 when CURSOR_SHARING is force  This note gives a brief overview of bug 20693579.
 The content was last updated on: 17-FEB-2017
Click here for details of each of the sections below.
Affects:Product (Component)Oracle Server (Rdbms)Range of versions believed to be affectedVersions >= 12.1 but BEL…

12c EM Manage Current Backups Returns Error for Container Database

We have multiple Databases running on same server and using EM Console to monitor backups information .. We are getting Error "Register Database in Recovery Catalog" which is already registered in catalog .
We got this error only for Container Database .

in EM console, navigate to Targets -> Databases -> Availability -> Backup and Recovery -> Manage Current Backups  and you get the following error on the screen:
Error
Only databases with a version of 10.1 or above, or databases that use a recovery catalog of schema version 10.1 or above are supported. You can click the following link to register the database in a recovery catalog.
Register Database In Recovery Catalog CAUSE Known bugs in 12.1.0.6.0 EM DB Plugin Bug 21825439
Bug 19346373
Bug 19152759

SOLUTION  Upgrade the DB Plugin from 12.1.0.6.0 to 12.1.0.7 and apply the latest EM DB Plugin Bundle Patch on top of 12.1.0.7.x

Database Patch Set Release Roadmap

Image
Database Patch Set Release Roadmap:


To Bottom
refer Release Schedule of Current Database Releases (Doc ID 742060.1) for more details.



12.2.0.1 Release Date 15-Mar-2017

Image
reference: Release Schedule of Current Database Releases (Doc ID 742060.1)

On-Premise Server Releases (includes client)


12.2.0.1 On-Premise Server release date for Linux x86-64 is 15-Mar-2017.

Jan 2017 PSU Patches not available for Database Version 11.2.0.4

Image
Jan 2017 PSU Patches not available for Database Version 11.2.0.4.


MOS Note: 854428.1
Oracle Recommended Patches -- Oracle Database (Doc ID 756671.1)





Quick Reference to Patch Numbers for Database/GI PSU, SPU(CPU), Bundle Patches and Patchsets (Doc ID 1454618.1)

As there are no Security Fixes for Oracle Database 11.2.0.4 this quarter there are no SPUs or PSU released.

PDBs Can have different character sets in 12cR2 to ease consolidation

When the character set of the root is AL32UTF8, PDBs that are plugged into the CDB or cloned can have a different character set than the root. PDBs that are created from the CDB seed inherit the AL32UTF8 from it, but you can migrate the PDB to a different character set.

http://docs.oracle.com/database/122/ADMIN/creating-and-configuring-a-cdb.htm#ADMIN13517

Table Recovery in 12c Enterprise Edition

RMAN> RECOVER TABLE 'TEST1'.'TEST1'
  UNTIL SCN 3785709
  AUXILIARY DESTINATION '/u06/aux'; 


Starting recover at 30-DEC-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=130 device type=DISK
RMAN-05026: WARNING: presuming following set of tablespaces applies to specified Point-in-Time

List of tablespaces expected to have UNDO segments
Tablespace SYSTEM
Tablespace UNDOTBS1

Creating automatic instance, with SID='flAE'

initialization parameters used for automatic instance:
db_name=TEST
db_unique_name=flAE_pitr_TEST
compatible=12.1.0.2.0
db_block_size=8192
db_files=200
diagnostic_dest=/u01/app/oracle
_system_trig_enabled=FALSE
sga_target=2560M
processes=200
db_create_file_dest=/u06/aux
log_archive_dest_1='location=/u06/aux'
#No auxiliary parameter file used


starting up automatic instance TEST

Oracle instance started

Total System Global Area    2684354560 bytes

Fixed Size                     2928008 bytes