Doing an Oracle upgrade with DBUA – and you have hidden parameters you want to keep?

Are you doing an Oracle upgrade with DBUA – and you have hidden parameters you want to keep? From 11.2.0.4 onwards there is a new switch to preserve the hidden parameters: dbua -keepHiddenParams If you don’t use it – you loose any hidden parameters you had.  

how far has your dbms_stats.gather_database_stats job progressed?

–alter session set nls_date_format=’dd-mon-yy hh24:mi:ss’; set sqlformat ansiconsole select * from v$session_longops where time_remaining > 0; SID SERIAL# OPNAME SOFAR TOTALWORK UNITS START_TIME LAST_UPDATE_TIME TIME_REMAINING ELAPSED_SECONDS 654 48,837 Gather Database Statistics 1,855 3,286 Objects 23-sep-16 20:05:40 23-sep-16 20:47:05 1,917 2,485 SID SERIAL# OPNAME SOFAR TOTALWORK UNITS START_TIME LAST_UPDATE_TIME TIME_REMAINING ELAPSED_SECONDS 654 48,837 Gather Database Statistics…

Drop old DB ID’s from a clone

Run the following SQL to identify old DBIDs. SELECT DISTINCT dbid FROM DBA_FEATURE_USAGE_STATISTICS WHERE dbid NOT IN (SELECT dbid FROM v$database); If the query above returns a record or more.  Run the following block of PL/SQL DECLARE current_dbid NUMBER; CURSOR old_dbids IS SELECT DISTINCT dbid FROM DBA_FEATURE_USAGE_STATISTICS WHERE dbid NOT IN (SELECT dbid FROM v$database);…

Oracle 11gR2 OEM dbcontrol drop and recreate after database clone – OC4J_DBConsole not found

Got this error after a 11gR2 database clone. oracle [prod] logs $ emctl status dbconsole OC4J Configuration issue. /u01/app/oracle/product/11.2.0.4/db_1/oc4j/j2ee/OC4J_DBConsole_hostname_prod not found. Just drop and recreate the repository and the configuration as follows – be aware this action will quiesce the database – and potentially impact operations emca -deconfig dbcontrol db -repos drop emca -config dbcontrol…