ORACLE OS WATCHER
ORACLE OS WATCHER What is oracle OS watcher? Oracle OS watcher is collects and stores as archives operating system and network metrics that you can use to diagnose performance…
Read MoreADOP: Fs_clone fails with error Failed to delete the directory
Issue : ADOP: Fs_clone fails with error Failed to delete the directory Observation : Fs_clone fails with the following error: ERROR ———————– *******FATAL ERROR******* PROGRAM : (/u01/ebs122/tech/apps/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl) FUNCTION: main::removeDirectory…
Read Moreadop fs_Clone Failed “ERRORMSG: File instantiation failed”
Issue : adop fs_Clone Failed “ERRORMSG: File instantiation failed” Observation : Fs_clone fails with the following error: Completed FSCloneStage… shell-init: error retrieving current directory: getcwd: cannot access parent directories: No…
Read Moreadop phase=FS_CLONE Failed On Slave Node
Issue : adop phase=FS_CLONE Failed On Slave Node Observation : ERROR ———————– FS_CLONE failed on slave node Reason : File ownership wrong/changed on [ EBSapps.env ]. preventing it from being…
Read MoreORACLE TRACE FILE ANALYZER UPGRADE TO 21.1.2
TRACE FILE ANALYZER UPGRADE TO 21.1.2 Oracle Trace file Analyzer provides a number of diagnostic tools in single bundle, making it easy to gather diagnostic information about oracle database and…
Read MoreSTANDBY 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 More