If you got this error in the RMAN active duplication of RAC database fails on restart operation with the following error messages: RMAN-03002: failure of Duplicate Db command at 02/17/2021 15:12:11…
Read More1. As <ROOT_USER>, log in to Node 1 and cd to the “/tmp” directory. # cd /tmp 2. Use “vi” or editor of your choice, to create the “osw_capture” script…
Read MoreManually Generating Segment Advisor Advice ========================================== Step 1 – Create a task. dbms_advisor.create_task ( advisor_name => ‘Segment Advisor’, task_id => my_task_id, task_name => test123, task_desc => my_task_desc); Step 2 – Assign an object…
Read MoreShutdown manage servers and Admin server, clear below extension file on under domain home. Clear temp and cache of manage and admin servers find . -name “*.DAT” -print find…
Read MoreWe at Doyensys, believe in the fact that every employee possesses their own set of strengths and efficiencies. It is those values of our employees that has kept us growing…
Read MoreData Guard Oracle 19c Database Replicate Restore Points from Primary to Standby Dynamically change Fast-Start Failover (FSFO) target standby database to another standby database in the target list without disabling…
Read MoreNew tables/views in Oracle 19c Database dba_auto_index_config dba_sql_quarantine V$SQL_TESTCASES DBA_REGISTRY_BACKPORTS
Read MoreNew initialization parameters in Oracle Database 19c “_optimizer_gather_stats_on_conventional_dml” and “_optimizer_use_stats_on_conventional_dml” which are true by default _optimizer_stats_on_conventional_dml_sample_rate (at 100%) DATA_GUARD_MAX_IO_TIME DATA_GUARD_MAX_LONGIO_TIME ADG_REDIRECT_DML (TRUE or FALSE) MAX_DATAPUMP_JOBS_PER_PDB aws_pdb_autoflush_enabled (TRUE or FALSE)
Read MoreOverview This document explains how to auto refresh report after a specified interval and hide processing spinners in oracle apex. Technologies and Tools Used The following technologies have been used…
Read MoreCause: Unable to initialize state monitor. oracle.apps.fnd.cp.gsm.GenCartCommException: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at “APPS.FND_CP_GSM_IPC”, line 499 ORA-06512: at line 1 at oracle.apps.fnd.cp.gsm.GenCartComm.initService(GenCartComm.java:233) at oracle.apps.fnd.cp.gsm.GenCartComm.<init>(GenCartComm.java:80)…
Read More