ANIL VEJENDLA

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 affected 12.1.0.2 (Server Patch Set) 11.2.0.4 Fixed: The fix for 20693579 is first included in 12.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. Aff...

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: To Bottom refer Release Schedule of Current Database Releases (Doc ID 742060.1) for more details.

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. 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.

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 ​

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...