Untitled
Log files differences in Oracle EBS Release 12.1.3 and Oracle EBS Release 12.2.4 The Log files locations in Oracle EBS Release 12.1.3 are given below: 1.Instance startup and configuration Log…
Read More“ORA_01033:ORACLE initialization or shutdown in progress” .
Issue: The issue is in racprd database while connecting to service name racprdha1 is showing ORACLE initialization or shutdown in progress. Workaround: The problem is with the scan listener in RAC1.…
Read MoreORA-20100: Temporary file creation for FND_FILE failed
Scenario: ———– While running a report in Payables or any of the program errored out and the log file shows the following error in 12.2.4 ORA-20100: Temporary file creation for…
Read MoreThe Data Guard status of xxxx is Error ORA-03135: connection lost contact from Primary database
We have got a error from OEM “The Data Guard status of xxxx is Error ORA-03135: connection lost contact.”After that, we have resolve the error using below steps, Step:1 Check the command…
Read MoreHow to Check or Validate The RMAN Backups
Step 1: The below command just gives the report of backups that are used to do the restore and recover : RMAN> run { set until time “to_date(‘2016-24-10:9:00:00′,’yyyy-dd-mm:hh24:mi:ss’)”; restore database…
Read MoreDifference between v$sql v$sqltext v$sqltext_with_newlines
Difference between v$sql v$sqltext v$sqltext_with_newlines v$sql : if you have multiple copies of the query: select * from x if user A and B are executing (in shared pool )…
Read More