Database Blog

WAIT Event : Log File Sync

Log File Sync : To Find out Storage is the problem? -> Run AWR Report during the problematic time  -> Check “Wait Avg(ms)” for the wait event “log file sync”,…

Read More

History of enq: TX – row lock contention

As a DBA, we should be able to provide the history of locks to the application team to check. This is the query to get the information from v$active_session_history This view…

Read More

Untitled

Actualize the old database editions after online patching to avoid possible performance issues: EBS 12.2.3/12.2.4 During Online patching (ADOP) :  An additional column ZD_EDITION_NAME is populated in the seed tables.This…

Read More

Untitled

Adpreclone Fails in EBS 12.2.3 : There is already an ACTIVE ADOP CYCLE with session id Adpreclone Fails in EBS 12.2.3 : There is already an ACTIVE ADOP CYCLE with…

Read More

Solved ” ORA-16057: server not in Data Guard configuration ” , in oracle dataguard environment

We faced the error ORA-16057 while building a standby database.archives were not shipping to the DR site Now in the production database, Select dest_id,error from v$archive_dest;    DEST_ID ERROR ———-…

Read More

EBS R12.2 Cloning Steps

NOTE: The following Clone approach is applicable for the APPLICATION version from R12.2.1 To R12.2.4 ENVIRONMENT:- Source:- BASE_PATH=/s01/oracle/R122 RUN_FILE_SYSTEM=/s01/oracle/R122/fs1 PATCH_FILE_SYSTEM=/s01/oracle/R122/fs2 Non-Editioned File System=/s01/oracle/R122/fs_ne Target:- BASE_PATH=/t01/oracle/R122 RUN_FILE_SYSTEM=/t01/oracle/R122/fs1 PATCH_FILE_SYSTEM=/t01/oracle/R122/fs2 Non-Editioned File System=/t01/oracle/R122/fs_ne…

Read More

AWR Snapshots are not generated Automatically

Scenario: ———— Oracle Database 11.2.0.4. My AWR Snapshots were not being generated even though it was full enabled. Basic Checks done: ———————— 1. Checked that I had enough free space…

Read More

Tempfiles in Standby database

In a active standby database we had a problem due to temp tablespace. So we increased the temp tablespace by adding a 10G tempfile in the primary database. SQL> select…

Read More

solved ORA-01187 ORA-01110 in standby database

We got the below error on a active standby databse ORA-01187: cannot read from file because it failed verification tests ORA-01110: data file 73: ‘/u02/oracle/oradata/test/temp_01.dbf’ so the sloutions is as…

Read More

Solved ORA-00304: requested INSTANCE_NUMBER is busy

On starting upan instance  in 3 node RAC Database,and got the below error SQL> startup mount ; ORA-00304: requested INSTANCE_NUMBER is busy SQL>EXIT on checking we found the background sessions…

Read More