STANDBY LOG NOT APPLYING IN STANDBY DATABASE
Issue: We found standby log was not applying in standby database and the difference count was keep increasing. Media recover process also not starting up. Cause: Upon receiving such alert…
Read MoreORACLE RAC STARTUP SEQUENCE
There are 2 ways we can do it as short and detail version . Short startup sequence : 1) OS 2) Cluster 3) ASM 4) INSTANCE 5) Listener 6) Service…
Read MoreORACLE GOLDENGATE ARCHITECTURE
Oracle Goldengate supports the replication of data for various heterogeneous platforms. It provides support for IBM Informix and extended support for Microsoft SQL Server and MySQL. Oracle GoldenGate is now …
Read MoreIn Oracle 12c Sql tuning advisor is not running even though its enabled
Faced a strange issue in oracle 12c. In automated maintenance task, sql tuning advisor was enabled. However, it was still not running. Validated dba_autotask_operation, that “sql tuning advisor” is enabled.…
Read Moreutlrp hangs after upgrade to 12c ERP database
We were performing database upgrade from oracle 11g to oracle 12c with Oracle Apps 12.1.3. We faced an issue where database upgrade took < 30 mins. However, it made huge…
Read MoreSOA webservices not working after 12c ERP db upgrade
After upgrading database from oracle 11g to 12c in Oracle Apps R12.1.3, got a strange issue where SOA webservices- SOAP, REST stopped. The following url showed 404 http://host.domain:8000/webservices/SOAProvider/?testquery The issue…
Read MoreOracle apps adpatch fails
Many times , when applying patch using adpatch in oracle apps, the patch session session gets terminated because of network problems. The best way to continue the patch is to…
Read MoreImporting excel data to oracle table using sqldeveloper
Importing excel data to oracle table using sqldeveloper Choose the table and right click Uncheck Header Select columns Choose match by position
Read MoreTechnical Solutions For Single Search box Filter the Value with highlights in Multiple Reports
Overview This document explains how to search single search box in Multiple reports with highlights using Oracle Apex Technologies and Tools Used The following technologies has been used to achieve…
Read MoreDOCUMENT SEQUENCE CREATION IN RECEIVABLES
Enable Sequential Numbering Profile Option The profile option Sequential Numbering must be enabled in order to use the Document Sequence feature. This can be set at the site, application or responsibility level. Valid…
Read More