Corrupted Redo log Files
Corrupted Redo log Files The unplanned power outage, my development database was not starting up because of Redo log files corrupted. Let’s have a look redo log file corrupt scenario:…
Read MoreImportant Data Guard Process
Remote File Server (RFS) Process: The RFS process runs on the standby database and is responsible for communication between the primary and the standby database. For the log transport service,…
Read MoreDataGuard Issue – Warning: ORA-16826: apply service state is inconsistent with the DelayMins property
Warning: ORA-16826: apply service state is inconsistent with the DelayMins property Workaround: Check DG configuration: DGMGRL> show configuration Configuration – ZEE_DG_CONFIG Protection Mode: MaxPerformance Databases: zee – Primary database zeedr…
Read MoreUpgrade Java plug-in (JRE) to the latest certified version
If you have already migrated to Java JRE with Oracle EBS 11i you may want to update EBS to the latest update from time to time. For example, if your…
Read MoreApply Phase Options ABANDON and RESTART
Options ABANDON and RESTART adop phase=apply patches=12121212 abandon=yes Used to specify whether to restart the previous run of adop. May be useful if the previous action had an error. Note:If…
Read MoreAdcfgclone failing with Error: AFTER PASTEBINARY COMMENV.SH FILE IS POPULATED WITH INCORRECT JAVA_HOME PATH in EBS 12.2
Adcfgclone failing with Error: AFTER PASTE BINARY COMMENV.SH FILE IS POPULATED WITH INCORRECT JAVA_HOME PATH in EBS 12.2 Oracle Support notes: ===================== 12.2 E-Business Suite Applications Manager Rapidclone Fails With…
Read MoreSteps to Implement Transparent Data Encryption(TDE) using fast offline conversion for Oracle Databases
Prerequisite: Make sure you have applied the patch 23315889(fast offline conversion patch) if you are on Oracle 11g Database or latest CPU patches are applied which already include all the…
Read MoreDBCA Configure Database option is greyed out in Oracle
Database Configuration Assistant was not showing the database and Configure Database Options and it was greyed out(disabled). We tried setting up ORACLE_SID and ORACLE_HOME and ran dbca but it was…
Read MoreGather Schema Statistics – Program error with Locks and Duplicate columns
Oracle E-Business Suite Release 12 uses cost–based optimization in order to choose the most efficient execution plan for SQL statements.Gather Schema Statistics is the favourite one among Apps DBA’s and…
Read MoreHow to open Concurrent Out file in excel format
An *.out file is a compiled executable file created by various source code compilers in Unix-like operating systems, such as Linux and AIX. *.out files are most commonly seen as…
Read More