ANIL VEJENDLA

/U01 Space Consumption By CVUCHECKREPORT.XML In Cluster We are observing /u01 is full in RAC Environments due to CVUCHECKREPORT.XML Getting created and not purged in  /u01/app/oracle/crsdata/@global/cvu/baseline/cvures/   Oracle Provided a Patch to fix  this Bug 20177779 in April PSU . We have already applied April PSU but issue was not fixed. CVU HEALTH CHECK REPORTS NOT PURGED EVEN AFTER APPLYING PATCH FOR 20177779 (Patch). Bug 20177779 has been replaced by new bug 22594310. So Now we need to Apply 22594310 to fix this bug in all Cluster environments. Workaround: Purge CVUCHECKREPORT.XML files Manually till we apply this Patch. -anil12cdba

List Targets with TNS Listener ports configured : SELECT mgmt$target.host_name , mgmt$target.target_name , mgmt$target.target_type , mgmt$target_properties.property_name , mgmt$target_properties.property_value FROM mgmt$target , mgmt$target_properties WHERE ( mgmt$target.target_name = mgmt$target_properties.target_name ) AND ( mgmt$target.target_type = mgmt$target_properties.target_type ) and ( mgmt$target.target_type = 'oracle_listener' ) and ( mgmt$target_properties.property_name = 'Port' ); Devora02       LISTENER_ora02                       oracle_listener Port 1529 Devora01       LISTENER_ora01                       oracle_listener Port 1529 Devora04       LISTENER_ora04                       oracle_listener Port 1529 List Machine_Names, CPU Count & Database Verion for Licensing SELECT mgmt$target.host_name , mgmt$target_properties.property_name , mgmt$target_properties.property_value FROM mgmt$target , mgmt$target_properties WHERE ( mgmt$

opatch prereq CheckConflict fails with Exception occured : PatchObject constructor:Input file does not exist Patch Prereq step is failing with following error.. The OPatch option of  -phBaseDir  option is used to specify the path to base dir where all the patches to be applied are kept.  The command enterred was $ opatch prereq CheckConflictAgainstOHWithDetail -ph ./  OPatch will look in $ORACLE_HOME/patches for the following directory structure: $ORACLE_HOME/patches/ 23615381 /etc/config Since unzipping the patch creates multiple directories, that directory structure does not exist and  -phBaseDir  must be the directory that is created when the patch is unzipped.  -phBaseDir $/u01/software/patches/23615381/23177648

********************************************** 12.2 New  Features from one of the presentation. ********************************************** AWR now available on PDB level Memory management on PDB level PDB cloning is now possible also online Flashback now possible on PDB level Backup / Restore on PDB level with RMAN

Standby Database is not Sync with Primary and gap is more than 40 days.. We don't have archivelog backups older than 30 days to apply on Standby Database. Instead of Rebuilding entire Standby Database we used Incremental Backup recover Standy database. Steps Followed briefly: 1 . Take current SCN From Standby Database 2. Take Primary DB Backup using FROM SCN. 3.Create standby controlfile 4. Copy Backups to Standby Server 5. shutdown standby ,startup nomount, Restore Standby control file & startup mount 6.   REcovery database noredo 7. alter database recover managed standby database disconnect from session; 8. Verify Standby Gap. Standby: ======== Current SCN From Standby Database: ---------------------------------- SQL> col current_scn for 999,999,999,999,999,9999 SQL>  select current_scn from v$database;               CURRENT_SCN -------------------------          917,102,315,7647 Cancel Recovery of Standby Database: ------------------------

SYS@S2411S > alter user S24RMAN grant connect through SREE;   User altered.   SYS@S2411S >   [oracle@s24-oratl15 ~]$ sqlplus SREE[S24RMAN]/long99991234@S2411S   SQL*Plus: Release 11.2.0.4.0 Production on Thu Jun 30 08:34:55 2016 Copyright (c) 1982, 2013, Oracle.  All rights reserved.     Connected to: Oracle Database 11g Release 11.2.0.4.0 - 64bit Production S24RMAN@S2411S > sho user USER is "S24RMAN" S24RMAN@S2411S >   Revoke : ------------- As sysdba > alter user S24RMAN revoke connect through SREE;   User altered.

How to Force SQL PLAN: Find the old query plan for an sql_id ====================================== set long 90000 SET PAGESIZE 14 set lines 150 pages 50 column begin_interval_time format a25 alter session set nls_date_format='dd-mon-yy hh24:mi:ss'; select begin_interval_time,plan_hash_value,cpu_time_delta,elapsed_time_delta,iowait_delta,disk_reads_delta from dba_hist_sqlstat A,dba_hist_snapshot B where A.snap_id = B.snap_id and A.sql_id = '&sql_id' order by 1; Forcing a SQL Plan : ====================== Step 1: ---------- SPO coe_xfr_sql_profile.log; SET DEF ON TERM OFF ECHO ON FEED OFF VER OFF HEA ON LIN 2000 PAGES 100 LONG 8000000 LONGC 800000 TRIMS ON TI OFF TIMI OFF SERVEROUT ON SIZE 1000000 NUMF "" SQ LP SQL>; REM REM $Header: 215187.1 coe_xfr_sql_profile.sql 11.4.1.4 2010/07/12 csierra $ REM REM Copyright (c) 2000-2010, Oracle Corporation. All rights reserved. REM REM AUTHOR R

Here are the TDE column implementation steps: ð  Run below statements sequentially: One sqlplus session is enough for entire action plan. Database : orcl Server : xxxxxxxxx OS User : tdeuser conn / as syskm define tde_wallet_full_path=&tde_wallet_full_path define password=&password col WRL_PARAMETER for a60 col WRL_TYPE for a8 col STATUS for a20 col WALLET_TYPE for a10 set lines 200 select * from gv$encryption_wallet; administer key management create keystore '&&tde_wallet_full_path' identified by "&&password"; select * from v$encryption_wallet; administer key management set keystore open identified by "&&password"; select * from v$encryption_wallet; administer key management create key identified by "&&password" with backup; select * from v$encryption_wallet; select key_id,activation_time from v$encryption_keys; administer key management use key &

Note: Online move only works with  Enterprise Edition(EE). When we try to perform online move in SE it will fail with below error. SYS@EPMDEV > ALTER DATABASE MOVE DATAFILE '/u05/odb/ORADATA_2/EPMDEV/epm_hfm_dev' TO '/u05/odb/ORADATA_2/EPMDEV/epm_hfm_dev.dbf'; ALTER DATABASE MOVE DATAFILE '/u05/odb/ORADATA_2/EPMDEV/epm_hfm_dev' TO '/u05/odb/ORADATA_2/EPMDEV/epm_hfm_dev.dbf' * ERROR at line 1: ORA-00439: feature not enabled: online move datafile SYS@EPMDEV > !oerr ora 439 00439, 00000, "feature not enabled: %s" // *Cause:  The specified feature is not enabled. // *Action: Do not attempt to use this feature. In SE we have to perform datafile rename in same old traditional way (OFFLINE).. Renaming an Online Data File: SYS@EPMDEV > ALTER DATABASE MOVE DATAFILE '/u05/odb/ORADATA_2/EPMDEV/epm_hfm_dev' TO '/u05/odb/ORADATA_2/EPMDEV/epm_hfm_dev_1.dbf'; Relocating an