Database Blog

Oracle Dataguard physical Standby configuration in 19c(Active method)

  Oracle Dataguard physical Standby configuration in 19c:(Active method-without using rman backup) Overview steps: Step:1 we have to enable the archive log mode ,flashback  on primary databases. Step:2 Then enable the force…

Read More

Resolving ORA-39701: database must be mounted EXCLUSIVE for UPGRADE or DOWNGRADE

SQL> Startup upgrade ORACLE instance started. Total System Global Area 1.3262E+11 bytes Fixed Size                  2304584 bytes Variable Size        …

Read More

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 More

ADOP: 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 More

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

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

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

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 More

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

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