Yearly Archives: 2021

ORA-17629: Cannot connect to the remote database server | Active Duplicate on RAC

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 More

Collecting OSWatcher Logs for a Particular Period of Time

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

Manually Generating Segment Advisor Advice

Manually 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 More

The Store Record X Could Not Be Found

Shutdown 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 More

Life At Doyensys – Bhagavathy Ramachandran M

We 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 More

New Data Guard Oracle 19c Database

Data 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 More

New tables/views in Oracle 19c Database

New tables/views in Oracle 19c Database   dba_auto_index_config dba_sql_quarantine V$SQL_TESTCASES DBA_REGISTRY_BACKPORTS

Read More

New initialization parameters in Oracle Database 19c

New 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 More

Auto Refresh Report and Hide Processing Spinners in Oracle Apex

Overview 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 More

“Output Post Processor” Concurrent Manager not able to start R12.1

Cause: 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