There were interesting situation happened after recreating undo. Most of the requests which have child requests and running more than hour are getting fail with ORA-1555 . When checking the undo [...]

Dear Readers I would like to explain more about the Oracle IoT Cloud services. Will provide continues blogs on this technology. In this block we will explore what is IOT and what are all the [...]

Please find the following High level steps to convert the primary to standby using switch over method .With this method the failover and switchover happens without much downtime .  It ensures [...]

Db file sequential read: This event occurs when a user tries to perform a Physical I/O while waiting for sequential reads from the Buffer cache. It occurs when the data on the table is accessed [...]

TXK Delta 13(32392507) plus critical TXK patches 33550674, 33535778 failed because of missing files adsign.txt and adkeystore.dat under $APPL_TOP_NE/ad/admin The Solution: The apply phase failed [...]

AutoPatch – aidafoGetFileDbVersion: INFO: ORA-01403: no data found when apply adop phase=cutover failing with AutoPatch Please follow below steps to overcome this issue Confirm that value [...]

It is possible to change the default request group for a given Analyzer at the individual analyzer level. 1.Start the menu with “perl Menu.pl” 2,Select a Product Family 3.Select an [...]

When  trying to submit one of GL report end with  error. The error message shows ORA-29532: Java call terminated by uncaught Java exception. select * from ************_LOV  [...]

Before upgrade or after upgrade, database may show INVALID status for component Real Application Clusters in dba_registry as below .   SQL> select comp_name,version,status from [...]

By default in Oracle Applications R12, users are not able to access Forms directly via the following url: http://hostname:port/forms/frmservlet The following error would pop out: APP-FND-01542: [...]