RMAN> DELETE FORCE NOPROMPT OBSOLETE DEVICE TYPE DISK; If error still occurs, then try the below RMAN> CROSSCHECK COPY OF CONTROLFILE; rman> DELETE FORCE NOPROMPT OBSOLETE DEVICE TYPE SBT; or…
Read MoreDescription: These two tables FND_ENV_CONTEXT FND_CONCURRENT_REQUESTS grown to 4 GB size . To speed up. Solution: 1. First Purge and then De-fragmentation to improve the performance of the DML fired…
Read MoreProblem: Concurrent program are running from long time and are not getting completed. $INST_TOP/ora/10.1.2/bin/appsrwrun.sh userid=apps/apps mode=character report=$FND_TOP/reports/US/FNDSCURS.rdf batch=yes destype=file desname=./ddr2.out desformat=$FND_TOP/reports/HPL pagesize=132×66 traceopts=trace_all tracefile=ddr2.trc tracemode=trace_replace Get error: Environment:Environment java.lang.UnsatisfiedLinkError: Can’t…
Read MoreExecute the below in Application Tier: Run adpreclone on Application Tier $ perl ./adpreclone.pl appsTier Execute the following on the Database Tier: Logon as oracle database user and set envirnoment…
Read MoreAPPLIES TO: Oracle Cloud Infrastructure - Database Service - Version N/A and later SYMPTOMS: OCI VMDB system automatic backup failed with DCS-10434:Control file and/or spfile handles could not be retrieved…
Read MoreAPPLIES TO: Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.2.0.1 [Release 12.1 to 12.2] Oracle Database Cloud Schema Service - Version N/A and later Gen 1 Exadata Cloud…
Read MoreAPPLIES TO: Oracle Database - Enterprise Edition - Version 9.2.0.8 and later Oracle Database Cloud Schema Service - Version N/A and later Oracle Database Exadata Express Cloud Service - Version…
Read MoreAPPLIES TO: Oracle Database - Enterprise Edition - Version 10.2.0.3 to 12.1.0.1 [Release 10.2 to 12.1] Oracle Database Cloud Schema Service - Version N/A and later Oracle Database Exadata Cloud…
Read MoreORA-02082: a loopback database link must have a connection qualifier Such error occurs when there is a db link which is a loop back database link i.e. points to itself…
Read MoreFix — ORA-19505: failed to identify file in RMAN RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on ch00 channel at 01/17/2011…
Read More