Steps to start/stop Workflow Notification Mailer Check workflow mailer service current status SQL> select running_processes from fnd_concurrent_queues where concurrent_queue_name = ‘WFMLRSVC’; RUNNING_PROCESSES —————– 1 Number of…
Read MoreOracle 21c introduces the ability to improve the performance of queries executed on the read-only active Standby Database by enabling the use of the Result Cache feature to store query…
Read MoreIf 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 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 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 MoreDescription: Following sql script is used to find the Application Express users , who all are logged in previous days or specific period (months , years) . Steps: 1.Login as…
Read MoreError Log location: $INST_TOP/logs/ora/10.1.3/opmn/default_group~oacore~default_group~1.log $INST_TOP/logs/ora/10.1.3/opmn/default_group~oafm~default_group~1.log Error : Error: Could not connect to the remote server. Please check if the server is down or the client is using invalid host, ORMI…
Read MoreWhile starting weblogic aAdmin server getting error as below Schema validation errors while parsing /Weblogic/Oracle/Admin/config/config.xml – Expected elements ‘administration-protocol@http://xmlns.oracle.com/weblogic/domain wldf-system-resource Solution: set JAVA_OPTIONS=%JAVA_OPTIONS% -Dweblogic.configuration.schemaValidationEnabled=false
Read More1. Overview This document will be helpful to insert data from intermediate table to source table with error log table 2. Technologies and Tools Used Oracle Plsql code. 3. Use Case Load…
Read More